IBM Support

Disaster Recovery using mksysb

Technote (troubleshooting)


Problem(Abstract)

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

Set Write command V10.5
DRM

Document information

More support for: IBM Spectrum Protect
Server

Software version: Version Independent

Operating system(s): AIX

Reference #: 2007294

Modified date: 28 August 2017


Translate this page: