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

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

book

Article ID: 11902

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction



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?

Environment

Release:
Component: PDA

Resolution

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