DSNZPARM Logging Parameters

This panel shows information about the logging parameters that are specified in the DSNZPARM module. 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.

 
_________________ ZPLOG    VTM     O2       V550.#P DC11 S 04/07/16  0:55:0211  
 ZLOG                                                                           
+ Collection Interval:  REALTIME                SNAPTIME: 04/07/16 00:55:02.26  
+                                                                               
+ DSNZPARM Module                         DSNZPARM                              
+ Assembly Date                           03/17/16                              
+ Initial Module                          DSNZPARM                              
+ Assembly Date                           03/17/16                              
+ Previous Module                         DSNZPARM                              
+ Assembly Date                           03/17/16                              
+                                                                               
+ DSNTIPL-Active Log Parms                                                      
+------------------------------------             
+ Output Buffer Size (OUTBUFF)                4000
+ (REMOTE_COPY_SW_ACCEL)                   DISABLE
+                                                                               
+ DSNTIPL1-Checkpoint Parameters                                                
+------------------------------------                                           
+ Checkpoint Type (CHKTYPE)                 SINGLE                              
+ Check Frequent (CHKFREQ)                  500000                              
+ Records/Checkpoint (CHKLOGR)                   0                              
+ Minutes/Checkpoint (CHKMINS)                   0                              
+ UR Check Freq (URCHKTH)                        0                              
+ UR Log Write Check (URLGWTH)                   0                              
+ Limit Backout (LBACKOUT)                    AUTO                              
+ Backout Duration (BACKODUR)                    5                              
+ RO Switch Chkpts (PCLOSEN)                    10                              
+ RO Switch Time (PCLOSET)                      10                              
+ Levelid Update Freq (DLDFREQ)                  5                              
===============================================================================

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.

DSNTIPL-Active Log Parms

Output Buffer Size (QWP2OBPS)

The OUTBUFF subsystem parameter determines the size of the output buffer that is used for writing active log data sets.

Valid values:

400K to 400000K

Default:

4000K

(REMOTE_COPY_SW_ACCEL) (QWP2RCSA)

Specifies whether Db2 uses software (SW) to control the remote copy process for active log output in peer-to-peer remote copy (PPRC) environments.

Valid values:

DISABLE (default)
ENABLE

Db2 12 and later.

DSNTIPL1-Checkpoint Parameters

Checkpoint Type (QWP1LOGT)

The CHKTYPE subsystem parameter indicates whether the interval between log checkpoints is based on the number of written log records, the time between checkpoints, or both.

Valid values:

SINGLE(LOGRECS or MINUTES)
BOTH

Check Frequent (QWP1LOGL)

The CHKFREQ subsystem parameter determines how many log records are created before log checkpoints occur.

Valid values:

1,000 - 16,000,000 (if CHKTYPE is SINGLE/LOGRECS)
1 - 60 (if CHKTYPE is SINGLE/MINUTES)
NOTUSED (if CHKTYPE is BOTH).
NOTUSED is displayed as 0.

Default:

Records/Checkpoint (QWP1LOGR)

The RECORDS/CHECKPOINT parameter determines how many log records are created between log checkpoints.

Valid values:

1,000 - 99,999,999 (if CHKTYPE is BOTH)
NOTUSED (if CHKTYPE is SINGLE)
NOTUSED is displayed as 0.

Default:

NOTUSED(0)

Minutes/Checkpoint (QWP1LOGM)

The MINUTES/CHECKPOINT parameter determines how many minutes are passing between log checkpoints.

Valid values:

 1- 1439 (if CHKTYPE is BOTH)
NOTUSED (if CHKTYPE is SINGLE)
NOTUSED is displayed as 0.

Default:

NOTUSED(0)

UR Check Freq (QWP1URCK)

The URCHKTH subsystem parameter determines the number of checkpoint cycles to be completed before a warning message is issued to the console by Db2 for an uncommitted unit of recovery (UR).

If you do not want these warning messages to be issued, you can disable this option.

Valid values:

 0 to 255

Default:

Log Apply Storage V9 (QWP1FLBZ)

This parameter determines the maximum amount of dsn1dbm1 storage that can be used for fast log application.

This value is used by Db2 during the log application phase of the recover utility. This field corresponds to field the field log apply storage on the installation panel DSNTIPL.

UR Log Write Check (QWP1LWCK)

The URLGWTH subsystem parameter determines the number of log records that are written before a warning message is issued to the console by an uncommitted unit of recovery (UR).

If you do not want these warning messages to be issued, you can disable this option.

Valid values:

0 to 1000K

Default:

10K

Limit Backout (QWP1LMBO)

The LBACKOUT subsystem parameter determines whether Db2 postpones backward-log processing for some units of work.

Valid values:

AUTO
YES
LIGHT
LIGHTAUTO
NO

Default:

AUTO

Backout Duration (QWP1BDUR)

The BACKODUR subsystem parameter determines the number of log records that are backed out during a restart. This value is applied when the LIMIT BACKOUT field is set to AUTO, YES, LIGHT, or LIGHTAUTO.

Valid values:

0 to 255

Default:

RO Switch Chkpts (QWP1FREQ)

The PCLOSEN subsystem parameter determines the number of consecutive Db2 checkpoints that are allowed after a page set or partition is updated. After the specified number of checkpoints occurred, Db2 converts the page set or partition from read-write to read-only.

Valid values:

1 to 32767

Default:

10 checkpoints

RO Switch Time (QWP1TMR )

The PCLOSET subsystem parameter determines the number of minutes that can elapse after a page set or partition is updated. After the specified number of minutes, Db2 converts the set or partition from read-write to read-only.

Valid values:

1 to 32767

Default:

 10 minutes

Levelid Update Freq (QWP1DFRQ)

The DLDFREQ subsystem parameter determines whether the level ID of a page set or partition is to be updated at Db2-determined checkpoint intervals.

If level ID updates for down-level detection are enabled (ON), 5 is displayed.
If level-ID updates for down-level detection are disabled, (OFF), 0 is displayed.

Valid values:

ON
OFF