V 5.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 5.1.0: Report Reference manual, SH12-6921-02.

Update 1* in PM40133 (September 2011): The information in the following chapters is updated:
- Chapter 6. Accounting Default Layouts, 'Data Sharing Locking' (replaced, see Update 2)
- Chapter 41. IFCID Record Blocks - IFCID 002 - Data Sharing Locking Data
- Chapter 41. IFCID Record Blocks - IFCID 197 - DB2 Messages
- Chapter 41. IFCID Record Blocks - IFCID 362 - Start Trace and Stop Trace with Audit Policy
- Chapter 41. IFCID Record Blocks - IFCID 366 - Incompatible Function Char(DEC) Executed
- Chapter 50. Statistics Report and Trace Blocks, 'Data Sharing Locking'
- Chapter 50. Statistics Report and Trace Blocks, 'Real Storage in Use - Summary'

Update 2* in PM47871 (October 2011): The information in the following chapters is updated:
- Chapter 6. Accounting Default Layouts, 'Data Sharing Locking'
- Chapter 41. IFCID Record Blocks - IFCID 316 - SQL Statement Statistics
- Chapter 41. IFCID Record Blocks - IFCID 401 - Static Statements in EDM Pool

Update 3* in PM47372 (November 2011): The information in the following chapter is updated:
- Chapter 10. "The Audit Detail Report and the Audit Trace" , section 'Authorization Change' and 'DDL access detail'

Update 4* in PM49684 and general update (January 2012):
* PM49684: The information in the following chapters is updated:
- Chapter 6. Accounting Default Layouts, 'Accelerator' (new)
- Chapter 41. IFCID Record Blocks– IFCID 001 - DB2 Command Data (modified)
- Chapter 41. IFCID Record Blocks– IFCID 002 - Accelerator Data (new) - modified in Update 7
- Chapter 41. IFCID Record Blocks– IFCID 003 - Accelerator Data (new)
- Chapter 50. Statistics Report and Trace Block, 'Accelerator' (new) - modified in Update 7
- Chapter 50. Statistics Report and Trace Block, 'DB2 Commands' (modified)
* General update:The information in the following chapter is updated:
-Chapter 3. Exception Log, 'Example of the Exception Log', 'Field Descriptions'

Update 5* in PM53549 and general update (January 2012):
* PM53549: The information in the following chapters is updated:
- Chapter 10. The Audit Detail Report and the Audit Trace, 'DML at Bind Access Detail (Type BIND)'
- Chapter 10. The Audit Detail Report and the Audit Trace, 'DML Access Detail (Type DML)'
* General update:The information in the following chapters is updated:
- Chapter 41. IFCID Record Blocks– IFCID 141 - Audit DDL Grant/Revoke
- Chapter 41. IFCID Record Blocks– IFCID 269 - Trusted/Context Trace
- Chapter 41. IFCID Record Blocks– IFCID 319 - Audit Security Record

Update 6* in PM48395 (February 2012): The information in the following chapters is updated:
- Chapter 6. Accounting Default Layouts, 'How Averages Are Calculated'
- Chapter 6. Accounting Default Layouts, 'Package General (Short Report)'
- Chapter 6. Accounting Default Layouts, 'Package General (Short Trace)'
- Chapter 6. Accounting Default Layouts, 'Package Buffer Pool Activity - Class 10'
- Chapter 6. Accounting Default Layouts, 'Package Global Contention L-Locks - Class 8'
- Chapter 6. Accounting Default Layouts, 'Package Global Contention P-Locks - Class 8'
- Chapter 6. Accounting Default Layouts, 'Package Identification - Report'
- Chapter 6. Accounting Default Layouts, 'Package Identification - Trace'
- Chapter 6. Accounting Default Layouts, 'Package Locking Activity - Class 10'
- Chapter 6. Accounting Default Layouts, 'Package SQL Activity - Class 10'
- Chapter 6. Accounting Default Layouts, 'Package Times - Class 8 - Suspensions'
- Chapter 6. Accounting Default Layouts, 'Package Times - Class 7'
- 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 239 - Package/DBRM Accounting Data'

Update 7* in PM55637 (March 2012): The information in the following chapters is updated:
- Chapter 41. IFCID Record Blocks – IFCID 002 - Accelerator Data
- Chapter 50. Statistics Report and Trace Block, 'Accelerator'

