Basic REORG PLUS installation options
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 for more details. If an option ships with no value, the table shows a recommended value or example value.
Option | Shipped value | Brief description | Reference |
|---|---|---|---|
AMISWITCH | NO | Enable LOB support via BMC AMI Reorg for Db2 | AMISWITCH=NO |
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 | |
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 | |
BMCSYSADM | No value | Sets the AUTHID to use for dynamic binds | |
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 | |
COPYPBGSIZE | HURBA | Dynamically allocates PBG SYSCOPY data sets | |
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 | |
ENBLUTXX | NO | Whether the object is set to restrictive status while being reorganized | |
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 | |
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 | |
INVALIDATECACHE
| YES | Whether the SQL Statements in the Dynamic Statement Cache should be invalidated | |
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 | |
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 | |
NEWFUNC | COMPAT | Determines whether the REORG PLUS should use BMCSORT or AMISORT for sorting. | |
OFFPOSLM | 10 | OFFPOS limit for table space reorganizations | |
OPNDB2ID | YES | Whether to use the Db2 DBM1 user ID instead of the submitting user ID | |
ORIGDISP | DELETE | Disposition of original data set during staging data set renaming process | |
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 | |
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 | NO | Whether to write Db2 diagnostic log records to indicate that a refresh is required for replicated objects | |
WRLOGDICT | NO | Whether to write Db2 diagnostic log records containing saved updated compression dictionaries. | |
| WRLOGID (BMC.DB2.SPE2507) | No value | Specifies the authorized user ID used for DSNUTILB REPAIR WRITELOG. | WRLOGID= |
XBMID | No value example value: XBMA | XBMsubsystem that REORG PLUS accesses when it uses XBM or SUF | |
ZIIP | ENABLED | Whether to enable zIIP processing |