Error While Restoring TSM Database

[buster99]

Hello, we would appreciate any help offered while we wait for IBM to get back to us regarding an issue we are having while restoring our TSM database from tape.
The first error is below...I can provide more details/errors, if needed...Thank you

ANR4589W The DB2 connection was lost following a database restore operation.ANR0238E A database recovery task is prohibiting activation of TSMDB1 with sqlcode -1119.

Found this message...

$ * db2start
ksh: ,REORG_ROWSCOMPRESSED: cannot execute

Then we retried...

2015-09-03-12.53.32.329193-240 I2886027A649 LEVEL: Severe
PID : 29622306 TID : 3857 PROC : db2sysc 0
INSTANCE: tsm16 NODE : 000 DB : TSMDB1
APPHDL : 0-11 APPID: *LOCAL.tsm16.150903165332
AUTHID : TSM16 HOSTNAME: uxtsmdresh2
EDUID : 3857 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr::StartUsingLocalDatabase, probe:3314
RETCODE : ZRC=0xFFFFFBA1=-1119
SQL1119N A connection to or activation of database "" cannot be made
because a previous restore is incomplete or still in progress.

 

[moon-buddy]

Have you tried rebooting to clear up the system and try the restore?

Are you doing a DR test? Or, recovering from a crash? I normally do a clean up of the LOG active and archive directories before the restore, or a remove DB routine prior to a restore.

 

[buster99]

Have you tried rebooting to clear up the system and try the restore?

Are you doing a DR test? Or, recovering from a crash? I normally do a clean up of the LOG active and archive directories before the restore, or a remove DB routine prior to a restore.

Hello Moon-Buddy, Thank you for the reply...

We did a drop db and restarted and we were good to go...so far...almost done the restore. Thanks again.