V 4.2.0: 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® ; IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS Version 4.2.0: Report Reference manual, SC19-2504-00.

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

For Update 11 (June 2012): The information in the following chapters is updated:
- Chapter 6. Accounting Default Layouts, 'Times - Class 1 - Application Time'
- Chapter 6. Accounting Default Layouts, 'Times - Class 2 - DB2 Time'
- Chapter 6. Accounting Default Layouts, 'Package Times - Class 7'

For Update 10: The information in the following chapter is updated:
-Chapter 3. Exception Log, 'Example of the Exception Log', 'Field Descriptions'

For Update 9: The information in the following chapters is updated:
-Chapter 6. Accounting Default Layouts, 'Times - Class 3 - Suspensions'
-Chapter 41. IFCID Record Blocks, 'IFCID 003 - Instrumentation Accounting Data Overflow'
-Chapter 41. IFCID Record Blocks, 'IFCID 147 - Instrumentation Accounting Data Overflow'

For Update 8: The information in the following chapter is updated:
-Chapter 6. Accounting Default Layouts, 'Accounting Report and Trace Blocks', 'Resource Limit Facility'

For Update 7: The information in the following chapter is updated for
ISAOPT-Support - APAR PM27581
-Chapter 41. IFCID Record Blocks (various section updates)

For Update 6: The information in the following section is updated:
-Chapter 6. Accounting Default Layouts, 'Identification'
-Chapter 41. IFCID Record Blocks,'IFCID 003 - Instrumentation Accounting Data'

For Update 5: The information in the following section is updated:
-Chapter 50. Statistics Report and Trace Blocks, 'DRDA Remote Locations'

For Update 4: The information in the following section is updated:
-Chapter 41. IFCID Record Blocks, 'IFCID 003 - Instrumentation Accounting Data'

For Update 3: The information in the following section is updated:
-Chapter 6. Accounting Default Layouts, 'Package General (Short Report)'
-Chapter 6. Accounting Default Layouts, 'Package Identification - Report'
-Chapter 6. Accounting Default Layouts, 'Package Identification - Trace'
-Chapter 6. Accounting Default Layouts, 'How averages are calculated'
(Replaces Update 2 below)
-Chapter 6. Accounting Default Layouts, 'Package Buffer Pool Activity'
-Chapter 6. Accounting Default Layouts, 'Package Locking Activity'
-Chapter 6. Accounting Default Layouts, 'Package SQL Activity'
-Chapter 6. Accounting Default Layouts, 'Package Times - Class 8 - Suspensions'
-Chapter 6. Accounting Default Layouts, 'Package Times - Class 7'

For Update 2: The information in the following section is updated:
-Chapter 41. IFCID Record Blocks, 'IFCID 199 - Buffer Pool Statistics at Data Set Level'
-Chapter 41. IFCID Record Blocks, 'IFCID 313 - Uncommitted Unit of Recovery'

For Update 1: The information in the following section is updated:
-Chapter 6. Accounting Default Layouts, 'Accounting Short Report' and 'Accounting Short Trace'
-Chapter 35. Locking Trace, 'Deadlock Trace'
-Chapter 35. Locking Trace, 'Timeout Trace'
-Chapter 41. IFCID Record Blocks, 'IFCID 002 - SQL Call Data' and 'IFCID 003 - SQL Call Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 199 - Buffer Pool Statistics at Data Set Level'

Content

Update 12 (June 2014 - for Version 4.2.0)

The following information has been updated:

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


The description of the following fields has been updated:


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 11 (June 2012 - for Version 4.2.0)

The following field descriptions are modified:

- Chapter 6. Accounting Default Layouts, 'Times - Class 1 - Application Time'

The following field description is modified:

SE CPU TIME
The sum of several accumulated CPU times consumed while running on an IBM specialty engine in all environments. These times are consumed when:

  • Running stored procedure requests and triggers on the main application execution unit.
  • Satisfying stored procedure requests processed in a DB2 stored procedure or WLM address space. SQLP times are included in this time if the SQLP was called on a nested task and was not invoked by the main application execution unit.
  • Satisfying UDF requests processed in a DB2 stored procedure or WLM address space.
  • Running triggers on a nested task.
  • Running parallel tasks in an application which contains the accumulated
  • CPU time used to satisfy UDF requests.
Note: All CPU times of an IBM Specialty Engine (SE) that are reported in DB2 trace records are already normalized by DB2 to the speed of the purpose processor.

