AGGREAGTE TCP TCB TIME FOR DB2 QWACAJST

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

ZIIP is included in the CPU time used while in DB2 (QWACAJST) of Distributed Threads. Is there a field that aggregates only the CP TCB time?

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

There is no such field but the available fields can be seen using the following link:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/exceptions/application-and-sql-exception-field-variables/application-and-sql-type-10-exceptions.html