Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Related topic

Disaster-recovery-data-collection

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:

//ARMD0013  EXEC PGM=ALPMAIN,PARM='DEBN',
//    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'

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Recovery Management for Db2 13.1