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):

Start of changeSQL request workloads that use DRDA to access Db2 for z/OS® over TCP/IP connections and native REST calls over HTTP End of change
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
Start of changeAfter reaching a CPU usage threshold, up to 100% of the processing of long-running parallel queries for Db2 for z/OS.End of change 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.
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.