Process 4--Reorganizing the Database

Operations › CA IDMS/DB Reorg Processing--z/OS or OS/390 Environment › Process 4--Reorganizing the Database

Process 4--Reorganizing the Database

This process reorganizes the database by executing the reorganization process of CA IDMS/DB Reorg as one z/OS or OS/390 job step.

 //*            SAMPLE JCL TO REORGANIZE A DATABASE
 //*
 //USREORG         EXEC    PGM=USRDRVR
 //STEPLIB         DD    DSN=your.loadlib,DISP=SHR
                   DD    DSN=idms.loadlib,DISP=SHR
 //*
 //*            YOUR DATABASE FILES
 //dbfil01  DD  DSN=user.dbfil01,DISP=SHR
 .
 :
 //dbfilnn         DD    DSN=user.dbfilnn,DISP=SHR 
 //*
 //*            SORT WORK FILES
 //SORTLIB         DD    DSN=your.sortlib,DISP=SHR
 //sortwknn        DD    UNIT=disk,SPACE=(CYL,(sort.space))
 //*  //*            WORK FILES
 //PAGUTIL         DD    DSN=vsam.work.file,vsam-buffer,DISP=SHR
 //dbmsdds         DD    DSN=work.files.dbmsdds,DISP=SHR
 //*
 //*            PRINT FILES
 //SYSLST          DD    SYSOUT=a            AUDIT REPORT
 //DBMSDUMP        DD    SYSOUT=a            USER-REQUESTED DUMP
 //SYSUDUMP        DD    SYSOUT=a            STANDARD ABEND DUMP
 //SORTMSG         DD    SYSOUT=a            SORT MESSAGE OUTPUT
 //SYSPRINT        DD    SYSOUT=a            DBMS INTERNAL DD
 //DBMSOUT         DD    SYSOUT=a            DBMS INTERNAL DD
 //*
 //*            PARAMETER INPUT TO DB/REORG
 //SYSIDMS         DD *    DMCL=newdmcl
 //SYSIPT          DD    * 
PROCESS,                 OLDSUB=subschema-name,
                                 NEWSUB=subschema-name,
                                 OLDDMCL=dmcl-name,
                                 NEWDMCL=dmcl-name,
                                 RESTART=NEXT  /*

Key for Sample JCL to Reorganize a Database:

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 subschema(s) and DMCL(s) reside. You must supply a separate statement for every OS/390 PDS library needed.
dbfil01 /dbfilnn	The DDnames of the database files to be accessed.
user.dbfil01 /user.dbfilnn	The dataset name of the file accessed by either the old subschema or the new subschema. You must supply a separate statement for every file that contains, or has set linkage with, an area named in a COPY statement.
your.sortlib	The dataset name of the z/OS or OS/390 PDS library in which your sort modules reside. (Your environment may not require this DD statement.)
sortwknn	The DDnames of the sort files. You must supply a separate statement for every sort file needed.
disk	The appropriate unit designation for your sort files.
sort.space	The space calculated on sort input needs if sort files are on disk.
vsam.work.file	The dataset name of the one VSAM file to be used by CA IDMS/DB Reorg. (Refer to the appropriate JCL in Process 3--Allocating Work Files if you prefer to use BDAM for this file.)
vsam-buffer	As a default, CA IDMS/DB Reorg allocates 10 buffers to process the VSAM PAGUTIL file. To override this, code AMP=BUFND=number-of-component-buffers. The space required for these buffers must be available below the line. The maximum number of buffers that can be useful is equal to the number of pages in the largest COPY area divided by 1020.
dbmsdds	The DDnames required by the CA IDMS/DB Reorg Utility. You must supply a DD statement for each of these work files: CNTRL1, CNTRL2, PRIOPTA, SECOPTA, EXTRACT, PRIREAL, UNALLOC, SECREAL, ALLOCX, SECALX2, SECIIX2, and DBREC. If CA IDMS/DB Reorg is reorganizing an index set sorted by db-key, or an area containing integrated index sets sorted by db-key, you must include IIXEXOL, IIXSRKY, and IIXEXTR.
work.files.dbmsdds	The dataset names assigned to the work files used by the DB/REORG Utility. (It is suggested that each dataset name include the required DDNAME.)
a	The appropriate SYSOUT class for your installation.
newdmcl	DMCL describing the database after the 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.