Db2 Parameters attributes

Indicates whether Db2 prefetch uses sequential mode to read cached data from a 3990 controller. When BYPASS (default), Db2 prefetch bypasses the cache.

When SEQ, Db2 prefetch uses sequential access for read activity. There is a performance benefit using SEQ with DFSMS or DFP controls with newer 3990 caches.

Install parameter SEQUENTIAL CACHE on panel DSNTIPE, or ZPARM SEQCACH in DSN6SPRM.

Shows the name of the default access control exit module.

This field corresponds to field ACCESS CONTROL on installation panel DSNTIPO3. The ZPARM name is ACCESS CNTL MODULE in DSN6SYSP.

ZPARM TWOACTV in DSN6LOGP

The name of the JCL procedure for starting the DB2 administrative scheduler task address space.

DB2 parameter ADMTPROC in DSN6SPRM.

Shows the aggregation fields used for DDF and RRSAF accounting rollup. Values are defined as follows:

0

End user ID, transaction name, and workstation name

1

End user ID

2

End user transaction name

3

End user workstation name

4

End user ID and transaction name

5

End user ID and workstation name

6

End user transaction name and workstation name

This value is ignored if DDF or RRSAF accounting are not used. Db2 writes individual accounting threads for threads that do not have all aggregation fields populated that are specified by this parameter.

Install parameter AGGREGATION FIELDS on installation panel DSNTIPN, or ZPARM ACCUMUID in DSN6SYSP.

The unit used in allocating archive data sets. Possible values are CYLINDER, TRACK, and BLOCK.

Install parameter ALLOCATION UNITS on panel DSNTIPA, or ZPARM ALCUNIT in DSN6ARVP.

ZPARM ABIND in DSN6SPRM.

Indicates whether EXPLAIN processing occurs during automatic rebind.

YES means EXPLAIN processing happens during automatic rebind of a plan or package that has EXPLAIN(YES) as a bind option. If the PLAN TABLE does not exist, automatic rebind continues, but there is no EXPLAIN output. Explain processing does not happen for a plan or package with EXPLAIN(NO).

ZPARM ABEXP in DSN6SPRM.

Shows whether you have specified the TRACKMOD option on ALTER TABLESPACE for an implicitly created table space.

This field corresponds to field TRACK MODIFIED PAGES on installation panel DSNTIP7. The ZPARM name is IMPTKMOD in DSN6SPRM.

The name of the application registration table.

Install parameter APPL REGISTRATION TABLE on panel DSNTIPZ or ZPARM RGFNMPRT in DSN6SPRM.

The Application encoding scheme.

Install parameter APPLICATION ENCODING on installation panel DSNTIPF, or ZPARM APPENSCH in DSNHDECP.

The block size of the archive log data set.

The block size must be compatible with the device type used for archive logs. The value is rounded up to the next multiple of 4096 bytes.

If the archive log is written to tape, use the largest possible block size to improve the reading speed.

Recommended block size values are 28672 for tape, 20480 for 3380, and 24576 for 3390 or RAMAC .

Install parameter BLOCK SIZE on panel DSNTIPA, or ZPARM BLKSIZE in DSN6ARVP.

Indicates whether archive log data sets are protected with individual RACF profiles when they are created.

When YES, RACF protection must be active for DB2. YES also means that you cannot use RACF generic profiles for archive log data sets. If your archive log is on tape, RACF class TAPEVOL must be active, otherwise, the off-load will fail.

Install parameter ARCHIVE LOG RACF on panel DSNTIPP, or ZPARM PROTECT in DSN6ARVP.

The escape character used in the application registration table (ART) or object registration table (ORT).

Sets of names in the ART and ORT can be represented by patterns that use the underscore (_) and percent sign (%) characters in the same way as in an SQL LIKE predicate.

Install parameter ART/ORT ESCAPE CHARACTER on panel DSNTIPZ, or ZPARM RGFESCP in DSN6SPRM.

Indicates the ASCII graphic coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM AGCCSID in DSNHDECP.

Indicates the ASCII mixed coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM AMCCSID in DSNHDECP.

The ASCII single-byte coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM ASCCSID in DSNHDECP.

Indicates whether IRLM is started automatically by DB2.

Install parameter AUTO START on panel DSNTIPI, or ZPARM IRLMAUT in DSN6SPRM.

Indicates how much of the log to process for backout when LIMIT BACKOUT = YES or AUTO.

A table space might be in restart pending mode, without the associated index spaces also in restart pending mode. This happens if a postponed abort UR makes updates only to non-indexed fields of a table in a table space. In this case, the indexes are accessible to SQL (for index-only queries), even though the table space is inaccessible.

Install parameter BACKOUT DURATION on panel DSNTIPL, or ZPARM BACKODUR in DSN6SYSP.

CURRENT
V9
V9_TRIM
V9_DECIMAL_VARCHAR
N/P

ZPARM BIF_COMPATIBILITY in DSN6SPRM.

ZPARM BINDNV in DSN6SPRM.

Indicates whether prepared dynamic SQL statements are saved for later use by eligible application processes in the EDM pool.

Install parameter CACHE DYNAMIC SQL on panel DSNTIP8, or ZPARM CACHEDYN in DSN6SPRM.

ZPARM CATALOG in DSN6ARVP.

ZPARM CHECK FASTREPLICATION in DSN6SPRM.

ZPARM COMPACT in DSN6ARVP.

Indicates that DB2 is running in compatibility mode.

DB2 parameter COMPAT in DSNHDECP.

Shows the COMPRESS DEST(SMF) TRACE records. This field corresponds to field COMPRESS SMF RECS on installation panel DSNTIPN. ZPARM name: SMFCOMP in DSN6SYSP.

OFF means that the depth of the connection queue is limited by the value of the CONDBAT subsystem parameter. ON means that the depth of the connection queue is limited by the value of the MAXDBAT subsystem parameter. A numeric value specifies the maximum number of connections that can be queued waiting for a DBAT to process a request.

ZPARM MAXCONQN in DSN6FAC.

ON means that connections wait as long as the value specified by the IDHTOIN subsystem parameter. OFF means that connections wait indefinitely for a DBAT to process requests. A numeric value specifies a time duration in seconds that a connection waits for a DBAT to process the request.

ZPARM MAXCONQW in DSN6FAC.

YES

DB2 checks threads at commit points and periodically returns unused storage to the system.

NO

DB2 does not check threads at commit points and returns acquired storage on deallocation.

ZPARM RGFDEDPL in DSN6SPRM.

ZPARM FLASHCOPY COPY in DSN6SPRM.

The correlation ID of the online application that made the last change to DB2 system settings.

Shows the default for the CURRENT DEGREE special register when no degree is explicitly set with SET CURRENT DEGREE.

The default disables query parallelism.

Install parameter CURRENT DEGREE on panel DSNTIP8, or ZPARM CDSSRDEF in DSN6SPRM.

The default allows query rewrite using system-maintained materialized query tables (SYSTEM) when CURRENT REFRESH AGE is set to ANY. When USER, query rewrite is done using user-maintained materialized query tables when CURRENT REFRESH AGE is set to ANY. ALL means that query rewrite uses both system-maintained and user- maintained materialized query tables.

Install parameter CURRENT MAINT TYPES on panel DSNTIP8, or ZPARM MAINTYPE in DSN6SPRM.

Determines the default value that is to be used for the CURRENT QUERY ACCELERATION special register. Possible values are:

NONE

Indicates that no query acceleration is done. This is the default value.

ENABLE

Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.

ENABLE WITH FAILBACK

Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If the accelerator returns an error during the PREPARE or first OPEN for the query, DB2 executes the query without the accelerator. If the accelerator returns an error during a FETCH or a subsequent OPEN, DB2 returns the error to the user, and does not execute the query.

ELIGIBLE

Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine whether to accelerate the queries. Queries that are not eligible for acceleration are executed by DB2. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.

ALL

Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine whether to accelerate the queries. Queries that are not eligible for acceleration are not executed by DB2, and an SQL error is returned. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.

ZPARM name QUERY ACCELERATION in DSN6SPRM.

Shows the default for the CURRENT REFRESH AGE special register deferred materialized query tables.

Install parameter CURRENT REFRESH AGE on panel DSNTIP8, or ZPARM REFSHAGE in DSN6SPRM.

Shows the time out factor of the SQL data definition. The time out value is the product of this value and the IRLMRWT value. ZPARM name DDLTOX in DSN6SPRM.

Indicates whether data sharing is enabled.

Install parameter DATA SHARING on panel DSNTIPA1, or ZPARM DSHARE in DSN6GRP.

The default protocol (DRDA or PRIVATE) used when option DBPROTOCOL BIND is not explicitly specified for the bind of a plan or a package.

When field INSTALL TYPE on panel DSNTIPA1 is INSTALL, the default value for DATABASE PROTOCOL is DRDA. When the value of INSTALL TYPE is MIGRATE, the default value for DATABASE PROTOCOL is PRIVATE.

An application program might contain statements with three-part names, or aliases that reference remote objects. At bind or rebind of a plan, a user can specify whether these statements flow to the remote site using DB2 private or DRDA protocol.

DB2 private protocol is appropriate if you do not plan to move applications that use three- part names to DRDA access immediately. To use DRDA access for applications with three-part names, you must bind packages for those applications at each location that the applications access, then bind all packages into a plan. If you cannot perform this activity immediately, and you want your applications to continue to work, you should specify PRIVATE for DATABASE PROTOCOL.

The BIND commands for DB2-supplied applications are in job DSNTIJSG.

Install parameter DATABASE PROTOCOL on panel DSNTIP5, or ZPARM DBPROTCL in DSN6SYSP.

Install parameter DATASET STATS TIME on panel DSNTIPN, or ZPARM DSSTIME in DSN6SYSP.

Default output format for dates.

Valid formats are ISO (yyyy-mm-dd), USA (mm/dd/yyyy), EUR (dd.mm.yyyy), JIS (yyyy- mm-dd), or LOCAL (your choice, defined by a date exit routine). DB2 interprets the input date from the punctuation and converts the output date to the required format.

Install parameter DATE FORMAT on panel DSNTIP4, or ZPARM DATE in DSNHDECP.

Indicates that DECP is supplied by DB2.

Using a DB2 supplied DECP could cause data corruption due to applications using wrong CCSIDs.

Shows whether a DB2 administrator can create a view or alias for another user. Possible values are YES or NO. The default is NO.

Install parameter DBADM CREATE AUTH on panel DSNTIPP. ZPARM DBACRVW in macro DSN6SPRM.

The default value of null means that the data types of the returned output data match the data types of the parameters in the stored procedure definition. This is the default behavior starting in DB2 for z/OS Version 10.

ZPARM CMTSTAT in macro DSN6FAC.

Shows whether DB2 accounting data for DDF and RRSAF threads is accumulated by end user.

When NO, DB2 writes an accounting record when a DDF thread is made inactive, or when signon occurs for an RRSAF thread. A value in the range 2 through 65535 shows the number of times an end-user identifier should occur before DB2 writes an accounting record. An end-user identifier is the concatenation of the end-user user ID, end-user transaction name, and the end-user workstation name. Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN).

These values can be set by DDF threads using SERVER CONNECT and SET CLIENT calls, and by RRSAF threads using the RRSAF SIGN, AUTH SIGNON, and CONTEXT SIGNON functions.

An accounting record might be written prior to the number of end user occurrences in the following instances:

• When an internal storage threshold is reached for the accounting RRSAF signon call.
• When the thread deallocates, the accumulated accounting data for all end users on this thread is written (one record per end user).
• When this parameter is dynamically changed to deactivate accounting accumulation. In this instance, the next end-UR (for DDF thread) or signon (for a RRSAF thread) causes DB2 to write the accumulated accounting data for all end users on this thread (one record per end user).

The associated IRLM PROC parameter is DEADLOK.

The associated IRLM PROC parameter is DEADLOK.

Indicates the rules of precision for a decimal field.

Install parameter DECIMAL ARITHMETIC on panel DSNTIP4, or ZPARM DECARTH in DSNHDECP.

Indicates whether the decimal contains a comma (,) or a period (.). This parameter is used for dynamic SQL and COBOL programs. It is not used or supported by other languages.

Install parameter DECIMAL POINT IS on panel DSNTIPF, or ZPARM DECIMAL in DSNHDECP.

ZPARM DEF DECFLOAT ROUND MODE in DSNHDECP.

• Table spaces with a 16 KB page size in implicitly created databases
• Explicitly created table spaces with a 16 KB page size, but without a buffer pool clause that is specified in the create table space statement.

• Table spaces with a 32 KB page size in implicitly created databases
• Explicitly created table spaces with a 32 KB page size, but without a buffer pool clause that is specified in the create table space statement

• Table spaces with an 8 KB page size in implicitly created databases
• Explicitly created table spaces with an 8 KB page size, but without a buffer pool clause that is specified in the create table space statement.

Acceptable values are any 4 KB, 8 KB, 16 KB, or 32 KB buffer pool names. Default is BP0.

ZPARM TBSBPLOB in DSN6SYSP.

The TBSBPXML subsystem parameter specifies the default buffer pool that is to be used for XML table spaces that are created implicitly. Acceptable values are any 16 KB buffer pool name. Default is BP16K0.

ZPARM TBSBPXML in DSN6SYSP.

The default encoding scheme, which can be ASCII or EBCDIC, or UNICODE.

Install parameter DEF ENCODING SCHEME on panel DSNTIPF, or ZPARM ENSCHEME in DSNHDECP.

ZPARM FCCOPYDDN in DSN6SPRM.

ZPARM DEL_CFSTRUCTS_ON_RESTART in DSN6SYSP.

Shows whether DB2 builds a DESCRIBE SQLDA when binding static SQL statements.

When NO (default), DB2 does not generate a DESCRIBE SQLDA at BIND time for static SQL statements. If a DESCRIBE request is received at execution time, DB2 generates an error. However, if the describe request comes from a DESCRIBE CURSOR statement, DB2 satisfies the request but is only able to provide data type and length information. Column names are not provided.

When YES, DB2 generates a DESCRIBE SQLDA at BIND time so that DESCRIBE requests for static SQL can be satisfied during execution.

Install parameter DESCRIBE FOR STATIC on panel DSNTIP4, or ZPARM DESCSTAT in DSN6SPRM.

ZPARM UNIT in DSN6ARVP.

ZPARM DISABLE EDMRTS in DSN6SPRM.

ZPARM DISALLOW_DEFAULT_COLLID in macro DSN6SPRM.

In most cases, requesters tell DB2 whether the apostrophe or the quotation mark is to be used as the SQL string delimiter.

Acceptable values are ' (apostrophe) or " (quotation mark).

ZPARM DRDA_RESOLVE_ALIAS in macro DSN6SPRM.

If you run the installation or migration CLIST, the setting of the NUMBER OF COPIES field determines the setting of the TWOARCH subsystem parameter. Valid values of the TWOARCH subsystem parameter are NO and YES.

ZPARM TWOARCH in DSN6LOGP.

Shows whether two BSDS data sets are used.

A second BSDS (strongly recommended) makes recovery much easier in most situations. In cases that normally require recovery and restart, a second BSDS allows you to continue working. The storage overhead required is small and the data set is relatively inactive.

DB2 parameter TWOBSDS in DSN6LOGP.

The name of the DFSMSHSM dump class used by the restore system utility to restore from a system-level backup that has been dumped to tape.

Install parameter DUMP CLASS NAME on installation panel DSNTIP6, or ZPARM UTILS DUMP CLASS NAME in DSN6SPRM.

The EBCDIC graphic coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM GCCSID in DSNHDECP.

The EBCDIC mixed coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM MCCSID in DSNHDECP.

The EBCDIC single-byte coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM SCCSID in DSNHDECP.

ZPARM EDMBFIT in DSN6SPRM.

The size (in kilobytes) of the environmental descriptor manager (EDM) pool.

This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.

ZPARM EDMPOOL in DSN6SPRM.

The minimum size of the DBD cache that can be used by the Environmental Descriptor Manager (EDM). This value is used at DB2 startup time as the minimum value. You can increase and subsequently decrease the value with the SET SYSPARM command. This value cannot be decreased below the value that is specified at DB2 startup. This storage pool is located above the 2 GB bar. The CLIST calculates the DBD cache size.

The value used at DB2 startup time is either calculated by the CLIST based on input from other installation information or an override value.

ZPARM EDMDBDC in DSN6SPRM.

ZPARM EDMSTMTC in DSN6SPRM.

ZPARM EDM_SKELETON_POOL in DSN6SPRM.

ZPARM CHGDC in DSN6SPRM.

ATTRIBUTE1 specifies how DB2 weights I/O and CPU cost during access path selection. ENABLE is the default value. The OPTIOWGT subsystem parameter is deprecated.

ZPARM EN_PJSJ in DSN6SPRM.

Shows whether DataPropagator NonRelational (DPROP) is used to propagate SQL changes made to tables defined with DATA CAPTURE CHANGES.

Install parameter DPROP SUPPORT on panel DSNTIPO, or ZPARM EDPROP and CHGDC in DSN6SPRM.

Shows whether stage 1 predicate evaluation during table access can proceed upon uncommitted data or not.

This applies to isolation levels of Read Stability and Cursor Stability only.

When NO (default), predicate evaluation occurs only on committed data (or on the application's own uncommitted changes). NO ensures that all qualifying data is always included in the answer set.

When YES, predicate evaluation can occur upon uncommitted data. Only committed data is returned to the query. However, a decision can be made to omit a row from the answer set based on uncommitted data. Later, undo processing (statement rollback or statement failure) could cause the data to revert to a state that satisfies the predicate.

When YES, DB2 can request fewer locks than in previous versions when processing isolation level Read Stability and Cursor Stability queries. The number of locks avoided is related to the access path of the query, the number of rows evaluated when processing the stage 1 predicate of the query, and the number of those rows that are overflow rows. Specifically, for isolation level Read Stability and Cursor Stability queries, locks are avoided for rows that do not satisfy the stage 1 predicate, provided they are not overflow rows. Table access includes table space scans and index-to-data access, including ridlist-to-data access. For isolation Cursor Stability ridlist production, all row/page locking is avoided.

Install parameter EVALUATE UNCOMMITTED on panel DSNTIP8, or ZPARM EVALUNC in DSN6SPRM.

Indicates whether DB2 accepts TCP/IP connection requests containing only a user ID.

When YES, a connection request is accepted with a user ID only. This value must be the same for all members of a data sharing group.

When NO (default), TCP/IP clients must provide authentication information (password, RACF PassTicket, or Kerberos ticket) to gain access to DB2.

ZPARM TCPALVER in DSN6FAC.

Extended security options.

When YES (strongly recommended), detailed reason codes are returned to a DRDA level 3 client when a DDF connection request fails because of security errors. When using SNA protocols, the requester must have included a product that supports the extended security sense codes, such as DB2 Connect version 5 and subsequent releases.

RACF users can change their passwords using the DRDA change password function. This support is only for DRDA level 3 requesters that have implemented support for changing passwords.

YES allows properly enabled DRDA clients to determine the cause of security failures without requiring DB2 operator support.

When NO, generic error codes are returned to the clients and RACF users are prevented from changing their passwords.

ZPARM EXTSEC in DSN6SYSP.

The maximum number of extra DRDA query blocks DB2 requests from a remote DRDA server.

The default is 100.

This controls the total amount of data that can be transmitted on any given network exchange. It does not limit the size of the SQL query answer set.

ZPARM EXTRAREQ in DSN6SYSP.

The maximum number of extra DRDA query blocks DB2 returns to a DRDA client.

The default is 100.

This controls the total amount of data that can be transmitted on any given network exchange. It does not limit the size of the SQL query answer set.

ZPARM EXTRASRV in DSN6SYSP.

ZPARM REC FASTREPLICATION in DSN6SPRM.

ZPARM FLASHCOPY PPRC in DSN6SPRM.

ZPARM CACHEDYN_FREELOCAL in macro DSN6SPRM.

Determines the default value that is to be used for the CURRENT GET ACCEL ARCHIVE special register:

NO

Indicates that if a table is archived in an accelerator server, and a query references that table, the query does not use the data that is archived.

YES

Indicates that if a table is archived in an accelerator server, and a query references that table, the query uses the data that is archived.

ZPARM name GET ACCEL ARCHIVE in macro DSN6SPRM.

The name of the DB2 data sharing group.

The group name encompasses the entire data sharing group and is the basis for the coupling facility structure names.

N/A means this DB2 is not part of a data sharing group.

ZPARM GRPNAME in DSN6GRP.

ZPARM HONOR_KEEPDICTIONARY in macro DSN6SPRM

Indicates whose authorization is checked at a second server (sometimes called a hop site) when the requester is not DB2 for z/OS.

This option applies only when DB2 private protocol is used for the hop from the second to the third site.

When BOTH (default), the package owner's authorization is checked for static SQL, and the runner's authorization ID is checked for dynamic SQL.

When RUNNER, both static and dynamic SQL use the runner's authorization.

Install parameter AUTH AT HOP SITE on panel DSNTIP5, ZPARM HOPAUTH in DSN6SPRM.

The alias of the VSAM integrated catalog facility user catalog or the name of the master catalog where the DB2 VSAM data sets created during installation are cataloged. The MVS catalog alias is also used as the high-level qualifier for DB2 VSAM data sets.

Install parameter CATALOG ALIAS on panel DSNTIPA, or ZPARM CATALOG in DSN6ARVP.

Shows the name of the default identify or authorization exit module.

This field corresponds to field IDENTIFY/AUTH on installation panel DSNTIPO3. The ZPARM name is IDAUTH MODULE in DSN6SYSP.

The approximate time, in seconds, that an active server thread can remain idle before it is canceled.

Inactive and indoubt threads are not subject to timeout.

hreads are checked for timeouts every 3 minutes. This means that timeouts might not be honored for up to 3 minutes when the timeout value is less than this.

0 (default) means timeout processing is disabled, idle server threads remain in the system and continue to hold their resources, if any.

ZPARM IDTHTOIN in DSN6FAC.

ZPARM IGNSORTN in DSN6SPRM.

Indicates how DB2 updates group buffer pool dependent pages. This is only valid in a data-sharing environment.

Group buffer pool dependent pages can be written to DASD or SYSTEM pagesets.

Install parameter IMMEDIATE WRITE on panel DSNTIP8, or ZPARM IMMEDWRI in DSN6GRP.

The implicit time zone that is associated with DB2 table columns and routine parameters that are declared as time stamp with time zone.

For IFCID 106 - Application Programming Defaults, this field is displayed twice, with its hex value and in a readable string.

This field corresponds to DSNHDECP field IMPLICIT TIMEZONE.

The number of RESOURCE TIMEOUT units that an IMS BMP connection waits for a lock to be released.

The default value is 4, meaning that an IMS BMP connection can wait 4 times the resource timeout value for a resource.

Install parameter IMS BMP TIMEOUT on panel DSNTIPI, or ZPARM BMPTOUT in DSN6SPRM.

The number of RESOURCE TIMEOUT units that a DL/I batch connection waits for a lock to be released.

For example, if you use the default value of 6, a DL/I batch application can wait 6 times the resource timeout value for a resource.

Install parameter DL/I BATCH TIMEOUT on panel DSNTIPI, or ZPARM DLITOUT in DSN6SPRM.

Indicates whether data definition support has been installed.

Install parameter INSTALL DD CONTROL SUPT on panel DSNTIPZ, or ZPARM RGFINSTL in DSN6SPRM.

The number of seconds DB2 waits before querying whether IRLM has completed initialization.

DB2 parameter SPRMISWI in DSNMSPRM.

The IRLM subsystem name defined to MVS.

This is used for communication between DB2 and the IRLM. It is included in the MVS subsystem table IEFSSN xx, where xx is the value of SUBSYSTEM MEMBER on installation panel DSNTIPM.

If the IRLM for IMS is installed, the DB2 IRLM name is different because two IRLMs on the same MVS system must have unique names.

Install parameter SUBSYSTEM NAME on panel DSNTIPI, or ZPARM IRLMSID in DSN6SPRM.

NO

Includes all columns

YES

Includes trailing columns only if they affect partitioning

Install parameter LANGUAGE DEFAULT on panel DSNTIPF, or ZPARM DEFLANG in DSNHDECP.

ZPARM DLDFREQ in DSN6SYSP.

The LIKE BLANK INSIGNIFICANT field specifies whether blanks are significant when applying the LIKE predicate to a string.

When the LIKE predicate is applied against fixed length character column data, DB2 strips trailing blanks from the data before performing the comparison. If the data is all blank, DB2 reduces it to a single blank before performing the comparison.

If not set, LIKE treats trailing blanks within fixed length character strings as significant.

ZPARM LBACKOUT in DSN6SYSP.

ZPARM FLASHCOPY LOAD in DSN6SPRM.

Shows the length of the longest field required to hold a locally defined date.

The default (0) indicates an IBM-supplied format (ISO, JIS, USA, or EUR).

Install parameter LOCAL DATE LENGTH on panel DSNTIP4, or ZPARM DATELEN in DSNHDECP.

Shows the length of the longest field required to hold a time when a locally defined time format is used.

The default (0) indicates an IBM-supplied format (ISO, JIS, USA, or EUR).

Install parameter LOCAL TIME LENGTH on panel DSNTIP4, or ZPARM TIMELEN in DSNHDECP.

The default (SYSTEM) for the LOCKMAX clause of the SQL statements CREATE TABLESPACE and ALTER TABLESPACE.

Install parameter LOCKS PER TABLE(SPACE) on panel DSNTIPJ, or ZPARM NUMLKTS in DSN6SPRM.

The maximum number of page or row locks that a single application can hold concurrently on all table spaces.

This includes locks on data pages, index pages, subpages, and rows that the program acquires when it accesses table spaces.

The limit applies to all table spaces defined with the LOCKSIZE PAGE, LOCKSIZE ROW, or LOCKSIZE ANY options. 0 means that there is no limit to the number of page and row locks a program can acquire.

DB2 assumes that 250 bytes of storage are required for each lock. If NO is specified for CROSS MEMORY, the value of this field has to take into account the available lock space. If referential constraints between tables is defined, the value of this field might need to be increased.

Install parameter LOCKS PER USER on panel DSNTIPJ, or ZPARM NUMLKUS in DSN6SPRM.

ZPARM CHKTYPE in DSN6SYSP.

Install parameter MANAGE THREAD STORAGE on panel DSNTIPE, or ZPARM MINSTOR in DSN6SPRM.

For best performance, this parameter should be NO, meaning DB2 does not manage thread storage.

When YES, DB2 uses best fit algorithm to manage and assign thread storage. This can help on systems that have many long-running threads and that are constrained on DBM1 address space.

The number of times a stored procedure is allowed to terminate abnormally, after which SQL CALL statements for the stored procedure are rejected.

Install parameter MAX ABEND COUNT on panel DSNTIPX, or ZPARM STORMXAB in DSN6SYSP.

• All batch jobs using QMF.
• All batch jobs using the DSN command processor.
• All tasks connected to DB2 through call attach facility (CAF) running in batch. This can include:
  • Batch jobs using QMF
  • APPC applications
  • TCP/IP FTP connections

Install parameter MAX BATCH CONNECT on panel DSNTIPE, or ZPARM IDBACK in DSN6SYSP.

ZPARM MAX_CONCURRENT_PKG_OPS in macro DSN6SPRM.

• TSO user (whether running a DSN command or a DB2 request from QMF)
• Batch job (whether running a DSN command or a DB2 utility)
• IMS region that can access DB2
• Active CICS transaction that can access DB2
• Task connected to DB2 through the call attachment facility.

ZPARM MXDTCACH in DSN6SPRM

The maximum DBM1 storage that can be used by the fast log apply process. The default value is 0 MB, which means that fast log apply is disabled except during DB2 restart, when fast log apply is always enabled.

Install parameter LOG APPLY STORAGE on panel DSNTIPL, or ZPARM LOGAPSTG in DSN6SYSP.

Shows the maximum DSSIZE in gigabytes that DB2 uses for creating each partition of an implicitly created base table space.

This field corresponds to field DEFAULT DSSIZE on installation panel DSNTIP7. The ZPARM name is IMPDSSIZE in DSN6SPRM.

Indicates the number of type 1 inactive threads that DB2 allows.

A large number of type 1 inactive threads can adversely affect system performance. Type 1 inactive threads are used for DB2 private protocol.

DRDA uses type 2 inactive threads.

Zero indicates that type 1 inactive connections are not allowed. Threads remain active when they become eligible to be made a type 1 inactive thread.

A value greater than zero indicates that type 1 inactive connections are allowed, but are limited to this number. When a thread becomes eligible to be made a type 1 inactive thread, and this threshold is reached, the remote connection is terminated.

When this is equal to MAX REMOTE CONNECTED on panel DSNTIPE, DB2 allows all remote threads to become type 1 inactive threads.

Install parameter MAX INACTIVE DBATS on panel DSNTIPR, or ZPARM MAXTYPE1 in DSN6FAC.

ZPARM INLISTP in macro DSN6SPRM.

The maximum number of data sets that can be open at one time.

The practical limit can be less than the MVS limit of 32727, depending on available storage below the line.

Install parameter DSMAX on panel DSNTIPC, or ZPARM DSMAX in DSN6SPRM.

Shows the maximum number of cursors, including allocated cursors, that are open at a given DB2 site per thread. RDS keeps a total of currently open cursors. If an application attempts to open a thread after the maximum is reached, the statement will fail.

In a data sharing group, this parameter is shown at member scope.

Install parameter MAX OPEN CURSORS on panel DSNTIPX, or ZPARM MAX_NUM_CUR in DSN6SPRM.

The maximum number of concurrently open data sets for processing LOB file references.

Install parameter MAX OPEN FILE REFS on panel DSNTIPE or ZPARM MAXOFILR in DSN6SYSP.

When DDF THREADS is ACTIVE and MAX REMOTE CONNECTED has not been reached, the allocation request is allowed but any further processing for the connection is queued waiting for an active database access thread to terminate.

When DDF THREADS is INACTIVE and MAX REMOTE CONNECTED has not been reached, the allocation request is allowed and is processed when DB2 can assign an unused database access thread slot to the connection.

The total number of threads accessing data concurrently is the sum of MAX USERS and MAX REMOTE ACTIVE. The maximum allowable value for this sum is 2000.

Install parameter MAX REMOTE ACTIVE on panel DSNTIPE, or ZPARM MAXDBAT in DSN6SYSP.

-1

If MAXTEMPS RID=NONE

0

If MAXTEMPS RID=NOLIMIT

1 to 329166

Otherwise

The amount of storage needed for the RID pool.

This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.

When 0, DB2 does not use access paths or join methods that depend on RID pool storage.

Install parameter RID POOL SIZE on panel DSNTIPC, or ZPARM MAXRBLK in DSN6SPRM.

Shows the maximum number of stored procedures per thread. If an application attempts to call a stored procedure after this is reached, the statement will fail. In a data sharing group, this parameter is shown as member scope.

Install parameter MAX STORED PROCS on panel DSNTIPX, or ZPARM MAX_ST_PROC in DSN6SPRM.

• Each TSO foreground user executing a DSN command.
• Each TSO foreground user connected to DB2 through the call attachment facility (CAF). This can include QMF users running in TSO foreground or user-written CAF applications running in TSO foreground.

Install parameter MAX TSO CONNECT on panel DSNTIPE, or ZPARM IDFORE in DSN6SYSP.

Indicates the upper limit on the degree of parallelism for a parallel group.

This field has a value of 0. This means PARAMDEG is not set and DB2 can set a default maximum degree of parallelism based on the system configuration.

Install parameter MAX DEGREE on panel DSNTIP8, or ZPARM PARAMDEG in DSN6SPRM.

The percentage of maximum open data sets until the asynchronous drain operations are stopped.

DB2 parameter SPRMMDD in DSNDSPRM.

The maximum number of LE tokens active at any time. When zero, no tokens are available.

A token is used each time one of the following is used: trigonometry functions, degrees, radians, rand, exp, power, log functions, upper, lower, translate.

Install parameter MAXIMUM LE TOKENS on panel DSNTIP7, or ZPARM LEMAX in DSN6SPRM.

The maximum number of archive log volumes that can be recorded in the BSDS.

When this number is exceeded, recording resumes at the beginning of the BSDS.

For dual archive, this value applies to each log data set. As an example, a value of 500 allows 500 COPY-1 and 500 COPY-2 data sets in the BSDS.

You must create image copies of all DB2 objects, probably several times, before the archive log data sets are discarded. If you fail to retain an adequate number of archive log data sets for all the image copies, you might need to cold start or reinstall DB2. In either case, data is lost.

Install parameter RECORDING MAX on panel DSNTIPA, or ZPARM MAXARCH in DSN6LOGP.

The maximum number of tape units that can be allocated for archive read purposes.

Install parameter READ TAPE UNITS on panel DSNTIPA, or ZPARM MAXRTU in DSN6LOGP.

The maximum number of tape units or tape drives that the restore system utility can use to restore from a system-level backup that has been dumped to tape.

Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE TAPEUNITS in DSN6SPRM.

The member name of this DB2.

N/A means this DB2 is not part of a data sharing group.

Install parameter MEMBER NAME on panel DSNTIPK, or ZPARM MEMBNAME in DSN6GRP.

ZPARM DECDIV3 in DSN6SPRM.

Shows the number of minutes between log checkpoints if the LOG checkpoint type is BOTH (records and minutes).

This field corresponds to field MINUTES/CHECKPOINT on installation panel DSNTIPL1, or ZPARM name CHKMINS in DSN6SYSP.

Checkpoint frequency. This shows either the number of minutes (1 through 60) or the number of DB2 log records between the start of successive checkpoints. DB2 starts a new checkpoint when this value is reached.

You can use the SET LOG command to change the number of log records between checkpoints dynamically. Valid values are 1-60 when specifying a time value and 200-16000000 when specifying a number of records.

Install parameter CHECKPOINT FREQ on panel DSNTIPL, ZPARM CHKFREQ in DSN6SYSP.

The MIXED DATA option has no effect on the UNICODE CCSID field. Regardless of the setting for MIXED DATA, UNICODE UTF-8 data is considered mixed data and is processed according to the rules for mixed data.

Install parameter MONITOR TRACE on panel DSNTIPN, or ZPARM MON in DSN6SYSP.

If YES, the Db2 subsystem/group is running in New Function Mode. At this mode/catalog level, the New Function Mode is enabled and available. The DB2 catalog is completely Unicode (UTF-8) and long names can be used.

Install parameter INSTALL TYPE on panel DSNTIPA1, or ZPARM NEWFUN in DSNHDECP.

DB2 parameter NPGTHRSH in DSN6SPRM.

The name of the object registration table.

Install parameter OBJT REGISTRATION TABLE on panel DSNTIPZ, or ZPARM RGFNMORT in DSN6SPRM.

ZPARM OPT1ROWBLOCKSORT in macro DSN6SPRM.

Shows whether DB2 can use optimization hints from the PLAN TABLE to influence the access paths used for certain queries.

Install parameter OPTIMIZATION HINTS on panel DSNTIP8, or ZPARM OPTHINTS in DSN6SPRM.

Indicates whether outer join performance enhancements are enabled.

DB2 parameter OJPERFEH in DSN6SPRM.

The output log buffer size in kilobytes.

There is only one output log buffer per Db2 subsystem.

Increasing this parameter reduces BSDS I/O updates when there is a buffer wraparound. Frequent wraparounds are likely in LOAD or REORG with logging, and mass insert operations.

Increasing this parameter also helps avoid log write waits for an available buffer during heavy update workload.

When the specified size is not a 4 KB multiple, it is rounded up to the next 4 KB multiple.

Install parameter OUTPUT BUFFER on DSNTIPL, or ZPARM OUTBUFF in DSN6LOGP.

The amount of storage allocated for caching authorization information for all packages on this DB2 member.

32 KB hold about 375 collection-ID.package-IDs. The cache is stored in the DSN1DBM1 address space.

Install parameter PACKAGE AUTH CACHE on panel DSNTIPP, or ZPARM CACHEPAC in DSN6SPRM.

The PACKAGE_DEPENDENCY_LEVEL subsystem parameter specifies whether packages record package-level dependencies only or record both package-level and statement-level dependencies. The subsystem parameter sets the default value for the DEPLEVEL option of the BIND PACKAGE command. The value of the DEPLEVEL option on BIND or REBIND always overrides the value of the PACKAGE_DEPENDENCY_LEVEL subsystem parameter.

Valid values are P (package) and S (statement). The default value is P.

DSN6SPRM: PACKAGE_DEPENDENCY_LEVEL

DB2 13 and later.

• YES indicates that a new index is padded unless the NOT PADDED option is specified on the CREATE INDEX statement.
• The default value, NO, indicates that a new index is not padded unless the PADDED option is specified on the CREATE INDEX statement.

Shows whether output host variables that are NULL-terminated strings are padded with blanks and a NULL terminator.

When NO, NULL-terminated output host variables have the NULL terminator placed at the end of actual data returned in the host variable. When YES, NULL-terminated output host variables have the NULL terminator placed at the end of the string, after the string has been padded with blanks from the end of the actual data to the declared length of the output host variable.

Install parameter PAD NUL-TERMINATED on installation panel DSNTIP4, or ZPARM PADNTSTR in DSNHDECP.

Indicates whether DB2 generates a trace record at the originating task level that summarizes accounting information for all parallel tasks.

DB2 parameter PTASKROL in DSN6SYSP.

Shows whether this DB2 member can assist a parallelism coordinator with parallel processing.

When YES, this member is considered an assistant at both bind and run time. To be a viable assistant at run time, both the VPPSEQT and VPXPSEQT buffer pool thresholds of this member must be greater than 0.

N/A means this DB2 is not part of a data sharing group.

Install parameter ASSISTANT on panel DSNTIPK or ZPARM ASSIST in DSN6GRP.

Shows whether this DB2 member can coordinate parallel processing on other members of the group.

When NO, a query can be processed by this DB2 member only.

When YES, a read-only query running on this DB2 member can be processed in part on other members of the group.

N/A means this DB2 is not part of a data sharing group.

Install parameter COORDINATOR on panel DSNTIPK or ZPARM COORDNTR in DSN6GRP.

ZPARM PARA EFF in DSN6SPRM.

The size of the authorization cache to be used if no CACHESIZE is specified on the BIND PLAN subcommand.

The size of the cache is 32 bytes of overhead + (8 bytes of storage X number of concurrent users).

0 means authorization caching is not used.

Install parameter PLAN AUTH CACHE on panel DSNTIPP, or ZPARM AUTHCACH in DSN6SPRM.

ZPARM PLANMGMTSCOPE in DSN6SPRM.

The approximate time, in seconds, that a DBAT can remain idle in the pool before it is terminated.

A DBAT thread in the pool counts as an active thread against MAX REMOTE ACTIVE and can hold locks, but does not have any cursors.

Threads are checked for timeouts every 3 minutes. This means that timeouts might not be honored for up to 3 minutes when the timeout value is less than this. The default is 120.

Install parameter POOL THREAD TIMEOUT on panel DSNTIP5, ZPARM POOLINAC in DSN6FAC.

The primary space allocation for archive data sets.

Install parameter PRIMARY QUANTITY on installation panel DSNTIPA, or ZPARM PRIQTY in DSN6ARVP.

The Private protocol is no longer supported for DB2 10; however, this subsystem parameter controls package EXECUTE authorization behavior related to remote DB2 requester applications. When a remote DB2 requester application accesses the server Db2 subsystem through DRDA protocol, a plan owner is associated with the remote DB2 requester application plan. For packages that are executed as part of this plan by a remote DB2 requester application using DRDA protocol, the PRIVATE_PROTOCOL parameter has the following effects. This parameter is online updatable, and valid values are NO and AUTH.

The name of the IRLM procedure invoked by MVS if AUTO START is YES.

The name cannot be the same as the subsystem name given for SUBSYSTEM NAME.

Install parameter PROC NAME on panel DSNTIPI, or ZPARM IRLMPRC in DSN6SPRM.

Specifies additional types of SQL queries that are eligible for acceleration.

NONE

Indicates that no additional types of SQL queries are eligible. Therefore, the types of queries that are described in the other available values for this parameter are not eligible for acceleration. This is the default value.

1

Indicates that queries that include data that is encoded with the EBCDIC mixed or graphic encoding schemes are eligible for acceleration.

2

Indicates that an INSERT with SELECT statement is eligible for acceleration. However, only the SELECT operation of the query is processed by the accelerator server.

3

Indicates that queries that contain built-in functions for which DB2 processes each byte of the input string, rather than each character of the input string, can run on an accelerator server.

ZPARM name QUERY ACCEL OPTIONS in macro DSN6SPRM.

The maximum amount of time (in seconds) permitted for DB2 to attempt a full system quiesce.

Install parameter QUIESCE PERIOD on panel DSNTIPA, or ZPARM QUIESCE in DSN6ARVP.

ZPARM RANDOMATT in DSN6GRP.

This field indicates whether the COPY2 archives should be read first when the Db2 subsystem is started.

Install parameter READ COPY2 ARCHIVE on DSNTIPO, or ZPARM ARC2FRST in DSN6LOGP.

The time interval that DB2 waits before it attempts to write out page set statistics to the real-time statistics tables. This value is between 1 and 65535 minutes.

Install parameter REAL TIME STATS on panel DSNTIPO, or ZPARM STATSINT in DSN6SPRM.

ZPARM FLASHCOPY REBUILD INDEX in DSN6SPRM.

• YES indicates that DFSMShsm is invoked to automatically recall migrated table spaces. This is the default.
• NO indicates that a DB2 table space that has been migrated is considered to be an unavailable resource. It must be recalled explicitly before DB2 can use it.

ZPARM RECALL in DSN6SPRM .

If the recall is not completed within the specified number of seconds, the program receives an error message indicating that the set is unavailable, but that a recall was initiated. If you use 0 and the RECALL DATABASE field is YES, the recall is performed asynchronously. This field is ignored if the RECALL DATABASE field is NO. The RECALL DELAY option is not used when running a DB2 utility against a DB2-migrated data set.

ZPARM RECALLD in DSN6SPRM.

Shows the number of records between log checkpoints if the LOG checkpoint type is BOTH (records and minutes).

This field corresponds to field RECORDS/CHECKPOINT on installation panel DSNTIPL1, or ZPARM name CHKLOGR in DSN6SYSP.

Checkpoint frequency. This shows either the number of minutes (1 through 60) or the number of DB2 log records between the start of successive checkpoints. DB2 starts a new checkpoint when this value is reached.

You can use the SET LOG command to change the number of log records between checkpoints dynamically. Valid values are 1-60 when specifying a time value and 200-16000000 when specifying a number of records.

Install parameter CHECKPOINT FREQ on panel DSNTIPL, ZPARM CHKFREQ in DSN6SYSP.

The name of the database that contains the registration tables.

Install parameter REGISTRATION DATABASE on panel DSNTIPZ, or ZPARM RGFDBNAM in DSN6SPRM.

The owner of the application registration table and the object registration table.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter REGISTRATION OWNER on panel DSNTIPZ, or ZPARM RGFCOLID in DSN6SPRM.

Indicates whether, at commit time, DB2 should release a data page or row lock on which a cursor defined WITH HOLD is positioned.

This lock is not necessary for maintaining cursor position.

YES indicates that DB2 releases this data page or row lock after a COMMIT is issued for cursors defined WITH HOLD. This can improve concurrency.

NO indicates that DB2 holds the data page or row lock for WITH HOLD cursors after the COMMIT. This option is provided to allow existing applications, which rely on this lock to continue to work correctly. Otherwise this field is left blank.

Install parameter RELEASE CURSOR HOLD LOCKS on panel DSNTIP8, or ZPARM RELCURHL in DSN6SPRM.

The value of this parameter specifies whether most newly created table spaces are to store data in reordered row format (RRF) or basic row format (BRF) by default.

ENABLE

Newly created table spaces or newly added partitions that are created by ALTER ADD PARTITION statements on partition-by-growth table spaces will be created in RRF. Existing BRF table spaces will be converted to RRF by running LOAD REPLACE or REORG TABLESPACE.

DISABLE

Newly created table spaces, including universal table spaces, and newly added partitions that are created by ALTER ADD PARTITION statements on partition-by-growth table spaces will be created in BRF. Existing BRF table spaces will not be converted to RRF by LOAD REPLACE or REORG TABLESPACE.

ZPARM FLASHCOPY REORG INDEX in DSN6SPRM.

ZPARM REORG_LIST_PROCESSING in macro DSN6SPRM.

ZPARM REORG PART SORT NPSI in DSN6SPRM.

ZPARM FLASHCOPY REORG TS in DSN6SPRM.

Indicates whether registered objects require fully qualified names.

Install parameter REQUIRE FULL NAMES on panel DSNTIPZ, or ZPARM RGFFULLQ in DSN6SPRM.

Shows the size of the RES trace table in 4 KB blocks. A value of 16 means 64 KB have been allocated for this table.

This is the default destination for the global trace records in DB2. Most trace records require 32-byte entries; events with more than three data items require 64-byte entries.

Install parameter TRACE SIZE on panel DSNTIPN, or ZPARM TRACTBL in DSN6SYSP.

The authorization ID used for the resource limit facility (governor).

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter RESOURCE AUTHID on panel DSNTIPP, or ZPARM RLFAUTH in DSN6SYSP.

The number of seconds before a timeout is detected.

This is an integer multiple of DEADLOCK TIME on panel DSNTIPJ.

Timeout means that a lock request has waited for a resource (or for claims on a resource for a particular claim class to be released) longer than this time.

For data sharing, the actual timeout period is longer than the timeout value.

Install parameter RESOURCE TIMEOUT on panel DSNTIPI, or ZPARM IRLMRWT in DSN6SPRM.

ZPARM RESTART in DSN6SPRM.

If YES, the system-level backup that is the recovery base, is from a dump on tape. Otherwise NO is shown.

Install parameter RESTORE/RECOVER on installation panel DSNTIP6, or ZPARM RESTORE RECOVER FROMDUMP in 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 (default) and YES.

The number of minutes between resynchronization periods.

A resynchronization period is the time during which indoubt logical units of work involving this Db2 subsystem and partner logical units are processed.

Install parameter RESYNC INTERVAL on panel DSNTIPR, or ZPARM RESYNC in DSN6FAC.

Indicates whether a request is suspended until an incompatible retained lock becomes available.

This value is only significant in a data sharing environment. It indicates how long a transaction should wait for a lock on a resource if another DB2 in the data sharing group has failed and is holding an incompatible lock on that resource. Locks held by failed DB2 members are called retained locks.

This value is a multiplier that is applied to the connection's normal timeout value. For example, if the retained lock multiplier is 2, then the timeout period for a call attachment connection that is waiting for a retained lock is twice the normal CAF timeout period. The default is 0, meaning applications do not wait for incompatible retained locks, the lock request is immediately rejected and the application receives a "resource unavailable" SQLCODE.

Install parameter RETAINED LOCK TIMEOUT on panel DSNTIPI, or ZPARM RETLWAIT in DSN6SPRM.

The number of days DB2 keeps archive log data sets.

This value is added to the current date to calculate the expiration date.

The retention period is often used in tape management systems to control the reuse and scratching of data sets and tapes. DB2 uses this as the value for the dynamic allocation parameter DALRETPD when archive log data sets are created.

Install parameter RETENTION PERIOD on panel DSNTIPA, or ZPARM ARCRETN in DSN6ARVP.

Shows what DB2 does when the governor cannot access the resource limit specification table or when no row in the table matches the currently executing statement.

NOLIMIT (default) allows all dynamic SQL statements to run without limit.

NORUN terminates all dynamic SQL statements immediately with an SQL error code.

The number of CPU service units allowed for a query can be anywhere from 1 to 5000000.

Install parameter RLST ACCESS ERROR on panel DSNTIPR, or ZPARM RLFERRD in DSN6FAC.

NOLIMIT

The dynamic SQL statements run without limit.

NORUN

The dynamic SQL statements terminated with an SQL error code.

A number from 1 to 5000000 represents the number of CPU service units allowed for a query.

Install parameter RLST ACCESS ERROR on panel DSNTIPO, or ZPARM RLFERR in DSN6SYSP.

The number of consecutive DB2 checkpoints that a page set or partition can remain in read/write mode since it was last updated. When this limit or the RO SWITCH TIME is reached, DB2 changes the page set or partition to read only.

This can improve performance for recovery, logging, and data-sharing processing.

Install parameter RO SWITCH CHKPTS on panel DSNTIPL, or ZPARM PCLOSEN in DSN6SYSP.

The number of minutes that a page set or partition can remain in read-write mode since it was last updated. When this limit or the RO SWITCH CHKPTS is reached, DB2 changes the page set or partition to read-only.

This can improve performance for recovery, logging, and data-sharing processing.

Install parameter RO SWITCH TIME on panel DSNTIPL, or ZPARM PCLOSET in DSN6SYSP.

The amount of storage allocated for caching authorization information for all routines on this DB2 member.

Routines include stored procedures and user-defined functions.

32 KB hold about 380 schema.routine.type entries.

Install parameter ROUTINE AUTH CACHE on panel DSNTIPP, or ZPARM CACHERAC in DSN6SPRM.

This field corresponds to field SEC ADMIN 1 TYPE on installation panel DSNTIPP1, or ZPARM SECADM1_TYPE in DSN6SPRM.

This field corresponds to field SEC ADMIN 2 TYPE on installation panel DSNTIPP1, or ZPARM SECADM2_TYPE in DSN6SPRM.

The device type or unit name for storing archive log data sets.

The value can be any alphanumeric string. If you choose to archive to DASD, you can specify a generic device type with a limited volume range. DB2 requires that all archive log data sets allocated on DASD are cataloged.

If the device type is DASD, CATALOG DATA must be set to YES. If the unit name specifies DASD, the archive log data sets can extend to a maximum of 15 volumes. PRIQTY and SECQTY must be large enough to contain all active log data set data without extending beyond 15 volumes. If the unit name specifies a tape device, DB2 can extend to a maximum of 20 volumes. Default is TAPE.

Install parameter DEVICE TYPE 1 on panel DSNTIPA, or ZPARM UNIT in DSN6ARVP.

Security administrator 1 authorization ID (blank if ROLE).

This field corresponds to field SECURITY ADMIN 1 on installation panel DSNTIPP1, or ZPARM SECADM1 in DSN6SPRM.

Security administrator 2 authorization ID (blank if ROLE).

This field corresponds to field SECURITY ADMIN 2 on installation panel DSNTIPP1, or ZPARM SECADM2 in DSN6SPRM.

This field corresponds to field SEC ADMIN 1 TYPE on installation panel DSNTIPP1, or ZPARM SECADM1_TYPE in DSN6SPRM.

This field corresponds to field SEC ADMIN 2 TYPE on installation panel DSNTIPP1, or ZPARM SECADM2_TYPE in DSN6SPRM.

ZPARM CHECK SETCHKP in DSN6SPRM.

Shows the name of the default signon exit module.

This field corresponds to field SIGNON on installation panel DSNTIPO3. The ZPARM name is SIGNON MODULE in DSN6SYSP.

Indicates whether single-volume DASD archives are used.

Install parameter SINGLE VOLUME on panel DSNTIPA, or ZPARM SVOLARC in DSN6ARVP.

Shows whether this system is at a local site or a recovery site.

The RECOVER utility uses this parameter to determine what site the current system is on and recovers everything from the copies of data registered at that site.

The RECOVER and MERGECOPY utilities use this to determine whether COPYDDN or RECOVERDDN is allowed with NEWCOPY NO.

Install parameter SITE TYPE on panel DSNTIPO, or ZPARM SITETYP in DSN6SPRM.

ZPARM SKIPUNCI in DSN6SPRM.

Acceptable values are blank (default) or a valid SMS data class name.

ZPARM CATDDACL in DSN6SPRM.

Acceptable values are blank (default) or a valid SMS management class name.

ZPARM CATDMGCL in DSN6SPRM.

Acceptable values are blank (default) or a valid SMS storage class name.

ZPARM CATDSTCL in DSN6SPRM.

Indicates the amount of storage needed for the sort pool.

This can be the value calculated by the CLIST, based on input from previous panels, or the value entered in the Override column at installation time.

Install parameter SORT POOL SIZE on panel DSNTIPC, or ZPARM SRTPOOL in DSN6SPRM.

Default inline length for any new storing large object (LOB) column in a Universal Table Space on the Db2 subsystem. The valid values are from 0 to 32680 inclusive (in bytes). The default value for this ZPARM is 0, which indicates that no inline attribute is required for any LOB column (BLOB, CLOB or DBCLOB) created on this subsystem. If NOINLINE is specified, the value is set to -1.

Acceptable values are DEFAULT (the default value), " (quotation mark), or ' (apostrophe).

Install parameter STD SQL LANGUAGE on panel DSNTIP4, or ZPARM STDSQL in DSNHDECP.

Shows the maximum size, in MB, of the virtual memory pool for star join queries. When zero, DB2 does not allocate a memory pool for star join queries, even if star join queries are enabled. A value between 1 and 1024, shows that DB2 uses a dedicated memory pool up to the size shown for star join queries.

Install parameter STAR JOIN MAX POOL on panel DSNTIP8, or ZPARM SJMXPOOL in DSN6SPRM.

ZPARM STARJOIN in DSN6SPRM.

The minimum number of tables in the star schema query block, including the fact table, dimensions tables, and snowflake tables. This value is considered only if the subsystem parameter STARJOIN qualifies the query for star join.

DB2 parameter SJTABLES in DSN6SPRM.

Shows whether the global trace is started automatically when DB2 is started.

When YES, the global trace starts for the default classes (classes 1, 2, and 3) whenever DB2 is started, and additional data consistency checks are made whenever a data page or index page is modified. When ALL, the global trace is automatically started for all classes.

The global trace is used to diagnose problems in DB2 but it also impacts DB2 performance. If you have production systems requiring high performance, you might consider turning off global trace. If you do this, be aware that this presents a serviceability exposure. In the event of a system failure, IBM service personnel will ask you to turn on global trace and attempt to recreate the problem.

Install parameter TRACE AUTO START on panel DSNTIPN, or ZPARM TRACSTR in DSN6SYSP.

Shows whether DB2 sends accounting data to SMF automatically when DB2 is started. Numeric values show what classes are sent. When YES, the default class (class 1) is sent. When ALL, accounting classes one through five are started.

The SMFPRM xx member of SYS1.PARMLIB must also be set to allow SMF to write the records.

Install parameter SMF ACCOUNTING on panel DSNTIPN, or ZPARM SMFACCT in DSN6SYSP.

Shows whether a Statistics trace was started automatically at DB2 startup time.

The classes started are shown separated by commas.

DB2 sends collected trace data to SMF. The SMFPRM xx member of SYS1.PARMLIB must be set to allow SMF to write the records.

Install parameter SMF STATISTICS on panel DSNTIPN, or ZPARM SMFSTAT in DSN6SYSP.

Shows if the RUNSTATS utility uses enhanced or standard clustering statistics: ENHANCED is used if it is on, otherwise STANDARD is shown.

Install parameter STATISTICS CLUSTERING on panel DSNTIP6, or ZPARM STATCLUS in DSN6SPRM.

Shows which inserts and updates are recorded in catalog history tables.

Install parameter STATISTICS HISTORY on panel DSNTIPO, or ZPARM STATHIST in DSN6SPRM.

Shows whether RUNSTATS utility aggregates the partition level statistics, even though some parts may not contain data.

This should be YES for DB2 systems that have large partitioned table spaces, index spaces, or both. This enables the aggregation of part level statistics and helps the optimizer to choose a better access path.

Install parameter STATISTICS ROLLUP on panel DSNTIPO, or ZPARM STATROLL in DSN6SPRM.

Shows whether DB2 statistics recording is synchronized with some part of the hour. The installation can specify that the DB2 statistics recording interval be synchronized with the beginning of the hour (00 minutes past the hour) or any number of minutes past the hour up to 59. Possible values are: 0-59, which indicate the synchronization point. When NO or N/A is shown, synchronization is disabled, this is the default.

If STATISTICS TIME INTERVAL IN MINUTES (STATIME) is greater than 60, NO or N/A is shown.

Install parameter STATISTICS SYNC on panel DSNTIPN, or ZPARM SYNCVAL in DSN6SYSP.

Install parameter STRING DELIMITER on panel DSNTIPF, or ZPARM DELIM in DSNHDECP.

The CPU service unit conversion factor for this CPU.

This factor allows conversion CPU time in seconds to a common unit, called service unit (SU). The conversion factor used depends on the machine. Service units allow you to calculate CPU execution times across a data sharing group.

Specifies whether to enable or disable multiple index access on some non-Boolean uncorrelated subquery predicates.

ZPARM SUBQ_MIDX in macro DSN6SPRM.

The MVS subsystem name for DB2. The name is used in member IEFSSN xx of SYS1.PARMLIB.

A valid name has 1-4 characters, the first must be A-Z, #, $, or @. Others must be A-Z, 1-9, #, $, or @. Default is DSN1.

Install parameter SUBSYSTEM NAME on panel DSNTIPM, or ZPARM SSID in DSNHDECP.

Shows whether the recording of errors, such as invalid decimal data and arithmetic exceptions, in the operating system data set SYS1.LOGREC is suppressed.

When YES, these exceptions are not recorded in the LOGREC data set.

Install parameter SUPPRESS SOFT ERRORS on panel DSNTIPM or ZPARM SUPERRS in DSN6SPRM.

One of two authorization IDs with SYSADM authority. SYSADM users can access to DB2 in all cases.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter SYSTEM ADMIN 1 on panel DSNTIPP, or ZPARM SYSADM in DSN6SPRM.

One of two authorization IDs with SYSADM authority. SYSADM users can access to DB2 in all cases.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter SYSTEM ADMIN 2 on panel DSNTIPP, or ZPARM SYSADM2 in DSN6SPRM.

Shows if RECOVER uses system level backups as the recovery base.

Install parameter SYSTEM-LEVEL BACKUPS on installation panel DSNTIP6, or ZPARM SYSTEM LEVEL BACKUPS in DSN6SPRM.

One of two authorization IDs with SYSOPR authority. SYSOPR users can access DB2 even if the DB2 catalog is unavailable.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter SYSTEM OPERATOR 1 on panel DSNTIPP, or ZPARM SYSOPR1 in DSN6SPRM.

One of two authorization IDs with SYSOPR authority. SYSOPR users can access DB2 even if the DB2 catalog is unavailable.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter SYSTEM OPERATOR 2 on panel DSNTIPP, or ZPARM SYSOPR2 in DSN6SPRM.

The number of minutes an archive read tape unit can remain unused before it is deallocated.

When archive log data is read from tape, this value should be high enough to allow DB2 to optimize tape handling for multiple read applications.

Install parameter DEALLOC PERIOD on panel DSNTIPA, or ZPARM DEALLCT in DSN6LOGP.

Indicates whether DB2 accepts TCP/IP connection requests containing only a user ID.

When NO (default), TCP/IP clients must provide authentication information (password, RACF PassTicket, or Kerberos ticket) to gain access to DB2.

When YES, a connection request is accepted with a user ID only. This value must be the same for all members of a data sharing group.

To ensure user credentials are not exposed in the network, SERVER_ENCRYPT is recommended.

Install parameter TCP/IP ALREADY VERIFIED on panel DSNTIP5, or ZPARM TCPALVER in DSN6FAC.

Indicates whether the TCP/IP configuration KeepAlive value has been overwritten.

When ENABLE (default), KeepAlive is enabled, the TCP/IP configuration stack value is used.

When DISABLE, TCP/IP KeepAlive has been disabled.

A value in the range 1 through 65534 means KeepAlive is active, and the TCP/IP stack value has been overridden. The number reported shows the time, in seconds, between TCP/IP probes.

When considering overwriting the keep-alive time, it is recommended to set a value close to the IDLE THREAD TIMEOUT value on installation panel DSNTIPR or the IRLM RESOURCE TIMEOUT value on installation panel DSNTIPI. It is good practice to set all these to about five minutes, or less.

Because KeepAlive detection is accomplished by probing the network at this interval, avoid small values, which can cause excessive network traffic and system resource consumption.

The trick is to find a proper balance that allows network failures to be detected on a timely basis without impacting system and network performance.

Install parameter TCP/IP KEEPALIVE on panel DSNTIP5, ZPARM TCPKPALV in DSN6FAC.

Shows the device type or unit name for allocating temporary data sets. It is the direct access or disk unit name used for the precompiler, compiler, assembler, sort, linkage editor, and utility work-files in the tailored jobs and CLISTs.

It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION options for DFSORT.

The default is SYSDA.

Install parameter TEMPORARY UNIT NAME on DSNTIPA2, or ZPARM VOLTDEVT in DSN6SPRM.

The value of TEMPORARY UNIT NAME is the direct access or disk unit name that is used for the precompiler, compiler, assembler, sort, linkage editor, and utility work files in the tailored jobs and CLISTs.

Indicates the default output format for times.

Valid values are ISO (hh.mm.ss), USA (hh:mm AM), EUR (hh.mm.ss), JIS (hh:mm:ss), or LOCAL (your choice, defined by a time exit routine). DB2 interprets the input time from the punctuation and converts the output time to the required format.

Install parameter TIME FORMAT on panel DSNTIP4, or ZPARM TIME in DSNHDECP.

The IRLM wait time in seconds.

DB2 autostart abends if IRLM does not start within this time.

Install parameter TIME TO AUTOSTART on panel DSNTIPI, or ZPARM IRLMSWT in DSN6SPRM.

The approximate time, in seconds, that an active server thread can remain idle before it is canceled.

Inactive and indoubt threads are not subject to timeout.

Threads are checked for timeouts every 3 minutes. This means that timeouts might not be honored for up to 3 minutes when the timeout value is less than this.

0 (default) means timeout processing is disabled, idle server threads remain in the system and continue to hold their resources, if any.

Install parameter IDLE THREAD TIMEOUT on panel DSNTIPR, or ZPARM IDTHTOIN in DSN6FAC.

The number of seconds before DB2 stops waiting for an SQL CALL statement to be assigned to one of the TCBs in the DB2 stored procedures address space.

Install parameter TIMEOUT VALUE on panel DSNTIPX, or ZPARM STORTIME in DSN6SYSP.

Indicates whether this subsystem is a remote tracker site for another Db2 subsystem.

When YES, this is a tracker site.

A DB2 tracker site is a separate Db2 subsystem or data sharing group that exists solely for the purpose of keeping shadow copies of your primary site's data. No independent work can be run on the tracker site.

Install parameter TRACKER TYPE on panel DSNTIPO, or ZPARM TRKRSITE in DSN6SPRM.

Indicates whether the U (UPDATE) lock is used when using repeatable read (RR) or read stability (RS) isolation to access a table.

When YES, the U lock is used for an updated cursor with repeatable read or read stability.

When NO, the S lock is used for an updated cursor with repeatable read or read stability. If the cursor in the running applications includes the clause FOR UPDATE OF, but updates are infrequent, S locks generally provide better performance.

Install parameter U LOCK FOR RR/RS on panel DSNTIPI, or ZPARM RRULOCK in DSN6SPRM.

Unicode graphics character set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM UGCCSID in macro DSNHDECP.

Install parameter UNICODE IFCIDS on panel DSNTIPN, or ZPARM UIFCIDS in DSN6SYSP.

Unicode Mixed Character Set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM UMCCSID in macro DSNHDECP.

Unicode Single Byte Character Set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM USCCSID in macro DSNHDECP.

The authorization ID used if RACF is not available for batch access and USER= is not specified in the job statement.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter UNKNOWN AUTHID on panel DSNTIPP, or ZPARM DEFLTID in DSN6SPRM.

The action taken for DDL that names an unregistered object.

Options are REJECT, ACCEPT, or APPL, which rejects the DDL when the current application is not registered.

Install parameter UNREGISTERED DDL DEFAULT on panel DSNTIPZ, or ZPARM RGFDEFLT in DSN6SPRM.

Indicates whether values in columns that participate in partitioning keys can be updated.

Possible values are YES, NO, or SAME. When SAME, updates are allowed only when the updated row remains in the same partition. The default value is YES.

Install parameter UPDATE PART KEY COLS on panel DSNTIP8, or ZPARM PARTKEYU in DSN6SPRM.

Shows the number of checkpoint cycles to complete before DB2 issues a warning message to the console and writes an IFCID 313 record for an uncommitted, indoubt, or inflight unit of recovery (UR). The default is 0, which disables this option.

Install parameter UR CHECK FREQ on panel DSNTIPL, or ZPARM URCHKTH in DSN6SYSP.

Shows the number of log records that are to be written by an uncommitted unit of recovery (UR) before DB2 issues a warning message to the console. This provides notification of a long-running UR. Long-running URs might result in a lengthy DB2 restart or a lengthy recovery situation for critical tables. Log records are specified in 1-K (1000 log records) increments. A value of 0 indicates that no write check is to be performed.

Install parameter UR LOG WRITE CHECK on panel DSNTIPL, ZPARM URLGWTH in DSN6SYSP.

Shows whether DB2 uses the application programming defaults specified on this panel or those of the DB2 precompiler options for dynamic SQL statements bound using DYNAMICRULES bind, define, or invoke behavior.

When YES, the application programming (DSNHDECP) defaults are used for dynamic SQL statements in plans or packages bound using DYNAMICRULES bind, define, or invoke behavior.

When NO, values of the precompiler options are used for dynamic SQL statements in plans or packages bound with DYNAMICRULES(BIND).

Install parameter USE FOR DYNAMICRULES on panel DSNTIP4, or ZPARM DYNRULS in DSNHDECP.

Shows whether DB2 performs authorization checking.

When all authorization checking by DB2 is disabled, the GRANT statement is also disabled (granting every privilege to PUBLIC); this is not recommended.

Install parameter USE PROTECTION on panel DSNTIPP, or ZPARM AUTH in DSN6SPRM.

ZPARM DB2SORT in DSN6SPRM.

ZPARM UTSORTAL in DSN6SPRM.

Shows whether utilities that scan a nonpartitioned index followed by an update of a subset of the pages in the index allow data to remain in 3990 cache longer when reading data.

Install parameter UTILITY CACHE OPTION on panel DSNTIPE, or ZPARM SEQPRES in DSN6PRM.

Shows how much longer utilities can wait for a resource than SQL applications can.

This is the number of RESOURCE TIMEOUT units that a utility or utility command can wait for a lock or for all claims on a resource of a particular claim class to be released. The default value is 6, meaning a utility can wait 6 times longer than an SQL application for a resource.

Install parameter UTILITY TIMEOUT on panel DSNTIPI, or ZPARM UTIMOUT in DSN6SPRM.

The percentage below 100% DSMAX that open data sets can reach before an asynchronous drain is started. The default is 1, meaning that asynchronous drain starts when the number of open data sets reaches 99% of DSMAX.

When one of these limits is reached, DB2 closes a number of data sets not in use equal to 3% (default) of the value DSMAX. Thus, DSMAX controls not only the limit of open data sets, but also the number of data sets that are closed when that limit is reached.

DB2 parameter SPRMTDD in DSN6SPRM.

Indicates whether the VARCHAR column is retrieved from the index.

The data sharing scope of this parameter is GROUP.

When NO, index-only access of variable length column data is disabled. DB2 must retrieve data from the data page. Data is retrieved with no padding.

When YES, index-only access of variable length column data is enabled. This can improve performance. Data retrieved from the index is padded with blanks to the maximum length of the column.

Install parameter VARCHAR FROM INDEX on panel DSNTIP8, or ZPARM RETVLCFK in DSN6SPRM.

The alert threshold of high space-usage for DGTTs or non-DGTT work files in the Workfile Database by an agent (derived from ZPARM WFSTGUSE_AGENT_THRESHOLD).

The alert threshold of high space-usage for DGTTs or non-DGTT work files in the Workfile Database (derived from zparm WFSTGUSE_SYSTEM_THRESHOLD).

Workload manager environment.

Install parameter WLM ENVIRONMENT on panel DSNTIPX, or ZPARM WLMENV in DSN6SYSP.

The MVS console routing codes.

These codes are assigned to messages that are not solicited from a specific console. Up to 16 comma-separated codes can be shown.

Install parameter WTO ROUTE CODES on panel DSNTIPO, or ZPARM ROUTCDE in DSN6SYSP.

Indicates whether DB2 must send a message to the operator and wait for an answer before attempting to mount an archive log data set.

Other DB2 users can be forced to wait while the mount is pending. They are not affected while DB2 is waiting for a response to the message.

When YES, a device such as tape is used that requires long delays for mounts. DEVICE TYPE 1 shows the device type or unit name.

Install parameter WRITE TO OPER on panel DSNTIPA, or ZPARM ARCWTOR in DSN6ARVP.

The locking method used when performing a searched UPDATE or DELETE.

When NO, DB2 uses an S or U lock when scanning for qualifying rows. For any qualifying rows or pages the lock is upgraded to an X lock before performing the update or delete. For nonqualifying rows or pages the lock is released if using ISOLATION(CS). For ISOLATION(RS), or ISOLATION(RR), an S lock is retained on the rows or pages until the next commit point. This option is used to achieve higher rates of concurrency.

When YES, DB2 gets an X lock on qualifying rows or pages. For ISOLATION(CS), the lock is released if the rows or pages are not updated or deleted. For ISOLATION(RS) or ISOLATION(RR), an X lock is retained until the next commit point. This is beneficial in a data sharing environment when most or all searched updates and deletes use an index. The downside is that if searched updates or deletes result in a tablespace scan, the likelihood of timeouts and deadlocks greatly increases.

Install parameter X LOCK FOR SEARCHED U/D on panel DSNTIPI, or ZPARM XLKUPDLT in DSN6SPRM.

ZPARM XML RANDOMIZE in DSN6SYSP.