recovering database access from TSM in DB2

[Rambergs]

I am stuck with an inaccessible database - attempts to connect with the database returns a

BACKUP PENDING. SQLSTATE=57019 message

I'm using DB2 version 9.0 under 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.

 

[sathyarams]

just issue a backup command

db2 backup db <dbname> to NUL

or

db2 backup db <dbname>

Then you can change the parm to whatever you want.

db2dart also has an option for unsetting the backup pending state, but the above method is a safer one.

HTH


Sathyaram



More DB2 questions answered at

http://www.dbforums.com/db2