cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 backup Fail: Exit Status 130

TsAdmin
Level 3

Hi, 

we are having failure on our db2 schedule backup. it was running fine all the while, but suddenly this morning the faiilure happen. on netbackup activity status shows below msg:

Mar 19, 2019 3:10:20 PM - Error bprd (pid=15413) Unable to write progress log </tmp/archive.log> on client <client> Policy=policy Sched=archive_infinite
Mar 19, 2019 3:10:22 PM - Error bprd (pid=15413) CLIENT <client>  POLICY <policy>  SCHED archive_infinite  EXIT STATUS 130 (system error occurred)

there is no update or changes done on the netbackup nor the server itself. please seeking your kindness to help us with this matter.

 

7 REPLIES 7

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

has /tmp on the client sufficient free space and permissions? Can you write to it when logged in interactively?

File system backup for this client is working?

Regards

Michal

hi Michal

we already check the /tmp/archive.log space are sufficient. and also we already clear the archive.log file and rerun the backup, still failure. 

Then we disable writing to archive.log command in the script and rerun the backup, seems like its working. so at the moment the backup running without writing the logs in archive.log.

is there anyway that we can have the backup running again with writing to the archive.log file?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Speak to server owner of db2 client to check permissions on /tmp.
The user account used for db2 backup should have full write access. 

Default permissions of /tmp normally has 'sticky bit' set, i.e. 1777, which 'ls -l' shows as drwxrwxrwt.
Maybe someone has changed this? 

 

Hi Marianne,

meaning the archive.log shud be 777 on permission in order to make the backup run? our current environment now :-

-rw-r--r-- 1 db2inst1 db2iadm1 archive.log....

Should i change it to 777?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I was referring to the /tmp folder permissions, not the log file. 

If the file is indeed created, then the problem is not on the db2 client, but rather with comms between the master and the client. 

You will probably need to dig into logs - the main ones are:
bprd on the master (NBU must be restarted after log folder is created)
bpdb2 and progress log on the client 
(See the Troubleshooting chapter in the NBU for DB2 manual for full set of log folders).

If everything was working before and no change was made on NBU side, then you need to find out from all role players (network admins, server owners, dba, etc) if anything else has changed. 

Found this technote https://www.veritas.com/support/en_US/article.100044915.html which might of interest.

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

quebek
Moderator
Moderator
   VIP    Certified

Maybe you need to whitelist this path -> /tmp on client end?

https://www.veritas.com/support/en_US/article.100031821.html