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.
Start of changeSQL statements referencing AI functionsEnd of change
Start of changeUp 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.End of change
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.
  • Start of changeUp to 100% of the portion of RUNSTATS utility processing that is used for statistics gathering.End of change
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:
  1. This information provides only general descriptions of the types and portions of workloads that are eligible for execution on Specialty Engines (for example, zIIP, zAAP, and IFLs) (SEs). IBM authorizes customers to use IBM SE only to execute the processing of Eligible Workloads of specific Programs expressly authorized by IBM as specified in the Authorized Use Table for IBM Machines provided at www.ibm.com/systems/support/machine_warranties/machine_code/aut.html (AUT).

    No other workload processing is authorized for execution on an SE. IBM offers SE at a lower price than General Processors/Central Processors because customers are authorized to use SEs only to process certain types and/or amounts of workloads as specified by IBM in the AUT.