Error to take DB2 backup, Netbackup 7.5

[YaraOB]

Hello all,

I am almost crazy, because I can't to make a backup for DB2 database on Windows 2008 Server. We configure 2 files:

db2.config

db2_backup_db_offline.cmd

Also we have the I/O library named: nbdb2.dll

We are sending from Netbackup console the backup and we received this error message:

21/05/2014 10:22:48 a.m. - Info nbjm(pid=4796) starting backup job (jobid=1614901) for client Desarrollo1-bkp, policy ERP-DB2-Test, schedule Full

21/05/2014 10:22:48 a.m. - Info nbjm(pid=4796) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1614901, request id:{164D61F6-1638-427B-9E80-73D6481B4080})

21/05/2014 10:22:48 a.m. - requesting resource st_dc1symmedsrv02_dd

21/05/2014 10:22:48 a.m. - requesting resource dc1symcon01.NBU_CLIENT.MAXJOBS.Desarrollo1-bkp

21/05/2014 10:22:48 a.m. - requesting resource dc1symcon01.NBU_POLICY.MAXJOBS.ERP-DB2-Test

21/05/2014 10:22:49 a.m. - granted resource dc1symcon01.NBU_CLIENT.MAXJOBS.Desarrollo1-bkp

21/05/2014 10:22:49 a.m. - granted resource dc1symcon01.NBU_POLICY.MAXJOBS.ERP-DB2-Test

21/05/2014 10:22:49 a.m. - granted resource st_dc1symmedsrv02_dd

21/05/2014 10:22:49 a.m. - estimated 0 Kbytes needed

21/05/2014 10:22:49 a.m. - Info nbjm(pid=4796) started backup (backupid=Desarrollo1-bkp_1400685769) job for client Desarrollo1-bkp, policy ERP-DB2-Test, schedule Full on storage unit st_dc1symmedsrv02_dd

21/05/2014 10:22:50 a.m. - started process bpbrm (14662)

21/05/2014 10:22:52 a.m. - connecting

21/05/2014 10:22:53 a.m. - connected; connect time: 00:00:01

21/05/2014 10:22:56 a.m. - end writing

21/05/2014 10:25:27 a.m. - Info bpbrm(pid=14662) Desarrollo1-bkp is the host to backup data from   

21/05/2014 10:25:27 a.m. - Info bpbrm(pid=14662) reading file list from client      

21/05/2014 10:25:29 a.m. - Info bpbrm(pid=14662) starting bphdb on client       

21/05/2014 10:25:30 a.m. - Info bphdb(pid=4348) Backup started         

21/05/2014 10:25:31 a.m. - Error bpbrm(pid=14662) from client Desarrollo1-bkp: ERR - Script <"E:\db2\db2td1\db2_software\BIN\db2_backup_db_offline.cmd"> failed with status: <1> 

21/05/2014 10:25:31 a.m. - Error bpbrm(pid=14662) from client Desarrollo1-bkp: ERR - bphdb exit status = 6: the backup failed to back up the requested files

21/05/2014 10:25:32 a.m. - Info bphdb(pid=4348) done. status: 6: the backup failed to back up the requested files the backup failed to back up the requested files(6)

I don't now where is the problem... Could you please help me?!

Thank you

Yara

[pri3006]

Status 6 is a generic error. Do you have the bphdb log folder on the client? If yes, can you provide the logs present in that folder? If no, create that folder in <install path>\Netbackup\logs, on the affected client, reproduce the error and then send across the logs.
 

[Michael_G_Ander]

Try to run the db2_backup_db_offline.cmd from a administrative command prompt, it might give output about what the problem is. My personal guess is that the db2 database does not shuts down properly for the offline backup

[YaraOB]

Hi Michael,

I am attaching the error message.

Tks!

Yara

[YaraOB]

Hi pri3006,

Let me configure the logs.

Tks

[Marianne]

I found the following in an older version of NBU for DB2 manual:

Message (from DB2):
SQL2071N An error occurred while accessing the shared library 
“C:\incorrect\path\nbdb2.dll”. Reason code: “1”.
Cause: 
The vendor library cannot be found or accessed.
Action: 
Verify that the correct path is specified, and that the vendor library exists and has 
the correct file access permissions

Please verify that your user id (and NBU Client Service logon account) have local admin rights.

When opening cmd, do it with right-click, run as Administrator.

PS:
Please try to copy text in future rather than taking screenshots.

*** EDIT ****

One more thing - have you created log folders under install_path\NetBackup\logs\ as per the manual?
e.g.
bphdb
dbclient
bpdb2

Were any log files created in any of these folders?
bphdb will only be written to when backup is initiated from the master.

If so, please copy logs to reflect process name (e.g. bpdb2.txt) and upload as File attachments.

[Michael_G_Ander]

In addition to Mariannes suggestion, I would also look in the db2 databases logs

I am not familar with db2, but seems to me that screen shot is lacking a shutdown command of some kind for a offline backup