How do you recover from a
BACKUP PENDING. SQLSTATE=57019 on DB2 (XP O/S)?
Reason probably because I set LOGARCHMETH1 to TSM in error
Need to be LOGARCHMETH1 OFF
Current situation means I cannot connect to database because it has 'BACKUP PENDING' - so I cannot do anything with the database - need a 'get out of jail' solution.
Help please.
User Profile
Collapse
-
DB2 v9.0 (Enterprise) vendor code
I am running a database under XP with DB2 Enterprise edition v9.0 (no longer supported).
The database is backed up and then an attempt to 'restore' it on a different machine. This fails with a SQL2071N error
The IBM site mentions
(quote)
If the user tries to restore a database from a backup image and transaction log files archived using a vendor library and later extracted to the disk, and if the vendor...
No activity results to display
Show More