Control statements for the Smart Reorg Driver
The control statement block for the Smart Reorg Driver contains user specifications for controlling the processes of the Smart Reorg Driver and the Parallel Reorganization Service.
The control statement block for the Smart Reorg
Driver starts with a line that specifies the block name (REORG). The control statements for the
(REORG) block are categorized as follows:
Conditional reorganization
Use the following control statement keywords to enable and control conditional reorganization.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| CONDREORG | YES YES,REORGDIAG YES,DIAGONLY NO |
NO | Specifies whether to enable the Conditional Reorganization Support Service. See CONDREORG control statement. |
| CRIC | COND ALWAYS |
None | Specifies to create image copies of all database data sets or HALDB partitions even when the Conditional Reorganization Support Service (CRSS) determines that reorganization of the entire database or some partitions are not needed. See CRIC control statement. |
| CRUNLOAD | COND ALWAYS |
None | Specifies to create an unload data set that contains data from the database or HALDB partitions. You can choose to create an unload data set only when the Conditional Reorganization Support Service (CRSS) determines that reorganization is needed or every time the job is run (regardless of whether reorganization is needed). See CRUNLOAD control statement. |
| RC_CHANGE | NONE (event_name,n) n=1 - 99 |
NONE | Specifies the return code that the Smart Reorg utility returns when a specific event is detected by the Conditional Reorganization Support Service. See RC_CHANGE control statement. |
Integration with IMS Tools Base
Use the following control statement keywords to enable the features provided by IMS Tools Base.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| ADDBGRP | dbgrpname or *NO | *NO | Specifies the database group name defined to Autonomics Director. See ADDBGRP control statement. |
| ADXCFGRP | xcfgrpname or *NO | *NO | Specifies the XCF group name of the Autonomics Director server. See ADXCFGRP control statement. |
| ITKBDATA | UTILHIST or *NO | *NO | Specifies the type of additional data to store in the IMS Tools KB repository. See ITKBDATA control statement. |
| ITKBLOAD | libname or *NO | *NO | Specifies the library name of IMS Tools KB. See ITKBLOAD control statement. |
| ITKBSRVR | servername servername,ERRC04 *NO |
*NO | Specifies the name of the IMS Tools KB server XCF group. See ITKBSRVR control statement. |
| TOSITEST | (max,interval) | (1,1) | Specifies the maximum number of attempts and the interval time for Reorganization Manager to verify whether the database is being used. See TOSITEST control statement. |
| TOSIWAIT | 0 - 9999 | 300 | Specifies the IMS Tools Online System Interface response timeout value in seconds. See TOSIWAIT control statement. |
| TOSIXCFGRP | grpname | None | Specifies the XCF group name that IMS Tools Online System Interface uses. See TOSIXCFGRP control statement. |
| ZIIPMODE | COND or NEVER | NEVER | Specifies whether to offload eligible workloads to zIIP processors. See ZIIPMODE control statement. |
Reorganization process control
Use the following control statement keywords to control the reorganization process.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| DALUNIT | group_name or device_type | SYSALLDA | Specifies the device on which dynamic allocation allocates temporary data sets. You can specify a group name or device type. See DALUNIT control statement. |
| HPIO | YES or NO | None | Specifies whether to use the High Performance I/O Driver in all subtasks that support it. See HPIO control statement. |
| IC | YES or NO | NO | Specifies whether to generate image copies of the reorganized database. See IC control statement. |
| ICTYPE | A or B | A | Specifies the type of Image Copy processing. See ICTYPE control statement. |
| INDEXBLD | NO YES,CURRENT YES,NEW |
NO | Specifies whether to rebuild all secondary indexes for the database in the Smart Reorg utility job step. See INDEXBLD control statement. |
| NEWDBD | ddname | None | Specifies the DD name for the new DBD library. Use this control statement keyword if you want to change the DBD during reorganization. See NEWDBD control statement. |
| PREFIXRES | YES or NO | NO | Specifies whether to do prefix resolution and prefix update to resolve internal logical relationships of non-HALDB database. See PREFIXRES control statement. |
| REORGINPUT | DBDS or ULDS | DBDS | Specifies the type of input data sets for reorganization processing. You can request the utility to unload data from input database data sets or supply unloaded data sets. See REORGINPUT control statement. |
| UNLOADONLY | YES or NO | NO | Specifies to run only the Unload task to create an unload data set without reorganizing the database. See UNLOADONLY control statement. |
HALDB reorganization
Use the following additional control statement keywords when you reorganize a HALDB.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| ILDSBLD | YES,COND YES,DSPR YES,INITONLY NO |
YES,COND | Specifies whether to build Indirect List data sets (ILDSs) during reorganization. See ILDSBLD control statement. |
| PARTITION | (partname,num) or *ALL | *ALL | Specifies the HALDB partitions to reorganize. See PARTITION control statement. |
| PSINDEXBLD | NO YES,CURRENT YES,NEW |
NO | Specifies whether to rebuild all partitioned secondary indexes for the database in the Smart Reorg utility job step. See PSINDEXBLD control statement. |
Input and output database data sets
Use the following control statement keywords to control input and output for database data sets; DASD space allocation for shadow data sets, dynamic allocation, name swapping, and so on.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| DDNMAP | (original_dd,shadow_dd) | (%%%-----, TMP-----) | Specifies DD names for shadow data sets. See DDNMAP control statement. |
| DELOLDDS | YES or NO | NO | Specifies to delete original input database data sets after successful reorganization. See DELOLDDS control statement. |
| DISPOLDDS | DELETE NEWSHADOW TEMPNAME |
TEMPNAME | Specifies the disposition of original input database data sets after successful reorganization. See DISPOLDDS control statement. |
| DYNALLOC | (a,b,c),x or d,x
Each of a, b, c, and d is either YES or NO |
YES,Z | Specifies dynamic allocation of input database data sets, shadow database data sets, and index data sets. See DYNALLOC control statement. |
| NAMESWAP | YES or NO | NO | Specifies to perform post-reorganization processing (data set name swapping and DBRC notification) after successful reorganization. See NAMESWAP control statement. |
| SINDEXSUF | YES or NO | NO | Specifies whether each shadow index has the name of the original index with a suffix character at the end. See SINDEXSUF control statement. |
| SPACEALLOC | YES NO YES,FORCE |
NO | Specifies whether to allocate DASD space for each shadow data set within the Smart Reorg utility job step. See SPACEALLOC control statement. |
Database access and state
Use the following control statement keywords to change the database access allowed during the reorganization and the database state after the reorganization. The Smart Reorg utility issues DBRC commands to change database access and IMS commands to change database state.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| DBRCAUTHCMD | YES or NO | NO | Specifies whether the Smart Reorg utility issues a CHANGE.DB READON or a CHANGE.DB NOAUTH command at the beginning of reorganization and a CHANGE.DB NOAUTH command before name swapping. See DBRCAUTHCMD control statement. |
| DBSHARE | YES or NO | NO if DBRC is active. No default if DBRC is not active. | Specifies whether to allow read-only access to the database while it is being reorganized. See DBSHARE control statement. |
| ICNEEDED | ON or OFF | If DBRC is active,
No default if DBRC is not active. |
Specifies whether the DBRC ICNEEDED flag is turned on after name swapping. See ICNEEDED control statement. |
| IMSCMD | NO YES,EMCS YES,TOSI |
NO | Specifies whether the Smart Reorg utility issues a /DBR or /DBD command at the beginning of reorganization and a /DBR command before name swapping. See IMSCMD control statement. |
| IMSCMDOPT | a,b a=ALL, DBD, DBR, or STA b=LOCAL or GLOBAL |
None | Specifies the option parameters for the IMS commands that IMS Tools Online System Interface issues. See IMSCMDOPT control statement. |
| LASTAUTHFLAG | OFF or ORIGINAL | OFF if DBRC is active. No default if DBRC is not active. |
Specifies the state of the READ ONLY flag and the PROHIBIT AUTHORIZATION flag in RECON after post-reorganization processing ends. See LASTAUTHFLAG control statement. |
| STARTDB | YES or NO | NO | Specifies whether to start the database after the completion of post-reorganization processing. See STARTDB control statement. |
Reports
Use the following control statement keywords to generate additional reports.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| DECODEDBD | (a,b) or c
Each of a, b, and c is either YES or NO |
NO | Specifies whether to decode the original and new DBDs and print the resulting DBD source statements in reports. See DECODEDBD control statement. |
| DECODESXD | (a,b) or c
Each of a, b, and c is either YES or NO |
NO | Specifies whether to decode secondary index DBDs related to the original and new DBDs and print the resulting DBD source statements in reports. See DECODESXD control statement. |
| STATRL | YES or NO | NO | Specifies whether the Reload task generates detailed database statistics reports in the HPSSTAT data set. See STATRL control statement. |
| STATUL | YES or NO | NO | Specifies whether the Unload task generates detailed database statistics reports in the HPSLIST data set. See STATUL control statement. |
IPRPIPE
Use the following control statement keywords to tune IPRPIPE. It is recommended that you use default values unless you need to use specific values.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| PIPEBLKSZ | (a,b) a=1024 - 65536, b=1 or 2 |
(32768,1) and (32768,2) | Specifies how many records can be moved to or from the pipe at one time. See PIPEBLKSZ control statement. |
| PIPEDEPTH | (a,b) a=2 - 32767, b=1 or 2 |
(62,1) and (62,2) | Specifies the number of blocks that can be in the pipe at any given time before the pipe becomes full. See PIPEDEPTH control statement. |
| PIPEWAIT |
(a,b),x, or a,x a=1 - 1440, b=1 or 2, x=RDWR or OPEN |
(15,1),RDWR (0.5,1),OPEN (15,2),RDWR (0.5,2),OPEN |
Specifies the amount of time a writer or reader of a pipe can remain in a wait state before the Smart Reorg Driver issues a message and abends. See PIPEWAIT control statement. |
Error handling
Use the following control statement keywords to control the behavior of the utility when the process fails.
| Keyword | Acceptable values | Default | Description |
|---|---|---|---|
| AUTHFAIL | WTOR or ABORT | ABORT if DBRC is active. No default if DBRC is not active. |
Specifies the action the Smart Reorg utility takes when DBRC authorization fails during initialization processing and before name swapping. See AUTHFAIL control statement. |
| NAMESWAPFAIL | WTOR ABORT BACKOUT |
ABORT | Specifies the action taken in case a name swapping error occurs. See NAMESWAPFAIL control statement. |