zIIP usage by DB2 Sort
agburke 060001QPDN Visits (1928)
DB2 Sort is a separate chargeable product which designed to help reduce elapsed time, and CPU time used by the IBM DB2 Utilities Suite. This product was designed to help the utilities with their sorting processes. Portions of the DB2 Sort are zIIP eligible, which go beyond what might be eligible using DFSORT. For customers using DB2 Sort with DB2 9, DB2 10, or DB2 11 if there was zIIP eligible DB2 Sort processing that was dispatched to a CP instead, there was previously no way of monitoring this. The IFCID 25 record for utilities processing times did not include this information previously.
With the following APARs the SMF type 30 records are interrogated to get the zIIP eligible processing that occured on a general CP, and reported on.