DB2 V8: The accumulated CPU time that is consumed while running on an IBM specialty engine in all environments.

Field Name: AWACC1Z

- Chapter 6. Accounting Default Layouts, 'Times - Class 2 - DB2 Time'

The following field description is modified:

SE CPU TIME
The accumulated and consumed class 2 time on an IBM specialty engine that consists of times for nonnested, stored procedures, user-defined functions, triggers, and parallel tasks.

Note: All CPU times of an IBM Specialty Engine (SE) that are reported in DB2 trace records are already normalized by DB2 to the speed of the purpose processor.

Field Name: AWACC2Z

- Chapter 6. Accounting Default Layouts, 'Package Times - Class 7'

The following field description is modified:
SE CPU TIME
The total CPU time for all executions of this package or DBRM that was consumed on an IBM specialty engine.

Note: All CPU times of an IBM Specialty Engine (SE) that are reported in DB2 trace records are already normalized by DB2 to the speed of the purpose processor.

Field Name: APACC7Z

Update 10 (December 2011 - for Version 4.2.0)

The following information is modified.

-Chapter 3. Exception Log, 'Example of the Exception Log', 'Field Descriptions'

The following value description of CONNTYPE is modified:
DB2 PRIV - DB2 private protocol

Update 9 (April 2011 - for Version 4.2.0)

The following information is modified.

-Chapter 6. Accounting Default Layouts, 'Times - Class 3 - Suspensions'

The field description of QWAXDSSE is modified:
EXT/DEL/DEF - AVERAGE TIME/ELAPSED TIME
Accumulated wait time for a synchronous execution unit switch to the DB2
data space manager services. This includes DEFINE DATA SET, EXTEND
DATA SET, DELETE DATA SET, RESET DATA SET, and VSAM CATALOG
ACCESS.
This value is an average.
Field Name: QWAXDSSE

-Chapter 41. IFCID Record Blocks, 'IFCID 003 - Instrumentation Accounting Data Overflow'
The field description of QWAXDSSE is modified:
EXC/DEL/DEF SUSP TIME
Accumulated wait time for a synchronous execution unit switch to the DB2
data space manager services. This includes DEFINE DATA SET, EXTEND
DATA SET, DELETE DATA SET, RESET DATA SET, and VSAM CATALOG
ACCESS.
This value is an average.
Field Name: QWAXDSSE

-Chapter 41. IFCID Record Blocks, 'IFCID 147 - Instrumentation Accounting Data Overflow'

The field description of QWAXDSSE is modified:
EXC/DEL/DEF SUSP TIME
Accumulated wait time for a synchronous execution unit switch to the DB2
data space manager services. This includes DEFINE DATA SET, EXTEND
DATA SET, DELETE DATA SET, RESET DATA SET, and VSAM CATALOG
ACCESS.
This value is an average.
Field Name: QWAXDSSE

Update 8 (January 2011 - for Version 4.2.0)

The following information has been modified.

-Chapter 6. Accounting Default Layouts, ''Accounting Report and Trace Blocks', 'Resource Limit Facility'
The field description of ADRLFTYP has been modified:


RESOURCE LIMIT TYPE (TYPE)
The resource limit type. This is taken from QTXAPREC and can be:
- AUTHID/PLAN
- AUTHID ANY PLAN
- PLAN ANY AUTHID
- BLANK AUTHID & PLAN
- INSTALL NO ENTRY
- INSTALL I/O ERROR
- NO LIMIT - SYSADM/SYSOPR
- AUTHID/COLLECTION/PACKAGE
- AUTHID ANY PACKAGE
- AUTHID ANY COLLECTION
- AUTHID ANY PACKAGE/COLLECTION
- PACKAGE/COLLECTION ANY AUTHID
- ANY AUTHID/PACKAGE
- ANY AUTHID/COLLECTION
- ANY AUTHID/PACKAGE/COLLECTION
The following can be reported:
INFINITE LIMIT
Reported when QTXAPREC has any value except NO LIMIT -
SYSADM/SYSOPR and QTXAILMT is on.
NO RUN OR ZERO LIMIT
Reported when QTXANRUN is on.
Field Name: ADRLFTYP

Update 7 (December 2010 - for Version 4.2.0)

ISAOPT-Support provided with APAR PM27581

The following file contains the updated information:

isaopt_support.pdf

Update 6 (April 2010 - for Version 4.2.0)

The following information has been modified.

-Chapter 6. Accounting Default Layouts, 'Identification'

The field description of QWACESC has been modified:

END TIME
The ending store clock value. You can use this field with the beginning
store clock value (QWACBSC) to determine the elapsed time of an
application.
If a roll-up record is written with accumulated accounting data, QWACESC
contains the accumulated elapsed time. In Accounting Trace reports, the
elapsed time is shown under CLASS 1: NONNESTED ELAPSED TIME and
the END TIME is reported as N/P, because QWACESC does not contain a
timestamp. In the Accounting FILE GENERAL table, the accumulated
elapsed time QWACESC is stored in column CLASS1_ELAPSED and
column CLASS1_TIME_END contains a timestamp 1900-01-01-
00.00.00.000000.
Field Name: QWACESC

-Chapter 41. IFCID Record Blocks,'IFCID 003 - Instrumentation Accounting Data'
The field description of QWACESC has been modified:
CLASS 1: ENDING STORE CLOCK TIME
The ending store clock value. You can use this field with the beginning
store clock value (QWACBSC) to determine the elapsed time of an
application.
If a roll-up record is written with accumulated accounting data, QWACESC
contains the accumulated elapsed time. In Accounting Trace reports, the
elapsed time is shown under CLASS 1: NONNESTED ELAPSED TIME and
the END TIME is reported as N/P, because QWACESC does not contain a
timestamp. In the Accounting FILE GENERAL table, the accumulated
elapsed time QWACESC is stored in column CLASS1_ELAPSED and
column CLASS1_TIME_END contains a timestamp 1900-01-01-
00.00.00.000000.
Field Name: QWACESC

Update 5 (February 2010 - for Version 4.2.0)

The following information has been modified.

--Chapter 50. Statistics Report and Trace Blocks, 'DRDA Remote Locations'

Chap5_DRDA Remote Locations.pdf

Update 4 (December 2009 - for Version 4.2.0)

The following information has been modified.

--Chapter 41. IFCID Record Blocks, 'IFCID 003 - Instrumentation Accounting Data'

The field description of QWACSUCV has been modified:
CLASS 1: CONVERSION FACTOR
The CPU service unit conversion factor allows for converting CPU time to a
common unit, which is called service unit (SU). The conversion factor
depends on the machine being used. With the SU, you can add up CPU
execution times across multiple DB2 systems running on different
machines. It is a raw value for RECORDTRACE and Accounting FILE data.
For Accounting SAVE data it cannot be determined.
Field Name: QWACSUCV

Update 3 (September 2009 - for Version 4.2.0)

The following information has been modified.

--Chapter 6. Accounting Default Layouts, 'Package General (Short Report)'

The field description of ADTOTPOC has been modified:
#OCCURS
The total number of accounting trace sections for a package or DBRM
regardless of enabled or disabled DB2 trace classes 7 and 8 at the time of
writing the trace record. In case of Distributed Data Facility (DDF) or
Recoverable Resource Manager Services Attach Facility (RRSAF) threads,
it is the number of accounting intervals rolled up in a record.
Field Name: ADTOTPOC

The field description of APACSWIT has been modified:
#ALLOCS
The number of package switches that occurred for a package regardless of
enabled or disabled DB2 trace classes 7 and 8 at the time of writing the
trace record. A package switch occurs when a (master) package has run
and started this package or a called (sub) package has returned to this
package. The initial execution of the first package in an application counts
as a package switch.
Field Name: APACSWIT

--Chapter 6. Accounting Default Layouts, 'Package Identification - Report'

The field description of ADTOTPOC has been modified:
OCCURRENCES
The total number of accounting trace sections for a package or DBRM
regardless of enabled or disabled DB2 trace classes 7 and 8 at the time of
writing the trace record. In case of Distributed Data Facility (DDF) or
Recoverable Resource Manager Services Attach Facility (RRSAF) threads,
it is the number of accounting intervals rolled up in a record.
Field Name: ADTOTPOC

The field description of APACSWIT has been modified:
NBR OF ALLOCATIONS
The number of package switches that occurred for a package regardless of
enabled or disabled DB2 trace classes 7 and 8 at the time of writing the
trace record. A package switch occurs when a (master) package has run
and started this package or a called (sub) package has returned to this
package. The initial execution of the first package in an application counts
as a package switch.
Field Name: APACSWIT

