Hi everybody!!

We are using DB2 UDB v8.2 on AIX. We are running full online backups every night on one of our databases and using TSM. When I query the TSM using db2adutl query, I saw that the logs are not getting archived on TSM for one of the databases. Ideally whenever an Online Backup is trigered, logs should be archived automatically, though its working fine with other databases in that instance.

Any thoughts?

Anks

Have a look at the INCLUDE LOGS Option in the backup command ... This option includes logs required for the successful restoration and rollforward of the online backup ...

For ROLLFORWARD to a later point of time, it is your responsibilty to archive log files and maintain it ... You can set LOGARCHMETH1 to TSM ..

What fixpak are you on ? IIRC, there was a fix to INCLUDE LOGS in FP9 ...

HTH

Satjhyaram

Thanks Sathyaram for such a quick reply

We have already set LOGARCHMETH1 to TSM. Thats the reason I am little concerned. I was wondering if I should use ARCHIVE LOGS command to archive logs manually, will that help?

I thought if we are running full online backups logs get archived automatically.

We are using FP7

Thanks again

Okay I have figured out the error in the db2diag after which the logs stopped getting archived...

2006-05-15-22.35.27.763928-360 I98832081A663 LEVEL: Error
PID : 5439654 TID : 1 PROC : db2med.3367116.0 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:0
DATA #1 : String, 108 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library libtsm.a:

DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFFDED8 : 0000 0199 3433 3520 3430 3900 0000 0000 ....435 409.....
0x0FFFFFFFFFFFDEE8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFDEF8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2006-05-15-22.35.27.764809-360 I98832745A316 LEVEL: Error
PID : 5439654 TID : 1 PROC : db2med.3367116.0 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:0
MESSAGE : Error in vendor support code at line: 435 rc: 409

2006-05-15-22.35.27.775557-360 I98833062A346 LEVEL: Warning
PID : 5439654 TID : 1 PROC : db2med.3367116.0 0
INSTANCE: xyz NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:85
MESSAGE : Media controller -- vendor device initialization error (zrc =
0x00000199)

Can anybody help me in comprehending these!!

I will appreciate any help

Anks