V 5.4.0: Updates to the Report Reference manual, IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Content

The most recent update is listed first.

Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.

Update 5
Date of change: February 2018
Topics: Multiple
Change description: Chapter 54 is updated as indicated in the following PDF:

td_ko2rr.pdf

Back to top

Update 4
Date of change: June 2017
Topics: Multiple
Change description: Chapter 49, “Statistics Report and Trace Blocks”, is updated as indicated in the following PDF:

OMPE-679rr.pdf

Back to top

Update 3
Date of change: June 2017
Topics: Multiple
Change description: The following two chapters will be updated, to cover information in APAR PI74256:

• Chapter 40, IFCID Record Blocks
• Chapter 54, System Parameters Report Blocks

Chapter 40, IFCID Record Blocks:
IFCID 106 - Miscellaneous Installation Parameters
SPT01 MAX LENGTH
The maximum length in bytes of LOB columns in the SPT01 directory
space that are maintained in the base table. This field corresponds to field
SPT01 INLINE LENGTH on installation panel DSNTIPA2. The ZPARM
name is SPT01_INLINE_LENGTH in DSN6SPRM.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL

Chapter 54, System Parameters Report Blocks:
Other System Parameters
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)
The maximum length in bytes of LOB columns in the SPT01 directory
space that are maintained in the base table. This field corresponds to field
SPT01 INLINE LENGTH on installation panel DSNTIPA2. The ZPARM
name is SPT01_INLINE_LENGTH in DSN6SPRM.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL

Back to top

Update 2
Date of change: February 2017
Topics: Multiple
Change description: The following field descriptions have been updated in the following chapters:

• Chapter 40. IFCID Record Blocks --> "IFCID 106 - Miscellaneous Installation Parameters"

PARALL EFFICIENCY
The parallelism efficiency factor.
Note: This field has value of 0 if the System Management Facilities (SMF) trace contains the hexadecimal value X'8000'.
This field corresponds to field PARALLELISM EFFICIENCY on installation panel DSNTIP8. The ZPARM name is PARA_EFF in DSN6SPRM.
Field Name: QWP4PAEF

MAX TAPE UNITS
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.
A value of 0 is displayed for NOLIMIT.
Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE_TAPEUNITS in DSN6SPRM.
Field Name: QWP4RSMT

MAX REAL+AUX STOR
The maximum amount of real plus auxiliary storage that can be used.
A value of 0 is displayed for NOLIMIT.
The ZPARM name is REALSTORAGE_MAX in DSN6SPRM.
Field Name: QWP4RSMX


• Chapter 40. IFCID Record Blocks --> "IFCID 106 - System Initialization Parameters"

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
• Chapter 40. IFCID Record Blocks --> "IFCID 106 - Distributed Data Facility Parameters"

CONN Q MAX WAIT
The maximum time that a connection waits for a DBAT request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value is 0.
A value of 0 is displayed for OFF; a value of 1 is displayed for ON.
This field corresponds to field CONN QUEUE MAX WAIT on installation panel DSNTIP5. The ZPARM name is MAXCONQW in DSN6FAC.
Field Name: QWP9MCONQW

CONN Q MAX DEPTH
The maximum depth of the connection-request queue of connections that are waiting for a DBAT to process a request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value were 0.
A value of 0 is displayed for OFF; a value of 32767 is displayed for ON.
This field corresponds to field CONN QUEUE MAX DEPTH on installation panel DSNTIP5. The ZPARM name is MACONQN in DSN6FAC.
Field Name: QWP9MCONQN

• Chapter 54. System Parameters Report Blocks --> "Performance and Optimization (DSNTIP8, DSNTIP81)"

PARALL EFFICIENCY
The parallelism efficiency factor.
Note: This field has value of 0 if the System Management Facilities (SMF) trace contains the hexadecimal value X'8000'.
This field corresponds to field PARALLELISM EFFICIENCY on installation panel DSNTIP8. The ZPARM name is PARA_EFF in DSN6SPRM.
Field Name: QWP4PAEF

• Chapter 54. System Parameters Report Blocks --> "Log Installation Parameters (DSNTIPL, DSNTIPH)"

CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)
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
• Chapter 54. System Parameters Report Blocks --> "DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)"

MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)
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.
A value of 0 is displayed for NOLIMIT.
Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE_TAPEUNITS in DSN6SPRM.
Field Name: QWP4RSMT

• Chapter 54. System Parameters Report Blocks --> "Distributed Data Facility Panel 2 (DSNTIP5)"

CONNECTION QUEUE MAX WAIT (MAXCONQW)
The maximum time that a connection waits for a DBAT request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value is 0.
A value of 0 is displayed for OFF; a value of 1 is displayed for ON.
This field corresponds to field CONN QUEUE MAX WAIT on installation panel DSNTIP5. The ZPARM name is MAXCONQW in DSN6FAC.
Field Name: QWP9MCONQW

CONNECTION QUEUE MAX DEPTH (MAXCONQN)
The maximum depth of the connection-request queue of connections that are waiting for a DBAT to process a request. If this value is non-zero, and QWP9CMST is active, or the subsystem is not a member of a data sharing group, DB2 operates as if this value were 0.
A value of 0 is displayed for OFF; a value of 32767 is displayed for ON.
This field corresponds to field CONN QUEUE MAX DEPTH on installation panel DSNTIP5. The ZPARM name is MACONQN in DSN6FAC.
Field Name: QWP9MCONQN

• Chapter 54. System Parameters Report Blocks --> "Storage Sizes Installation Parms (DSNTIPC, DSNTIPE, DSNTIPE1)"

MAXIMUM REAL STORAGE (REALSTORAGE_MAX)
The maximum amount of real plus auxiliary storage that can be used.
A value of 0 is displayed for NOLIMIT.
The ZPARM name is REALSTORAGE_MAX in DSN6SPRM.
Field Name: QWP4RSMX

Back to top

Update 1
Date of change: January 2017
Topics: Multiple
Change description: The lists of values for "STATEMENT TYPE" and "OBJECT TYPE" have been updated in the following chapter:

• Chapter 40. IFCID Record Blocks --> "IFCID 062 - DDL Start"
  Chap_40_IFCID_062_DDL_Start.pdf

The record trace sample layout has been modified in the following chapter:

• Chapter 40. IFCID Record Blocks --> "IFCID 125 - RID Pool Processing"
  Chap_40_IFCID125_RID_Pool_Processing.pdf
  

Back to top