Troubleshooting
Problem
Unsuccessful Disaster Recovery using mksysb on latest level of IBM Spectrum Protect
Symptom
After mksysb recovery, the documented IBM Spectrum Protect steps to recover are not successful.
Cause
When the database was backed up by mksysb, DB2 was in active mode and there were in-flight transactions. This will cause unpredictable results.
Resolving The Problem
The following DB2 command can be used to pause the database before the mksysb gathers the needed data. After the DB is suspended, then run mksysb. Once the mksysb has competed, then Resume the database.
The full DB2 documentation link is provided below.
Example- To suspend the DB activity, do these commands from the instance user:
db2 connect to tsmdb1
SET WRITE SUSPEND FOR tsmdb1
Run mksysb. Once done:
SET WRITE RESUME FOR tsmdb1
See full details in the DB2 documentation link below.
With the stable mksysb backup, the normal process of DR or DRM recovery can then be followed.
Related Information
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22007294