一、问题现象client端备份DB2时候失败
db2inst1@mqserver1:~> db2 backup db dss USE TSM compress
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "12".db2diag.log里信息:
2014-06-20-11.24.19.276419-240 I44798E940 LEVEL: Error
PID : 63051 TID : 140462904043264PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DSS
APPHDL : 0-26 APPID: *LOCAL.db2inst1.140620152407
AUTHID : DB2INST1
EDUID : 90 EDUNAME: db2agent (DSS) 0
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=0x00000006=6 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 48 bytes
0x00007FBFE4761DB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FBFE4761DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FBFE4761DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2014-06-20-11.24.19.281918-240 E45739E599 LEVEL: Error
PID : 63051 TID : 140462904043264PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DSS
APPHDL : 0-26 APPID: *LOCAL.db2inst1.140620152407
AUTHID : DB2INST1
EDUID : 90 EDUNAME: db2agent (DSS) 0
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:708
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:
二、SEVER端设置
tsm: SERVER1>q dr
Library Name Drive Name Device Type On-Line
------------ ------------ ----------- -------------------
VTL01 DRV0 ECARTRIDGE Yes
VTL01 DRV1 ECARTRIDGE Yes
VTL01 DRV2 ECARTRIDGE Yes
VTL01 DRV3 ECARTRIDGE Yes
tsm: SERVER1>q path
Source Name Source Type Destination Destination On-Line
Name Type
----------- ----------- ----------- ----------- -------
SERVER1 SERVER VTL01 LIBRARY Yes
SERVER1 SERVER DRV0 DRIVE Yes
SERVER1 SERVER DRV1 DRIVE Yes
SERVER1 SERVER DRV2 DRIVE Yes
SERVER1 SERVER DRV3 DRIVE Yes
tsm: SERVER1>q node
Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Acce- Password
ss Set
------------------------- -------- -------------- ---------- ---------- -------
MQNODE DB2/LIN- DO_VTL <1 <1 No
UXX8664
tsm: SERVER1>q stgpool
Storage Device Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- ---------- ----- ----- ---- --- -----------
ARCHIVEPOOL DISK 0.0 M 0.0 0.0 90 70
AR_TAPE_PO- LTO2 0.0 M 0.0 0.0 90 70
OL
BACKUPPOOL DISK 0.0 M 0.0 0.0 90 70
BA_TAPE_PO- LTO2 0.0 M 0.0 0.0 90 70
OL
SPACEMGPOOL DISK 0.0 M 0.0 0.0 90 70
收起