分类： DB2/Informix
2013-07-17 10:51:52
查看备份过程：
Tue Jul 16 03:43:18 CEST 2013
Start of check:
Backup on QSA on db2qsa started at 2013-07-16-03.43.20 with 1 sessions
SQL2062N An error occurred while accessing media "VENDOR". Reason code:
"518".
logger -p daemon.notice -t db2 CRITICAL OPEN status QSA backup_error Backup on QSA on db2qsa failed at 2013-07-16-19.00.58
Backup return code: 4
End of check:
Tue Jul 16 19:00:58 CEST 2013
arlqsap01:db2qsa:QSA:/db2/QSA/db2dump> db2 ? SQL2062N
SQL2062N An error occurred while accessing media "
code: "
Explanation:
An unexpected error occurred while accessing a device, file, or the
vendor shared library during the processing of a database utility. The
following is a list of reason codes:
1 An attempt to initialize a device, file, or the vendor shared
library failed.
Other reason codes refer to vendor api codes.
The utility stops processing.
User response:
Ensure the device, file, or vendor shared library used by the utility is
available and resubmit the utility command. If the command is still
unsuccessful, contact your technical service representative.
For other reason codes, consult the appropriate vendor documentation for
further details on the code.
--------------------------------------------------------------------------------------------------------------------------------------------------
arlqsap01:db2qsa:QSA:/db2/QSA/db2qsa> db2 list history backup since 20130716 for qsa
List History File for qsa
Number of matching file entries = 1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130716034325001 N O S1506854.LOG
----------------------------------------------------------------------------
Contains 85 tablespace(s):
00001 SYSCATSPACE
00002 PSAPBTABD4
00003 PSAPBTABI4
00004 PSAPPOOLD2
00005 PSAPPOOLI2
00006 PSAPDDICD
00007 PSAPDDICI
00008 PSAPDOCUD
00009 PSAPDOCUI
00010 PSAPBTABD12
00011 PSAPBTABI12
00012 DBASTATS
00013 PSAPBTABD16
00014 PSAPLOADD
00015 PSAPLOADI
00016 PSAPPOOLD
00017 PSAPPOOLI
00018 PSAPPROTD
00019 PSAPPROTI
00020 PSAPSOURCED
00021 PSAPSOURCEI
00022 PSAPSTABD
00023 PSAPSTABI
00024 PSAPUSER1D
00025 PSAPUSER1I
00026 PSAPBTABD23
00027 PSAPBTABI23
00028 PSAPBTABD15
00029 PSAPBTABI15
00030 PSAPBTABI16
00031 PSAPBTABD17
00032 PSAPBTABD14
00033 PSAPBTABI14
00034 PSAPBTABI17
00035 PSAPBTABD18
00036 PSAPBTABI18
00037 PSAPBTABD21
00038 PSAPBTABI21
00039 PSAPBTABD22
00040 PSAPBTABI22
00041 PSAPEL702D
00042 PSAPES702D
00043 PSAPPOOLD_NEW
00044 PSAPPOOLI_NEW
00045 SYSTOOLSPACE
00046 PSAPBTABD3
00047 PSAPBTABI3
00048 PSAPBTABD5
00049 PSAPBTABI5
00050 PSAPEL702I
00051 PSAPES702I
00052 PSAPBTABD2
00053 PSAPBTABI2
00054 PSAPBTABD
00055 PSAPBTABD13
00056 PSAPBTABI
00057 PSAPCLUD2
00058 PSAPBTABI13
00059 PSAPBTABD11
00060 PSAPBTABI11
00061 PSAPBTABD19
00062 PSAPBTABI19
00063 PSAPDIMI
00064 PSAPODSI
00065 PSAPFACTI
00066 PSAPEL700I
00067 PSAPES700I
00068 PSAPDIMD
00069 PSAPODSD
00070 PSAPFACTD
00071 PSAPEL700D
00072 PSAPES700D
00073 PSAPCLUD
00074 PSAPCLUI
00075 PSAPBTABD8
00076 PSAPBTABI8
00077 PSAPCLUI2
00078 PSAPBTABD20
00079 PSAPBTABI20
00080 PSAPBTABD10
00081 PSAPBTABI10
00082 PSAPBTABD6
00083 PSAPBTABI6
00084 PSAPBTABD9
00085 PSAPBTABI9
----------------------------------------------------------------------------
Comment: DB2 BACKUP QSA ONLINE
Start Time: 20130716034325
End Time: 20130716190058
Status: A
----------------------------------------------------------------------------
EID: 1622411 Location: /usr/openv/netbackup/bin/nbdb2.sl64
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 10
sqlerrmc: VENDOR?518
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
----------------------------------------------------------------------------------------------------------------------------------
2013-07-16-19.00.57.592545+120 E90924412A500 LEVEL: Error
PID : 56033520 TID : 79387 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000 DB : QSA
APPHDL : 0-33467 APPID: *LOCAL.db2qsa.130716014325
AUTHID : DB2QSA
EDUID : 79387 EDUNAME: db2agent (QSA) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:970
MESSAGE : SQL2062N An error occurred while accessing media "VENDOR". Reason
code: "518".
2013-07-16-19.00.58.354210+120 E90926441A421 LEVEL: Severe
PID : 56033520 TID : 79387 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000 DB : QSA
APPHDL : 0-33467 APPID: *LOCAL.db2qsa.130716014325
AUTHID : DB2QSA
EDUID : 79387 EDUNAME: db2agent (QSA) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:911
MESSAGE : Backup terminated.
查看日志归档问题（因为在在线备份结束的时候，会进行截断日志并日志归档）
arlqsap01:db2qsa:QSA:/db2/QSA/db2dump> db2pd -d qsa -logs
Database Partition 0 -- Database QSA -- Active -- Up 131 days 16:36:35 -- Date 07/17/2013 04:12:03
Logs:
Current Log Number 1506882
Pages Written 983
Cur Commit Disk Log Reads 0
Cur Commit Total Log Reads 0
Method 1 Archive Status Failure
Method 1 Next Log to Archive 1506881
Method 1 First Failure 1506872
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a
Log Chain ID 8
Current LSN 0x00011CE59EC5F6DE
Address StartLSN State Size Pages Filename
0x0A00030D7F5D5CD0 00011CE57C5A8010 0x00000000 70000 7691 S1506880.LOG
日志在1506872上失败。
查看db2diag.log
2013-07-16-19.01.34.253978+120 E90926863A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506872.LOG.
2013-07-16-19.16.45.710581+120 E90927238A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-19.16.45.711023+120 I90928100A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-19.16.45.711250+120 E90928525A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506872.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-19.16.45.742987+120 E90928955A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506872.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-19.16.45.743327+120 I90929486A378 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc -2045771739 for LOGARCHMETH1.
2013-07-16-19.17.06.745469+120 E90929865A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506872.LOG.
2013-07-16-19.32.19.100737+120 E90930240A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-19.32.19.100991+120 I90931102A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-19.32.19.101247+120 E90931527A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506872.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-19.32.19.101546+120 E90931957A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506872.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-19.32.19.101681+120 I90932488A488 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 1506872 due to rc -2045771739 for
LOGARCHMETH1 using method 3 and target
/usr/openv/netbackup/bin/nbdb2.sl64.
2013-07-16-19.32.20.101824+120 E90932977A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506872.LOG.
2013-07-16-19.47.31.010798+120 E90933352A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-19.47.31.011014+120 I90934214A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-19.47.31.011353+120 E90934639A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506872.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-19.47.31.011629+120 E90935069A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506872.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-19.47.31.011795+120 I90935600A488 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 1506872 due to rc -2045771739 for
LOGARCHMETH1 using method 3 and target
/usr/openv/netbackup/bin/nbdb2.sl64.
2013-07-16-19.47.32.011994+120 E90936089A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506872.LOG.
2013-07-16-20.02.43.222607+120 E90936464A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-20.02.43.222898+120 I90937326A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-20.02.43.223103+120 E90937751A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506872.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-20.02.43.223467+120 E90938181A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506872.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-20.02.43.223628+120 I90938712A488 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 1506872 due to rc -2045771739 for
LOGARCHMETH1 using method 3 and target
/usr/openv/netbackup/bin/nbdb2.sl64.
………………………...
2013-07-17-03.23.32.944763+120 E91034039A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506872.LOG.
通过上述日志的观察，发现，数据库会对未归档的日志进行重复归档的尝试（虽然这里每次尝试都失败了。。。）
从这个日志开始，下面的日志也都开始出现归档失败的现象
2013-07-16-20.02.43.223747+120 E90939201A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506873.LOG.
2013-07-16-20.17.53.885639+120 E90939576A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-20.17.53.885882+120 I90940438A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-20.17.53.886105+120 E90940863A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506873.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-20.17.53.886382+120 E90941293A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506873.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-20.17.53.886517+120 I90941824A378 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc -2045771739 for LOGARCHMETH1.
2013-07-16-21.03.31.895896+120 E90952633A374 LEVEL: Info
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S1506874.LOG.
2013-07-16-21.18.43.740225+120 E90953008A861 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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
0x0A00030D9A8F1B70 : 0000 0201 4E65 7442 6163 6B75 7020 4265 ....NetBackup Be
0x0A00030D9A8F1B80 : 6769 6E20 4163 7469 6F6E 2046 6169 6C65 gin Action Faile
0x0A00030D9A8F1B90 : 6400 0000 0000 0000 0000 0000 0000 0000 d...............
2013-07-16-21.18.43.740464+120 I90953870A424 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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."
2013-07-16-21.18.43.740688+120 E90954295A429 LEVEL: Warning
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S1506874.LOG" to "VENDOR chain
8" from "/db2/QS1C/log_dir/".
2013-07-16-21.18.43.740972+120 E90954725A530 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 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 S1506874.LOG to VENDOR chain 8 from /db2/QS1C/log_dir/.
2013-07-16-21.18.43.741113+120 I90955256A378 LEVEL: Error
PID : 56033520 TID : 4282 PROC : db2sysc 0
INSTANCE: db2qsa NODE : 000
EDUID : 4282 EDUNAME: db2logmgr (QSA) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc -2045771739 for LOGARCHMETH1.
而且，通过日志观察，在每次尝试归档一个新的日志号之前，会先尝试归档第一个失败的日志（这里是1506872），如果归档不成功，在继续归档下一个，即：
归档1506873前，先看一下能不能归档成功1506872。不能，则归档1506873也失败；
继续，尝试归档1506874，再看一下能不能归档成功1506872，不能，则归档1506874也失败；
以此类推，直到归档成功或者完全失败。
结论：检查备份失败，需要从数据备份和日志备份两个方面进行着手调查。
