dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

DB2 SQL2413N - Online backup is not allowed

01 January,2011 by Tom Collins

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: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 7:23 AM in Backup & Restore, DB2 error tips | Permalink | Comments (1) | TrackBack (0)

Searches: , , , ,

Thank you for helping me solve the problem. Now, I don't see the error message for my DB2 SQL2413N.

Posted by: online back up | Oct 23, 2011 9:52:43 PM

Verify your Comment

Previewing your Comment

Posted by: |

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