BMC Software, Inc., Confidential and Proprietary Information
6-20 Administrative Products for DB2 Installation Guide
Default Option Descriptions
ROUTINA=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSROUTINEAUTH DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
ROUTINE=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSROUTINES DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
SCHEMAA=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSSCHEMAAUTH DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
SDSN=&&ZUSER..BMCCAT.SQLS
The name of the SQL Explorer summary listing.
SSID=DB2 The DB2 subsystem ID. The SSID must match the -SSID command in the
worklist. This parameter is required.
STMT=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSSTMT DB2 catalog table. The default STATIC
uses the privileges of the package owner. DYNAMIC uses the privileges of
the person who is listing the table.
STOGROU=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSSTOGROUP DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
STRINGS=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSSTRINGS DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
SYNONYM=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSSYNONYMS DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
SZDEV=3380 The device type for data set sizing for JCLGEN. Valid values are 3380 and
3390. The default is 3380.
TABAUTH=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSTABAUTH DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
