DB2 SQL2413N - Online backup is not allowed

01 January,2011 by Jack Vamvas

I started seeing this message appear in the backup logs:

 

SQL2413N  Online backup is not allowed because the database is not recoverable

or a backup pending condition is in effect.

 

                                         

The problem was Archival Logging wasn’t enabled on the databases . The problem was rectified by:

db2 update db cfg for MYDB using LOGARCHMETH1 TSM

db2 update db cfg for MYDB using logretain RECOVERY

 Read More

The Backup failed - DBA DB2

DB2 – How to manage backup failures - DBA DB2

DB2 – Backup history - DBA DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.

Working...

Post a comment on DB2 SQL2413N - Online backup is not allowed

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright