V 5.1.1: Update to the Report Reference manual of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Manual


Abstract

This document updates the IBM® Tivoli® OMEGAMON® XE for DB2® Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS Version 5.1.1: Report Reference manual, SH12-6963-00.

Update 1* in PM68928 (September 2012): The information in the following chapters is updated:
- Chapter 6. "The Accounting Save-File Utility" -> "Converting Data Sets"
- Chapter 7. "The Accounting File Data Set and Output Record"
- Chapter 49. "The Statistics Save-File Utility" -> "Converting Data Sets"
- Chapter 50. "The Statistics File Data Set and Output Records"
(Note: The latest information is provided with update 4, see below.)

Update 2* in PM72949 and general updates (October 2012): The information in the following chapters is updated:
** PM72949 : The information in the following chapters is added:
- Chapter 39. IFCID Record Blocks, 'IFCID 369 - Aggregated Accounting Statistics' >>See update 5!
- Chapter 48. Statistics Report and Trace Blocks, 'Aggregated Accounting Statistics'
** General updates:The information in the following chapters is updated:
- Chapter 48. Statistics Report and Trace Blocks, 'CPU Times'
- Chapter 48. Statistics Report and Trace Blocks, 'Data Sharing Locking' >>See update 6!

Update 3* in PM73152 (December 2012): The information in the following chapter is updated:
- Chapter 9. "The Audit Detail Report and the Audit Trace" ->"Authorization Control Detail (Type AUTHCNTL)"
- Chapter 39. "IFCID Record Blocks" ->"IFCID 361 - Audit Admin Authorities"

Update 4* in PM73732 (December 2012):
The description of the new Spreadsheet Input-Data Generator utility has been added to the information:
- Chapter 6. "The Accounting Save-File Utility" -> "Converting Data Sets"
- Chapter 7. "The Accounting File Data Set and Output Record"
- Chapter 50. "The Statistics Save-File Utility" -> "Converting Data Sets"
- Chapter 51. "The Statistics File Data Set and Output Records"

Update 5* in PM72622 (December 2012):
The information in the following chapters is updated to include new accelerator information:
- Chapter 33. "Locking Activity Report"->"Table 33-1. Lock Resource Type"
- Chapter 5. "Accounting Default Layouts" -> "Times - Class 3 - Suspensions"
- Chapter 5. "Accounting Default Layouts" -> "Package Times - Class 8 - Suspensions"
- Chapter 40. "IFCID Record Blocks"->"IFCID 002 - Accelerator Data"
- Chapter 40. "IFCID Record Blocks"->"IFCID 003 - Instrumentation Accounting Data"
- Chapter 40. "IFCID Record Blocks"->"IFCID 106 - Miscellaneous Installation Parameters (DB2 9 and later)"
- Chapter 40. "IFCID Record Blocks"->"IFCID 239 - Package/DBRM Accounting Data"
- Chapter 40. "IFCID Record Blocks"->"IFCID 369 - Aggregated Accounting Statistics"
- Chapter 40. "IFCID Record Blocks"->"IFCID 378 - Accel. Call Event Begin (DB2 10)"
- Chapter 40. "IFCID Record Blocks"->"IFCID 379 - Accel. Call Event End (DB2 10)"
- Chapter 49. "Statistics Report and Trace Blocks"->"Accelerator"
- Chapter 54. System Parameters Report Blocks"->"Other System Parameters" >>See update 11!

Update 6* in PM71183 and general updates (January 2013):
The information in the following chapters is updated:
** PM71183: The information in the following chapters is updated to include new fields for DB2 parameters (DSNZPARM settings):
- Chapter 40. "IFCID Record Blocks"->'IFCID 106 - System Initialization Parameters'
- Chapter 40. "IFCID Record Blocks"->'IFCID 106 - Log Initialization Parameters (Part 1)'
- Chapter 40. "IFCID Record Blocks"->'IFCID 106 - Miscellaneous Installation Parameters (DB2 9 and later)'
- Chapter 54. "System Parameters Report Blocks"-> 'Define Group or Member (DSNTIPK)'
- Chapter 54. "System Parameters Report Blocks"-> 'Performance and Optimization (DSNTIP8)'
- Chapter 54. "System Parameters Report Blocks"-> 'Log Installation Parameters (DSNTIPL, DSNTIPH)'
- Chapter 54. "System Parameters Report Blocks"-> 'Other System Parameters' >>See update 7!
- Chapter 54. "System Parameters Report Blocks"-> 'Default Startup Modules (DSNTIPO3)' (new)
** General updates:The information in the following chapters is updated:
- Chapter 40. "IFCID Record Blocks", 'IFCID 002 - Data Sharing Locking Data'
- Chapter 49. "Statistics Report and Trace Blocks", 'Data Sharing Locking'
– The following blocks are removed from the information:
- Chapter 40. "IFCID Record Blocks"->'IFCID 003 - Package/DBRM Accounting Data'
- Chapter 40. "IFCID Record Blocks"->'IFCID 147 - Package/DBRM Accounting Data'

Update 7* in PM78041 and general updates (February 2013):
The information in the following chapters is updated:
** PM78041: The information in the following chapter is updated to show the new field label and description of QW0366FN and QW0366TS:
- Chapter 40. "IFCID Record Blocks"->'IFCID 366 - Incompatible Function Char(DEC) Executed'
** General updates: Two field labels in Chapter 54. "System Parameters Report Blocks"-> 'Other System Parameters' are modified.

Update 8* in PM85660 (June 2013):
The information in the following chapters is updated:
- Chapter 5. "Accounting Default Layouts" -> 'RID List'
- Chapter 5. "Accounting Default Layouts" -> 'SQL DDL'

Update 9* (July 2013):
The information in the following chapter is updated:
- Chapter 5. "Accounting Default Layouts" -> 'Times - Class 1 - Application Time' >>See update 10!

Update 10* in PM94202 and general updates (October 2013):
The information in the following chapters is new or updated:
**PM94202:
- Chapter 5. "Accounting Default Layouts" -> 'Measured/Elig Times' (new)
- Chapter 5. "Accounting Default Layouts" -> 'Service Units'
- Chapter 5. "Accounting Default Layouts" -> 'Times - Class 1 - Application Time'
- Chapter 40. "IFCID Record Blocks"->'IFCID 003/IFCID 147 - Instrumentation Accounting Data'
- Chapter 40. "IFCID Record Blocks"->'IFCID 239 - Package/DBRM Accounting Data'
**General updates:
- Chapter 40. "IFCID Record Blocks"->'IFCID 003 - Instrumentation Accounting Data'
- Chapter 40. "IFCID Record Blocks"->'IFCID 225 - Address Space Summary - DIST'
- Chapter 49. "Statistics Report and Trace Blocks"->'DBM1 and MVS Storage Below 2 GB'
- Chapter 49. "Statistics Report and Trace Blocks"->'DIST and MVS Storage Below 2 GB (DB2 10)'

Update 11* in PM99691 (December 2013):
The information in the following chapters is new or updated:
- Chapter 40. "IFCID Record Blocks"->'IFCID 106 - Miscellaneous Installation Parameters'
- Chapter 54. "System Parameters Report Blocks"->'Other System Parameters'

Update 12* in PM99308 (February 2014):
The information in the following chapter is new:
- Chapter 40. IFCID Record Blocks -> "IFCID 360 - Incrementally Rebound Queries"

Update 13* in PI06091 (February 2014):
The information in the following chapter is updated for the field descriptions of AWTLOLA and QWACAWTL:
- Chapter 5. "Accounting Default Layouts" -> 'Times - Class 3 - Suspensions'

Update 14* (June 2014):
The following information has been updated:
- Chapter 49. "Statistics Report and Trace Blocks"-->"Authorization Management"


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

