legato backup db2 failed

Question

now i use legato networker 7.2 backup db2,backup server is win2003,db2 server is win2003 + db2 8.2.5,before backup is ok.lately the same error issued many times. There were two weeks to resolve this problem.Pls help me resolve the problem,thanks very much. the following info is the error info in the file nsrdb2sv: - --- end error report ------------------------ 05/30/07 23:07:51 nsrdb2sv: NMDB2_ERROR: ... Backup Failed ... 05/30/07 23:07:51 nsrdb2sv: *** NetWorker Module for DB2 backup session started (5724) *** 05/30/07 23:07:51 nsrdb2sv: *** NetWorker Module for DB2 backup session started (4996) *** 05/30/07 23:07:52 nsrdb2sv: ---- error report ----------------------------- application message = db2 backup -- interrupted SQLCODE = -2062 SQL2062N 存!建χê 'C:\Program Files\Legato
sr\bin\libnsrdb2.dll' 狈￠扫泊í唯￡-舀奥氇'11' ? ---- end error report ------------------------ 05/30/07 23:07:52 nsrdb2sv: NMDB2_ERROR: ... Backup Failed ... 05/30/07 23:07:52 nsrdb2sv: Backing up 'LKMDDB' database... 05/30/07 23:07:52 nsrdb2sv: Backing up 'JCRDB' database... 05/30/07 23:07:52 nsrdb2sv: *** NetWorker Module for DB2 backup session started (5992) *** 05/30/07 23:07:52 nsrdb2sv: Backing up 'WPSDB' database... 05/30/07 23:07:53 nsrdb2sv: ---- error report ----------------------------- following is the error info in the debug file: 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Entering Function 3704#4388 Wed May 30 20:05:55 2007 sqluvput: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 sqluvend: Entering Function 05/30/07 20:05:55 NetWorker: tiv:DB2:\JCRDB\NODE0000\DB2LOG\ size 4009 KB, 1 file(s), took 0 min 1 sec 3704#4388 Wed May 30 20:05:55 2007 sqluvend: Leaving Function: Result = 0 3704#4388 Wed May 30 20:05:55 2007 nsrdb2_delete_session: Entering Function 3704#4388 Wed May 30 20:06:13 2007 sqluvint: Entering Function 3704#4388 Wed May 30 20:06:13 2007 nsrdb2_check_init_input: Entering Function 3704#4388 Wed May 30 20:06:13 2007 nsrdb2_check_init_input: Leaving Function: Result = 0 05/30/07 20:06:13 NetWorker: nsrports_init_from_env('7937-9936', '10001-30000') 3704#4388 Wed May 30 20:06:14 2007 sqluvint: NMDB2_ERROR 3704#4388 Wed May 30 20:06:14 2007 sqluvint: Leaving Function: Result = 11 3704#4388 Wed May 30 20:06:14 2007 nsrdb2_delete_session: Entering Function 3704#4388 Wed May 30 20:06:35 2007 sqluvint: Entering Function 3704#4388 Wed May 30 20:06:35 2007 nsrdb2_check_init_input: Entering Function 3704#4388 Wed May 30 20:06:35 2007 nsrdb2_check_init_input: NMDB2_WARNING: Could not open/process options @file 3704#4388 Wed May 30 20:06:35 2007 nsrdb2_check_init_input: Leaving Function: Result = 0 05/30/07 20:06:35 NetWorker: nsrports_init_from_env('7937-9936', '10001-30000') 3704#4388 Wed May 30 20:06:36 2007 sqluvint: NMDB2_ERROR 3704#4388 Wed May 30 20:06:36 2007 sqluvint: Leaving Function: Result = 11 3704#4388 Wed May 30 20:06:36 2007 nsrdb2_delete_session: Entering Function 3704#4388 Wed May 30 20:06:39 2007 sqluvint: Entering Function 3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: Entering Function 3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: NMDB2_WARNING: Could not open/process options @file 3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: Leaving Function: Result = 0 05/30/07 20:06:39 NetWorker: nsrports_init_from_env('7937-9936', '10001-30000') 3704#4388 Wed May 30 20:06:40 2007 sqluvint: NMDB2_ERROR 3704#4388 Wed May 30 20:06:40 2007 sqluvint: Leaving Function: Result = 11 3704#4388 Wed May 30 20:06:40 2007 nsrdb2_delete_session: Entering Function 3704#4388 Wed May 30 20:06:56 2007 sqluvint: Entering Function 3704#4388 Wed May 30 20:06:56 2007 nsrdb2_check_init_input: Entering Function 3704#4388 Wed May 30 20:06:56 2007 nsrdb2_check_init_input: NMDB2_WARNING: Could not open/process options @file 3704#4388 Wed May 30 20:06:56 2007 nsrdb2_check_init_input: Leaving Function: Result = 0 05/30/07 20:06:56 NetWorker: nsrports_init_from_env('7937-9936', '10001-30000')

kissma · Answer

I don`t know your mean,whether you mean is make the debug level to 9?

ble1 · Answer

Debug doesn't show part when error is encountered. I would suggest to open this with support and send them whole log for inspection.

kissma · Answer

following info is cfg file:DB2_NODE_NAME=db2adminDB2_USR=db2adminDB2INSTANCE=db2adminDB2PATH=D:\DB282\SQLLIB\BINDB2_VENDOR_LIB_PATH=C:\Program Files\Legato
sr\bin\libnsrdb2.dllDB2_OPTIONS=DB2BACKUP_ONLINENSR_SERVER=backupserverNSR_CLIENT=tivNSR_DATA_VOLUME_POOL=menhudb2NSR_LOG_VOLUME_POOL=menhudb2NSR_DEBUG_FILE=C:\Program Files\Legato
sr\applogs	amldap.LOGNSR_LIBNSRDB2_DEBUG_LEVEL=9NSR_LIBNSRDB2_DEBUG_FILE=C:\Program Files\Legato
sr\applogs	amldapsql.logDB2_PSWD=lc5Fdaf&bhk)jl

kissma · Answer

pls help me to analysis the issue

ble1 · Answer

Do you have anything in event log for that time (or perhaps even in dr. watson log)?

ble1 · Answer

What I said was that log you pasted didn't show the error so I assume it is not whole part. Your support should be able to run analysis of such log and maybe with webex even do few tests on their own and resolve it.

kissma · Answer

after backup failed output same info as following(debug file):now in the cfg file the debug level is 1,only output the following info3704#4388 Wed May 30 20:06:36 2007 sqluvint: NMDB2_ERROR3704#4388 Wed May 30 20:06:36 2007 sqluvint: Leaving Function: Result = 113704#4388 Wed May 30 20:06:36 2007 nsrdb2_delete_session: Entering Function3704#4388 Wed May 30 20:06:39 2007 sqluvint: Entering Function3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: Entering Function3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: NMDB2_WARNING: Could not open/process options @file3704#4388 Wed May 30 20:06:39 2007 nsrdb2_check_init_input: Leaving Function: Result = 005/30/07 20:06:39 NetWorker: nsrports_init_from_env('7937-9936', '10001-30000')in the nsrdb2sv file output following info:05/30/07 23:07:51 nsrdb2sv: NMDB2_ERROR: ... Backup Failed ...05/30/07 23:07:51 nsrdb2sv: *** NetWorker Module for DB2 backup session started (5724) ***05/30/07 23:07:51 nsrdb2sv: *** NetWorker Module for DB2 backup session started (4996) ***05/30/07 23:07:52 nsrdb2sv: ---- error report -----------------------------application message = db2 backup -- interruptedSQLCODE = -2062SQL2062N storage device C:\Program Files\Legato
sr\bin\libnsrdb2.dll'狈￠扫泊í唯reason code'11' ?

kissma · Answer

in the db2 log has these,2007-05-22-11.32.57.013000+480 I552706256H532 LEVEL: ErrorPID : 2492 TID : 1180 PROC : db2syscs.exeINSTANCE: DB2ADMIN NODE : 000FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1030MESSAGE : sqluvint failed! Vendor rc: DATA #1 : Hexdump, 40 bytes0x1689DD9C : 0B00 0000 4C69 6E65 203D 2034 3734 2072 ....Line = 474 r0x1689DDAC : 6320 3D20 3131 0000 0000 0000 0000 0000 c = 11..........0x1689DDBC : 0000 0000 0000 0000 ........2007-05-22-11.32.57.013000+480 I552706790H277 LEVEL: ErrorPID : 2492 TID : 1180 PROC : db2syscs.exeINSTANCE: DB2ADMIN NODE : 000FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1050RETCODE : ZRC=0x0000000B=112007-05-22-11.32.57.029000+480 I552707069H278 LEVEL: ErrorPID : 2492 TID : 1180 PROC : db2syscs.exeINSTANCE: DB2ADMIN NODE : 000FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1820RETCODE : ZRC=0x0000000B=112007-05-22-11.32.57.029000+480 I552707349H387 LEVEL: ErrorPID : 2492 TID : 1180 PROC : db2syscs.exeINSTANCE: DB2ADMIN NODE : 000FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160MESSAGE : Failed to archive log file S0002951.LOG to VENDOR chain 1 from F:\DB2ADMIN\NODE0000\SQL00003\SQLOGDIR\ with rc = 11.2007-05-22-11.32.57.029000+480 I552707738H310 LEVEL: ErrorPID : 2492 TID : 1180 PROC : db2syscs.exeINSTANCE: DB2ADMIN NODE : 000FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500MESSAGE : Log archive failed with rc 11 for LOGARCHMETH1.we ask ibm 800 tel,they said this is legato content,do you know what is in the libnsrdb2.dll file line 474.

ble1 · Answer

That's exactly why you should open this with your NetWorker support.

kissma · Answer

customer`s production system is ok,only bakcup fail,and above info is the error info,i need help to resolve the problem,but now i have no usfull info.

kissma · Answer

I don`t know what you mean.

pgerke · Answer

I believe this is similar to what Hrvoje was telling you: As you have already realized, this problem is not simple to identify. You need help in determining if any additional, relevant log information from NetWorker is available. That help is best provided by NetWorker support and not this forum. If the customer does not have support for NetWorker then I would recommend that the customer either purchase a support contract or attempt to purchase support for just this one problem. I believe that the EMC contact info for NetWorker support is: 1-408-566-2000, option #2 or E-mail: ESG_Renewals_Storage@emc.com.

NetWorker

legato backup db2 failed

Was this post helpful?