Will zIIP usage generated by CA Database Analyzer Extract parameter ZIIP_ENABLE (YES) be displayed in CA Detector?

Document ID : KB000011902
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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?

Answer:

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