PXM Correlation High CPU demand in Xmanager and the potentiall CPU reduction

Products

• Subsystem Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Detector for DB2 for z/OS
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

What is the correlation of higher CPU demand in the Xmanager and the potential reduction of CPU in the overall SQL class 2 statistics?

Environment

Release : 20.0

Component : CA Subsystem Analyzer for Db2 for z/OS

Resolution

Here's the source of those values:

TOTAL ZIIP USAGE:

ASSB_SUP_ENCT

Enclave zIIP time in an address space. This is "normalized" time

TOTAL ZIIP ON CP

ASSB_SUP_ON_CP_ENCT

Enclave time for SUP on CP in an address space. When zAAPzIIP=YES is in effect, zAAP-eligible work running on a CP is included.

Note - we have been told by IBM that there is really no specific zAAP time, all is accumulated into zIIP.

These are the best values available for zIIP and zIIP eligible on CP.