Content

Update 14* (June 2014)

The following information has been updated:

  • Chapter 49. "Statistics Report and Trace Blocks"-->"Authorization Management"


The description of the following fields has been updated in:


PKG-AUTH UNSUCC-CACHE
The number of unsuccessful package EXECUTE authorization checks in the package authorization cache. No applicable entry was found in the cache and DB2 catalog access was used.
Field Name: QTPACNOT

RTN-AUTH UNSUCC-CACHE
Number of unsuccessful authorization checks for user-defined function or stored procedure EXECUTE authority because no applicable entry was found in the routine authorization cache.
Field Name: QTRACNOT



Update 13* in PI06091 (February 2014)

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

- Chapter 5. "Accounting Default Layouts" -> 'Times - Class 3 - Suspensions'

The following field descriptions are updated:

LOCK/LATCH(DB2+IRLM) - AVERAGE TIME/ELAPSED TIME
This field depends on the DB2 version that is installed:

  • DB2 10 or later: The sum of the accumulated wait time due to local contention for locks and the accumulated wait time due to latch contention.
  • Prior to DB2 10: The accumulated lock and latch elapsed time. It indicates the elapsed time that the allied agent waited for locks and latches in DB2. This value does not include suspensions because of group-level lock contentions in a data sharing environment. When the event completes, the ending time is used to calculate the total elapsed wait time. The result is added to the previously saved lock and latch wait time in DB2. If class 9 is not active, the time shown does not include the time for internal latching.
Field Name: AWTLOLA

IRLM LOCK+LATCH - AVERAGE TIME/ELAPSED TIME
This field depends on the DB2 version that is installed:
  • DB2 10 or later: The accumulated wait time because of local contention for locks. The term local contention is used to differentiate from global contention (which is reported in QWACAWTJ). Local contention does not require intersystem communication. The contention is detected and resolved entirely within this subsystem.
  • Prior to DB2 10: The value is reported in field AWTLOLA.
Field Name: QWACAWTL
This is an exception field.

Update 12* in PM99308 (February 2014)

The information in the following chapter is new:
- Chapter 40. IFCID Record Blocks -> "IFCID 360 - Incrementally Rebound Queries"
Chap_40_IFCID_360_Incrementally_Rebound_Queries.pdf


Update 11* in PM99691 (December 2013)

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

-Chapter 40. "IFCID Record Blocks"-> IFCID 106 - Miscellaneous Installation Parameters:
The following description is modified. A new field is introduced:


ACCEL MODELING

    The ACCELMODEL subsystem parameter determines whether to enable modeling of query workload for evaluating potential savings for both the accumulated elapsed time and CPU time if the plan is executed on an accelerator.
    Only queries that are deemed eligible for execution on an accelerator by DB2 will be included in accelerator-related fields of accounting trace IFCID 3:
    No Specifies that no modeling is to be performed. This is the default setting.
    Yes Specifies that modeling is to be performed. Consider acceleration eligibility for an SQL statement and update the new Accounting fields accordingly.
    To enable modeling, the IBM DB2 Analytics Accelerator for z/OS special register CURRENT QUERY ACCELERATION and ZPARM QUERY_ACCELERATION (set by the CURRENT QUERY ACCEL) must be set to NONE for accelerator modeling. All other values for the special register and ZPARM will take the existing logic of IBM DB2 Analytics Accelerator for z/OS. This means that existing queries that already execute on the accelerator with CURRENT QUERY ACCELERATION = ENABLE, ENABLE WITH FAILBACK, ELIGIBLE, or ALL will not be part of the accelerator-related Accounting fields.
    Field Name: QWP4ACMO

-Chapter 54. "System Parameters Report Blocks"-> Other System Parameters:
The following description is modified. The new fields are described below the sample:



ACCEL ARCHIVED DATA (GET_ACCEL_ARCHIVE)

    Determines the default value that is to be used for the GET_ACCEL_ARCHIVE special register:
    NO Indicates that if a table is archived in an accelerator server, and a query references that table, the query does not use the data that is archived.
    YES Indicates that if a table is archived in an accelerator server, and a query references that table, the query uses the data that is
    archived.
    ZPARM name GET_ACCEL_ARCHIVE in macro DSN6SPRM.
    Field Name: QWP4CGAA

QUERY ACCEL OPT (QUERY_ACCEL_OPTIONS)
    Specifies additional types of SQL queries that are eligible for acceleration.
    NONE - Indicates that no additional types of SQL queries are eligible. Therefore, the types of queries that are described in the other available values for this parameter are not eligible for acceleration. This is the default value.
    1 - Indicates that queries that include data that is encoded with the EBCDIC mixed or graphic encoding schemes are eligible for acceleration.
    2 - Indicates that an INSERT with SELECT statement is eligible for acceleration. However, only the SELECT operation of the query is
    processed by the accelerator server.
    3 - Indicates that queries that contain built-in functions for which DB2 processes each byte of the input string, rather than each character
    of the input string, can run on an accelerator server.
    4 - The queries that reference an expression with a DATE data type that uses a LOCAL format are not blocked from executing on IBM
    DB2 Analytics Accelerator for z/OS. IBM DB2 Analytics Accelerator for z/OS will use the dd/mm/yyyy format to interpret the input and output date value. Specify option 4 only when you also specify LOCAL as the setting for the DSNHDECP.DATE parameter and your LOCAL date exit defines the specific dd/mm/yyyy date format. Otherwise, queries may return unpredictable results.
    ZPARM name QUERY_ACCEL_OPTIONS in macro DSN6SPRM.
    Field Name: QWP4QACO

QUERY ACCELERATION (QUERY_ACCELERATION)
    Determines the default value that is to be used for the CURRENT QUERY ACCELERATION special register. Possible values are:
    NONE - Indicates that no query acceleration is done. This is the default value.
    ENABLE - Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
    ENABLE_WITH_FAILBACK - Indicates that queries are accelerated only if DB2 determines that it is advantageous to do so. If the accelerator returns an error during the PREPARE or first OPEN for the query, DB2 executes the query without the accelerator. If the accelerator returns an error during a FETCH or a subsequent OPEN, DB2 returns the error to the user, and does not execute the query.
    ELIGIBLE - Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine
    whether to accelerate the queries. Queries that are not eligible for acceleration are executed by DB2. If there is an accelerator failure
    while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
    ALL - Indicates that queries are accelerated if they are eligible for acceleration. DB2 does not use cost information to determine whether to accelerate the queries. Queries that are not eligible for acceleration are not executed by DB2, and an SQL error is returned. If there is an accelerator failure while a query is running, or the accelerator returns an error, DB2 returns a negative SQLCODE to the application.
    ZPARM name QUERY_ACCELERATION in DSN6SPRM.
    Field Name: QWP4CQAC

ACCEL MODELING
    The ACCELMODEL subsystem parameter determines whether to enable modeling of query workload for evaluating potential savings for both the accumulated elapsed time and CPU time if the plan is executed on an accelerator.
    Only queries that are deemed eligible for execution on an accelerator by DB2 will be included in accelerator-related fields of accounting trace IFCID 3:
    No Specifies that no modeling is to be performed. This is the default setting.
    Yes Specifies that modeling is to be performed. Consider acceleration eligibility for an SQL statement and update the new Accounting fields accordingly.
    To enable modeling, the IBM DB2 Analytics Accelerator for z/OS special register CURRENT QUERY ACCELERATION and ZPARM QUERY_ACCELERATION (set by the CURRENT QUERY ACCEL) must be set to NONE for accelerator modeling. All other values for the special register and ZPARM will take the existing logic of IBM DB2 Analytics Accelerator for z/OS. This means that existing queries that already execute on the accelerator with CURRENT QUERY ACCELERATION = ENABLE, ENABLE WITH FAILBACK, ELIGIBLE, or ALL will not be part of the accelerator-related Accounting fields.
    Field Name: QWP4ACMO