The field description of QPACSQLC has been modified:
SQL STMT - AVERAGE
The number of SQL statements issued in this package or DBRM.
This number may not be equal to the total number of SQL statements in the
QXST data section because QXST does not count all SQL statements. For
example, it does not count commit or rollback statements.
For Package Identification (Accounting report and trace): The average of
this counter is calculated by dividing the total value by ADTOTPOC which is
the number of package occurrences (sections). It is regardless of enabled
or disabled DB2 trace classes 7 and 8 at the time of writing the trace
record.
Field Name: QPACSQLC
This is an exception field.

--Chapter 6. Accounting Default Layouts, 'Package Identification - Trace'

The field description of APACSWIT has been modified:
NBR OF ALLOCATIONS
The number of package switches that occurred for a package regardless of
enabled or disabled DB2 trace classes 7 and 8 at the time of writing the
trace record. A package switch occurs when a (master) package has run
and started this package or a called (sub) package has returned to this
package. The initial execution of the first package in an application counts
as a package switch.
Field Name: APACSWIT

--Chapter 6. Accounting Default Layouts, 'How averages are calculated'

The following information has been modified:

Chap_6_Accounting_Calculate_Averages.pdf

--Chapter 6. Accounting Default Layouts, 'Package Buffer Pool Activity'

The introduction has been updated:

--Chapter 6. Accounting Default Layouts, 'Package Locking Activity'

The introduction has been updated:

--Chapter 6. Accounting Default Layouts, 'Package SQL Activity'

The introduction has been updated:

--Chapter 6. Accounting Default Layouts, 'Package Times - Class 8 - Suspensions'

The introduction has been updated:

--Chapter 6. Accounting Default Layouts, 'Package Times - Class 7'

The introduction has been updated:

Update 2 (August 2009 - for Version 4.2.0)

The following information has been modified.

--Chapter 41. IFCID Record Blocks, 'IFCID 199 - Buffer Pool Statistics at Data Set Level'

The field description of QW0199AP has been modified:
TOTAL I/O PAGES - ASYNC.I/O FOR WRITE, READ, CASTOUT
Number of pages read or written asynchronously for the pageset in the
reported interval.
Field Name: QW0199AP

--Chapter 41. IFCID Record Blocks, 'IFCID 313 - Uncommitted Unit of Recovery'

The following information has been modified: Chap41_IFCID_313.pdf

Update 1 (June 2009 - for Version 4.2.0)

The following information has been modified.

--Chapter 6. Accounting Default Layouts, 'Accounting Short Report' and 'Accounting Short Trace'

The following information has been modified:

Chap6_Accounting Short Report and Trace.pdf.pdf

--Chapter 35. Locking Trace, 'Deadlock Trace'

The following information has been corrected:

"CONTOKEN" instead of "CONSTOKN":
Figure 35-2. The Format of Deadlock-Specific Data:

--Chapter 35. Locking Trace, 'Timeout Trace'

The following information has been updated:
Figure 35-4. The Format of Timeout-Specific Data:

--Chapter 41. IFCID Record Blocks, 'IFCID 002 - SQL Call Data' and 'IFCID 003 - SQL Call Data'
Here is a sample Record trace - IFCID 002 - SQL Call Data:

The following field descriptions have been added:

NUMBER OF ROWS FETCHED
The number of rows fetched.
Field Name: QXRWSFETCHD

NUMBER OF ROWS INSERTED
The number of rows inserted.
Field Name: QXRWSINSRTD

NUMBER OF ROWS UPDATED
The number of rows updated.
Field Name: QXRWSUPDTD

NUMBER OF ROWS DELETED
The number of rows deleted.
Field Name: QXRWSDELETD

--Chapter 41. IFCID Record Blocks, 'IFCID 199 - Buffer Pool Statistics at Data Set Level'
Here is a sample Record trace - IFCID 199 - Buffer Pool Statistics at Data Set Level:

The following fields have been added:
LAST IN SEQUENCE
Indicates if this is the last IFCID 0199 record.
Field Name: QW0199LS

CURRENT GETPAGES
The current number of Getpage requests.
Field Name: QW0199GP

Related information

Information Management
Tivoli Software Information Center

Publication number

SC19-2504-00

Copyright date

1985, 2009.

Original publication date

2009/5/22

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:

4.2.0

Operating system(s):

z/OS

Reference #:

7016001

Modified date:

2011-04-07

Translate my page

Machine Translation

Content navigation