IFCID 106 - System Initialization Parameters
This topic shows detailed information about "Record Trace - IFCID 106 - System Initialization Parameters".
When this block contains names that are too long for the space available, they are truncated. The full name is shown in the list of long names, which is printed at the end of this block. When present, the list shows the parameter identifier, in alphabetic order, and the complete name. If the name is too long for one line, it continues on the next.
Record trace - IFCID 106 - System Initialization Parameters
The field labels shown in the following sample layout of "Record Trace - IFCID 106 - System Initialization Parameters" are described in the following section.
SYSTEM INITIALIZATION PARAMETERS
CHECKP FREQUENCY : 5 TRACETAB SIZE(4K): 16 GLOBAL CLASSES ..: X'00000000'
WTO ROUTE CODES .: X'8000' LOCAL TRACETAB SZ: 16 STATS CLASSES ...: X'BC000000'
BACKGROUND IDS ..: 50 MONITOR BUF SIZE : 1048576 ACCOUNT CLASSES .: X'80000000'
FOREGROUND IDS ..: 50 STATS INTERVAL ..: 1 AUDIT CLASSES ...: X'00000000'
RLIMIT TABLE ID .: 01 PSEUDOCLOSE CHCKP: 10 MONITOR CLASSES .: X'80000000'
RLIMIT TAB AUTHID: SYSIBM PSEUDOCLOSE MIN .: 10 REM THRDS(ACTIVE): 200
RLF DYNAMIC ERROR: NOLIMIT CONCURR THREADS .: 200 REM THRDS(CONN) .: 10000
RLF STATIC ERROR.: NOLIMIT RLF SCOPE........: DYNAMIC
RLF AUTO START ..: NO UR LOG THRESHOLD : 10000 LIMIT BACKOUT ...: AUTO
EXTENDED SECURITY: YES UR CHECK FREQ ...: 5 BACKOUT DURATION : 5
WLM ENVIRONMENT .: N/P
ROLLUP PARAL THRD: YES UNIT PRICE TRACK : NO OTC LIC ACCEPTED : NO
LEVEL ID CHECKPS : 5 USER LOB VAL STOR: N/A USER XML VAL (KB): N/A
DEF 4K BP U.DATA : BP0 SYS LOB VAL STOR : 51200 SYS XML VAL (MB) : 51200
DEF 8K BP U.DATA : BP8K0 LOB INLINE LENGTH: 0 RANDOM XML DOCID : NO
DEF 16K BP U.DATA: BP16K0 EXTRA BLOCKS SRV : 100 SYNCVAL W/IN HOUR: N/P
DEF 32K BP U.DATA: BP32K EXTRA BLOCKS REQ : 100 SYNCHR FLAG .....: NO
DEF BP USER INDEX: BP0 DDF/RRSAF ACCUM .: 10 TS ALLOCATION ...: 0
DEF BP IMPL LOB .: BP0 DSET STATS TIME .: 5 IX ALLOCATION ...: 0
DEF BP IMPL XML .: BP16K0 UNICODE IFCIDS ..: NO OPT EXTENT SIZING: NO
VARY DS CTRL INTV: YES DEL CF STRUCTS ..: NO DEF PART SEGSIZE : 32
AGGREGATION FLDS : 0 USE DATA COMPRESS: NO DSSIZE IMPL TS ..: 4
DEFINE DATA SETS : YES COMPRESS SMF RECS: OFF TRACKMOD IMPL TS : YES
PARAMETER MODULE : DC11BIF9 MAX OPEN FILE REF: 100 RESERV Z/OS SPACE: 40960
ACCESS CONTROL ..: DSNX@XAC CHECKPOINT TYPE .: SINGLE RESERV CRIT SPACE: 26279936
IDENTIFY/AUTH ...: DSN3@ATH RECORDS/CHECKP ..: N/P RESERV SOS SPACE : 26279936
SIGNON ..........: DSN3@SGN MINUTES/CHECKP ..: N/P PROFILE AUTOSTART: NO
QWP1LVLC ........: DSN1210 QWP1LVL .........: 99 QWP1DONT ........: NO- CHECKP FREQUENCY
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.
Field Name: QWP1LOGL
- TRACETAB SIZE(4K)
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.
Field Name: QWP1TRSZ
- GLOBAL CLASSES
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.
Field Name: QWP1TRST
- WTO ROUTE CODES
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.
Field Name: QWP1SMRC
- LOCAL TRACETAB SZ
The size of the local trace tables in multiples of 4 KB.
ZPARM name TRACLOC in DSN6SYSP.
Field Name: QWP1TLSZ
- STATS CLASSES
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.
Field Name: QWP1SMFS
- BACKGROUND IDS
- The maximum allowed number of concurrent connections for batch jobs and utilities. This includes:
- 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.
Field Name: QWP1IDB
- MONITOR BUF SIZE
The default number of bytes allocated for the monitor trace buffer.
Install parameter MONITOR SIZE on panel DSNTIPN, or ZPARM MONSIZE in DSN6SYSP.
Field Name: QWP1MONS
- ACCOUNT CLASSES
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.
Field Name: QWP1SMFA
- FOREGROUND IDS
The maximum number of concurrent TSO foreground connections (QMF, DSN, DB2I, and SPUFI).
Each of the following is a separate user:- 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.
When the number of TSO users attempting to access DB2 exceeds this limit, connection requests are rejected.
There is no subsystem parameter to control the maximum concurrent connections for IMS and CICS. These are controlled by using IMS and CICS facilities. For CICS attachment, the maximum number of connections to DB2 can be controlled using the resource control table (RCT) TYPE=INIT THRDMAX value.
Install parameter MAX TSO CONNECT on panel DSNTIPE, or ZPARM IDFORE in DSN6SYSP.
Field Name: QWP1IDF
- STATS INTERVAL
The time interval, in minutes, between statistics collections. Statistics records are written approximately at the end of this interval.
Install parameter STATISTICS TIME on panel DSNTIPN, or ZPARM STATIME in DSN6SYSP.
Field Name: QWP1STIM
- AUDIT CLASSES
Shows whether the audit trace is started automatically when DB2 is started.
When YES, the audit trace is started for the default class (class 1) whenever DB2 is started. When ALL, an audit trace is automatically started for all classes.
Install parameter AUDIT TRACE on panel DSNTIPN, or ZPARM AUDITST in DSN6SYSP.
Field Name: QWP1AUDT
- RLIMIT TABLE ID
The default resource limit specification table (RLST) suffix.
This suffix is used when the resource limit facility (governor) is automatically started or when the governor is started without specifying a suffix.
Install parameter RLST NAME SUFFIX on panel DSNTIPO4, or ZPARM
RLFTBL in DSN6SYSP.Prior to DB2 12:
Install parameter RLST NAME SUFFIX on panel DSNTIPO4, or
ZPARM RLFTBL in DSN6SYSP.Field Name: QWP1RLFT
- PSEUDOCLOSE CHCKP
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.
Field Name: QWP1FREQ
- MONITOR CLASSES
Shows whether the monitor trace is started automatically when DB2 is started. When YES, the default (trace class 1) is started. Numeric values show which classes are started. When ALL, monitor trace classes 1 through 8 are started.
Install parameter MONITOR TRACE on panel DSNTIPN, or ZPARM MON in DSN6SYSP.
Field Name: QWP1MON
- RLIMIT TAB AUTHID
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.
Field Name: QWP1RLFA
- PSEUDOCLOSE MIN
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.
Field Name: QWP1TMR
- REM THRDS(ACTIVE)
The maximum number of database access threads (DBATs) that can be active concurrently.
When this limit has been reached, DB2 uses the value of DDF THREADS on panel DSNTIPR to decide how to handle a new allocation request.
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.
Field Name: QWP1RMT
- RLF DYNAMIC ERROR
Shows whether the resource limit facility (governor) is automatically started when DB2 is started.
Install parameter RLF AUTO START on panel DSNTIPO4, or ZPARM RLF in DSN6SYSP.
Field Name: QWP1RLF
- CONCURR THREADS
The maximum number of allied threads (threads started at the local subsystem) that can be allocated concurrently.
Separate threads are created for each occurrence of the following:- 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.
Install parameter MAX USERS on panel DSNTIPE, or ZPARM CTHREAD in DSN6SYSP.
Field Name: QWP1CT
- REM THRDS(CONN)
The maximum allowed number of concurrent remote connections.
When this limit is reached, any new connection request is rejected.
Install parameter MAX REMOTE CONNECTED on panel DSNTIPE, or ZPARM CONDBAT in DSN6SYSP.
Field Name: QWP1CDB
- UR LOG THRESHOLD
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.
Field Name: QWP1LWCK
- LIMIT BACKOUT
Shows whether some backward log processing should be postponed.
When NO, DB2 backward log processing processes all inflight units of recovery (URs) and URs for abending transactions.
When YES, DB2 postpones backout processing for some units of work until the command RECOVER POSTPONED is issued.
AUTO (default) postpones some backout processing but automatically starts the backout processing when DB2 restarts and begins accepting new work.
When YES or AUTO, backout processing runs concurrently with new work. Page sets or partitions with backout work pending are unavailable until their backout work is complete.
Install parameter LIMIT BACKOUT on panel DSNTIPL, or ZPARM LBACKOUT in DSN6SYSP.
Field Name: QWP1LMBO
- EXTENDED SECURITY
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.
Install parameter EXTENDED SECURITY on panel DSNTIPR, or ZPARM EXTSEC in DSN6SYSP.
Field Name: QWP1SCER
- UR CHECK FREQ
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.
Field Name: QWP1URCK
- BACKOUT DURATION
Indicates how much of the log to process for backout when LIMIT BACKOUT = YES or AUTO.
During restart, backward log processing continues until both of the following events occur:- All inflight and inabort URs with update activity against the catalog or directory are backed out.
- The number of log records processed is equal to the number specified in BACKOUT DURATION times the value of CHECKPOINT FREQ. If the checkpoint frequency is specified in minutes, the number of records processed is the default of 50000 records multiplied by the value of CHECKPOINT FREQ.
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.
Field Name: QWP1BDUR
- WLM ENVIRONMENT
Workload manager environment.
Install parameter WLM ENVIRONMENT on panel DSNTIPX, or ZPARM WLMENV in DSN6SYSP.
Field Name: QWP1WLME
- ROLLUP PARAL THRD
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.
Field Name: QWP1PROL
- UNIT PRICE TRACK
- Specifies whether
DB2® performs
detailed tracking for measured usage pricing. You can select
the following
values:
- YES
- DB2 does detailed measured usage tracking if SMF type 89 records are activated. When SMF89 is set to YES, DB2 invokes a z/OS® service on every entry into or exit out of DB2 to ensure accurate tracking.
- NO (the default value)
- DB2 does not do detailed measured usage tracking.
If the SMF type
89 record is activated, only high-level tracking is recorded
in the
SMF type 89 record. Selecting NO reduces CPU usage,
but also increases
the amount of time spent in DB2 as measured by SMF 89.
Note: Select SMF89 YES only if you use measured usage pricing.
DB2 parameter SMF89.
Field Name: QWP1SM89
- OTC LIC ACCEPTED
- Indicates that the one-time charge (OTC) license
terms are accepted for this
DB2 installation.DB2 parameter OTC_LICENSE.
Field Name: QWP1OLAC
- LEVEL ID CHECKPS
- Shows how often, in checkpoints, the level ID of a page
set or partition is updated. When zero
(0), down-level detection is disabled. When five (5),
down-level is enabled. Use the following criteria to decide on a suitable value for this parameter:
- How often are backup and restore methods used outside of the DB2 control (such as DSN1COPY or DFDSS dump and restore)? If rarely used, there is no need to update the level ID frequently.
- How many page sets are open for update at the same time? If DB2 updates level IDs frequently, there is extra protection against down-level page sets. However, a performance degradation can occur if the level IDs for many page sets must be set at every checkpoint.
- How often does the subsystem take checkpoints? If the DB2 subsystem takes frequent system checkpoints, set the level ID frequency to a higher value.
Install parameter LEVELID UPDATE FREQ on panel DSNTIPL, or ZPARM DLDFREQ in DSN6SYSP.
Field Name: QWP1DFRQ
- USER LOB VAL STOR
The maximum amount of storage (KB) each user can use for LOB values.
Install parameter USER LOB VALUE STORAGE on panel DSNTIP7, or ZPARM LOBVALA in DSN6SYSP.
Field Name: QWP1LVA
- USER XML VAL (KB)
The maximum amount of memory in kilobytes (KB) for each user for storing XML values.
ZPARM XMLVALA in DSN6SYSP.
Field Name: QWP1XVA
- DEF 4K BP U.DATA
The name of the 4 KB buffer pool for user table spaces.
Install parameter DEFAULT BUFFER POOL FOR USER DATA on installation panel DSNTIP1, or ZPARM TBSBPOOL in DSN6SYSP.
Field Name: QWP1TBPL
- SYS LOB VAL STOR
The maximum amount of storage (MB) each system can use for LOB values.
Install parameter SYSTEM LOB VALUE STORAGE on panel DSNTIP7, or ZPARM LOBVALS in DSN6SYSP.
Field Name: QWP1LVS
- SYS XML VAL (MB)
The maximum amount of memory in megabytes (MB) for each system for storing XML values.
ZPARM XMLVALS in DSN6SYSP.
Field Name: QWP1XVS
- DEF 8K BP U.DATA
- The default 8 KB buffer pool for:
- 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.
Field Name: QWP1TP8
- LOB INLINE LENGTH
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 desired for any LOB column (BLOB, CLOB or DBCLOB) created on this subsystem.
Field Name: QWP1LBIL
- RANDOM XML DOCID
Specifies whether DB2 generates document ID elements sequentially or randomly. Possible values are:
- YES
- Sequentially
- NO
- Randomly
ZPARM name XML_RANDOMIZE_DOCID in DSN6SYSP.
Field Name: QWP1XRDI
- DEF 16K BP U.DATA
- The default 16 KB buffer pool for:
- 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.
Field Name: QWP1TP16
- EXTRA BLOCKS SRV
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.
Install parameter EXTRA BLOCKS SRV on panel DSNTIP5, ZPARM EXTRASRV in DSN6SYSP.
Field Name: QWP1EXBS
- SYNCVAL W/IN HOUR
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.
Field Name: QWP1SYNV
- DEF 32K BP U.DATA
- The default 32 KB buffer pool for:
- 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.
Field Name: QWP1TP32
- EXTRA BLOCKS REQ
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.
Install parameter EXTRA BLOCKS REQ on panel DSNTIP5, ZPARM EXTRAREQ in DSN6SYSP.
Field Name: QWP1EXBR
- SYNCHR FLAG
Interval synchronization flag, shows whether the synchronization is enabled. The default is NO. When YES, the DB2 statistics are synchronized to the value shown in INTERVAL SYNCHR W/IN HOUR.
Field Name: QWP1SYFL
- DEF BP USER INDEX
The name of the 4 KB buffer pool used for indexes on user data.
Install parameter DEFAULT BUFFER POOL FOR USER INDEXES on installation panel DSNTIP1, or ZPARM IDXBPOOL in DSN6SYSP.
Field Name: QWP1IXPL
- DDF/RRSAF ACCUM
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.
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).
Install parameter DDF/RRSAF ACCUM on installation panel DSNTIPN, or ZPARM ACCUMACC in DSN6SYSP.
Field Name: QWP1ACCU
- TS ALLOCATION
Shows the amount of space in KB for primary and secondary space allocation for DB2-defined data sets for table spaces created without the USING clause. 0 indicates that DB2 uses standard defaults.
Install parameter TABLE SPACE ALLOCATION on panel DSNTIP7, or ZPARM TSQTY in DSN6SYSP.
Field Name: QWP1TSQT
- DEF BP IMPL LOB
The name of the buffer pool that is used for implicitly created LOB table spaces. This field corresponds to field default buffer pool for USER LOB DATA on installation panel DSNTIP1. The ZPARM name is TBSBPLOB in DSN6SYSP.
Field Name: QWP1TPLB
- DSET STATS TIME
The time interval, in minutes, before DB2 resets data set statistics collected for the online performance monitors. Online performance monitors can request DB2 data set statistics for the current interval with an IFI READS request for IFCID 199.
Install parameter DATASET STATS TIME on panel DSNTIPN, or ZPARM DSSTIME in DSN6SYSP.
Field Name: QWP1DTIM
- IX ALLOCATION
Shows the amount of space in KB for primary and secondary space allocation for DB2-defined data sets for index spaces created without the USING clause. 0 indicates that DB2 uses standard defaults.
Install parameter INDEX SPACE ALLOCATION on panel DSNTIP7, or ZPARM IXQTY in DSN6SYSP.
Field Name: QWP1IXQT
- DEF BP IMPL XML
The name of the buffer pool that is used for XML table spaces. This field corresponds to field default buffer pool for USER XML DATA on installation panel DSNTIP1. The ZPARM name is TBSBPXML in DSN6SYSP.
Field Name: QWP1TPXM
- UNICODE IFCIDS
Shows whether output from IFC records should include Unicode information. Only a subset of the character fields (identified in the IFCID record definition by a %U in the comment area to the right of the field declaration in the DSNDQWxx copy files) are encoded in Unicode. The remaining fields maintain the same encoding of previous releases.
Install parameter UNICODE IFCIDS on panel DSNTIPN, or ZPARM UIFCIDS in DSN6SYSP.
Field Name: QWP1_UNICODE
- OPT EXTENT SIZING
Indicates whether DB2 uses sliding secondary quantity for DB2 managed data sets to optimize extent sizing.
Install parameter OPTIMIZE EXTENT SIZING on panel DSNTIP7, or ZPARM MGEXTSZ in DSN6SYSP.
Field Name: QWP1MESZ
- VARY DS CTRL INTV
Indicates whether DB2 optimizes VSAM CONTROL INTERVAL to page size for data set allocation.
Install parameter VARY DS CONTROL INTERVAL on panel DSNTIP7, or ZPARM DSVCI in DSN6SYSP.
Field Name: QWP1VVCI
- DEL CF STRUCTS
- Shows whether to:
- Delete change-data (CD) structures during restart
- Attempt to delete coupling-facility (CF) structures, including shared communications area (SCA) structures, internal resource lock manager (IRLM lock) structures, and allocated group buffer pools.
This field corresponds to field DEL CF STRUCTS on installation panel DSNTIPK.
ZPARM name DEL_CFSTRUCTS_ON_RESTART in DSN6SYSP.
Field Name: QWP1DCFS
- DEF PART SEGSIZE
The default segment size to be used for a partitioned table space when the CREATE TABLESPACE statement does not include the SEGSIZE parameter. This field corresponds to field DEFAULT PARTITION SEGSIZE on installation panel DSNTIP7. The ZPARM name is DPSEGSZ IN DSN6SYSP.
Field Name: QWP1DPSS
- AGGREGATION FLDS
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.
Field Name: QWP1ACID
- USE DATA COMPRESS
Shows whether data compression in table spaces in implicitly defined databases is used.
Install parameter USE DATA COMPRESSION on panel DSNTIP7 or ZPARM IMPTSCMP in DSN6SYSP.
Field Name: QWP1CITS
- DSSIZE IMPL TS
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.
Field Name: QWP1DSSZ
- DEFINE DATA SETS
Defines the underlying data sets when a table space (TS) that is contained in an implicitly created database is created.
Install parameter DEFINE DATA SETS on panel DSNTIP7 or ZPARM IMPDSDEF in DSN6SYSP.
Field Name: QWP1DIDS
- COMPRESS SMF RECS
Shows the COMPRESS DEST(SMF) TRACE records. This field corresponds to field COMPRESS SMF RECS on installation panel DSNTIPN. ZPARM name: SMFCOMP in DSN6SYSP.
Field Name: QWP1CSMF
- TRACKMOD IMPL TS
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.
Field Name: QWP1TKMD
- PARAMETER MODULE
Shows the name of the active subsystem parameter module.
This field corresponds to field PARAMETER MODULE on installation panel DSNTIPO3.
Field Name: QWP1ZPNM
- MAX OPEN FILE REF
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.
Field Name: QWP1MOFR
- RESERV Z/OS SPACE
- The amount of space reserved for MVS
functions.
Field Name: QWP1DB1M
- ACCESS CONTROL
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.
Field Name: QWP1DXAC
- CHECKPOINT TYPE
Shows the LOG checkpoint type. It can have the following values:
- SINGLE
- Either records or minutes.
- BOTH
- Both records and minutes, as specified by Records Between Checkpoint (QWP1LOGR) and Mins Between Checkpoint (QWP1LOGM).
ZPARM CHKTYPE in DSN6SYSP.
Field Name: QWP1LOGT
- RESERV CRIT SPACE
The amount of space reserved for critical work that must be completed.
Field Name: QWP1CRIT
- IDENTIFY/AUTH
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.
Field Name: QWP1DATH
- RECORDS/CHECKP
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.
Field Name: QWP1LOGR
- RESERV SOS SPACE
The amount of space above z/OS and critical (QWP1DB1M + QWP1CRIT) that DB2 tries to leave available.
Field Name: QWP1SOS
- SIGNON
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.
Field Name: QWP1DSGN
- MINUTES/CHECKP
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.
Field Name: QWP1LOGM
- PROFILE AUTOSTART
- Specifies whether START PROFILE command processing
is automatically initiated as part of DB2 startup
(DB2 field: QWP1PFASY):
- 0 indicates NO
- 1 indicates YES
Field Name: QWP1PFASY
- QWP1LVLC
- This field is for IBM service use.
Field Name: QWP1LVLC
- QWP1LVL
Level of this block. It is used to detect parameters or code that is out of sync.
Field Name: QWP1LVL
- QWP1DONT
- Indicates whether the resource limit facility (RLF)
is started automatically by DB2.
Field Name: QWP1DONT