Basic installation options
This topic lists the options contained in the $AMUOPTS macro in $730DOP2.
For each option, the following table provides the value that ships with this version of LOADPLUS (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 |
|---|---|---|---|
APCOLLECTION | No value Example value: APTAB6S | Default collection ID for SQLAPPLY load jobs | |
APCOMMIT | 2500 | Number of records between commits for SQLAPPLY load jobs | |
APDOPTS | No value | For future use | |
APMULTIROW | 100 | Number of rows inserted during a single insert action for SQLAPPLY load jobs | |
APMXAGNT | 10 | Maximum number of agents to start for SQLAPPLY load jobs | |
APOWNER | No value Example value: RDAMZL | Default authorization ID to use to bind the Db2 plan and packages for SQPLAPPLY load jobs | |
APRETLIM | COUNT | Type of retry to use after a SQL error during apply processing (in conjunction with APRETVAL) | |
APRETVAL | 5 | Value of the type of retry to use after a SQL error during apply processing (in conjunction with APRETLIM) | |
AUTOENUMROWS | YES | Whether to enable automated file size estimation | |
AVAILPAGEPCT | 0 | Percentage of available 4-KB pages that the system reports and that LOADPLUS can allocate to BMCSORT for sort processing | |
CBUFFS | 30 | Multiplier that controls the amount of buffer pool storage for each copy data set | |
CENTURY | (1950,2049) | Century specification for two-digit years | |
CHEKPEND | (YES,) | Whether to set CHECK pending when needed | |
COPYDDN | (BMCCPY,BMCCPZ) | Default ddname or prefix for local primary and secondary copy data sets | |
COPYLVL | FULL | How to dynamically allocate copy data sets for partitioned table spaces | |
COPYPEND | (YES,) | Whether to set COPY pending when needed | |
COPYSUBSET | NO | Whether to allow a single copy of a subset of partitions | |
DELFILES | (YES,NO) | Whether to delete work files on completion | |
DISCARDLIMRC | 8 | Return code to assign when the discard limit is reached | |
DISCARDRC | 0 | Return code to assign on successful job completion when there are discards | |
DISCDDN | SYSDISC | Default ddname for the discard data set | |
DRNDELAY | 1 | Minimum number of seconds to wait before the next attempt to obtain a drain | |
DRNRETRY | 255 | Maximum number of times to attempt to obtain a drain before terminating | |
DRNWAIT | NONE | Timeout value for object drains | |
DSNUEXIT | (NONE,ASM) | Name of the user exit for creating dynamically allocated data set names, and the language it is written | |
DSNUTILB | YES | Whether to use DSNUTILB to process the load job when a feature requires it | |
ENFORCE | CHECK | Whether to check Db2-defined constraints | |
ERRDDN | SYSERR | Default ddname for the error data set | |
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 work file | |
FILEVAR | Not applicable | Obsolete | |
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 a report of the canceled threads | |
HASHAX | Not applicable | Obsolete | |
HISTORY | YES | Whether to update the BMCHIST table when the load is successfully completed | |
IBUFFS | 20 | Multiplier that controls the amount of buffer pool storage for each input data set | |
IDCACHE | 1000 | Cache size of identity column numbers | |
IDCDDN | SYSIDCIN | Default ddname for the data set that contains IDCAMS commands | |
IDERROR | DISCARD | Which action to take when encountering an error on the identity column range | |
INDDN | SYSREC | Default ddname or prefix for input data sets | |
INFORI | NO | Whether to enforce informational referential constraints | |
INLINECP | YES | Whether to create an inline image copy | |
INLOB | Not applicable | Obsolete | |
INVALIDATECACHE (SPE2010) | 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 | |
LBUFFS | 20 | Multiplier that controls the amount of buffer pool storage for each load data set | |
LOADDN | SORTOUT | Default ddname or prefix for load data sets | |
LOB | Not applicable | Obsolete | |
LOBAVGPCT | 50 | Estimate of the percentage of the maximum size defined for the LOB | |
LOCKROW | YES | Serialization method for BMCSYNC and BMCUTIL | |
LONGNAMETRUNC | MIDDLE (or M) | Long name truncation method for messages | |
MAPDDN | SYSMAP | Default ddname for the mapping data set for a DSNUTILB load | |
MAXP | 5 | Maximum number of partitions to load concurrently | |
MAXSORTMEMORY | 0 | Maximum amount of memory to allocate to each sort task | |
MAXTAPE | 3 | Maximum number of tape units to allocate dynamically | |
MGEXTENT | CONTINUE | How to allocate extents when extending to a new data set | |
MINSORTMEMORY | 0 | Minimum amount of memory to allocate to each sort task | |
MSGLEVEL | 1 | Default for the message-level execution parameter | |
OPNDB2ID | YES | Whether to use the user’s RACF ID instead of the Db2 RACF ID | |
ORIGDISP | DELETE | Disposition of the original data set during the staging data set rename or FASTSWITCH process | |
PAUSEDISCARDRC | 4 | Return code to assign when pausing after the PRELOAD phase when there are discards | |
PLAN | AMU1120 | Product plan name | |
PREFORMAT | NO | Whether to preformat unused data set pages | |
PRELOAD | LOAD | Whether to perform single-phase or two-phase processing | |
RCVYDDN | (BMCRCY,BMCRCZ) | Default ddname or prefix for remote primary and secondary copy data sets | |
REDEFINE | YES | Whether to delete and redefine the VSAM data sets | |
RENMMAX | 30 | Maximum number of tasks to start during the staging data set rename process | |
RULES | STANDARD | Which set of comparison rules to use in WHEN, NULLIF, and DEFAULTIF processing | |
SDUMP | (ALLPSA,CSA,RGN,SQA,LSQA,SUM,TRT,IO) | System dump parameters | |
SHORTMEMORY | CONTINUE | Which action to take when a memory shortage exists | |
SHRLEVEL | (NONE,NONE) | SHRLEVEL option default | |
SMAX | 16 | Maximum number of each type of task 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 | |
SQLDELAY | 3 | Number of seconds between retry attempts after SQLCODE -911 | |
SQLRETRY | 100 | Number of SQL attempts | |
SSIGNRPAUSE | NO | Whether SmartSwitch ignores PRELOAD PAUSE | |
SSREPORT | REPORT_NGT | Which cases are written to the tracking table | |
STOP@CMT | YES | Whether to add the AT(COMMIT) parameter to all DB2 STOP commands that LOADPLUS 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 | |
TEMPRALDATA | Not applicable | Obsolete | |
TOTALPAGEPCT | 30 | Percentage of total 4-KB pages that the system reports and that LOADPLUS can allocate to BMCSORT for sort processing | |
TSSAMPLEPCT | 100 | Percentage of sampling to perform during statistics gathering | |
UNICODE | Not applicable | Obsolete | |
UPDMAXA | NO | Whether to update MAXASSIGNEDVAL when loading identity column values | |
UPDMAXA_AUTHID | USER | Which authorization ID to use to provide ALTER privileges to update MAXASSIGNEDVAL | |
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 prefix for work data sets | |
WORKUNIT | SYSALLDA | Temporary unit for work data sets | |
WRLOG (SPE2005) | NO | Whether to write Db2 diagnostic log records to indicate that a refresh is required for replicated objects | |
XBLKS | 3 | Number of blocks to use for transferring data between tasks | |
XBMID | No value Example value: XBMA | XBM subsystem that LOADPLUS accesses when it uses XBM or SUF | |
XML | Not applicable | Obsolete | |
XMLAVGSIZE | 10M | Average size of the XML input data | |
ZEROROWRC | 0 | Return code to assign when no rows are loaded | |
ZIIP | ENABLED | Whether to enable zIIP processing |