Update 10* in PM94202 and general updates (October 2013)

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

-Chapter 5. "Accounting Default Layouts" -> 'Measured/Elig Times' (new):
The following Accounting data block is new:

Chap_5_Accounting_Default_Layouts_MeasuredElig_Times.pdfChap_5_Accounting_Default_Layouts_MeasuredElig_Times.pdf

-Chapter 5. "Accounting Default Layouts" -> 'Service Units' :
The following Accounting data block is updated:

Chap_5_Accounting_Default_Layouts_Service_Units.pdfChap_5_Accounting_Default_Layouts_Service_Units.pdf

-Chapter 5. "Accounting Default Layouts" -> 'Times - Class 1 - Application Time':
Field name AWACZEL (SECP CPU) and its description has been moved to the new Accounting data block: Measured/Elig Times (see above).

- Chapter 40. "IFCID Record Blocks"->'IFCID 003 - Instrumentation Accounting Data'
Class 2 of the IFCID record blocks in IFCID 003 and IFCID 147 has been updated:

Chap_40_IFCID_003_ 147_Instrumentation_Accounting_Data_Update.pdfChap_40_IFCID_003_ 147_Instrumentation_Accounting_Data_Update.pdf

- Chapter 40. "IFCID Record Blocks"->'IFCID 239 - Package/DBRM Accounting Data'
The highlighted field name in the sample layout has been modified:

- Chapter 40. "IFCID Record Blocks"->'IFCID 003 - Instrumentation Accounting Data'
The sample layout has been updated to include field QWAC_PT_COUNT:
....
CLASS 7 DATA COLLECTED YES CLASS 8 DATA COLLECTED YES
WLM SERVICE CLASS: N/P PARALLEL CHILDS ROLLED INTO RECORD: 0
ROLLUP DATA FOR PARALLEL CHILD TASKS YES
....
PARALLEL CHILDS ROLLED INTO RECORD
The number of parallel child agents rolled into this record. The value
depends on the record type:
1. For all non-rollup records, this value is 0.
2. For a parallel query rollup record, this value is the number of parallel child agents rolled into this record.
3. For a DDF/RRSAF rollup record, this value is the number of parallel query child agents rolled into this record. These agents are NOT counted in QWACPCNT.
4. For an autonomous procedure rollup record, this value is 0.
Field Name: QWAC_PT_COUNT

- Chapter 40. "IFCID Record Blocks"->'IFCID 225 - Address Space Summary - DIST', - Chapter 49. "Statistics Report and Trace Blocks"->'DBM1 and MVS Storage Below 2 GB', and - Chapter 49. "Statistics Report and Trace Blocks"->'DIST and MVS Storage Below 2 GB (DB2 10)'

The field description of QW0225VR has been updated for:

  • IFCID 225 - Address Space Summary - DIST
  • DBM1 and MVS Storage Below 2 GB
  • DIST and MVS Storage Below 2 GB (DB2 10)

TOTAL 31-BIT VARIABLE POOL
Total storage used by all variable pools. This includes storage used by:
  • System agents
  • Local agents
  • RID pool
  • Pipe manager subpool
  • Local dynamic statement cache control blocks
  • Local dynamic statement cache statement pool
  • Buffer and data manager trace tables
  • A list of objects in restricted state including the new PRO state. If consumption of this storage pool is high, review restrictive exception state of database objects and check whether they can be resolved or reduced.
Field Name: QW0225VR




Update 9* (July 2013)

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

- Chapter 5. "Accounting Default Layouts" -> 'Times - Class 1 - Application Time'

The following field description is updated:

CP CPU TIME - PAR.TASKS
The sum of the CPU times of the parallel tasks running in an application. It can also include the accumulated class 1 CPU time for processing stored procedures, user-defined functions, and triggers if present.

These parallel tasks can be query CP, sysplex query parallel tasks, or parallel tasks produced by utilities. In sysplex query parallelism, the accumulated time reflects only parallel tasks running on the same DB2
subsystem as the originating task.

This time does not include CPU time consumed on an IBM specialty engine.

CPU time for agent tasks is not charged to this counter.

Field Name: ADCPUPLL



Update 8* in PM85660 (June 2013)

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

- Chapter 5. "Accounting Default Layouts" -> 'RID List'

RID List
This block shows information about the Record identifier (RID) list. The following example shows both layouts, the report on the left, and the trace layout on the right.

Report: Trace:
RID LIST AVERAGE TOTAL RID LIST TOTAL
---------------------- -------- -------- --------------- --------
USED 0.00 0 USED 0
FAIL-NO STORAGE 0.00 0 FAIL-NO STORAGE 0
FAIL-LIMIT EXCEEDED 0.00 0 FAIL-LIMIT EXC. 0
INTERRUPTED-NO STORAGE 0.00 0 INTERRUPTED-NO STORAGE 0
INTERRUPTED-LIMIT EXC. 0.00 0 INTERRUPTED-LIMIT EXC. 0
OVERFLOWED-NO STORAGE 0.00 0 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0.00 0 OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0.00 0 SKIPPED-INDEX KNOWN 0

The following fields are new:

INTERRUPTED-NO STORAGE
The number of times a RID list append for a hybrid join was interrupted because no RID pool storage was available to hold the list of RIDs.
Field Name: QXHJINCS

INTERRUPTED-LIMIT EXC.
The number of times a RID list append for a hybrid join was interrupted because the number of RIDs exceeded one or more internal limits.
Field Name: QXHJINCT

OVERFLOWED-NO STORAGE
The number of times a RID list was overflowed to a work file because no RID pool storage was available to hold the list of RIDs.
Field Name: QXWFRIDS

OVERFLOWED-LIMIT EXC.
The number of times a RID list was overflowed to a work file because the number of RIDs exceeded one or more internal limits.
Field Name: QXWFRIDT

SKIPPED-INDEX KNOWN
The number of times a RID list retrieval for multiple index access was skipped because it was not necessary due to DB2 being able to predetermine the outcome of index ANDing or ORing.
Field Name: QXRSMIAP

- Chapter 5. "Accounting Default Layouts" -> 'SQL DDL'
SQL DDL
This block shows information about SQL DDL (Data Definition Language) statements.
The following example applies to both, the report layout and the trace layout.

SQL DDL CREATE DROP ALTER
---------- ------ ------ ------
TABLE 0 0 0
CRT TTABLE 0 N/A N/A
DCL TTABLE 0 N/A N/A
AUX TABLE 0 N/A N/A
INDEX 0 0 0
TABLESPACE 0 0 0
DATABASE 0 0 0
STOGROUP 0 0 0
SYNONYM 0 0 N/A
VIEW 0 0 513
ALIAS 0 0 N/A
PACKAGE N/A 0 N/A
PROCEDURE 0 0 0
FUNCTION 0 0 0
TRIGGER 0 0 N/A
DIST TYPE 0 0 N/A
SEQUENCE 0 0 0
TRUST. CTX 521 522 523
ROLE 531 532 N/A
JAR N/A N/A 543
MASK/PERM 0 0 0

TOTAL 1052 1054 1579
TRUNC TBL 0
RENAME TBL 0
RENAME IX 551
COMMENT ON 0
LABEL ON 0

The following fields are new:

CREATE MASK/PERM
The number of CREATE MASK and CREATE PERMISSION statements executed.
Field Name: QXCREMP

DROP MASK/PERM
The number of DROP MASK and DROP PERMISSION statements executed.
Field Name: QXDRPMP

ALTER MASK/PERM
The number of ALTER MASK and ALTER PERMISSION statements executed.
Field Name: QXALTMP



Update 7* in PM78041 and general updates (February 2013)

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



Update 6* in PM71183 and general updates (January 2013)

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

  • PM71183: The information in the following chapters is updated to include new fields for DB2 parameters (DSNZPARM settings):
  • General updates:

    The description of field QTGSFLSE has been corrected in:
    Chapter 40. IFCID Record Blocks, 'IFCID 002 - Data Sharing Locking Data':
    SYNC-ASYNC XES CONV
    The number of synchronous to asynchronous heuristic conversions for LOCK requests in XES. This conversion is done when XES determines that it is more efficient to drive the request asynchronously to the coupling facility (CF).
    Field Name: QTGSFLSE

    Chapter 49. Statistics Report and Trace Blocks, 'Data Sharing Locking':
    ASYNCH.XES - CONVERTED LOCKS
    The number of synchronous to asynchronous heuristic conversions for LOCK requests in XES. This conversion is done when XES determines that it is more efficient to drive the request asynchronously to the coupling facility (CF).
    Field Name: QTGSFLSE




Update 5* in PM72622 (December 2012)

The information in the following chapters is updated to include new accelerator information:


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




Update 4* in PM73732 (December 2012)

The description of the new Spreadsheet Input-Data Generator utility has been added to the information:


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

Update 3 in PM73152 (December 2012)

The following information is updated to include new fields:

- Chapter 9*. "The Audit Detail Report and the Audit Trace" ->"Authorization Control Detail (Type AUTHCNTL)"

Chap_9_Authorization Control Detail (Type AUTHCNTL).pdfChap_9_Authorization Control Detail (Type AUTHCNTL).pdf

- Chapter 39*. "IFCID Record Blocks" ->"IFCID 361 - Audit Admin Authorities"

Chap_39_IFCID 361 - Audit Admin Authorities.pdfChap_39_IFCID 361 - Audit Admin Authorities.pdf

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

Update 2 in PM72949 and general updates (October 2012)

The following information is modified:

*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.
  • General updates
    • The description of the following field has been corrected Chapter 48. Statistics Report and Trace Blocks, 'Data Sharing Locking':
      QTGSFLSE >>See update 6!
    • The description of all PREEMPT SRB fields in the Statistics CPU TIMES report block has been enhanced in Chapter 48. Statistics Report and Trace Blocks, 'CPU Times':
      Chap_48_StatisticsReportandTraceBlocks_CPU Times.pdfChap_48_StatisticsReportandTraceBlocks_CPU Times.pdf
*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.

Update 1 in PM68928 (September 2012)

The following information is updated to include accelerator data:

  • Chapter 6. "The Accounting Save-File Utility" -> "Converting Data Sets":
    (Note: The latest information is provided with update 4, see above.)
  • Chapter 7. "The Accounting File Data Set and Output Record":
    (Note: The latest information is provided with update 4, see above.)
  • Chapter 49. "The Statistics Save-File Utility" -> "Converting Data Sets":
    (Note: The latest information is provided with update 4, see above.)
  • Chapter 50. "The Statistics File Data Set and Output Records":
    (Note: The latest information is provided with update 4, see above.)

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

Related information

Information Management
Tivoli OMEGAMON XE for DB2 Performance Expert on zOS
Tivoli Documentation Central

Publication number

SH12-6963

Copyright date

1985, 2012

Original publication date

2012/6/15

Product Alias/Synonym

OMEGAMON XE for DB2 PE
OMEGAMON XE for DB2 PM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Tools for z/OS
IBM Tivoli OMEGAMON XE for DB2 PE / PM / BPA

Software version:

5.1.1

Operating system(s):

z/OS

Reference #:

7036084

Modified date:

2014-06-23

Translate my page

Machine Translation

Content navigation