-
Title
DB2 backup fails with SQL2413N Online backup is not allowed because the database is not recoverab -
Description
Solution Details Date - 02/2011
Affected Product & Version - All supported versions
Affected Module & Version - APM for DB2 (all supported versions)
OS Version - All supported OS
Application Information - DB2 9.7
Error in French:
SQL2413N La sauvegarde en ligne n'est pas autorisée car la base de données ne peut pas faire l'objet d'une récupération ou la sauvegarde de la base de données est en attente.
Description:
A backup fails and leaves processes hang on the system, which causes the subsequent backup jobs to fail.
Symptoms:
After a DB2 backup fails and leaves hang processes on the system, any subsequent backup will fail with:
SQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.
-
Resolution
1. Issue the following command to list these applications and its corresponding Application Handles:
DB2 LIST APPLICATIONS FOR DATABASE <<DataBaseName>> SHOW DETAIL
2. Issue one of the following commands to un-lock these applications:
a)- DB2 FORCE APPLICATION (xxxxxxx, yyyyyyy, zzzzzzz).
xxxxxxx, yyyyyyy, zzzzzzz are Application Handles listed by the DB2 List command issued on the step 1 above.
or
b) DB2 FORCE APPLICATION ALL
3. Wait enough time for the command to complete.
4. Issue the list command to check the status:
DB2 LIST APPLICATIONS FOR DATABASE <<DataBaseName>> SHOW DETAIL
5. The previous command will eventually result in the following message indicating that the system released the hung processes and you are ready to run the backup again:
DB2 LIST APPLICATIONS FOR DATABASE TOOLSDB SHOW DETAIL
SQL1611W No data was returned by Database System Monitor. -
Additional Information
BakBone SFDC Solution Number: 00006134