Update 8* (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'

Update 9* in PM60459 and general update (August 2012): The information in the following chapter is updated:
- Chapter 6. Accounting Default Layouts - Distributed Activity - Server
- Chapter 6. Accounting Default Layouts - Distributed Activity - Requester
- Chapter 41. IFCID Record Blocks – IFCID 001 - DDF Data by Location
- Chapter 41. IFCID Record Blocks – IFCID 003 - DDF Data by Location
- Chapter 41. IFCID Record Blocks – IFCID 226 - Page Latch Contention Start
- Chapter 41. IFCID Record Blocks – IFCID 227 - Page Latch Contention End
- Chapter 50. Statistics Report and Trace Blocks - DRDA Remote Locations

Update 10* 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 11* in PM73732 (December 2012):
Information for Accelerator data and 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 12* in PM78041 (February 2013):
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'

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

Update 14* 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 15* (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 15* (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 14* 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 13* (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 12* in PM78041 (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 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'
Chap_40_IFCID 366 - Incompatible Function Char(DEC) Executed.pdf


Update 11 in PM73732 (December 2012)

Information for Accelerator data and 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 10 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).pdf

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

Chap_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 9 in PM60459 and general update (August 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.
*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.

Update 8 (June 2012)

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 7 in PM55637 ( (March 2012)

The following information (new fields Q8STWNOD, Q8STWCPU, and Q8STCCPU, and new layouts) is modified:

- Chapter 41. IFCID Record Blocks– IFCID 002 - Accelerator Data

The following description is modified:

Chap41_IFCID Record Blocks_IFCID 002 - Accelerator Data.pdfChap41_IFCID Record Blocks_IFCID 002 - Accelerator Data.pdf

- Chapter 50. Statistics Report and Trace Block, 'Accelerator'

The following description is modified:

Chap50_Statistics Report and Trace Blocks_Accelerator.pdfChap50_Statistics Report and Trace Blocks_Accelerator.pdf

Update 6 in PM48395 (February 2012)

The calculation of package average data in batch Accounting reports has changed for DB2 10. The following information is modified:

- Chapter 6. Accounting Default Layouts, 'How Averages Are Calculated'

The following description is modified:

Chap6_How Averages Are Calculated.pdfChap6_How Averages Are Calculated.pdf


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

The following description is modified:

Chap6_Package General (Short Report).pdfChap6_Package General (Short Report).pdf


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

The following description is modified:

Chap6_Package General (Short Trace).pdfChap6_Package General (Short Trace).pdf


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

The following description is modified:

Chap6_Package Buffer Pool Activity - Class 10.pdfChap6_Package Buffer Pool Activity - Class 10.pdf


- Chapter 6. Accounting Default Layouts, 'Package Global Contention L-Locks - Class 8'

The following description is modified:

Chap6_Package Global Contention L-Locks - Class 8.pdfChap6_Package Global Contention L-Locks - Class 8.pdf


- Chapter 6. Accounting Default Layouts, 'Package Global Contention P-Locks - Class 8'

The following description is modified:

Chap6_Package Global Contention P-Locks - Class 8.pdfChap6_Package Global Contention P-Locks - Class 8.pdf


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

The following description is modified:

Chap6_Package Identification - Report and Trace.pdfChap6_Package Identification - Report and Trace.pdf


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

The following description is modified:

Chap6_Package Locking Activity - Class 10.pdfChap6_Package Locking Activity - Class 10.pdf


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

The following description is modified:

Chap6_Package SQL Activity - Class 10.pdfChap6_Package SQL Activity - Class 10.pdf


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

The following description is modified

:Chap6_Package Times - Class 8 - Suspensions.pdfChap6_Package Times - Class 8 - Suspensions.pdf


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

The following description is modified:

Chap6_Package Times - Class 7.pdfChap6_Package Times - Class 7.pdf


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

The following description is modified:

Chap41_IFCID 003 - PackageDBRM Accounting Data.pdfChap41_IFCID 003 - PackageDBRM Accounting Data.pdf


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

The following description is modified:

Chap41_IFCID 147 - Package_DBRM Accounting Data.pdfChap41_IFCID 147 - Package_DBRM Accounting Data.pdf


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

The following description is modified:

Chap41_IFCID 239 - Package_DBRM Accounting Data.pdfChap41_IFCID 239 - Package_DBRM Accounting Data.pdf

Update 5 in PM53549 and general update (January 2012)

The following information is modified:

* PM53549
A new statement ID field is added to the batch Audit report:

- Chapter 10. The Audit Detail Report and the Audit Trace, 'DML at Bind Access Detail (Type BIND)'
A new statement ID field is added to the following batch Audit report:

DML at Bind Access Detail (Type BIND).pdfDML at Bind Access Detail (Type BIND).pdf

- Chapter 10. The Audit Detail Report and the Audit Trace, 'DML Access Detail (Type DML)'
A new statement ID field is added to the following batch Audit report:

DML Access Detail (Type DML).pdfDML Access Detail (Type DML).pdf

* General update:

The following IFCID layouts and fields are modified:

- Chapter 41. IFCID Record Blocks– IFCID 141 - Audit DDL Grant/Revoke

The following description is modified:

Chap_41_IFCID_141.pdfChap_41_IFCID_141.pdf


- Chapter 41. IFCID Record Blocks– IFCID 269 - Trusted/Context Trace

The following description is modified:

Chap_41_IFCID_269.pdfChap_41_IFCID_269.pdf


- Chapter 41. IFCID Record Blocks– IFCID 319 - Audit Security Record

The following description is modified:

Chap_41_IFCID_319.pdfChap_41_IFCID_319.pdf

Update 4 in PM49684 and general update (January 2012)

* PM49684

You can now monitor and tune DB2 systems and applications that employ accelerators for SQL query execution. The following information is new or modified:

- Chapter 6. Accounting Default Layouts, 'Accelerator' (new)

The following information is new:

Chap_6_Accounting_Accelerator.pdfChap_6_Accounting_Accelerator.pdf


- Chapter 41. IFCID Record Blocks– IFCID 001 - DB2 Command Data (modified)

The following information is modified:

Chap_41_IFCID 001_DB2_Command_Data.pdf


- Chapter 41. IFCID Record Blocks– IFCID 002 - Accelerator Data (new)
- see Update 7

The following information is new:
Chap_41_IFCID_002_Accelerator_Data.pdfChap_41_IFCID_002_Accelerator_Data.pdf

- Chapter 41. IFCID Record Blocks– IFCID 003 - Accelerator Data (new)

The following information is new:
Chap_41_FCID_003_Accelerator_Data.pdf

- Chapter 50. Statistics Report and Trace Block, 'Accelerator' (new) - see Update 7

The following information is new:

Chap_50_Statistics_Accelerator.pdfChap_50_Statistics_Accelerator.pdf


- Chapter 50. Statistics Report and Trace Block, 'DB2 Commands' (modified)

The following information is new:
Chap_50_Statistics_DB2_Commands.pdf

* General update:

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 3 in PM47372 (November 2011)

The following information is modified:

- Chapter 10. "The Audit Detail Report and the Audit Trace" , section 'Authorization Change'
The following information is updated (information about IFCID 270 is moved to section 'DDL access detail'):

Authorization Change.pdfAuthorization Change.pdf

- Chapter 10. "The Audit Detail Report and the Audit Trace" , section 'DDL access detail'
The following information is updated. This section now contains information about IFCID 270:

DDL Access Detail.pdfDDL Access Detail.pdf


Update 2 in PM47871 (October 2011)
The following information is modified:

- Chapter 6. Accounting Default Layouts, 'Data Sharing Locking'
The following information is updated:
Chap6_AccDefaultLayouts_DataSharingLocking.pdfChap6_AccDefaultLayouts_DataSharingLocking.pdf

- Chapter 41. IFCID Record Blocks - IFCID 316 - SQL Statement Statistics

The following information is updated:

Chap41_IFCID316_SQLStatementStatistics.pdf


- Chapter 41. IFCID Record Blocks - IFCID 401 - Static Statements in EDM Pool

The following information is added:

Chap41_IFCID401_StaticStatementsinEDMPool.pdf

Update 1 in PM40133 (September 2011)

The following information is modified.

- Chapter 6. Accounting Default Layouts, 'Data Sharing Locking'
The following information update is replaced, see Update 2 above.


- Chapter 41. IFCID Record Blocks - IFCID 002 - Data Sharing Locking Data
The following information is updated:
Chap41_IFCID_002_DataSharingLockingData.pdf


- Chapter 41. IFCID Record Blocks - IFCID 197 - DB2 Messages
The following information is added:
Chap41_IFCID_197_DB2Messages.pdf


- Chapter 41. IFCID Record Blocks - IFCID 362 - Start Trace and Stop Trace with Audit Policy
The following information is updated:

Chap41_IFCID_362_StartTrace_Stop_Trace.pdf


- Chapter 41. IFCID Record Blocks - IFCID 366 - Incompatible Function Char(DEC) Executed
The following information is added:

Chap41_IFCID_366_Incompatible_Function.pdf

-Chapter 50. Statistics Report and Trace Blocks, 'Data Sharing Locking'

The following description is updated.

Chap50_Statistics_DataSharingLocking.pdf

-Chapter 50. Statistics Report and Trace Blocks, 'Real Storage in Use - Summary'
The following information is added:
Chap50_Statistics_RealStorageinUseSummary.pdf


Related information

Information Management
Tivoli Software Information

Publication number

SH12-6921-02

Copyright date

1985, 2011

Original publication date

2011/3/8

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

Operating system(s):

z/OS

Reference #:

7020420

Modified date:

2014-06-25

Translate my page

Machine Translation

Content navigation