Skip to Content
0

"Table Space Operational State" is in state "Restore pending" db2 restore

Sep 28, 2017 at 10:04 AM

143

avatar image
Former Member

Hi everyone,

During a DB2 database restore, we are getting the below error:

FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500 MESSAGE : ADM10502W Health indicator "Table Space Operational State" ("ts.ts_op_status") is in state "Restore pending" on "table space" "db2mev.MEV .SYSTOOLSTMPSPACE".

SQL1119N A connection to or activation of database "" cannot be made because a previous restore is incomplete or still in progress.

in db2diag.log file and the restore is stuck.

If anyone knows the solution for this error. Please post here.

Thanks and Regards,

Bhupesh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prithviraj Rajpurohit Sep 28, 2017 at 10:50 AM
0

Hi

Please try below steps to see if they help

1. Disconnect all applications that are connected: db2 FORCE APPLICATION ALL

2. Deactivate the database: db2 deactivate database SID

3. Repeat the restore: db2 RESTORE DB SID FROM RESTORE_FILE_PATH TAKEN AT BACKUP_TIMESTAMP WITHOUT PROMPTING

4. Reactivate the database: db2 activate database SID

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded