New and changed subsystem parameters in Db2 11

This version of Db2 for z/OS® includes new and changed subsystem parameters.

New subsystem parameters in Db2 11

Begin general-use programming interface information.

Table 1. New subsystem parameters
Subsystem Parameter Description
APPL COMPAT LEVEL field (APPLCOMPAT subsystem parameter) Determines the default value for application compatibility.
AUTH EXIT CACHE REFR (AUTHEXIT_CACHEREFRESH subsystem parameter) Specifies whether the package authorization cache, routine authorization cache, and dynamic statement cache entries are to be refreshed, when access control authorization exit is active and the user profile is changed in RACF®.
AUTH EXIT CHECK (AUTHEXIT_CHECK subsystem parameter) Specifies whether the owner or the primary authorization ID is to be used for authorization checks, when the access control authorization exit is active.
CDDS_MODE in macro DSN6LOGP Specifies whether a member is part of a Db2 data sharing group that participates in a GDPS® Continuous Availability with zero data loss environment.
CDDS_PREFIX in macro DSN6LOGP Specifies the prefix for the name of the data set that contains dictionaries that Db2 uses to decompress compressed log records when a proxy data sharing group in an GDPS Continuous Availability with zero data loss environment captures the log records on behalf of a source data sharing group.
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.
FLASHCOPY XRCP field (FLASHCOPY_XRCP subsystem parameter) If z/OS DFSMSdss support for RPFC in XRC is installed and enabled, specifies whether a data set level FlashCopy operation is allowed to a primary volume in an XRC relationship.
INDEX CLEANUP THREADS field (INDEX_CLEANUP_THREADS subsystem parameter) Specifies the maximum number of threads that can be created to process the cleanup of pseudo-deleted index entries on this subsystem or data sharing member. Pseudo-deleted entries in an index are those that are logically deleted but still physically present in the index. This parameter works in conjunction with the SYSIBM.SYSINDEXCLEANUP catalog table, which controls cleanup processing of pseudo-deleted index entries.
LIKE BLANK INSIGNIFICANT field (LIKE_BLANK_INSIGNIFICANT subsystem parameter) Specifies whether the LIKE predicate should ignore trailing blanks within fixed length character strings.
MAX IN-MEMORY SORT SIZE field (MAXSORT_IN_MEMORY subsystem parameter) Specifies the maximum size in kilobytes of storage to allocate for sorting the results of each query that specifies the ORDER BY clause, the GROUP BY clause, or both. The storage is allocated only during the query processing. Increasing the value in this field can improve performance of such queries.
OBJECT CREATE FORMAT field (OBJECT_CREATE_FORMAT subsystem parameter) Specifies whether Db2 is to create new table spaces and indexes to use a basic or extended log record format.
MAX DEGREE FOR DPSI (PARAMDEG_DPSI subsystem parameter) Specifies the maximum degree of parallelism that is allowed for a parallel group where a data partitioned secondary index (DPSI) is used to drive parallelism.
MAX UTILS PARALLELISM field (PARAMDEG_UTIL subsystem parameter) Specifies the maximum degree of parallelism that is allowed when a Db2 utility is driving parallelism.
PERCENT FREE FOR UPDATE field (PCTFREE_UPD subsystem parameter) Specifies the default percentage of each page that Db2 will leave as free space for updates when you create a table space without specifying the FOR UPDATE clause of the PCTFREE option, and a table within that table space is populated. Reserved free space is consumed only by update operations. It is reserved when the table loaded or reorganized or populated by means of SQL INSERT statements. It is not reserved for a LOB table space, a hash table space, a table space that is implicitly created for an XML column, or a table space in a work file database.
PACKAGE RELEASE COMMIT field (PKGREL_COMMIT subsystem parameter) Specifies whether the following operations on a package that is bound as RELEASE(DEALLOCATE) are permitted while the package is active and allocated by Db2:
  • BIND and REBIND requests, including automatic rebinds
  • DDL changes to objects that are statically referenced by the package
PREVENT ALTER LIMITKEY field (PREVENT_ALTERTB_LIMITKEY subsystem parameter) Determines whether Db2 disallows altering the limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. This alter operation places the table space in REORG-pending (REORP) restrictive status, and the data is unavailable until the affected partitions are reorganized. Use PREVENT_ALTERTB_LIMITKEY to avoid this data unavailability.
PROFILE AUTOSTART field (PROFILE_AUTOSTART subsystem parameter) Specifies whether START PROFILE command processing is automatically initiated as part of Db2 start processing.
REMOTE_COPY_SW_ACCEL Specifies whether Db2 uses software to control the remote copy process for active log output in peer-to-peer remote copy (PPRC) environments. The default value is DISABLE.

This parameter is also added to DB2® 10.

