Subsystem parameters that are not on installation panels

Some subsystem parameters are defined by job DSNTIJUZ and are not associated with fields on any installation panels.

ACCEL in macro DSN6SPRM
Specifies whether accelerator servers can be used with a DB2 subsystem, and how the accelerator servers are to be enabled and started. An accelerator server cannot be started unless it is enabled.
ACCELMODEL in macro DSN6SPRM
Specifies whether to enable the modeling of query workloads for evaluating the potential savings for both accumulated elapsed time and processor time if the plan is run on an accelerator server.
CACHE_DEP_TRACK_STOR_LIM in macro DSN6SPRM
Specifies the amount of storage in gigabytes that DB2 allocates for hashing entries in the dynamic statement cache.
CACHEDYN_FREELOCAL in macro DSN6SPRM
Indicates whether DB2 can free cached dynamic statements to relieve DBM1 below-the-bar storage. CACHEDYN_FREELOCAL applies only when the KEEPDYNAMIC(YES) bind option is active.
DDF_COMPATIBILITY in macro DSN6FAC
Controls certain characteristics of a connection between a client application and a DB2 for z/OS® data server.
DDLTOX in macro DSN6SPRM
The DDLTOX subsystem parameter specifies how long a request for SQL data definition is to wait for a resource before timing out. This parameter is used for the processing of DDL statements and GRANT, REVOKE, and LOCK statements.
DISABLE_EDMRTS in macro DSN6SPRM
The DISABLE_EDMRTS subsystem parameter specifies whether to disable the collection of real-time statistics by the environmental description manager (EDM). By default, EDM collects real-time statistics to track when packages were last used.
DISABSCL in macro DSN6SPRM
Specifies whether SQLWARN1 and SQLWARN5 are set for non-scrollable cursors on OPEN and ALLOCATE CURSOR.
DISALLOW_DEFAULT_COLLID in macro DSN6SPRM
Specifies whether the default collection ID, DSN_DEFAULT_COLLID_plan-name, is used for implicitly generated packages during the automatic DBRM to package conversion process.
DISALLOW_SEL_INTO_UNION in macro DSN6SPRM
Specifies whether to disallow a UNION or UNION ALL as the outermost from-clause of a SELECT INTO statement, which is invalid SQL syntax. Such statements were inadvertently allowed before DB2 12. However, starting in DB2 12 they are disallowed by default.
EN_PJSJ in macro DSN6SPRM
Specifies whether to enable dynamic index ANDing, which is also called pair-wise join processing, when star join processing is enabled on DB2.
HONOR_KEEPDICTIONARY in macro DSN6SPRM
Specifies whether DB2 honors the LOAD and REORG parameter KEEPDICTIONARY when tables are converted between basic row format and reordered row format.
IMPDSSIZE in macro DSN6SYSP
Specifies the maximum data set size (DSSIZE) in gigabytes that DB2 should use for creating an implicit base table space.
IMPTKMOD in macro DSN6SYSP
Specifies whether DB2 is to track modifications to the pages of base table spaces.
INDEX_IO_PARALLELISM in macro DSN6SPRM
Specifies whether I/O parallelism is enabled for index insertion.
INLISTP in macro DSN6SPRM
Allows you to specify the maximum number of elements in an IN-list for certain IN predicate optimizations to occur.
IX_TB_PART_CONV_EXCLUDE in macro DSN6SPRM
Specifies whether to exclude trailing columns from the table-controlled partitioning keys when table spaces are converted from index-controlled partitioning to table-controlled partitioning.
MATERIALIZE_NODET_SQLTUDF in macro DSN6SPRM
Specifies whether the DB2 database manager materializes the result of a user-defined SQL table function that is defined as NOT DETERMINISTIC.
MAX_CONCURRENT_PKG_OPS in macro DSN6SPRM
Specifies the maximum number of automatic bind requests, remote bind requests, remote rebind requests, CREATE TRIGGER statements, and CREATE PROCEDURE statements for packages that can be processed simultaneously. If the value of the AUTO BIND field of panel DSNTIPO is set to NO, the value of MAX_CONCURRENT_PKG_OPS has no effect.
MAXCONQN in macro DSN6FAC
The MAXCONQN subsystem parameter specifies the maximum number of inactive or new connections that can be queued waiting for a DBAT to process the request.
MAXCONQW in macro DSN6FAC
The MAXCONQW subsystem parameter specifies the maximum length of time that a client connection waits for a DBAT to process the next unit-of-work or new connection request.
NPGTHRSH in macro DSN6SPRM
Specifies whether DB2 is to use special access path selection for tables under a given size.
NEWFUN in macro DSNHDECP
Specifies the default setting for the NEWFUN SQL processing option for the DB2 precompiler and coprocessor.
OJPERFEH in macro DSN6SPRM
Specifies whether to disable performance enhancements for outer join operations.
OPT1ROWBLOCKSORT in macro DSN6SPRM
Specifies whether DB2 explicitly blocks sort operations when the OPTIMIZE FOR 1 ROW clause is specified on a query. Valid values are ENABLE or DISABLE.
OPTIOPIN in macro DSN6SPRM
Controls whether DB2 is to use an enhancement to more accurately estimate the cost of accessing the inner table of a join that involves index and data access. This enhancement removes an inconsistency with the calculation of the cost for the outer table of a join.
OPTIOWGT in macro DSN6SPRM
Controls how DB2 balances the I/O cost and CPU estimates when selecting access paths.
PGRNGSCR in macro DSN6SPRM
Determines whether to enable a function that is introduced by APAR PM81692.
PREVENT_NEW_IXCTRL_PART in macro DSN6SPRM
The PREVENT_NEW_IXCTRL_PART subsystem parameter determines whether DB2 disallows the creation of new index-controlled partitioned tables. This subsystem parameter ensures that new partitioned tables use table-controlled partitioning, which is the preferred partitioning method for non-universal table spaces.
PRIVATE_PROTOCOL in macro DSN6FAC
Private protocol is no longer supported; however, this subsystem parameter controls package EXECUTE authorization behavior related to remote DB2 requester applications.
QUERY_ACCEL_OPTIONS in macro DSN6SPRM
The QUERY_ACCEL_OPTIONS subsystem parameter specifies additional types of SQL queries that are eligible for acceleration.
QUERY_ACCELERATION in macro DSN6SPRM
The QUERY_ACCELERATION subsystem parameter determines the default value that is to be used for the CURRENT QUERY ACCELERATION special register.
REALSTORAGE_MANAGEMENT in macro DSN6SPRM
The REALSTORAGE_MANAGEMENT subsystem parameter specifies whether DB2 should manage real storage consumption.
PTASKROL in macro DSN6SYSP
Indicates whether to roll up accounting trace records from a parallel query task into the originating task's accounting trace. A value of YES means the originating task is to generate an additional accounting trace record with all the roll-up values from parallel tasks.
REALSTORAGE_MAX in macro DSN6SPRM
Specifies the maximum GB of real and auxiliary storage that DB2 can consume. Valid values are NOLIMIT and 1 to 65535.
REMOTE_COPY_SW_ACCEL in macro DSN6LOGP
The REMOTE COPY SW ACCEL field specifies whether DB2 uses software to control the remote copy process for active log output in peer-to-peer remote copy (PPRC) environments.
REORG_IGNORE_FREESPACE in macro DSN6SPRM
By default, when REORG TABLESPACE is run against a partition-by-growth table space, it uses the defined PCTFREE and FREEPAGE values in the partition or table space. As data is loaded back into the table space, new partitions are created as necessary to accommodate the partition or table space’s growth in size.
REORG_LIST_PROCESSING in macro DSN6SPRM
The REORG_LIST_PROCESSING subsystem parameter specifies the default setting for the PARALLEL option of the DB2 REORG TABLESPACE utility.
REORG_PART_SORT_NPSI in macro DSN6SPRM
The REORG_PART_SORT_NPSI subsystem parameter specifies whether the REORG TABLESPACE PART utility decides to sort all of the keys of a non-partitioned secondary index. The setting is ignored for a REORG that is not part-level or without non-partitioned secondary indexes.
RESTRICT_ALT_COL_FOR_DCC in macro DSN6SPRM
Specifies whether restrictions apply to ALTER TABLE ALTER COLUMN statements for target tables that are defined with the DATA CAPTURE CHANGES attribute. Valid values are NO and YES.
RETRY_STOPPED_OBJECTS in macro DSN6SPRM
The RETRY_STOPPED_OBJECTS subsystem parameter specifies whether DB2 immediately rejects requests for a stopped object or rechecks whether the object is started, up to the IRLM timeout limit.
RETVLCFK in macro DSN6SPRM
Specifies whether the VARCHAR column is to be retrieved from a padded index. Valid values are YES or NO. The data sharing scope of this parameter is GROUP.
SECADM1_INPUT_STYLE in macro DSN6SPRM
Specifies whether the SECADM1 setting is passed as a hexadecimal string or as a standard character string. Valid values are HEX or CHAR.
SECADM2_INPUT_STYLE in macro DSN6SPRM
Specifies whether the SECADM2 setting is passed as a hexadecimal string or as a standard character string. Valid values are HEX or CHAR.
SEQCACH in macro DSN6SPRM
Specifies whether the sequential mode is to be used to read cached data from a 3990 controller. Valid values are BYPASS and SEQ.
SEQPRES in macro DSN6SPRM
Some DB2 utilities scan nonpartitioning indexes and then update a subset of the pages in the indexes. The SEQPRES subsystem parameter specifies whether, when reading data, these utilities are to allow data to remain in cache longer. Valid values are YES and NO.
SIMULATED_CPU_COUNT in macro DSN6SPRM
Specifies the number of CPUs that are being simulated. This parameter is to be used for DB2 optimization modeling only. Valid values are OFF and numbers 1 - 255.
SIMULATED_CPU_SPEED in macro DSN6SPRM
Specifies the microseconds of execution time for tasks or service request blocks (SRBs) per service unit for the CPU that is being simulated. This parameter is used only for DB2 optimization modeling.
SJTABLES in macro DSN6SPRM
Specifies when DB2 is to enable star join processing.
SMF89 in macro DSN6SYSP
Specifies whether DB2 is to do detailed tracking for measured usage pricing. If you select YES, DB2 does detailed measured usage tracking if SMF type 89 records are activated.
SMSDCFL in macro DSN6SPRM
Specifies a DFSMS data class for table spaces. Before you set this parameter, you need to define the data classes for your table space data sets. You also need to code SMS automatic class selection (ACS) routines to assign indexes to one SMS storage class and table spaces to a different SMS storage class.
SMSDCIX in macro DSN6SPRM
Specifies a DFSMS data class for indexes. Before you set this parameter, you need to define the data classes for your index data sets. You also need to code SMS automatic class selection (ACS) routines to assign indexes to one SMS storage class and table spaces to a different SMS storage class.
SQWIDSC in macro DSN6SPRM
Specifies whether, when RENAME TABLE or DROP ALIAS is issued against an object against which there is already SQL activity, the DB2 database manager performs only an invalidate operation, or performs a quiesce operation and an invalidate operation on all SQL statements in the dynamic statement cache that depend on that object.
STATCLUS in macro DSN6SPRM
Specifies the type of clustering statistics that are to be collected by the RUNSTATS utility. Valid values are ENHANCED and STANDARD.
SUBQ_MIDX in macro DSN6SPRM
Specifies whether to enable or disable multiple index access on some non-Boolean uncorrelated subquery predicates.
SUPPRESS_HINT_SQLCODE_DYN in macro DSN6SPRM
Specifies whether DB2 suppresses SQLCODE +394 and SQLCODE +395 when specified access paths are applied for dynamic SQL statements. Valid values of SUPPRESS_HINT_SQLCODE_DYN are NO, STMT, and ALL.
TEMPLATE_TIME in macro DSN6SPRM
The TEMPLATE_TIME subsystem parameter specifies the default setting for the TIME option of the TEMPLATE statement.
UNION_COLNAME_7 in macro DSN6SPRM
Specifies the behavior for result column names in UNION queries.
XML_RESTRICT_EMPTY_TAG in DSN6SPRM
Specifies whether DB2 always serializes an empty XML element using a start-element tag followed by an end-element tag. Valid values are NO and YES. NO is the default.
ZOSMETRICS in macro DSN6SPRM
Enables DB2 to gather z/OS metrics, including CPU usage and storage metrics, by using the z/OS Resource Measurement Facility™ (RMF™) interface. Valid values are YES and NO.

Parent topic: Tailoring DB2 jobs to your environment using the installation CLIST

Related reference:

Defining data classes (DFSMS Implementing System-Managed Storage: Optimizing Tape Usage)