Record mode JCL


The figure in this topic shows sample JCL for a reorganization when MODE(RECORD) is specified.

For a complete explanation of the Online/Defrag Record Analysis, see Online-Defrag-Record-Analysis.

//********************************************************************//*
  ONLINE REORG JCL FOR A DATABASE USING MODE(RECORD)
//********************************************************************
//*
//BMCOLR   EXEC PGM=BMCOLR
//STEPLIB  DD DISP=SHR,DSN=load.dataSet
//         DD DISP=SHR, DSN=mdalib.dataSet
//         DD DISP=SHR,DSN=steplib.dataSet
//DFSRESLB DD DISP=SHR,DSN=dfs.dataSet
//IMS      DD DISP=SHR,DSN=ims.dataSet
//OLRKEYS  DD DISP=SHR,DSN=DBU.HSR.KEYLIST <== KEYS FROM ANALYZE STEP
//RECON1   DD DISP=SHR,DSN=recon1.dataSet
//RECON2   DD DISP=SHR,DSN=recon2.dataSet
//RECON3   DD DISP=SHR,DSN=recon3.dataSet
//BMCMSG   DD SYSOUT=*
//BMCPRINT DD SYSOUT=*
//BMCTRACE DD SYSOUT=*
//PLUSIN   DD *
 OREORG    MONITOR(060) DBD(DATABASE) PSB(PSBNAME)    +
           SSID(IMSID) DYNALLOC(Y) FSPF(10) BIPF(01)  +
           KEYS(DBRECORDKEY1,DBRECORDKEY2)            +
           MODE(RECORD)
//*

For DD statement descriptions, see JCL requirements—online reorganization. The PLUSIN control statement specifies the reorganization parameters:

OREORG DBD(DATABASE) DYNALLOC(Y) MODE(RECORD)-
KEYS(DBRECORDKEY1,DBRECORDKEY2)
BIPF(90) FSPF(100)

Dynamic allocation is specified, which requires that the primary database be registered in the RECON.

MODE(RECORD) requires an OLRKEYS DD statement or the KEYS keyword. The OLRKEYS DD statement defines the data set produced by the Online/Defrag Record Analysis. The KEYS keyword defines a hard-coded list of record keys. The record keys defined in the KEYS keyword identify records to be reorganized. If KEYS and OLRKEYS are specified, Online/Defrag processes the records that are specified in KEYS, then the records that are specified in OLRKEYS.

The BIPF keyword value is 90. The analysis identifies only those records that can be improved by 90 percent. For example, a record that spans 100 blocks must be capable of being reduced to 10 blocks. If the record cannot meet the specified percentage, the record is not recommended for reorganization.

The MBI keyword was not specified; therefore, the default value (5) is used. If a record cannot be reduced by at least 5 blocks, it is not be recommended for reorganization.

The FSPF keyword value is 100. Online/Defrag determines database blocks as available or not available, based on the FSPF value. If a block is not at least 100 percent free, it is not identified as available.


 

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