Authorized zIIP uses for Db2 processing
Portions of certain specific Db2 processes are authorized and eligible for dispatching to IBM® Z Integrated Information Processor (zIIP).
Some or all of the following processes are authorized 1 and eligible for dispatching to IBM Z Integrated Information Processor (zIIP):
- SQL request workloads that use DRDA to access Db2 for z/OS® over TCP/IP connections and native REST calls over HTTP
- Up to 60% of the Db2 for z/OS instructions executing such SQL requests, when running in Enclave SRB Mode and accessing Db2 for z/OS.
- Parallel query child processes
- After reaching a CPU usage threshold, up to 80% of the processing of long-running parallel queries for Db2 for z/OS. Long running parallel queries are those which the Db2 for z/OS Query Optimizer determines should be run in parallel and whose execution exceeds an identified period of time as established by Db2 for z/OS (the “CPU usage threshold.”) The CPU usage threshold is defined by IBM uniquely for each IBM Z Machine type.
- Utility processes
- Including the following processes:
- Up to 100% of the portion of LOAD, REORG, and REBUILD INDEX utility function that is used to maintain index structures.
- Portions of RUNSTATS processing, including column group distributed statistics processing
- XML processing
- Including the following processes:
- Up to 100% of XML schema validation and non-validation parsing.
- Up to 100% of the deletion of unneeded versions of XML documents.
- Db2 system agents processing
- Up to 100% of processing for Db2 system agents processing under enclave SRBs (service request blocks) that execute in the Db2 ssnmMSTR, ssnmDBM1 and ssnmDIST address spaces, with the exception of p-lock negotiation processing. These processes include Db2 buffer pool processing for prefetch, deferred write, page set castout, log read, and log write processing. Additional eligible processes include index pseudo-delete and XML multi version document cleanup processing.
Notes: