Process 2--Information Gathering

Operations › CA IDMS/DB Reorg Processing--VSE/ESA Environment › Process 2--Information Gathering

Process 2--Information Gathering

This process gathers the information needed to determine the best strategy for a database reorganization. It initiates CA IDMS/DB Reorg, examines user parameters and subschemas, stops CA IDMS/DB Reorg after the ANALYSIS step, and produces the Audit/Analysis Report. In the control parameters that follow the JCL it is necessary to include a COPY statement for each area that is to be reorganized.

 // JOB DBREORG1
 // OPTION LOG,PARTDUMP
 *
 *    LIBRARY DEFINITIONS
 *
 // DLBL   DBMS,'your.loadlib'
 // EXTENT ,volser
 // DLBL   IDMS,'idms.loadlib'
 // EXTENT ,volser
 // LIBDEF *,SEARCH=(DBMS.sublib,IDMS.sublib)
 *
 * CONTROL WORK FILES
 *      THE NEXT FILES ARE CREATED IN THIS STEP AND USED
 *      THROUGHOUT THE REMAINDER OF THE PRODUCT. IT IS SUGGESTED
 *      THAT THE ACCOMPANYING SECTION ON FILE CREATION BE CONSULTED
 *      IF THE USER WISHES TO ASSIGN THE FILES TO DISK.
 *      DBMSNMS SHOULD BE "CNTRL1" AND "CNTRL2".
 *
 // DLBL   DBMSNMS,'WORK.FILES.dbmsnms',0,SD
 // EXTENT SYSnnn
 // ASSGN  SYSnnn,DISK,VOL=volser,SHR
 *
 *    CA INTERNAL FILES
 *
 // ASSGN  SYS012,SYSLST
 // ASSGN  SYS013,SYSLST
 *
 *    PARAMETER INPUT TO DB/REORG
 *
 // DLBL SYSIDMS,'#SYSIPT',0,SD
 // EXEC   USRDRVR,SIZE=(USRDRVR,#K)
 *
 * SYSIDMS PARAMETERS
 *INCLUDE DMCL=olddmcl
 /*
 *   -----------------------------------------------
 *          --- DB/REORG CONTROL CARDS ---
 *   -----------------------------------------------
 *        CONTROL CARD FORMAT IS FREE FORM. COMMENTS ARE INDICATED BY
 *        AN ASTERISK IN COLUMN 1. THE PROCESS STATEMENT CONSISTING OF
 *        AT LEAST THE OLDSUBSCHEMA AND NEWSUBSCHEMA PARAMETERS MUST BE
 *        INCLUDED FOR THIS INITIAL RUN, AS WELL AS AT LEAST ONE COPY
 *        STATEMENT.
 *
 PROCESS,  OLDSUB=subschema-name,
           NEWSUB=subschema-name,
           OLDDMCL=dmcl-name,
           NEWDMCL=dmcl-name,
           OLDDBN=db-name,
           NEWDBN=db-name,
           STOPAFTER=ANALYSIS
 COPY,     AREA=area-name

           &invellip.

/* * $$ EOJ

Key for Sample JCL to Obtain AUDIT/ANALYSIS Report:

Parameter	Description
your.loadlib	The data set name of the core image library into which you download CA IDMS/DB Reorg.
volser	The volume serial number or the generic assignment of the disk volume on which the file, specified in the preceding DLBL statement, resides.
SYSnnn	The programmer logical units of the database files to be accessed.
idms.loadlib	The data set name of the core image library in which your DMCL and subschema reside.
dbms.sublib /idms.sublib	The sublibrary name of the VSE/ESA library specified in the previous file name.
olddmcl	The DMCL of the old database, before it is reorganized.
subschema-name	Two subschema names are required. The first subschema name (OLDSUB=) describes the database before reorganization. The second subschema name (NEWSUB=) describes the database after reorganization.
dmcl-name	Two DMCL names are required. The first DMCL name (OLDDMCL=) describes the database before reorganization. The second DMCL name (NEWDMCL=) describes the database after reorganization.
db-name	Two db-names are optional. The first db-name (OLDDBN=) describes the database before reorganization. The second db-name name (NEWDBN=) describes the database after reorganization.
area-name	The name of an area to be reorganized by CA IDMS/DB Reorg. (You must include a COPY parameter statement for each area that is to be reorganized.)