23 April,2012 by Tom Collins
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
DB2 backup online summary - DBA DB2
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |