V 4.1.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.1.0: Report Reference manual, SC18-9984-02.

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

For Update 11: 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 10: The information in the following chapter is updated:
-Chapter 6. Accounting Default Layouts, 'Accounting Report and Trace Blocks', 'Resource Limit Facility'

For Update 9: 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 8: The information in the following section is updated:
-Chapter 50. Statistics Report and Trace Blocks, 'DRDA Remote Locations'

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

For Update 6: 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 5: 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 4: 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 199 - Buffer Pool Statistics at Data Set Level'

For Update 3: The information in the following section is updated:
-Chapter 6. Accounting Default Layouts, 'Package Identification - Report '
-Chapter 6. Accounting Default Layouts, 'Package Identification - Trace'
-Chapter 41. IFCID Record Blocks, 'IFCID 003 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 147 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 148 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 239 - Package/DBRM Accounting Data'

For Update 2: The information in the following section is updated:
-Chapter 6. Accounting Default Layouts, 'How Averages Are Calculated '
Refer to Update 6 above for the latest information!

For Update 1: The information in the following section is updated:
-Chapter 50. Statistics Report and Trace Blocks, 'Global DDF Activity'

Content

Update 12 (December 2011 - for Version 4.1.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 11 (April 2011 - for Version 4.1.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 10 (January 2011 - for Version 4.1.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 9 (April 2010 - for Version 4.1.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 8 (February 2010 - for Version 4.1.0)

    The following information has been modified.

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

    Chap5_DRDA Remote Locations.pdf

    Update 7 (December 2009 - for Version 4.1.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 6 (September 2009 - for Version 4.1.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 5 (August 2009 - for Version 4.1.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 4 (June 2009 - for Version 4.1.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 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

Update 3 (May 2009 - for Version 4.1.0)

The field description of QPACAAFG has been modified:

The type of activity. The following values indicate how the package was
loaded:
STORED PROC -- When running an external procedure
TRIGGER -- When running a trigger
UDF -- When running a user-defined function
NATIVE SQL PROC -- When running a native SQL procedure
NONNESTED --Indicates that none of the above values is true

The nested activity values that are shown in column
NEST_ACTIVITY_TYPE of the table DB2PMFACCT_PROGRAM are:

S For Stored Procedure
T For Trigger
U For UDF
Q For native SQL procedure
N For nonnested

Field Name: QPACAAFG

The following information has been updated accordingly:

-Chapter 41. IFCID Record Blocks, 'IFCID 003 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 147 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 148 - Package/DBRM Accounting Data'
-Chapter 41. IFCID Record Blocks, 'IFCID 239 - Package/DBRM Accounting Data'

The field description of ADPATYP has been modified:

The type of activity. The following values indicate how the package was
loaded:
STORED PROC -- When running an external procedure
TRIGGER -- When running a trigger
UDF -- When running a user-defined function
NATIVE SQL PROC -- When running a native SQL procedure
NONNESTED --Indicates that none of the above values is true

The nested activity values that are shown in column
NEST_ACTIVITY_TYPE of the table DB2PMFACCT_PROGRAM are:

S For Stored Procedure
T For Trigger
U For UDF
Q For native SQL procedure
N For nonnested

Field Name: ADPATYP

The following information has been updated accordingly:

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

Update 2 (February 2009 - for Version 4.1.0)

The following information has been updated.

--Chapter 6. Accounting Default Layouts, 'How Averages Are Calculated '
Note: This information has been modified with Update 6!

Update 1 (October 2008 - for Version 4.1.0)

The following information has been modified.

--Chapter 50. Statistics Report and Trace Blocks, 'Global DDF Activity'

The following field descriptions have been modified:


ACC QUEUED TYPE 2 INACT THR
The number of queued RECEIVE requests for a type 2 inactive thread and the number of requests for new connections received after the maximum number of remote DBATs was reached.
Field Name:
QDSTQIN2

CUR QUEUED TYPE 2 INACT THR

The current number of type 2 inactive threads that are queued waiting to process. This includes receive requests that completed for a type 2 inactive thread and requests for new connections that were received after the maximum number of remote active threads was reached.
Field Name:
QDSTNQR2

QUEUED TYPE 2 INACT THR HWM

The maximum number of type 2 inactive threads that were queued waiting for a database access thread. This includes both receive requests that completed for a type 2 inactive thread and requests for new connections that were received after the maximum number of remote active threads was reached.
Field Name:
QDSTMQR2


Related information

Information Management
Tivoli Software Information Center

Publication number

SC18-9984-02

Copyright date

1985, 2008

Original publication date

2008/6/30

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.1.0

Operating system(s):

z/OS

Reference #:

7008733

Modified date:

2011-04-07

Translate my page

Machine Translation

Content navigation