Basic REORG PLUS installation options
The following table shows the options contained in the $ARUOPTS macro in $730DOP2.
For each option, the following table provides the value that ships with this version of REORG PLUS (or No value if the option is shipped without a value), a brief description, and a reference to more details. If an option ships with no value, the table shows a recommended value or example value.
Option | Shipped value | Brief description | Reference |
|---|---|---|---|
ALTRFAIL | Not applicable | Obsolete | |
ANALMAX | * | Maximum number analyze tasks to start | |
ARC | NO | Whether to use the AR/CTL interface | |
ARCHDDN | SYSARC | Default ddname for the archive data set | |
ARCHFORMAT | BMC | Default format for the archive data set | |
AUXREORG | Not applicable | Obsolete | |
AVAILPAGEPCT | 100 | Percentage of available 4-KB pages reported by the system that REORG PLUS can allocate to BMCSORT for sort processing | |
BILDMAX | 300% | Maximum number of tasks to start for the index build process | |
BMCHIST | YES | Whether to update the BMCHIST table | |
CBUFFS | 30 | Multiplier that controls the amount of buffer pool storage for each copy data set | |
CONDEXEC | NO | Whether REORG PLUS should consider performing a conditional reorganization | |
COPYDDN | (BCPY,BCPZ) | Default ddname or prefix for the local primary and secondary copy data sets | |
COPYLVL | PART | Whether to assign full or partition-level copy data sets for partitioned table spaces | |
COPYMAX | * | Maximum number of tasks to start during the image copy process | |
COPYSUBSET | NO | Whether to allow a single copy of a subset of partitions | |
CPYRFAIL | TERM | Which action to take if the image copies cannot be registered in SYSIBM.SYSCOPY | |
DATACAP | NO | Whether to turn on the Data Capture Changes flag | |
DDLDDN | DDLIN | Default ddname or prefix of the DDLIN data set | |
DEADLINE | NONE | Time by which the LOGFINAL phase should finish applying log records | |
DELAY | 1200 | Number of seconds that are to elapse from the time REORG PLUS detects a longlog condition until it performs the action specified on the LONGLOG option | |
DELFILES | YES | Whether to delete data sets on completion | |
DESCCDE | (3,7) | Descriptor codes to control how WTO messages are displayed on a console | |
DRAINTYP | ALL | Type of drain that REORG PLUS issues when it enters the LOGFINAL phase, after reaching the MAXRO threshold | |
DRNDELAY | 1 | Minimum number of seconds that REORG PLUS waits before it retries to obtain the drain after a drain times out | |
DRNRETRY | 255 | Maximum number of times that REORG PLUS attempts to obtain a drain before terminating | |
DRNWAIT | NONE | Drain timeout value to use | |
DROPPBGPARTS | YES | The system parameter REORG_DROP_PBG_PARTS setting is honored | |
DSNUEXIT | (NONE,ASM) | Name of a user exit for creating dynamically allocated data set names and the language in which the exit is written | |
DSNUTILB | YES | Whether to use DSNUTILB to run the job when a feature requires DSNUTILB | |
DSPLOCKS | DRNFAIL | Whether to display claims and locks if a drain attempt times out | |
DSRSEXIT | (NONE,REXX) | Name of a user exit for managing the redefinition of Db2 VSAM data sets and the programming language in which the exit is written | |
EXCLDUMP | (X37,X22,X06) | System codes to ignore during the dump process | |
FASTSWITCH | NO | Whether to bypass the VSAM rename process and directly update the Db2 catalog to use the staging data set names | |
FILECHK | FAIL | Which action to take when encountering a temporary data set | |
FORCE | NONE | Whether to cancel Db2 threads that might prevent a drain process from completing | |
FORCE_AT | (START,3) | When to cancel Db2 threads that might prevent the drain process from completing | |
FORCE_RPT | NO | Whether to display the canceled threads | |
FSFALLBACK | NO | Whether to perform rename processing when FASTSWITCH processing fails | |
FSTHRESHOLD | 0 | The minimum number of staging data sets that will trigger FASTSWITCH processing | |
HASHAX | Not applicable | Obsolete | |
ICDDN | (BICY,BICZ) | The ddnames or ddname prefixes for the local copy data sets that receive an incremental image copy | |
ICTYPE | AUTO | Whether to update the full image copy data sets or create incremental image copy data sets | |
IDCACHE | 10000 | Cache size of document ID values | |
INDREFLM | 10 | Limit over which REORG PLUS is to reorganize the specified table space | |
INLINECP | YES | Whether to create an inline image copy | |
INLOB | Not applicable | Obsolete | |
(SPE2010) INVALIDATECACHE | YES | Whether the SQL Statements in the Dynamic Statement Cache should be invalidated | |
IXONEX | Not applicable | Obsolete | |
IXRANDOM | Not applicable | Obsolete | |
KEEPDICTIONARY | NO | Whether to keep an existing compression dictionary or build a new one | |
LEAFDSLM | 200 | Limit over which REORG PLUS is to reorganize the index named in the reorganization | |
LOB | Not applicable | Obsolete | |
LOCKROW | YES | Serialization method for BMCSYNC and BMCUTIL | |
LOGFINAL | NONE | Time by which LOGFINAL is to start | |
LOGMEM | 0 | Amount of memory for log records | |
LOGSPIL | (20000,10000) | Space allocation for spill data sets that hold the log records | |
LOGTHRSH | 0 | Number of remaining log records | |
LONGLOG | CONTINUE | Which action to take when a long log condition occurs | |
LONGNAMETRUNC | MIDDLE (or M) | Long name truncation method for messages | |
MAPTEXIT | (NONE,REXX) | Name of a user-written mapping table exit and the language in which the exit is written | |
MAXNEWPARTS | 2 | Maximum number of partitions that can be added to partition-by-growth table spaces | |
MAXRO | 300 | Maximum number of seconds that REORG PLUS spends applying log records | |
MAXSORTMEMORY | 0 | Maximum amount of memory that REORG PLUS can allocate to each sort task | |
MAXTAPE | 3 | Maximum number of tape devices to allocate dynamically | |
MGEXTENT | CONTINUE | How to allocate extents when extending to a new data set | |
MINSORTMEMORY | 0 | Minimum amount of memory that REORG PLUS should allocate to each sort task | |
MSGLEVEL | 1 | Default for the message level execution parameter | |
OFFPOSLM | 10 | OFFPOS limit for table space reorganizations | |
OPNDB2ID | YES | Whether to use the user’s RACF ID instead of the Db2 RACF ID | |
ORIGDISP | DELETE | Disposition of original data set during staging data set renaming process | |
PENDDDL | Not applicable | Obsolete | |
PLAN | ARU1120 | Product plan name | |
PREFORMAT | NO | Whether to preformat unused data set pages | |
RCVICDDN | (BIRY,BIRZ) | The ddnames or ddname prefixes for the remote copy data sets that receive an incremental image copy | |
RCVYDDN | (BRCY,BRCZ) | The ddnames or ddname prefixes for the remote copy data sets that receive a full image copy | |
REDEFINE | YES | Whether to delete and redefine the VSAM data sets for the table space or index space as part of the reorganization | |
RENMMAX | 30 | Maximum number of tasks to start during the staging data set rename and delete process | |
RIDMDSSZ | 2097152 | Maximum data space size for RID maps | |
RIDMMAXD | 1 | Number of data spaces for RID maps | |
RMAPMEM | 0 | Amount of memory for RID maps | |
RORGMAX | 300% | Maximum number of tasks to start for the REORG phase | |
ROUTCDE | (11,1) | WTO console routing codes | |
SCPYMAX | 8 | Maximum number of tasks to start during the nonpartitioned index copy process | |
SDUMP | (ALLPSA,CSA,RGN,SQA,LSQA,SUM,TRT,IO) | System dump parameters | |
SHORTMEMORY | CONTINUE | Which action to take when a memory shortage exists | |
SIXSNAP | NO | Whether to use the Instant Snapshot technology of SUF or XBM to create a copy of storage-group-defined nonpartitioned indexes | |
SMAX | 0 | Maximum number of sort processes to invoke concurrently | |
SMCORE | (0K,0K) | Maximum amount of sort memory | |
SORTDEVT | (,SYSALLDA) | Sort device types | |
SORTNUM | 32 | Number of sort work files per sort task for BMCSORT to allocate dynamically | |
SPILDSNP | &&UID | Pattern for spill data set name prefix | |
SPILSCLS | NONE | SMS storage class for spill data sets | |
SPILUNIT | WORK | DASD unit for spill data sets | |
SQLDELAY | 3 | Number of seconds between retry attempts after SQLCODE -911 | |
SQLRETRY | 100 | Number of retry attempts after SQLCODE -911 | |
STAGEDSN | BMC | Naming convention to use for staging data sets | |
STOP@CMT | YES | Whether to add the 'AT (COMMIT)' parameter to all Db2 STOP commands that REORG PLUS issues | |
STOPDELAY | 1 | Number of seconds between checking to determine whether Db2 has stopped the object | |
STOPRETRY | 300 | Number of times to check to determine whether Db2 has stopped the object | |
TAPEDISP | DELETE | Tape file disposition | |
TASKMAX | 1000% | Global maximum number of tasks to start | |
TERMEXIT | (NONE,REXX) | Name of user-written TERM exit and the language in which the exit is written | |
TIMEOUT | TERM | Which action to take when a drain attempt times out | |
TOTALPAGEPCT | 0 | Percentage of total 4-KB pages reported by the system that REORG PLUS can allocate to BMCSORT for sort processing | |
TSSAMPLEPCT | 100 | Percentage of sampling to perform during statistics gathering | |
UBUFFS | 20 | Multiplier that controls the amount of buffer pool storage for unload data sets | |
UNLDDN | SYSREC | Default ddname or ddname prefix for the output data set that contains the unloaded rows to be reorganized | |
UNLDMAX | 300% | Maximum number of unload tasks to start | |
UNLOAD | RELOAD | Whether to use single- or two-phase processing | |
UTILB_COLCCSID | Not applicable | Obsolete | |
UTILB_NULLIX | Not applicable | Obsolete | |
UXSTATE | SUP | How to invoke Db2 user exits | |
WBUFFS | (20,10) | Multiplier that controls the amount of buffer pool storage for each work data set | |
WORKDDN | SYSUT1 | Default ddname or ddname prefix for the index work data set | |
WORKUNIT | SYSALLDA | Temporary unit for work data sets | |
WRLOG (PTF BQU2911 applied) | NO | Whether to write Db2 diagnostic log records to indicate that a refresh is required for replicated objects | |
XBMID | No value example value: XBMA | XBM subsystem that REORG PLUS accesses when it uses XBM or SUF | |
ZIIP | ENABLED | Whether to enable zIIP processing |
Related topic