Failed to archive log file and db2 online backup

Question: These errors started appearing in the db2diag.log files for a production DB2 database. I have a process to Manage DB2 db2diag.log files.The daily DB2 online backup was successful – but failed to archive log.

2012-04-20-11.15.52.720713+060 E1088884685E547 LEVEL: Error
PID : 13535 TID : 47411049261376PROC : db2sysc 0
INSTANCE: db2misc NODE : 000
EDUID : 24 EDUNAME: db2logmgr (db1) 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 S0005908.LOG to TSM chain 2 from /db2inst1/logs/db1/NODE0000/.

Answer:  1)  check the configuration on the database are correct. LOGARCHMETH1 = TSM , LOGRETAIN=RECOVERY. And you’re not  getting the DB2 SQL2413N – Online backup is not allowed  error

2)       Break connections to the database  and take a full DB2 offline backup

Db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
Db2 BACKUP DATABASE MYDBI USE TSM

Leave a Reply

Discover more from ciquery

Subscribe now to keep reading and get access to the full archive.

Continue reading