Will CA Detector for DB2 for z/OS (PDT) display information related to zIIP utilization for CA Database Analyzer for DB2 for z/OS (PDA) parameter ZIIP_ENABLE (YES) found in the PDA member of hlq.CDBAPARM?
The ZIIP_ENABLE (YES) option is not SQL based. Therefore, it's activity will not be present in CA Detector. However, zIIP messages will be displayed in the CA Database Analyzer Extract output, like so:
zIIP Statistics for Current Step
Statistics reflect only zIIP enabled subtasks:
Total TCB CPU Used......... 0.149963
Total SRB CPU Used......... 0.039547
CPU zIIP eligible on zIIP.. 0.038748
CPU zIIP eligible on CP.... 0.000808
CPU zIIP eligible total.... 0.039560
Subtasks zIIP enabled..............16
- Tablespace ......................13
- Index ............................3
Subtasks not zIIP enabled...........0