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

[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

[prithvirajr]

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