Online/Defrag options
Online/Defrag follows an iterative process to determine the option values to use for a particular database.
Each succeeding step adds to or replaces option values determined in the previous step:
- Online/Defrag builds an initial parameter table from the default values that are coded internally. The only values that are coded internally are for extracting data during the Record Analysis.
- Online/Defrag searches the Online/Defrag load module library for a global options module named DLIMPARM. If Online/Defrag finds the DLIMPARM module, it uses the values coded in that module to replace values in the initial parameter table.
- Online/Defrag uses keyword values that are coded in the control statement to replace the table options which are built in the previous steps.
The following figure represents the parameter table that Online/Defrag uses to build options during the reorganization of the database.
Online/Defrag option construction
The following table lists and describes Online/Defrag commands.
Command | Description |
|---|---|
ANALYZE | Invoke the Extractor and Recommendation Selector, and the Online/Defrag Analyzer when MODE(RECORD) is specified. |
OREORG | Perform a reorganization on the input data set. Online/Defrag does not support logical relationships. |
The following table lists and describes the keywords that you can specify in the PLUSIN control statement. Refer to the corresponding page number for more information about each keyword.
Option | Command | Accepted values | Default values | Description |
|---|---|---|---|---|
OREORG | (agnName) | None | Specify the application group name for the BMP subtask. | |
OREORG | (TIME,hhmm) (MINUTES,n) (RECORDS,n) (KEY,keyValue) | None | Specify parameters to automatically stop the online reorganization. | |
OREORG ANALYZE | (1-99) | (25) | Specify the expected percentage of block improvement to qualify a record for reorganization. | |
OREORG ANALYZE | (dbdName) not required with ANALYZE | None The DBD processed by the Extractor (ANALYZE command only) | Specify the DBD to be reorganized or analyzed. | |
OREORG | (nn,...) | (7) | Specify descriptor codes used to route messages to the console. | |
OREORG | (YES) (NO) | (NO) | Specify dynamic allocation of database data sets. | |
OREORG ANALYZE RELOAD USERLOAD REORG | (1-100) | (95) | Specify the percentage of free space to qualify a block as free. | |
OREORG ANALYZE | (rootKey) | None | Specify the root key value of records to be reorganized or analyzed. | |
OREORG ANALYZE | (1-9999) | (5) | Specify the minimum number of expected blocks to be saved per record. | |
OREORG ANALYZE | (1-9,999,999) | Variable 20% of available records | Specify the minimum number of records to reorganize or analyze. | |
OREORG | (RECORD) (SCAN) (BLOCK) | None | Specify the mode of reorganization. | |
OREORG | (nnnnnnn) | No automatic monitoring | Monitor job progress. | |
OREORG | (user01, user02,...) | Send monitor messages to TSO users and BMCMSG | Send monitor messages to up to 10 specified TSO user IDs. | |
OLRPRINT | OREORG | (ddname) | (BMCPRINT) | |
OREORG | (partNum) | None | Specify the partition to reorganize. | |
OREORG | (OKAYnnnn) (STOPnnnn) | (OKAY0004) | Specify the action to take if PDX is unavailable. | |
OREORG | (PSBNAME) | None | Specify the name of the PSB that is used for BMP. The PSB must be defined to the Online Control Region. | |
OREORG | (YES) (NO) | (NO) | Display detailed information about each record reorganized during the reorganization process. | |
OREORG | (NO) (YES) (YES, keyValue) | (NO) | Specify whether the reorganization job is a continuation. | |
OREORG | (nn,...) | (2,7) | Specify routing codes to control destination of messages sent to the console. | |
OREORG | (ssid) | None | Specify the name of the IMS system where the job reorganization subtask runs. |
The Online/Defrag Extractor offers a global options module. DLIMPARM is a load module that is assembled and link-edited during installation using the $OLRPARM macro. To set or modify default values, you must edit and reassemble DLIMPARM.
The $OLRPARM macro also includes the following options to specify for the Online/Defrag reorganization job:
- PDXDSN
- PDX
The PDXDSN option specifies the name of the PDX data set. The PDX data set is used to store a record that contains information for use when a reorganization is interrupted and later resumed. The PDXDSN value can be specified as a global option or in the //PDX DD statement. The JCL value overrides the global option value.
The PDX keyword specifies the action to take if PDXDSN is unavailable. The PDX value can be specified as a global option in $OLRPARM or in the PLUSIN control statement.
Related topic