60 Mainstar MS/VCR: The Tool for Efficient Device Cloning
VCR11102I RENAMING VTOCIX ENTRIES ON VOLUME: DB2B02
VCR11301I 11.15.44 VVDS UPDATE STARTED FOR VOLUME: DB2B02 - PROGRAM REV=28
VCR11303I DDNAME=VDDB2B02 ALLOCATED FOR DSN=SYS1.VVDS.VDB2B02
VCR11301I 11.15.51 VVDS UPDATE COMPLETED; RETURN CODE=0
VCR11101I 11.15.51 VOLUME UPDATE COMPLETED; RETURN CODE=0 F1DSCB COUNT=192
VCR11101I 11.15.30 VOLUME UPDATE STARTED - PROGRAM REV=25
VCR11102I RENAMING VTOC ENTRIES ON VOLUME: DB2B03
VCR11102I RENAMING VTOCIX ENTRIES ON VOLUME: DB2B03
VCR11301I 11.15.39 VVDS UPDATE STARTED FOR VOLUME: DB2B03 - PROGRAM REV=28
VCR11303I DDNAME=VDDB2B03 ALLOCATED FOR DSN=SYS1.VVDS.VDB2B03
VCR11301I 11.15.41 VVDS UPDATE COMPLETED; RETURN CODE=0
VCR11101I 11.15.41 VOLUME UPDATE COMPLETED; RETURN CODE=0 F1DSCB COUNT=16
VCR11101I 11.15.30 VOLUME UPDATE STARTED - PROGRAM REV=25
VCR11102I RENAMING VTOC ENTRIES ON VOLUME: DB2B04
VCR11102I RENAMING VTOCIX ENTRIES ON VOLUME: DB2B04
VCR11301I 11.16.02 VVDS UPDATE STARTED FOR VOLUME: DB2B04 - PROGRAM REV=28
VCR11303I DDNAME=VDDB2B04 ALLOCATED FOR DSN=SYS1.VVDS.VDB2B04
VCR11301I 11.16.18 VVDS UPDATE COMPLETED; RETURN CODE=0
VCR11101I 11.16.18 VOLUME UPDATE COMPLETED; RETURN CODE=0 F1DSCB COUNT=1208
VCR14101I 11.15.32 BCS UPDATE STARTED - PROGRAM REV=33
VCR14103I DDNAME=BCS00001 ALLOCATED FOR DSN=USERCAT.DB2B
VCR14103I DDNAME=SRT00001 ALLOCATED FOR DSN=VCR.WRK.UCATBKUP.SRT00001
BCS UPDATE COUNT= 1000
VCR14122I IDCAMS WILL BE USED FOR THIS BCS
VCR14101I 11.15.56 BCS UPDATE COMPLETED; RETURN CODE=0 RECORD COUNT=1594
3.4.5 Step 5 - Execute MS/VCR DB2UPDATE command
The MS/VCR DB2UPDATE command is used to 'condition' the cloned DB2
subsystem to reflect the renamed data sets. This is accomplished with a
combination of direct DB2UPDATE modification to the DB2 directory and BSDSs
and remaining DB2 catalog changes via the DB2 SQL commands. This solution
eliminates performance and human intervention issues of a pure SQL approach,
yet allows flexibility in the desired condition of clone. This facility provides a
complete wrap-around facility for DB2, enabling the online environment to be
Chapter 3. Using MS/VCR for cloning an online DB2 subsystem 61
started with the cloned databases in the absolute minimum time and effort. If
DB2 data sharing is involved, run the MS/VCR DB2UPDT2 JCL member for each
additional DB2 member. This member makes the same changes to each
subsequent member's BSDSs as the DB2UPDATE command in the previous
step. However, it does not do any DB2 directory updates.
For more information, see the MS/VCR Installation and User Guide.
DB2UPDATE updates the following:
򐂰 The DB2 directory
򐂰 The VCATNAME in the boot strap data sets (BSDSs)
򐂰 The active log data set names in the boot strap data sets (BSDSs)
򐂰 Optionally, the archive data set names and volume serials in the BSDSs
򐂰 Optionally, the DDF parameters in the BSDSs
The MS/VCR DB2UPDATE command works with any mainframe DB2 database
environment, including SAP and PeopleSoft.
Example 3-12 illustrates a sample job for executing the DB2UPDATE command.
Example 3-12 Sample DB2UPDATE job
//DB2UPDTE JOB ,'VCR DB2 UPDATE',CLASS=A,MSGCLASS=X,
// NOTIFY=&SYSUID
//*
//S1 EXEC PGM=VCR00010,REGION=6M
//STEPLIB DD DSN=VCR.LOAD,DISP=SHR
//VCRINI DD DSN=VCR.PARMLIB(VCRINI),DISP=SHR
//VCRPRINT DD SYSOUT=*
//BSDS01 DD DSN=DB2BPROD.BSDS01,DISP=OLD
//BSDS02 DD DSN=DB2BPROD.BSDS02,DISP=OLD
//DBD01 DD DSN=DB2BPROD.DSNDBC.DSNDB01.DBD01.I0001.A001,
// DISP=OLD
//JOURNAL DD DSN=VCR.JRNL,DISP=SHR
//*YSUDUMP DD SYSOUT=*
//VCRIN DD *
DB2UPDATE -
DB2-HLQS(DB2APROD,DB2BPROD -
DB2CPROD,DB2DPROD) -
STOGROUPS(DB2ASTG,DB2BSTG) -
ARCHIVE -
JOURNAL-DDN(JOURNAL)
//*
62 Mainstar MS/VCR: The Tool for Efficient Device Cloning
SYSOUT from DB2UPDATE
The output of the DB2UPDATE command execution is shown in Example 3-13.
Example 3-13 DB2UPDATE execution output
VOLUME CONFLICT RENAME (C) MAINSTAR SOFTWARE CORPORATION, BELLEVUE, WA, USA 22 FEB 2005
16.48.57 V1.07
VCRINI INFORMATION MODULE INFORMATION OPERATING SYSTEM
REL: V1.07 REL: V1.07 z/OS 1.5
DATE: 04 NOV 2004
MAINT: 04 NOV 2004
MSC00019I Authorization - completed successfully
DB2UPDATE -
DB2-HLQS(DB2APROD,DB2BPROD -
DB2CPROD,DB2DPROD) -
STOGROUPS(DB2ASTG,DB2BSTG) -
ARCHIVE -
JOURNAL-DDN(JOURNAL)
VCR22001I 16.48.58 DB2UPDATE STARTED - PROGRAM REV=27
VCR22085I PAIRS FOR KEYWORD: DB2-HLQS
DB2APROD DB2BPROD
DB2CPROD DB2DPROD
VCR22085I PAIRS FOR KEYWORD: STOGROUPS
DB2ASTG DB2BSTG
VCR22030I OPTIONS IN EFFECT FOR THIS EXECUTION:
SIMULATION: N
VCR22101I 16.48.59 BSDS UPDATING STARTED - PROGRAM REV=26
VCR22130I PROCESSING BSDS01
VCR22130I PROCESSING BSDS02
VCR22101I 16.49.02 BSDS UPDATING COMPLETED; RETURN CODE=0
VCR22201I 16.49.02 LINEAR FILE UPDATING STARTED - PROGRAM REV=31
VCR22230I PROCESSING DDNAME: DBD01
VCR22231I THE FILE'S ENDING RBA IS: 000002949120 X'002D0000'
VCR22242I DBD01 CHANGED RECORDS: 5 CHANGED FIELDS: 27
Note: DB2UPDATE can also run with the SIMULATE option, resulting in the
modified records being printed, but no updates to the DB2 environment are
actually done.DB2UPDATE SIMULATE requires a real COPY and RENAME
run prior to the DB2UPDATE SIMULATE. DB2UPDATE SIMULATE produces
too much output for this document.

Get Mainstar MS/VCR: The Tool for Efficient Device Cloning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.