DSNZPARM Trace Parameters

This panel shows traces, classes, the size of the internal trace table, and the size of the monitor trace buffer as specified in DSNZPARM for automatic startup. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.

If a field is not available for the current Db2 release, the string N/A is displayed. For other conditions, for example, if specific Db2 traces are not started or control block data is not available, the string N/P is displayed.

 
________________ ZPTRC    VTM     O2       V540.#P DA41 S 11/05/13 16:03:23 2 
>       Help PF1      Back PF3      Left PF10      Right PF11                  
> R.H.B                                                                        
>       DSNZPARM INFORMATION:  Enter a selection letter on the top line.       
                                                                               
>  A-THREAD    *-TRACE     C-LOGGING   D-ARCHIVING     E-AUTH/RLF/DDF   F-IRLM 
>  G-STORAGE   H-DATASET   I-DDCS      J-DATA SHARING  K-STORED PROC    L-UTIL 
>  M-APPL      N-DATA      O-PERF      P-BUFFERPOOL    Q-OTHERS                
===============================================================================
>                          DSNZPARM TRACE PARAMETERS                           
 ZTRC                                                                          
+ Collection Interval:  REALTIME                SNAPTIME: 11/05/13 15:03:26.95 
+                                                                              
+ DSNZPARM Module                         DSNZPARM                             
+ Assembly Date                           06/30/11                             
+ Initial Module                          DSNZPARM                             
+ Assembly Date                           06/30/11                             
+ Previous Module                         DSNZPARM                             
+ Assembly Date                           06/30/11                             
+                                                                              
+ DSNTIPN-Trace Parameters                                                     
+------------------------------------                                          
+ Audit Trace (AUDITST)                         NO                             
+ Trace Auto Start (TRACSTR)                    NO                             
+ Trace Size (TRACTBL)                          16                             
+ SMF Accounting (SMFACCT)                       1                             
+ SMF Statistics (SMFSTAT)               1,3,4,5,6                             
+ Statistics Time (STATIME)                      1                             
+ Statistics Sync (SYNCVAL)                     NO                             
+ Dataset Stats Time (DSSTIME)                   5                             
+ Monitor Trace (MON)                            1                             
+ Monitor Size (MONSIZE)                   1048576                             
+ UNICODE IFCIDs (UIFCIDS)                     YES                             
+ DDF-RRSAF Accum (ACCUMACC)                    10                             
+ Aggregation Fields (ACCUMUID)                  0                             
+ Compress SMF Recs (SMFCOMP)                   NO                             
===============================================================================

Navigation

For additional information about

related topics, select one of the options on the top of the panel.
other topics, use the PF keys.

Fields

The DSNZ command displays the following lines to reflect the usage of the DB2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.

DSNZPARM Module: The name of the DSNZPARM module that is specified for Db2 startup.
Initial Module: The name of the initial DSNZPARM load module.
Previous Module: The name of the previous DSNZPARM load module.
Assembly Date: The date on which this module was assembled.

DSNTIPN-Trace Parameters

Audit Trace (AUDITST) (QWP1AUDT)

This parameter determines the start options of the audit trace (4 bytes are used as bits 1-32).

Valid values:

Asterisk (*): All bits are set to the value 1.
NO: The bit string consists of zero values.
1-32: If any class between 1 and 32 is defined, the NTH bit in the string from left to right is set to 1. This means it is turned on.
YES: The default of class 1 is used.

Trace Auto Start (TRACSTR) (QWP1TRST)

This parameter determines the start trace options for global trace classes (4 bytes are used as bits 1-32).

Valid values:

Asterisk (*): All bits are set to the value 1.
NO: The bit string consists of zero values.
1-32: If any class between 1 and 32 is defined, the NTH bit in the string from left to right is set to 1. This means it is turned on.
YES: The default of class 1, 3, and 4 is used.

Trace Size (TRACTBL) (QWP1TRSZ)

This parameter determines the size of the trace table.

SMF Accounting (SMFACCT) (QWP1SMFA)

This parameter determines the SMF accounting start options (4 bytes are used as bits 1-32.

Valid values:

Asterisk (*): All bits are set to the value 1.
NO: The bit string consists of zero values.
1-32: If any class between 1 and 32 is defined, the NTH bit in the string from left to right is set to 1. This means it is turned on.
YES: The default of class 1 is used.

SMF Statistics (SMFSTAT) (QWP1SMFS)

This parameter determines the SMF start options (4 bytes are used as bits 1-32).

Valid values:

Asterisk (*): All bits are set to the value 1.
NO: The bit string consists of zero values.
1-32: If any class between 1 and 32 is defined, the NTH bit in the string from left to right is set to 1. This means it is turned on.
YES: The default of class 1 is used.

Statistics Time (STATIME) (QWP1STIM)

This parameter determines the time interval in minutes between the collection of statistics. At the end of this interval, statistics records are written.

Statistics Sync (SYNCVAL) (QWP1SYNV)

This parameter determines when Db2 statistics recording is synchronized, for example, 15 minutes past the hour.

Valid values:

1-59 minutes

Dataset Stats Time (DSSTIME) (QWP1DTIM)

This parameter determines the time interval in minutes before DB2 resets data set statistics that are collected for online performance monitors by using IFI reads requests for IFCID 0199.

Monitor Trace (MON) (QWP1MON )

This parameter determines the monitor tracing start options (4 bytes are used as bits 1-32).

Valid values:

Asterisk (*): All bits are set to the value 1.
NO: The bit string consists of zero values.
1-32: If any class between 1 and 32 is defined, the NTH bit in the string from left to right is set to 1. This means it is turned on.
YES: The default of class 1 is used.

Monitor Size (MONSIZE) (QWP1MONS)

This parameter determines the monitor buffer size.

UNICODE IFCIDs (UIFCIDS) (QWP1_UNICODE)

This parameter determines whether fields that contain the characters %U in the comments are coded in Unicode (UTF-8).

Valid values:

1=YES: The trace is coded in Unicode.
0=NO: The trace is not coded in Unicode.

DDF-RRSAF Accum (ACCUMACC) (QWP1ACCU)

This parameter determines whether to roll up accounting data by end user for DDF or RRSAF threads.

Valid values:

NO
YES

Aggregation Fields (ACCUMUID) (QWP1ACID)

This parameter determines the subset of end user fields by which accounting data is aggregated.

Valid values:

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 the parameter DDF-RRSAF Accum is set to NO.

Compress SMF Recs (SMFCOMP) (QWP1CSMF)

This parameter determines whether Db2 is compressing trace records that are written to SMF.