Installation option descriptions
This section describes the installation options and, in some cases, indicates the default value of the option.
Descriptions of the $ACTDOPT options
Term | Definition | ||||||
|---|---|---|---|---|---|---|---|
ALLC=N | This option determines whether to display all panel titles, column heads, field prompts, and messages in uppercase characters (Y or N). | ||||||
AOPTS=ACMDOPD1 | This option is no longer used to specify the ALTER or CATALOG MANAGERnstallation options module name to be used to run a CATALOG MANAGER worklist. Instead, CATALOG MANAGER uses the ACT vrDM plan to execute a worklist through the Execution component. The plan name is generated in the Execution JCL. | ||||||
AUDIT=Y | This option indicates whether to use audit logging (Y or N). | ||||||
BDSN='''&&HLQ..BMCDBRM''' | This option indicates the DBRM library that CATALOG MANAGER uses when executing the BIND command. | ||||||
BOPTS=ASUDOPD1 | This option indicates whether the DASD MANAGER PLUS product is also installed. If DASD MANAGER PLUS is installed, the installation options module name specified with this option is used to enable the use of the SPACE and STATS commands in CATALOG MANAGER. | ||||||
BPLAN=ACTvrDB | This option specifies the authorization plan for DSN commands. This plan is not used currently, but will be enabled in a future release. | ||||||
CATOP=Y | This option indicates whether to perform the installation SYSADM check when CATALOG MANAGER is initialized (Y or N). Selecting Y starts a DB2 trace. | ||||||
CRS=N | This option indicates whether issuing the SET PROFILE and SET PROFILE OFF commands requires SYSADM (System Administrator) authority ( Y or N). | ||||||
CUP=Y | This option specifies the conditional uppercase indicator.
| ||||||
DBCS=N | This option indicates if DB2 subsystem character strings can contain a mixture of SBCS and DBCS data or SBCS data only.
| ||||||
DPT=('.') | This option indicates that the decimal point character for CATALOG MANAGER must be a comma or a period. | ||||||
DRO=O | This option indicates the Drop Recovery option:
| ||||||
EPLAN=ACTvrDE | This option specifies the name of the plan that enables access to the data editing and browsing functions. | ||||||
ESC='''' | This option indicates the SQL string delimiter. This delimiter must be an apostrophe (') or a quotation mark ('). You must select the one that matches the way your DB2 system was generated. The character that you do not select becomes the SQL escape character. | ||||||
GPLAN=ACTvrDG | This option specifies the authorization plan for commands that will generate SQL for execution. This plan is not used currently, but will be enabled in a future release. | ||||||
GRPAT | This option indicates the group attachment name for data sharing in a sysplex. This name is used as the SSID when JCL for utilities is generated. | ||||||
HDAL=N | This option indicates whether to include aliases in the HDDL (Y or N). | ||||||
HDAU=N | This option indicates whether to include authorization in the HDDL (Y or N). | ||||||
HDDT=N | This option indicates whether to include the user defined data types in the HDDL | ||||||
HDIX=Y | This option indicates whether to include indexes in the HDDL (Y or N). | ||||||
HDMQ=N | This option indicates whether to include materialized query tables (MQT) in the HDDL (Y or N). | ||||||
HDPL=N | This option indicates whether to include plans in the HDDL (Y or N). | ||||||
HDSY=N | This option indicates whether to include synonyms in the HDDL (Y or N). | ||||||
HDTB=Y | This option indicates whether to include tables in the HDDL (Y or N). | ||||||
HDTR=Y | This option indicates whether to include triggers in the HDDL (Y or N). | ||||||
HDTS=Y | This option indicates whether to include table spaces in the HDDL (Y or N). | ||||||
HDVW=Y | This option indicates whether to include views in the HDDL (Y or N). | ||||||
HPLAN=ACTvrDH | This option specifies the plan for displaying BMC utility status. | ||||||
ICCOL | This option specifies the CATALOG MANAGER collection ID for indirect access. | ||||||
ICSYC | This option indicates the CATALOG MANAGER synonym creator ID that is used when installing catalog indirection for CATALOG MANAGER. | ||||||
JDSN=&&ZUSER..BMCCAT.JCL() | This option specifies the default data set name that is used for utility JCL. The data set can be either a sequential or a partitioned data set. The product uses the utility name as the default member name automatically. | ||||||
KPLAN=ACTvrDK | This option specifies the name of the DB2 commands plan. | ||||||
LDSN=&&ZUSER..BMCCAT.SQL | This option specifies the name of the SQL output data set. CATALOG MANAGER dynamically allocates the data set the first time that it is used. If you want to preallocate this data set, use the following parameters: DCB=(LRECL=4092,BLKSIZE=4096,RECFM=VB) | ||||||
LPLAN=ACTvrDL | This option specifies the name of the CATALOG MANAGER logs maintenance plan. | ||||||
MAX=300 | This option indicates the maximum number of lines to generate in a list. | ||||||
MPLAN=ACTvrDM | This option specifies the name of the CATALOG MANAGER main plan. | ||||||
PDSN=&&ZUSER..BMCCAT.PRINT | This option specifies the name of the print output data set. CATALOG MANAGER dynamically allocates this data set the first time that it is used. If you want to preallocate this data set, use the following parameters: DCB=(LRECL=4092,BLKSIZE=27998,RECFM=VBA) | ||||||
PLP=55 | This option indicates the number of print lines per page for the PRINT commands. | ||||||
POFDS='&&HLQ..UBMCCNTL(&POFNAME)' | This option specifies the name of the JCL Generation Product Options File (POF). | ||||||
RCCOL=ACTvr_D_MAIN | This option specifies the CATALOG MANAGER collection ID for direct catalog access. | ||||||
SPLAN=ACTvrDSdt | This option specifies the authorization plan for the SEARCH command. This plan is not used currently, but will be enabled in a future release. | ||||||
TDSNdt | This option specifies the data set in which site utility profiles are saved. The data set can be either sequential or partitioned. If the data set is partitioned, ensure that you include the member name in the data set. | ||||||
TNCC= bigger smaller symbols | This parameter specifies the characters that replace the beginning and end of a truncated string in an object name that is too long to be displayed. | ||||||
TNLMR=M | This parameter specifies the location of characters to be omitted in object names that are too long to be displayed:
| ||||||
TRS=N | This option indicates whether all users or just users with DB2 SYSADM authority can terminate utilities.
| ||||||
UCOMD | (optional) This option indicates the name of the user commands table. This user commands table contains your modifications to existing commands and any new commands, and overrides the primary commands table in member ACTCOMND in the HLQ.BMCCNTL library. When you invoke CATALOG MANAGER, the product merges the primary commands table with your user commands table. | ||||||
UODSN='''&&ZUSER..BMCACT.USEROPT''' | This option specifies the name of the data set that contains values for user options in XML format. CATALOG MANAGER dynamically allocates the data set the first time that it is used. If you want to preallocate this data set, use the following parameters: DCB=(LRECL=255,BLKSIZE=6124,RECFM=VB) | ||||||
UPLAN=ACTvrDU | This option specifies the name of the utilities plan. | ||||||
WDSN=&&ZUSER..BMCCAT.WORK | This option specifies the name of the work data set in which statements that the HDDL command produces are stored. CATALOG MANAGER dynamically allocates the data set the first time that it is used. If you want to preallocate this data set, use the following parameters: DCB=(RECFM=FB,LRECL=80,BLKSIZE=3440) | ||||||
XODSN=('&&HQL..BMCXML') | This option specifies the name of the data set that defines the set of options for DESCRIBE package and DESCRIBE plan in XML format. The data set must be partitioned. ACTDESC is the default member name. |
Descriptions of the $ACTSQLD options
The $ACTSQLD options that are listed in Installation-option-example indicate that lists the $ACTSQLD options and the corresponding table that CATALOG MANAGER accesses. For DB2 Version 12.1 and later, CATALOG MANAGER disregards the value of the $ACTSQLD options and supports only DYNAMIC SQL. For earlier versions of DB2, CATALOG MANAGER uses the value of the option that you specified.
Option | Catalog table |
|---|---|
AUDPOL | SYSIBM.SYSAUDITPOLICIES |
AUTOALE | SYSIBM.SYSAUTOALERTS |
AUTORUN | SYSIBM.SYSAUTORUNS_HIST |
AUTOWIN | SYSIBM.SYSAUTOTIMEWINDOWS |
AUXRELS | SYSIBM.SYSAUXRELS |
CHECKDE | SYSIBM.SYSCHECKDEP |
CHECKS | SYSIBM.SYSCHECKS |
CHECKS2 | SYSIBM.SYSCHECKS2 |
COLAUTH | SYSIBM.SYSCOLAUTH |
COLDISH | SYSIBM.SYSCOLDIST_HIST |
COLDISS | SYSIBM.SYSCOLDISTSTATS |
COLDIST | SYSIBM.SYSCOLDIST |
COLSTAT | SYSIBM.SYSCOLSTATS |
COLUMNH | SYSIBM.SYSCOLUMNS_HIST |
COLUMNS | SYSIBM.SYSCOLUMNS |
CONSTDE | SYSIBM.SYSCONSTDEP |
CONTRL | SYSIBM.SYSControlS |
CONTXT | SYSIBM.SYSCONTEXT |
COPY | SYSIBM.SYSCOPY |
CXATTR | SYSIBM.SYSCTXTTRUSTATTRS |
CXAUTH | SYSIBM.SYSCONTEXTAUTHIDS |
DATABAS | SYSIBM.SYSDATABASE |
DATATYP | SYSIBM.SYSDATATYPES |
DBAUTH | SYSIBM.SYSDBAUTH |
DBRM | SYSIBM.SYSDBRM |
DEPEND | SYSIBM.SYSDEPENDENCIES |
ENVIRON | SYSIBM.SYSENVIRONMENT |
FIELDS | SYSIBM.SYSFIELDS |
FOREIGN | SYSIBM.SYSFOREIGNKEYS |
INDEXES | SYSIBM.SYSINDEXES |
INDEXH | SYSIBM.SYSINDEXES_HIST |
INDEXPA | SYSIBM.SYSINDEXPART |
INDEXPH | SYSIBM.SYSINDEXPART_HIST |
INDEXSH | SYSIBM.SYSINDEXSTATS_HIST |
INDEXST | SYSIBM.SYSINDEXSTATS |
IPLIST | SYSIBM.IPLIST |
IPNAMES | SYSIBM.SYSIPNAMES |
JARCONT | SYSIBM.SYSJARCONTENTS |
JAROBJT | SYSIBM.SYSJAROBJECTS |
JAVAPTH | SYSIBM.SYSVARIABLEAUTH |
JAVOPTS | SYSIBM.SYSJAVAOPTS |
KCOLUSE | SYSIBM.SYSKEYCOLUSE |
KEYS | SYSIBM.SYSKEYS |
KEYTDST | SYSIBM.SYSKEYTGTDISTSTATS |
KEYTGD | SYSIBM.SYSKEYTGTDIST |
KEYTGDH | SYSIBM.SYSKEYTGTDIST_HIST |
KEYTGHS | SYSIBM.SYSKEYTARGETS_HIST |
KEYTGST | SYSIBM.SYSKEYTARGETSTATS |
KEYTGT | SYSIBM.SYSKEYTARGETS |
LOBSTAH | SYSIBM.SYSLOBSTATS_HIST |
LOBSTAT | SYSIBM.SYSLOBSTATS |
LOCATIO | SYSIBM.LOCATIONS |
LULIST | SYSIBM.LULIST |
LUMODES | SYSIBM.LUMODES |
LUNAMES | SYSIBM.LUNAMES |
MODESEL | SYSIBM.MODESELECT |
OBDS | SYSIBM.SYSOBDS |
OBJROL | SYSIBM.SYSOBJROLEDEP |
PACKAGE | SYSIBM.SYSPACKAGE |
PACKAUT | SYSIBM.SYSPACKAUTH |
PACKCPY | SYSIBM.SYSPACKCOPY |
PACKDEP | SYSIBM.SYSPACKDEP |
PACKLIS | SYSIBM.SYSPACKLIST |
PACKSTM | SYSIBM.SYSPACKSTMT |
PARMS | SYSIBM.SYSPARMS |
PENDDDL | SYSIBM.SYSPENDINGDDL |
PKSYSTE | SYSIBM.SYSPKSYSTEM |
PLAN | SYSIBM.SYSPLAN |
PLANAUT | SYSIBM.SYSPLANAUTH |
PLANDEP | SYSIBM.SYSPLANDEP |
PLSYSTE | SYSIBM.SYSPLSYSTEM |
PROCEDU | SYSIBM.SYSPROCEDURES |
QUEROPT | SYSIBM.SYSQUERYOPTS |
QUERPLN | SYSIBM.SYSQUERYPLAN |
QUERY | SYSIBM.SYSQUERY |
RELS | SYSIBM.SYSRELS |
RESAUTH | SYSIBM.SYSRESAUTH |
ROLES | SYSIBM.SYSROLES |
ROUTINA | SYSIBM.SYSROUTINEAUTH |
ROUTINE | SYSIBM.SYSROUTINES |
ROUTOPT | SYSIBM.SYSROUTINES_OPTS |
ROUTSRC | SYSIBM.SYSROUTINES_SRC |
SCHEMAA | SYSIBM.SYSSCHEMAAUTH |
SEQAUTH | SYSIBM.SYSSEQUENCEAUTH |
SEQDEP | SYSIBM.SYSSEQUENCESDEP |
SEQUENC | SYSIBM.SYSSEQUENCES |
STMT | SYSIBM.SYSSTMT |
STOGROU | SYSIBM.SYSSTOGROUP |
STRINGS | SYSIBM.SYSSTRINGS |
SYNONYM | SYSIBM.SYSSYNONYMS |
TABAUTH | SYSIBM.SYSTABAUTH |
TABCNST | SYSIBM.SYSTABCONST |
TABLEPA | SYSIBM.SYSTABLEPART |
TABLES | SYSIBM.SYSTABLES |
TABLESH | SYSIBM.SYSTABLES_HIST |
TABLESP | SYSIBM.SYSTABLESPACE |
TABPRTH | SYSIBM.SYSTABLEPART_HIST |
TABSTAH | SYSIBM.SYSTABSTATS_HIST |
TABSTAT | SYSIBM.SYSTABSTATS |
TBLPROF | SYSIBM.SYSTABLES_PROFILES |
TRIGGER | SYSIBM.SYSTRIGGERS |
USERAUT | SYSIBM.SYSUSERAUTH |
USERNAM | SYSIBM.USERNAMES |
VAR | SYSIBM.SYSVARIABLES |
VARAUTH | SYSIBM.SYSVARIABLEAUTH |
VIEWDEP | SYSIBM.SYSVIEWDEP |
VIEWS | SYSIBM.SYSVIEWS |
VOLUMES | SYSIBM.SYSVOLUMES |
XMLREL | SYSIBM.SYSXMLRELS |
XMLSTR | SYSIBM.SYSXMLSTRINGS |
XMLTYPM | SYSIBM.XMLTYPMOD |
XMLTYPS | SYSIBM.XMLTYPMSCHEMA |
XSROBJ | SYSIBM.XSROBJECTS |
Related topic