Automatic archive log error in DB2 ?

hungng89

ADSM.ORG Member
Joined
May 25, 2010
Messages
115
Reaction score
2
Points
0
Location
VietNam
HI everyone

I am configuring the automatic archive log in DB2 using vendoropt tsm
First log archive method (LOGARCHMETH1) = VENDOR:/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
Options for logarchmeth1 (LOGARCHOPT1) = /db2/PIP/tdp_r3/vendor.env
Second log archive method (LOGARCHMETH2) = VENDOR:/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a
Options for logarchmeth2 (LOGARCHOPT2) = /db2/PIP/tdp_r3/vendor.env
Failover log archive path (FAILARCHPATH) = /db2/PIP/log_archive/
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) = /db2/PIP/tdp_r3/vendor.env

But when i check the db2diag.log , there some thing wrong with the log archive process
2010-09-17-11.28.56.945565+420 I3233027A424 LEVEL: Error
PID : 11206784 TID : 4933 PROC : db2sysc 0
INSTANCE: db2pip NODE : 000
EDUID : 4933 EDUNAME: db2logmgr (PIP) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogVendor, probe:2870
MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR
"A vendor device reported a media error."

2010-09-17-11.28.56.945740+420 E3233452A437 LEVEL: Warning
PID : 11206784 TID : 4933 PROC : db2sysc 0
INSTANCE: db2pip NODE : 000
EDUID : 4933 EDUNAME: db2logmgr (PIP) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W Failed to archive log file "S0000374.LOG" to "VENDOR chain
1" from "/db2/PIP/log_dir/NODE0000/".

2010-09-17-11.28.56.946098+420 E3233890A538 LEVEL: Error
PID : 11206784 TID : 4933 PROC : db2sysc 0
INSTANCE: db2pip NODE : 000
EDUID : 4933 EDUNAME: db2logmgr (PIP) 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 : <preformatted>
Failed to archive log file S0000374.LOG to VENDOR chain 1 from /db2/PIP/log_dir/NODE0000/.

Does any one have any advice ? Thanks so much
:cool:
 
Hi

Anything in the tsmserver actlog when this fails?

Do your full backups work ok or is it just the archive logs you are having a problem with ?

Cheers
 
Back
Top