db cfg配置如下
First log archive method (LOGARCHMETH1) = TSM
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
归档路径设置为TSM
但是在db2diag.log中一直在报归档失败
2017-02-17-15.16.30.871928+480 E6633226179A377 LEVEL: Warning
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
MESSAGE : ADM1844I Started archive for log file "S0001283.LOG"
2017-02-17-15.17.46.969185+480 E6633226557A347 LEVEL: Error
PID : 180474 TID : 1 PROC : db2vend
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluvint, probe:402
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0xFFFFFFCE=-50 -- see TSM API Reference for meaning.
2017-02-17-15.17.47.970774+480 E6633226905A865 LEVEL: Error
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpInitVendorDevice, probe:1030
MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
"A vendor device reported a media error."
DATA #1 : String, 29 bytes
Init failed! Vendor rc info:
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000000B=11 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 48 bytes
0x07000000202C8AD0 : FFFF FFCE 3430 3220 2D35 3000 0000 0000 ....402 -50.....
0x07000000202C8AE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x07000000202C8AF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2017-02-17-15.17.47.971009+480 I6633227771A428 LEVEL: Error
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogVendor, probe:1820
RETCODE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
"A vendor device reported a media error."
2017-02-17-15.17.47.971143+480 E6633228200A466 LEVEL: Warning
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S0001283.LOG" to "TSM chain 0"
from "/db2data/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/".
2017-02-17-15.17.47.971443+480 E6633228667A567 LEVEL: Error
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
"A vendor device reported a media error."
DATA #1 :
Failed to archive log file S0001283.LOG to TSM chain 0 from /db2data/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.
2017-02-17-15.17.47.971610+480 I6633229235A443 LEVEL: Warning
PID : 164678 TID : 3343 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 3343 EDUNAME: db2logmgr (TRSWCM6) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 1283 due to rc -2045771739 for
LOGARCHMETH1 using method 2 and target .
一直在归档S0001283.LOG,日志是存在的
$ ls -trl S0001283.LOG
-rw------- 1 db2inst1 db2iadm1 16785408 Dec 25 2011 S0001283.LOG
$
不明白是什么原因……