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 100% 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 zSystems Machine type.
- SQL statements referencing AI functions
- Up to 100% of the portion of SQL statements that use the AI functions (AI_ANALOGY, AI_SEMANTIC_CLUSTER, or AI_SIMILARITY) that is eligible to be run as a parallel query child process. A portion of those SQL statements that reference AI functions and are ineligible to be run as a parallel query child process may still be eligible if the SQL request is made through DRDA.
- 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.
- Up to 100% of the portion of RUNSTATS utility processing that is used for statistics gathering.
- 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 ssnmMSTR address space, database services address space (ssnmDBM1), and DDF address space (ssnmDIST), 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: