Disaster Recovery using mksysb
Unsuccessful Disaster Recovery using mksysb on latest level of IBM Spectrum Protect
After mksysb recovery, the documented IBM Spectrum Protect steps to recover are not successful.
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.
Translate this page: