Process 2--Gathering Information

Operations › CA IDMS/DB Reorg Processing--z/OS or OS/390 Environment › Process 2--Gathering Information

Process 2--Gathering Information

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 which follow the JCL, it is necessary to include a COPY statement for each area that is to be reorganized.

 //*            SAMPLE JCL TO OBTAIN AUDIT/ANALYSIS REPORT
 //*
 //USREORG         EXEC    PGM=USRDRVR
 //STEPLIB         DD        DSN=your.loadlib,DISP=SHR
 //                DD        DSN=idms.loadlib,DISP=SHR
 //*            CONTROL WORK FILES
 //dbmsdds         DD        DSN=work.files.dbmsdds,DISP=(,CATLG,DELETE),
 //                          VOL=SER=volser,UNIT=disk,SPACE=(number.tracks)
 //*            PRINT FILES
 //SYSLST          DD        SYSOUT=a            AUDIT REPORT
 //DBMSDUMP        DD        SYSOUT=a            USER-REQUESTED DUMP
 //SYSUDUMP        DD        SYSOUT=a            STANDARD ABEND DUMP
 //SYSPRINT        DD        SYSOUT=a            INTERNAL DD
 //DBMSOUT         DD        SYSOUT=a            INTERNAL DD
 //*            PARAMETER INPUT TO DB/REORG
 //SYSIDMS         DD *
   DMCL=
 //SYSIPT          DD        *
     PROCESS,      OLDSUB=subschema-name,
                   NEWSUB=subschema-name,
                   OLDDMCL=dmcl-name,
                   NEWDMCL=dmcl-name,
                   STOPAFTER=ANALYSIS
     COPY,         AREA=area-name

                         &invellip.

Key for Sample JCL to Obtain AUDIT/ANALYSIS Report:

Parameter	Description
your.loadlib	The dataset name of the z/OS or OS/390 PDS library into which CA IDMS/DB Reorg was installed.
idms.loadlib	The dataset name of the z/OS or OS/390 PDS library in which your CA IDMS modules reside. You must supply a separate statement for every OS/390 PDS library needed.
dbmsdds	The DDnames required by the CA IDMS/DB Reorg Utility. You must supply a DD statement for each of the control work files: CNTRL1, CNTRL2.
work.files.dbmsdds	The dataset names assigned to the control work files used by the CA IDMS/DB Reorg Utility. (It is suggested that each dataset name include the required DDNAME.)
volser	The volume serial number of the disk or tape to be use d for the control work files.
disk	An appropriate unit designation for the work file.
number.tracks	The number of tracks needed for the control work files if they reside on disk (3 cylinders on a 3350 are usually sufficient).
a	The appropriate SYSOUT class for your installation.
olddmcl	DMCL of the database prior to reorganization.
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.
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.)