Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 28, 2017 at 10:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded