DSNZPARM Other System Parameters
This panel shows information about the installation parameters that affect Db2 subsystem default settings. These system parameters are not displayed from Db2 installation panels.
If a field is not available for the current Db2 release,
the string
N/A is displayed. For other conditions, for example, if specific Db2 traces are not started or control block data is not available,
the string N/P is displayed.
________________ ZPOTH VTM O2 V550./C DB1H S 07/31/13 15:33:43 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.Q
> DSNZPARM INFORMATION: Enter a selection letter on the top line.
> A-THREAD B-TRACE C-LOGGING D-ARCHIVING E-AUTH/RLF/DDF F-IRLM
> G-STORAGE H-DATASET I-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> M-APPL N-DATA O-PERF P-BUFFERPOOL *-OTHERS
===============================================================================
> OTHER SYSTEM PARAMETERS
ZOTH
+ Collection Interval: REALTIME SNAPTIME: 07/31/13 13:33:44.01
+
+ DSNZPARM Module DB1HUNIN
+ Assembly Date 07/30/13
+ Initial Module DSNZPARM
+ Assembly Date 07/29/13
+ Previous Module DSNZPARM
+ Assembly Date 07/29/13
+
+ From DSN6SYSP
+------------------------------------
+ Size of Local Trace Table (TRACLOC) 16
+ Parallel Task AcctRollup (PTASKROL) NO
+ Measured Usage Pricing (SMF89) NO
+ DB2 OTC License Term (OTC_LICENSE) NO
+ Trackmod Implicit TS (IMPTKMOD) YES
+ Max DSSIZE Implicit TS (IMPDSSIZE) 4
+
+ From DSN6LOGP
+------------------------------------
+ Offload Option (OFFLOAD) YES
+ (CDDS_MODE)
+ (CDDS_PREFIX)
+
+ From DSN6ARVP
+------------------------------------
+ MSS Volume Group 1 Name (MVSGP) N/A
+ MSS Volume Group 2 Name (MVSGP2) N/A
+
+ From DSN6SPRM
+------------------------------------
+ Enable Database Check (DBCHK) NO
+ Utility Cache Option (SEQPRES) N/A
+ 3990-3 Seq Cache (SEQCACH) N/A
+ Disable Code Page Protect (PROTOFF) NO
+ Varchar from Index (RETVLCFK) N/A
+ Outer Join Perf Enh (OJPERFEH) N/A
+ Minimum RID Lists (MINRBLK) 1
+ NPAGES Threshold (NPGTHRSH) 0
+ Star Join Threshold (SJTABLES) 10
+ SMS Data Class for TS (SMSDCFL) N/A
+ SMS Data Class for IX (SMSDCIX) N/A
+ MIN SCALE DECIMAL DIVIDE (MINDVSCL) NONE
+ Max RDS OP Pool (MAX_OPT_STOR) 40
+ Max CPU Sec OP Use (MAX_OPT_CPU) 100
+ Disable SQLWANR1,5 (DISABSCL) N/A
+ Max Entry Seclabel Cache (SECLCACH) 255
+ Max Numb in IN-List (INLISTP) 50
+ Recover to Point-in-Time (RPITWC) YES
+ (UNION_COLNAME_7) NO
+ Statistics Cluster (STATCLUS) N/A
+ (CACHEDYN_FREELOCAL) 1
+ (MAX_CONCURRENT_PKG_OPS) 10
+ (HONOR_KEEPDICTIONARY) NO
+ (INDEX_IO_PARALLELISM) YES
+ Z/OS Metrics (ZOSMETRICS) YES
+ OPT I/O Weighting (OPTIOWGT) N/A
+ Enable Pair-wiseJoin (EN_PJSJ) NO
+ (REALSTORAGE_MAX) 0
+ (RESTRICT_ALT_COL_FOR_DCC) NO
+ (DISALLOW_DEFAULT_COLLID) N/A
+ I/O Scheduling feature (SPRMIOP) YES
+ Correlation ID Monitor (SPRMOZCI) 023.GCSCN602
+ User ID Monitor (SPRMOZUS) HONG
+ Value For Trigger Drain (SPRMTDD) 1
+ Max # OF DDS Withhold (SPRMMDD) 3
+ #Field Procs for TB Block (SPRMFDP) 5
+ Max NotFound Hash Records (SPRMKFC) 100
+ Max Extend Service Tasks (SPRMEST) 20
+ Max ZIVLEMPEL Dict Entry (SPRMMDE) 4096
+ ProjectZ Insert Threshold (SPRMZTN) 2
+ Default index type (SPRMDXT) 2
+ (OPT1ROWBLOCKSORT) NO
+ (SUBQ_MIDX) YES +
+ (ACCELMODEL) NO
+ (AUTH_COMPATIBILITY) NO
+ (CHECK_FASTREPLICATION) REQUIRED
+ (XML_RESTRICT_EMPTY_TAG) NO
+ (PREVENT_NEW_IXCTRL_PART) NO
+ (SUPPRESS_HINT_SQLCODE_DYN) NO
+ (LIKE_BLANK_INSIGNIFICANT) NO
+ (SIMULATED_CPU_COUNT) 0
+ (SIMULATED_CPU_SPEED) 0
+ (MATERIALIZED_NODET_SQLTUDF) NO
+ (MOVE_TO_ARCHIVE_DEFAULT) N
+ (DISALLOW_SEL_INTO_UNION) YES
+ (COMCRIT) NO
+ (ENCRYPTION_KEYLABEL) DB2SYS.KEY01
+ (ALLOW_UPD_DEL_INS_WITH_UR) NO
+ (DISALLOW_SSARAUTH) YES
+ (LA_SINGLESEL_ISOCS_CDY) NO
+
+ From DSN6FAC
+------------------------------------
+ Enable SQL Interrupt (SQLINTRP) NO
+ (PRIVATE_PROTOCOL) NO
+ DDF_COMPAT: IDNTFY_PRIOR_VERSION 0
+ DDF_COMPAT: SP_PARMS_NJV NO
+ DDF_COMPAT: DISABLE_IMPCAST_NJV NO
+ DDF_COMPAT: DISABLE_IMPCAST_JV NO
+ DDF_COMPAT: IGNORE_TZ NO
+ DDF_COMPAT: SP_PARMS_JV NO
+ DDF_COMPAT: RESET IFCID402 N/A
+
+ From DSNHDECP
+------------------------------------
+ DB2 Supplied DECP Indic (DB2SUPLD) N
+ Charset Default (CHARSET) N/A
+
+ Others
+------------------------------------
+ Space Above DB2 Leave Available 39387136
+ Space Reserved For Critical Work 39387136
+ Space Reserved For z/OS Functions 40960
+ Extended Datestamp Indicator NO
+ Online ZPARM Time of Last Change 07/30/13 13:44:59.62
+ Online ZPARM Type LOAD
+ Number of Facility Entries 1
+ Facility Name DDF
+ SU Conversion Factor 281
+ New Function Mode (NEWFUN) YES
===============================================================================
Navigation
For additional information about
- related topics, select one of the options on the top of the panel.
- other topics, use the PF keys.
Fields
The DSNZ command displays the following lines to reflect the usage of the Db2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.- DSNZPARM Module
- The DSNZPARM module name specified for Db2 startup.
- Initial Module
- The name of the initial DSNZPARM load module.
- Previous Module
- The name of the previous DSNZPARM load module.
- Assembly Date
- The date on which this module was assembled.
From DSN6SYSP
- Size of Local Trace Table (TRACLOC)
- Determines a multiple of 4K that determines the size of the local trace tables.
- Parallel Task AcctRollup
- Indicates whether to roll up the accounting trace of the query parallel tasks into the
accounting trace of the originating task. Valid values:
- Yes
- The originating task cuts an additional accounting trace record with all the roll-up values from parallel tasks.
- No
- Each parallel task produces its own accounting trace.
- Measured Usage Pricing
- Indicates whether Db2 is tracking for measured usage pricing.
- Db2 OTC License Term (OTC_LICENSE)
- Determines whether this Db2 subsystem or data sharing
member operates under an OTC license. The terms of the OTC license are accepted. Valid values:
- Not used
- Indicates that an OTC license is not in effect on this Db2.
- Terms accepted
- Indicates that an OTC license is in effect on the Db2 and that the owner accepts the terms of that license. To view the terms, see the member DSNTIPO1 of the SDSNSPFP target library for this version of Db2.
- Trackmod Implicit TS
- Determines whether Db2 tracks modifications to the pages of implicitly created table spaces.
- Max DSSIZE Implicit TS
- Determines the maximum DSSIZE in gigabytes that can be used by Db2 for creating each partition of an implicitly created base table space.
From DSN6LOGP
- Offload Option
- Determines whether online initiation of the offload process is used. Valid values: YES or NO.
- (CDDS_MODE) - (QWP2CPSY, QWP2CSRC)
The CDDS_MODE subsystem parameter specifies how a member of a Db2 data sharing group participates in a GDPS Continuous Availability with zero data loss (GDPS Continuous Availability with zero data loss) environment.
ZPARM NAME: DSN6LOGP.CDDS_MODE
Valid values are:
- NONE
- (Default) The Db2 subsystem or data sharing group does not participate in a GDPS Continuous Availability with zero data loss environment. The subsystem or data sharing group member supports only the replication of its own log. The data set that the CDDS_PREFIX parameter specifies can be defined locally but is not used.
- SOURCE
- The data sharing group that contains the member that is being installed is the source group in an implementation of the GDPS Continuous Availability with zero data loss solution. The source data sharing group supports replication of the logs and log data sets of its members by another data sharing group, which is the proxy group in the implementation of the GDPS Continuous Availability with zero data loss solution. The proxy group performs replication of tables in the source data sharing group that are enabled for changed data capture. The source group must contain a key-sequenced data set with the name that is specified by the CDDS_PREFIX subsystem parameter. That data set is the compression dictionary data set (CDDS). When IFI READS calls are made to the proxy group to retrieve compressed log records, Db2 uses the CDDS to decompress the log records. The location of the source group must be defined in the communications database of the proxy group.
- PROXY
- The data sharing group that contains the member that is being installed supports only replication of log data sets for the source data sharing group in an implementation of the GDPS Continuous Availability with zero data loss solution. The location of the proxy group must be defined in the communications database of the source group.
- (CDDS_PREFIX) - (QWP2CDDS)
The CDDS_PREFIX subsystem parameter 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 implementation of the GDPS Continuous Availability with zero data loss (GDPS Continuous Availability with zero data loss) solution captures the log records on behalf of a source data sharing group. The data set is known as the compression dictionary data set (CDDS).
The data set name is formed by appending the string '.CDDS' to the value of CDDS_PREFIX.
Valid values: 1 - 39 bytes
Default: DSNCAT
ZPARM NAME: DSN6LOGP.CDDS_PREFIX
Db2 11 and later.
From DSN6ARVP
- MSS Volume Group 1 Name
- The name of the mass storage system volume group 1. Db2 10 only.
- MSS Volume Group 2 Name
- The name of the mass storage system volume group 2. Db2 10 only.
From DSN6PRM
- Enable Database Check
- Determines whether additional internal checking is performed to determine whether the database manager is producing defective data or index records. Internal checking increases the cost of a database request, however, it provides early detection of system errors that might produce incorrect data. Valid values: YES or NO.
- Utility Cache Option
- Determines whether the sequential prestage function of 3990 sequential caching for utilities is used.
- 3990-3 Seq Cache
- Determines whether sequential mode to read cached data from a 3990 controller is used.
- Disable Code Page Protect
- Determines whether Code Page Protect is used.
- Varchar from Index
- Determines whether Db2 can return data from an index key for a varying length column. Db2 10 only.
- Outer Join Perf Enh
- Determines whether outer join performance enhancements are used. Db2 10 only.
- Minimum RID Lists
- The minimum number of RID blocks in the Db2 subsystem.
- NPAGES Threshold
- The NPAGES threshold for optimizer.
- Star Join Threshold
- Determines the minimum number of tables in a query block before Db2 considers the query block for star join. Star join must be enabled before Db2 can use this system parameter. Valid values:
- 0
- Star join is enabled for a query block with 10 or more tables.
- 1,2,3
- Star joins is enabled.
- 4-225
- Star join is enabled if the query block contains a minimum of this number of tables.
- 226-32767
- Star join is not enabled.
- SMS Data Class for TS
- The SMS data class name that is used by Db2 when a cluster for a table space is defined. If this value is blank, a data class name is not used. Db2 10 only.
- SMS Data Class for IX
- The SMS data class name that is used by Db2 when a cluster for an index is defined. If this value is blank, a data class name is not used. Db2 10 only.
- MIN SCALE DECIMAL DIVIDE
- The minimum scale for the result of a decimal division.
- Max RDS OP Pool (QWP4MXOS)
- The maximum amount of RDS op pool storage in MB to be used by the Db2 Optimizer. Valid values: 0 to 100. If 0 is specified, Db2 uses the maximum of 100. Default: 20.
- Max CPU Sec OP Use (QWP4MXOC)
- The maximum amount of CPU time in seconds to be used by the Db2 Optimizer. Valid values: 0 to 500. If 0 is specified, Db2 uses the maximum of 500. Default: 100.
- Disable SQLWANR1,5 (QWP4DSCM)
- Do not set SQLWARN1, SQLWARN4 and SQLWARN5 after the scrollable cursor has been successfully opened. Db2 10 only.
- Max Entry Seclabel Cache (QWP4SCLC)
- Maximum number of entries in the SECLABEL cache. Used to avoid RACROUTE REQUEST=DIRAUTH REQUESTS.
- Max Numb in IN-List (QWP4INLP)
- The maximum number of elements in an IN-List for an in-list predicate to be optimized. If the
IN-List contains this number or fewer elements, it is optimized in the following ways:
- The IN-List predicated is pushed down into a materialized view or table expression
- A correlated IN-List predicate in a subquery that is generated by transitive closure can be moved up to the parent query block.
- Recover to Point-in-Time (QWP4RPTC)
- Recover to Point-In-Time with consistency.
- (UNION_COLNAME_7) (QWP4UNM7)
- The SQLNAME field in the SQLDA after a query describe in which the result table is the result of a union, is the name of the column from the first subquery of the union.
- Statistics Cluster
- Defines whether enhanced clustering is used. Db2 10 only.
- (CACHEDYN_FREELOCAL)
- Determines whether statements from the dynamic statement cache can be freed by Db2 to relieve storage constraints below the 2GB bar.
- MAX_CONCURRENT_PKG_OPS
- The maximum number of package requests that can be processed simultaneously.
- (HONOR_KEEPDICTIONARY) (QWP4HKPD)
- Valid values: YES, NO.
- (INDEX_IO_PARALLELISM)
- Determines whether index I/O parallelism is enabled. Db2 10 and Db2 11 only.
- Z/OS Metrics
- Determines whether the gathering of Z/OS metrix through the RMF interface is enabled.
- OPT I/O Weighting
- Determines whether the optimizer I/O weighting is enabled. Db2 10 only.
- Enable Pair-wise Join
- Determines whether pair-wise join is enabled.
- (REALSTORAGE_MAX) (QWP4RSMX)
- Maximum amount of real plus auxiliary storage that can be used.
- (RESTRICT_ALT_COL_FOR_DCC) (QWP4RACD)
- RESTRICT_ALT_COL_FOR_DCC.
- (DISALLOW_DEFAULT_COLLID) (QWP4DDCI)
- Disallow default collection ID. Db2 10 only.
- I/O Scheduling feature
- Determines whether the I/O scheduling feature is activated.
- Correlation ID Monitor (QWP4OZCI)
- Online system parameter correlation ID monitor.
- User ID Monitor
- Online system parameter user ID monitor.
- Value for Trigger Drain (QWP4TDDN)
- Value for trigger drain.
- Max # of DDS withhold (QWP4MDDN)
- Maximum number of DDS with HOLD.
- Field Procs for TB Block
- The number of field procs for Describe Table Block.
- Max NotFound Hash Records (QWP4KNFC)
- Maximum number of "Not Found" hash records.
- Max Extend Service Tasks (QWPEST)
- Maximum extend service tasks.
- Max ZIVLEMPEL Dict Entry (QWP4MDE)
- Maximum number of ZIVLEMPEL dictionary entries.
- ProjectZ Insert Threshold (QWP4ZTN)
- Project Z insertion threshold.
- Default index type (S) (QWP4DXTP)
- Default index type (type 1 or type 2).
- (OPT1ROWBLOCKSORT)
- Determines for queries that use the option Optimize For 1 Row whether all access paths that require sorting are blocked if there is at least one access path that avoids sorting.
- (SUBQ_MIDX)
- Determines whether Multiple Index Access for queries that have subquery predicates is enabled.
- (ACCELMODEL) (QWP4ACMO)
- 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.
- (AUTH_COMPATIBILITY) (QWP4AUTCSU)
- The AUTH_COMPATIBILITY parameter specifies whether the default authorization check is overridden
when users request to use the UNLOAD utility. Valid values:
- NO for blank (default)
- Indicates that AUTH_COMPATIBILITY has no effect and that there is no authorization check override.
- YES for SELECT_FOR_UNLOAD
- When this value is specified, the UNLOAD utility checks if the user has the SELECT privilege on the target table. When this value is not specified, the UNLOAD utility checks if the user has the UNLOAD privilege on the target table.
- (CHECK_FASTREPLICATION) (QWP4CFRP)
- Specify the type of replication to be used by DSSCOPY when invoked by the Db2 check utilities to
copy objects to shadow data sets. The check utilities use DSSCOPY to copy Db2 objects to shadow data
sets for processing and can stipulate fast replication as either preferred or required. Valid values are:
- REQUIRED (default)
- The check utilities force DSSCOPY to use fast replication ensuring that object copies occur as quickly as possible. This reduces the opportunity for resource contention and unavailability. This option causes the check to fail if flash copy cannot be used.
- PREFERRED
- The check utilities direct DSSCOPY to use fast replication only if flash copy support is available.
- NONE
- XML_RESTRICT_EMPTY_TAG (QWP4NOET)
- Specifies whether Db2 always serializes an empty XML element using a start-element tag followed by an end-element tag.
- (PREVENT_NEW_IXCTRL_PART) (QWP4PCIP)
- 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 tablespaces. Valid values:
- NO
- Specifies that new index-controlled partitioned tables can be created.
- YES
- Specifies that new partitioned table spaces must use table-controlled partitioning. A CREATE INDEX statement must not attempt to create an index-controlled partitioned table.
- (SUPPRESS_HINT_SQLCODE_DYN) (QWP4SHDE)
- Specifies whether Db2 suppresses SQLCODE +394 and SQLCODE +395 when specified access paths are
applied for dynamic SQL statements.
- NO (default)
- Specifies that Db2 issues SQLCODEs +394 and +395 for statement-level access paths and PLAN_TABLE access paths.
- STMT
- Specifies that Db2 suppresses SQLCODEs +394 and +395 for statement-level access paths for dynamic SQL statement.
- ALL
- Specifies that Db2 suppresses SQLCODEs +394 and +395 for statement-level access paths and PLAN_TABLE access paths for dynamic SQL statements.
- (LIKE BLANK INSIGNIFICANT) (QWP4LBIN)
- Specifies whether blanks are significant when applying the LIKE predicate to a string. If set, the blank insignificant behavior applies. Valid values: YES, NO. The default is NO.
- (SIMULATED_CPU_COUNT) (QWP4NCPU)
- 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. The parameter is online changeable.
- (SIMULATED_CPU_SPEED) (QWP4CPUM)
- 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. Valid values:
- OFF
- Db2 optimizes for the CPU on which it is running. Use this setting in production environments.
- 1 - 2,147,483,647
- Microseconds of execution time for tasks or service request blocks (SRBs) per service unit for the CPU that is being simulated. For values 1 - 27, Db2 uses a value of 27.
- (MATERIALIZE_NODET_SQLTIDF) (QWP4MNSU)
- Specifies whether the Db2 database manager materializes the result of a user-defined SQL table
function that is defined as NOT DETERMINISTIC. Valid values are:
- NO (default)
- The Db2 database manager does not materialize the result of a user-defined SQL table function that is defined as NOT DETERMINISTIC.
- YES
- The Db2 database manager materializes the result of a user-defined SQL table function that is defined as NOT DETERMINISTIC. Use this setting to avoid errors in processing SQL statements that reference those user-defined SQL table functions
- (MOVE_TO_ARCHIVE_DEFAULT) - (QWP4MTAD)
- Specifies the default for the SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable.
ZPARM NAME: DSN6SPRM.MOVE_TO_ARCHIVE_DEFAULT
Valid values are:
- N
- (Default) Specifies that a delete of a row in an archive-enabled table will not result in storing a copy of the deleted row in the associated archive table.
- E
- Specifies that a delete of a row in an archive-enabled table will result in storing a copy of the deleted row in the associated archive table.
- Y
- Specifies that a delete of a row in an archive-enabled table will result in storing a copy of the deleted row in the associated archive table. Additionally, when the global variable is set to 'Y', an insert or update operation that specifies the archive-enabled table as the target of the statement will result in an error.
- (DISALLOW_SEL_INTO_UNION) - (QWP4DSINUN)
- 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, in Db2 12 they are disallowed by default.
Online changeable: YES
ZPARM NAME: DSN6SPRM DISALLOW_SEL_INTO_UNION
Valid values are:
- YES
- (Default) SELECT INTO statements with UNION or UNION ALL as the outermost from-clause are not supported. This setting enforces valid SQL syntax.
- NO
- SELECT INTO statements with UNION or UNION ALL as the outermost from-clause are accepted. This setting tolerates invalid SQL syntax.
- (COMCRIT) - (QWP4COMC)
- Sets the Common Criteria environment, which requires that tables that you create (other than
created global temporary tables, declared global temporary tables, and auxiliary tables) must have
multilevel security.
ZPARM NAME: DSN6SPRM.COMCRIT
Security parameter: YES
Valid values are:
- NO
- (Default) The behavior of Db2 is unchanged.
- YES
- All tables that you create (other than created global temporary tables, declared global temporary tables, and auxiliary tables) must have multilevel security. If the AS SECURITY LABEL clause is missing from a table, an error occurs and the table is not created. Setting COMCRIT to YES causes some of the current installation and migration processes to fail. A value of YES also limits the number of concurrent sessions that are allowed for a primary authorization ID if a RACF custom field is defined for that ID.
- (ENCRYPTION_KEYLABEL) - (QWP4ENKL)
- The ENCRYPTION_KEYLABEL subsystem parameter specifies the name of an ICSF key label to provide
to DFSMS when using z/OS DFSMS data set encryption support to define encrypted data sets for the Db2
catalog, directories, and archive logs. The setting is used to define encrypted data sets for the
Db2 catalog, directory objects, user-defined indexes on the catalog, and archive logs only when the
Db2 function level is V12R1M502 or higher. The default setting of blank means Db2 does not provide
the key label during allocation of the data sets associated with the system objects. If non-blank,
ENCRYPTION_KEYLABEL must be set to a string from 1 - 64 bytes that identifies a protected data key
in the ICSF key repository. A change to this parameter does not take effect until you use the -SET
SYSPARM command to bring it online. Even if you start or restart Db2 after changing the value, the
change is not honored until you issue the -SET SYSPARM command. In Db2 data sharing, all members
need to use the same setting. When changing the setting of ENCRYPTION_KEYLABEL for a data sharing
group, make the change on all members before running the -SET SYSPARM command on any member.
Acceptable values: 1 - 64 bytes.
Default: Blanks
ZPARM NAME: DSN6SPRM.ENCRYPTION_KEYLABEL
Db2 12 and later. - (ALLOW_UPD_DEL_INS_WITH_UR) (QWP4AUDIWU)
- Specifies whether Db2 allows UPDATE, DELETE, or INSERT statements to be prepared with the isolation-clause attribute WITH UR.
- (DISALLOW_SSARAUTH) (QWP4DSSAR)
- Determines whether user address spaces are blocked from setting a Db2 address space as a secondary address space.
- (LA_SINGLESEL_ISOCS_CDY) (QWP4LSSIC)
- Specifies whether Db2 enables lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA(YES).
From DSN6FAC
- Enable SQL Interrupt
- Determines whether SQL Interrupt processing is enabled.
- (PRIVATE_PROTOCOL)
- Determines the Db2 behavior that is relative to legacy
private protocol usage.
- NO
- Does not allow private protocol-related behavior.
- AUTH
- Allows private protocol-related plan owner-based package authorization behavior.
- (DDF_COMPATIBILITY) (QWP9DDFCIP)
- Determines whether DDF behavior for compatibility with previous releases is enabled.
From DSNHDECP
- Db2 Supplied DECP Indic (DB2SUPLD) (QWPBDB2S)
- Db2-supplied DECP indication.
- Charset Default (CHARSET) (QWPBCHAR)
- Character set default. Db2 10 only.
Others
- Space Above Db2 Leave Available
- The amount of space that is kept available by Db2 for critical tasks.
- Space Reserved for Critical Work
- The amount of space that is reserved for critical work that must be completed.
- Space Reserved for z/OS Functions
- The amount of space that is reserved for z/OS functions.
- Extended Datestamp Indicator
- Determines whether the time stamp archive log data sets with the date in the format YYYYDDD are used.
- New Function Mode
- Determines whether subsystem is in the New Function mode.