Hi Slonk,
Thanks for your reply mate.
Even after doing what you suggested and following up Installation Guide, I am still not able to backup the database through TSM.
I did further digging and was able to capture the db2diag information, looking at it is is complaining about a specific dll file, I am not sure how to proceed further. Does it make any sense to you?
FYI my tsm is updated to fix pack 6.1.2
C:\Program Files\Tivoli\TSM\db2\BIN>db2set -i server1 -all
[e] DB2PATH=C:\Program Files\Tivoli\TSM\db2
DB2_SKIPINSERTED=ON
DB2_KEEPTABLELOCK=ON
DB2_EVALUNCOMMITTED=ON
DB2_VENDOR_INI=C:\Progra~1\Tivoli\TSM\server1\tsmdbmgr.env
DB2_SKIPDELETED=ON
DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2TSM1
DB2COMM=TCPIP
DB2_PARALLEL_IO=*
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=MG-01
[g] DB2PATH=C:\Program Files\Tivoli\TSM\db2
[g] DB2INSTDEF=DB2TSM
[g] DB2ADMINSERVER=DB2DAS00
C:\Program Files\Tivoli\TSM\db2\BIN>db2set -l
SERVER1
DB2TSM
db2diag
------------
2009-09-18-13.34.51.308000+600 E2927658H458 LEVEL: Info
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1508
MESSAGE : Starting an online db backup.
2009-09-18-13.34.51.447000+600 E2928118H411 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvint, probe:374
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x00000262=610 -- see TSM API Reference for meaning.
2009-09-18-13.34.51.449000+600 I2928531H734 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:646
DATA #1 : String, 141 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library C:\PROGRA~1\Tivoli\TSM\db2\bin\db2tsm.dll:
DATA #2 : Hexdump, 40 bytes
0x73F72E20 : 6202 0000 3337 3420 3631 3000 0000 0000 b...374 610.....
0x73F72E30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x73F72E40 : 0000 0000 0000 0000 ........
2009-09-18-13.34.51.451000+600 I2929267H382 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:686
MESSAGE : Error in vendor support code at line: 374 rc: 610
2009-09-18-13.34.51.453000+600 E2929651H358 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
MESSAGE : Media controller -- Generic error
2009-09-18-13.34.51.455000+600 E2930011H451 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
MESSAGE : SQL2033N An error occurred while accessing TSM during the processing
of a database utility. TSM reason code: "".
2009-09-18-13.34.51.457000+600 E2930464H345 LEVEL: Error
PID : 8436 TID : 356 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 356 EDUNAME: db2med.12964.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:677
DATA #1 : String, 3 bytes
610
2009-09-18-13.34.51.460000+600 E2930811H565 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1144
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2033
DATA #2 : Hexdump, 8 bytes
0x71EA4E70 : 0FF8 FFFF 3631 3000 ....610.
2009-09-18-13.34.51.462000+600 E2931378H988 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1144
MESSAGE : SQL2033N An error occurred while accessing TSM during the processing
of a database utility. TSM reason code: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2033 sqlerrml: 3
sqlerrmc: 610
sqlerrp : sqlubHan
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2009-09-18-13.34.51.942000+600 E2932368H515 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvdel, probe:1742
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x00000262=610 -- see TSM API Reference for meaning.
2009-09-18-13.34.51.945000+600 I2932885H927 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:558
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
DATA #1 : String, 27 bytes
Error returned by sqluvdel.
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000001A=26 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 40 bytes
0x73F72F40 : 6202 0000 3137 3432 2036 3130 0000 0000 b...1742 610....
0x73F72F50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x73F72F60 : 0000 0000 0000 0000 ........
2009-09-18-13.34.51.947000+600 E2933814H611 LEVEL: Error
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:708
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
"".
DATA #1 : String, 63 bytes
Could not delete partial backup image created on vendor device.
2009-09-18-13.34.52.091000+600 E2934427H437 LEVEL: Severe
PID : 8436 TID : 12964 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-750 APPID: *LOCAL.SERVER1.090918033454
AUTHID : SYSTEM
EDUID : 12964 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:848
MESSAGE : Backup terminated.