Retrieving data from the DR site
Disaster recovery estimations and simulations are performed at the local site, and historical data is immediately stored in the data collection tables. Data about actual disaster recoveries is collected at the disaster recovery site and must be returned to the local site. The disaster recovery JCL that you use at the remote site contains statements that call
BMC AMI Log Master for Db2
.
Log Master
generates output that you can then use to insert the information into the data collection tables at the local site.
Log Master gathers data from the recovery from the log records, then stores SQL INSERT statements in a flat file that you can use to populate the data collection tables at your local site.
By default,Log Master names the flat file userId.BMCARMDC.D date.T time.MIGSQL. You should take this file back to your local site and use it as input to the BMC High-speed Apply Engine (formerly Apply Plus) or to an SQL processor such as DSNTEP2. This file contains DELETE and INSERT SQL statements.
The following is a sample of the JCL used to retrieve the data from the recovery site:
// REGION=0M,COND=(4,LT)
//STEPLIB DD DISP=SHR,DSN=SYS2.DB2V91M.DSNLOAD
// DD DISP=SHR,DSN=SYS3.DEBN.DSNEXIT
// DD DISP=SHR,DSN=BMCRMD.TEST.LOAD
//ALPPRINT DD SYSOUT=*
//SQLPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSERR DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *,DLM=##
LOGSCAN
REPORT TYPE SUMMARY
SYSOUT
CLASS(*) NOHOLD
SQL
MIGRATE
DATASET &SYSUID..BMCARMDC.D&DATE..T&TIME..MIGSQL NEW
CYLINDERS SPACE(1,1) UNIT(SYSALLDA) RELEASE
DB2CATALOG NO
FROM RBA X'000865B1FFFF'
TO CURRENT
WHERE
TABLESPACE NAME = 'BMCARM.BMCESTM'
Related topic