Hi TSM'ers Env: TSM-Server: AIX 5.3 ML 4, 64 bit TSM-Client: AIX 5.3 ML 4, TSM 5.3.4.0, API at the same level, 32 bit ICM : 8.3.0 IBM Content Manager DB2 : 8.1.1.104
Desc: 1. recently installed IBM's Content Manager using DB2 and TSM via the "db2uext2". 2. Setting the "LOGRETAIN ON" and "USEREXIT ON" in the DB2-config 3. Running successfully incremental and full backup's (checked via LIST HISTORY and via db2adutl ) 4. Accordingly to IBM'S RedBook Backing Up DB2 Using Tivoli Storage Manager, June 2001 Chapter 10, pp 208-210 we ran db2 restore database icm22 use tsm taken at 20060629142959 from a FULL ONLINE backup working as expected and leaving the DB in "Rollforward pending DATABASE" 5. Trying to run the db2 rollforward database icm22 to end of logs and stop ended: SQL1268N Roll-forward recovery stopped due to error "21" while retrieving logfile "S0000306.LOG" for database "ICM22" on node "0". 6. Diving into /icmdb/db2inst1/sqllib/db2dump/db2diag.log we found the first occurence of "rc = 21": ---->>>>>>>>>>>> 2006-03-01-17.30.05.597600+060 I33398913C395 LEVEL: Error PID : 643126 TID : 1 PROC : db2logmgr (ICM22) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160 MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from /icmdb/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc = 21. 2006-03-01-17.30.05.597827+060 I33399309C370 LEVEL: Warning PID : 643126 TID : 1 PROC : db2logmgr (ICM22) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780 MESSAGE : Still unable to archive log file 0 due to rc 21 for LOGARCHMETH1 using method 4 and target . ----------->>>>>>>>>>>>>> and repeating this message up today, i.e. 2006-06-30-16.32.19.648066+120 I736430021C394 LEVEL: Error PID : 327834 TID : 1 PROC : db2logmgr (RM22) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160 MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from /icmdb/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/ with rc = 21. 2006-06-30-16.32.19.648292+120 I736430416C369 LEVEL: Warning PID : 327834 TID : 1 PROC : db2logmgr (RM22) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780 MESSAGE : Still unable to archive log file 0 due to rc 21 for LOGARCHMETH1 using method 4 and target . BUT, NO reference to S0000306.LOG 7. I checked "db2uext2.c" again and found only ONE change in the #define AUDIT_ERROR_PATH "/icmdb/db2inst1/tsm/" which suits our installation paths 8. If I look for the "rc = 21" via grep 21 /usr/tivoli/tsm/client/api/bin/sample/dsmrc.h|head -1 I get: #define DSM_RS_ABORT_NODE_ALREADY_DEFED 21 Google'ing for "DSM_RS_ABORT_NODE_ALREADY_DEFED" which tells me that db2ext2 is trying to open a new node via "open registration" Questions: 1. Is my conclusion with "open registration" in 8. OK or is it just a misinterpretation ? 2. Has anybody out there had this problem ? With some hope for a good idea, Peter -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 Braunschweig Tel : ++49/531/391-5535