Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN)

This topic shows detailed information about "System Parameters - Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN)".

This block shows audit, global, accounting, and monitor trace and checkpoint frequency parameters.

TRACING, CHECKPOINT & PSEUDO-CLOSE PARAMETERS (DSNTIPN)        
-------------------------------------------------------        
START AUDIT TRACE (AUDITST)...................................1
START GLOBAL TRACE (TRACSTR).................................NO
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16
START SMF ACCOUNTING (SMFACCT)........................1,2,3,7,8
START SMF STATISTICS (SMFSTAT).....................1,3,4,5,6,10
STATISTICS TIME INTERVAL IN MINUTES (STATIME).................1
SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)...........NO
ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)......5
START MONITOR TRACE (MON)....................................NO
MONITOR BUFFER SIZE IN BYTES (MONSIZE)................1,048,576
UNICODE IFCIDS (UIFCIDS).....................................NO
DDF/RRSAF ACCUM (ACCUMACC)...................................20
AGGREGATION FIELDS (ACCUMUID).................................0
COMPRESS SMF RECS (SMFCOMP).................................OFF

START AUDIT TRACE (AUDITST)

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

START GLOBAL TRACE (TRACSTR)

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

TRACE TABLE SIZE IN 4K BYTES (TRACTBL)

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

LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC)

The size of the local trace tables in multiples of 4 KB. ZPARM name TRACLOC in DSN6SYSP.

Field Name: QWP1TLSZ

START SMF ACCOUNTING (SMFACCT)

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

START SMF STATISTICS (SMFSTAT)

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

STATISTICS TIME INTERVAL IN MINUTES (STATIME)

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

SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)

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

ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)

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

START MONITOR TRACE (MON)

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

MONITOR BUFFER SIZE IN BYTES (MONSIZE)

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

UNICODE IFCIDS (UIFCIDS)

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

DDF/RRSAF ACCUM (ACCUMACC)

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

AGGREGATION FIELDS (ACCUMUID)

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

COMPRESS SMF RECS (SMFCOMP)

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