|

- 帖子
- 23
- 金钱
- 30 米
|
db2 backup db kabpiw tablespace TBS32K3 online use TSM open 2 sessions exclude logs without prompting
tsm 备份db2的一个tablespace不成功:
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "-72".
db2diag.log里找到如下内容:
2010-02-04-09.50.57.217699+480 E84045795A348 LEVEL: Error
PID : 741540 TID : 1 PROC : db2vend
INSTANCE: kabpiw1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluvput, probe:1338
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x0000009D=157 -- see TSM API Reference for meaning.
2010-02-04-09.50.57.218426+480 I84046144A743 LEVEL: Error
PID : 200766 TID : 22506 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000
EDUID : 22506 EDUNAME: db2med.25064.1 (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:646
DATA #1 : String, 129 bytes
Vendor error: rc = 25 returned from function sqluvput.
Return_code structure from vendor library /kabpiw1/sqllib/adsm/libtsm.a:
DATA #2 : Hexdump, 48 bytes
0x070000024B338110 : 0000 009D 3133 3338 2031 3537 0000 0000 ....1338 157....
0x070000024B338120 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x070000024B338130 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2010-02-04-09.50.57.218602+480 I84046888A376 LEVEL: Error
PID : 200766 TID : 22506 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000
EDUID : 22506 EDUNAME: db2med.25064.1 (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:686
MESSAGE : Error in vendor support code at line: 1338 rc: 157
2010-02-04-09.50.57.478525+480 E84047265A348 LEVEL: Error
PID : 741540 TID : 1 PROC : db2vend
INSTANCE: kabpiw1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluvend, probe:1504
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0xFFFFFFB8=-72 -- see TSM API Reference for meaning.
2010-02-04-09.50.58.480731+480 E84047614A378 LEVEL: Error
PID : 200766 TID : 22506 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000
EDUID : 22506 EDUNAME: db2med.25064.1 (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:909
MESSAGE : Media controller -- problem during writing to vendor device
2010-02-04-09.50.58.480864+480 E84047993A444 LEVEL: Error
PID : 200766 TID : 22506 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000
EDUID : 22506 EDUNAME: db2med.25064.1 (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:909
MESSAGE : SQL2033N An error occurred while accessing TSM during the processing
of a database utility. TSM reason code: "".
2010-02-04-09.50.58.481038+480 E84048438A338 LEVEL: Error
PID : 200766 TID : 22506 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000
EDUID : 22506 EDUNAME: db2med.25064.1 (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:909
DATA #1 : String, 3 bytes
-72
2010-02-04-09.50.58.481254+480 E84048777A561 LEVEL: Severe
PID : 200766 TID : 25064 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000 DB : KABPIW
APPHDL : 0-24116 APPID: *LOCAL.kabpiw1.100204000002
AUTHID : KABPIW1
EDUID : 25064 EDUNAME: db2agent (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1145
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2033
DATA #2 : Hexdump, 8 bytes
0x070000024B2E1778 : FFFF F80F 2D37 3200 ....-72.
2010-02-04-09.50.58.481446+480 E84049339A969 LEVEL: Severe
PID : 200766 TID : 25064 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000 DB : KABPIW
APPHDL : 0-24116 APPID: *LOCAL.kabpiw1.100204000002
AUTHID : KABPIW1
EDUID : 25064 EDUNAME: db2agent (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqlubHandleTSMError, probe:1145
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: -72
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:
2010-02-04-09.51.05.594758+480 E84050309A428 LEVEL: Severe
PID : 200766 TID : 25064 PROC : db2sysc 0
INSTANCE: kabpiw1 NODE : 000 DB : KABPIW
APPHDL : 0-24116 APPID: *LOCAL.kabpiw1.100204000002
AUTHID : KABPIW1
EDUID : 25064 EDUNAME: db2agent (KABPIW) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:848
MESSAGE : Backup terminated.
tsm activelog里找到如下内容:
02/08/10 08:29:36 ANR0530W (Session: 98215, Origin: KABARC02) Transaction
failed for session 1670 for node KABARC02 (DB2/AIX64) -
internal server error detected. (SESSION: 98215)
02/08/10 08:29:36 ANR0482W (Session: 98215, Origin: KABARC02) Session 1671
for node IVOTSM1 (AIX-RS/6000) terminated - idle for more
than 15 minutes. (SESSION: 98215)
02/08/10 08:29:36 ANR0480W (Session: 98215, Origin: KABARC02) Session 1670
for node KABARC02 (DB2/AIX64) terminated - connection
with client severed. (SESSION: 98215) |
|