Basic installation options
For each option, the table provides the value that ships with this version of UNLOAD PLUS (or No value if the option was 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.
The following table describes the basic UNLOAD PLUS installation options:
Option | Shipped value | Brief description | Reference |
|---|---|---|---|
ANALYZE | (DB2STATS,NOLIMIT) | Whether to use statistics to estimate the number of rows | |
BMCSYSADM | No value | Sets the AUTHID to use for dynamic binds | |
CENTURY | (1950,2049) | Century specification for two-digit years | |
CHANGE_CONSISTENT | NO | SHRLEVEL CHANGE CONSISTENT default | |
CHANGE_QUIESCE | NO | QUIESCE default | |
CMAX | 16 | Maximum number of concurrent tasks when using dynamic SQL | |
CMRATIO | 50 | Compression ratio | |
CONSTRULES | BMC | How to handle character constants in SELECT lists | |
CURRENTDEGREE | NONE | Whether to issue SET CURRENT DEGREE before dynamically executed SELECT statements | |
DELFILES | YES | Whether to delete work files on failure | |
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 | The timeout value for object drains | |
DSPLOCKS | DRNFAIL | How to display locks if the drain times out | |
EXCLDUMP | (X37, X22, X06) | System codes to ignore during dump processing | |
FILEREFDN | SYSREF | Default output descriptor for referenced output files | |
FILL | NO | Whether to fill numeric external data types with zeros | |
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 a drain process from completing | |
FORCE_RPT | NO | Whether to display a report of the canceled threads | |
HISTORY | YES | Whether to update the BMCHIST table for each table space | |
IBUFFS | 25 | The multiplier that controls the amount of buffer pool storage for image copy input data sets | |
INLINE | NO | Whether to unload from inline-image copies | |
KEYDSNAM | No value Example value: ACP.EKEYDS | Name of the key data set to use with encrypted copies | |
LOADDECP | NO | Whether to use a DSNHDECP other than the local subsystem default | |
LOCKROW | YES | Serialization method for BMCSYNC and BMCUTIL | |
MAXP | 5 | Maximum number of partitions to unload concurrently | |
MSGLEVEL | 1 | The default for the message-level execution parameter | |
NEWFUNC | COMPAT | Determines whether the UNLOAD PLUS should use BMCSORT or AMISORT for sorting. | |
NULLCHAR | ? | Default character for the null indicator | |
NULLTYPE | T1 | Whether the null indicator is leading or trailing and 1 byte or 2 bytes | |
OPNDB2ID | YES | Whether to use the Db2 DBM1 user ID instead of the submitting user ID | |
PLAN | ADU1120 | Product plan name | |
RECFM | AUTO | Record format for unload data sets | |
ROWSETSZ | 100 | Size of rowset for a single FETCH request | |
SCHEMA | No Value | Schema name | |
SDUMP | (ALLPSA,CSA,RGN,SQA,LSQA,SUM,TRT,IO) | System dump parameters | |
SHRLEVEL | REFERENCE | SHRLEVEL option default | |
SMAX | 16 | Maximum number of sort processes to invoke concurrently | |
SMCORE | (0K,0K) | The maximum amount of sort memory | |
SORTNUM | 32 | Number of sort work files per task for BMCSORT to allocate dynamically | |
SORTSTCLAS | STORCLAS | AMISORT uses it when dynamically allocating sort work files | |
SQLDELAY | 3 | Number of seconds between retry attempts after SQLCODE -911 | |
SQLRETRY | 100 | Number of retry attempts after SQLCODE -911 | |
SSREPORT | REPORT_NGT | Defines which cases are written to the tracking table | |
SSEXCNTL | DB2LOAD, DB2, BMCLOAD and DB2DDL | Provides the list of CNTLCARDS formats that are precluded from switching to BMC AMI Unload | |
TAPEDISP | DELETE | Tape file disposition | |
TAPES | NONE | List of default tape units | |
TASKMAX | 200% | Global setting for the maximum number of concurrent tasks to start | |
UBUFFS | 25 | The multiplier that controls the amount of buffer pool storage for unload data sets | |
UNLDMAX | * | Maximum number of tasks to start per CPU during the UNLOAD phase | |
UNLOADDN_ACTIVE | (YES, NO) | Whether to activate dynamic allocation for unload data sets | |
UNLOADDN | (SYSREC, SYSRED) | Default ddnames or output descriptors for unload data sets | |
USELRECL | NO | Whether to use the LCRECL value in the JCL | |
UXSTATE | SUP | How to invoke Db2 user exits | |
WORKUNIT | SYSALLDA | Temporary unit for work data sets | |
XBMID | No value Example value: XBMA | SUF (also known as XBM) subsystem that UNLOAD PLUS accesses when it uses SUF (also known as XBM) | |
ZIIP | ENABLED | Whether to enable zIIP processing | |
ZONEDDECOVP | (C,D) | Overpunch values for zoned decimal values |