REORG DROP PBG PARTS field (REORG_DROP_PBG_PARTS subsystem parameter) Specifies whether REORG is to remove trailing empty partitions when operating on an entire partitioned by growth (PBG) table space. An empty trailing partition occurs when REORG moves all data records from a partition into lower numbered partitions. This parameter is meaningful only when REORG is run against an entire PBG table space. It is ignored for REORGs of non-PBG table spaces and for partition-level REORGs of PBG table spaces.
REORG MAPPING DB field (REORG_MAPPING_DATABASE subsystem parameter) Specifies the default database in which REORG TABLESPACE SHRLEVEL CHANGE should implicitly create the mapping table.
STATISTICS COLGROUP DATA SORT STG LIMIT field (STATCLGSRT subsystem parameter) Specifies the maximum amount of storage that Db2 can use to avoid a sort for a RUNSTATS utility or inline statistics job when collecting frequency statistics on one or more single-column column groups, defined with the COLGROUP option.
STATISTICS FEEDBACK field (STATFDBK_SCOPE subsystem parameter) Specifies the scope of SQL statements for which Db2 is to recommend statistics.
TEMPLATE TIME field (TEMPLATE_TIME subsystem parameter) Specifies the default setting for the TIME option of the Db2 utilities TEMPLATE statement, that is the value to use when the TEMPLATE statement does not specify the TIME option.
UTILITY OBJECT CONVERSION field (UTILITY_OBJECT_CONVERSION subsystem parameter) Specifies whether Db2 utilities that accept the RBALRSN_CONVERSION option will convert existing table spaces and indexes to 6-byte page format, to a 10-byte page format, or perform no conversion.
AGENT LEVEL THRESHOLD field (WFSTGUSE_AGENT_THRESHOLD subsystem parameter) Specifies the percentage of the space available in the work file database on this Db2 subsystem or data sharing member that can be consumed by a single agent before a warning message is issued. Space in the work file database can be configured for temporary (DGTT-oriented) work and for sort work, including CGTTs and trigger transition tables.
SYSTEM LEVEL THRESHOLD field (WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter) Specifies the percentage of the space available in the work file database on this Db2 subsystem or data sharing member that can be consumed by all agents before a warning message is issued. Space in the work file database can be configured for temporary (DGTT-oriented) work and for sort work, including CGTTs and trigger transition tables.
DB2 zHyperLinks SCOPE field (ZHYPERLINK subsystem parameter) Specifies the default scope of the zHyperLink protocol for I/O requests.

Changed subsystem parameters in Db2 11

End general-use programming interface information.

The following table shows the existing subsystem parameters that have new and changed options. For information about an option with a changed default value, see Other release incompatibilities.

Begin general-use programming interface information.

Table 2. Changes to existing subsystem parameters
Subsystem parameter Description of enhancements and notes
AUTO BIND field (ABIND subsystem parameter) COEXIST behavior is used even when YES is specified. That is, no automatic bind occurs in release coexistence or fallback scenarios when a plan or package that was automatically bound in Db2 10 runs again in Db2 11.

This change prevents repeating automatic remigration binds each time that a plan or package runs again on a different release during coexistence or fallback scenarios. For more information, see Automatic binds in coexistence.

DSMAX field (DSMAX subsystem parameter) The upper limit for the maximum number of data sets that can be open at one time is changed from 100,000 to 200,000.
EDM DBD CACHE field (EDMDBDC subsystem parameter) The upper limit for the minimum size (in KB) of the DBD cache that is to be used by EDM is changed from 2,097,152 to 4,194,304.
EDM SKELETON POOL SIZE field (EDM_SKELETON_POOL subsystem parameter) The upper limit of the minimum size of the EDM skeleton pool (in KB) is changed from 2,097,152 to 4,194,304.
EDM STATEMENT CACHE field (EDMSTMTC subsystem parameter) The upper limit for the size (in KB) of the statement cache that is to be used by the EDM is changed from 1,048,576 to 4,194,304.
MAX KEPT DYN STMTS field (MAXKEEPD subsystem parameter) The upper limit for the total number of prepared, dynamic SQL statements that can be saved past a commit point by all threads in the system using the KEEPDYNAMIC(YES) bind option is changed is changed from 65,535 to 204,800.
REORG PART SORT NPSI field (REORG_PART_SORT_NPSI subsystem parameter) The default value is changed from NO to AUTO.
SUBQ_MIDX The default value is changed from DISABLE to ENABLE.

Removed subsystem parameters in Db2 11

The following tables lists subsystem parameters that are removed from this version of Db2 for z/OS. Refer to the information for the earlier version for detailed descriptions of the removed subsystem parameters.

Table 3. Removed subsystem parameters
Subsystem parameter Setting used in Db2 11 behavior
ASSIST NO
COORDNTR NO
DISABSCL NO
DISALLOW_DEFAULT_COLLID NO
MSVGP and MSVGP2 These devices are not recognized in Db2 11.
OJPERFEH YES
OPTIOPIN ENABLE
OTPIOWGT ENABLE
OPTIXIO ON
PGRNGSCR YES
PTCDIO OFF
RETVLCFK NO
SEQCACH SEQ
SEQPRES YES
SMSDCFL blank
SMSDCIX blank
STATCLUS ENHANCED

End general-use programming interface information.