PK18454: DB2 Z/OS EXPLOITATION OF THE IBM SYSTEM Z9 INTEGRATED D/T2094 INFORMATION PROCESSOR (IBM ZIIP) FOR DRDA THREADS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2DDF DDFL09
  DB2 z/OS exploitation of the IBM System z9 Integrated
  Information Processor ( IBM zIIP ) for DRDA threads.
  ***
  FIX IN ERROR. See PK46171 for correction.
  ***
  ZIIP/K D/T2096 D/T2094 D/T2817 D/T2818
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Users                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Exploitation of the IBM System      *
  *                      z9 Integrated Information Processor     *
  *                      (IBM zIIP).                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 exploitation of the IBM System z9 Integrated Information
  Processor (IBM zIIP).
  

Problem conclusion

• KEYWORDS: ZIIP/K
  D/T2096 D/T2094
  

Temporary fix

Comments

• DB2 Version 8 is changed to allow portions of DDF server
  thread processing, Utility processing and Star Join parallel
  child processing to be redirected to an IBM zIIP. The amount
  of CPU time eligible to run on an IBM zIIP can be projected
  without installing any IBM zIIPs by using new accounting
  fields provided by DB2 and zIIP related improvements to RMF.
  
  Once this PTF is installed and the z/OS software prerequisites
  are installed, DB2 automatically redirects portions of functions
  running under an enclave SRB to any available IBM zIIP. No
  special enablement procedure is necessary for DB2 to utilize
  zIIPs. If a zIIP is installed and online, z/OS automatically
  manages the processing of each enclave and redirects a portion
  to zIIPs. If a zIIP is not installed or is not online, the work
  continues to run on standard CPs. DB2 provides the amount of
  CPU eligible to be directed to a zIIP processor in new
  accounting fields when a zIIP is not installed and the z/OS
  PROJECTCPU parmlib parameter is enabled. For more details on
  the use of the z/OS zIIP related parameters, refer to the z/OS
  MVS Initialization and Tuning Reference.
  
  DDF server threads processing SQL requests can redirect
  processing to an IBM zIIP from applications accessing DB2
  using TCP/IP. A portion of the of the SQL processing executed
  under an independent enclave SRB is eligible to run on an IBM
  zIIP. External stored procedures, triggers or functions that
  join the enclave SRB using a TCB are not eligible. DDF server
  threads using SNA are also not eligible.
  
  Utility index build/maintenance process for the LOAD, REORG,
  and REBUILD INDEX utilities can redirect processing to an IBM
  zIIPs. A portion of the index build/maintenance is changed
  run under a dependent enclave SRB. A portion of the processing
  that executes under the enclave is eligible to run on an IBM
  zIIP.
  Infrastructure is being provided for this support. Actual
  support will be provided in another APAR.
  
  Star Join parallel child processes can utilize IBM zIIPs. A
  portion of each child process is changed to execute under a
  dependent enclave SRB if processing on behalf of an application
  accessing DB2 from an allied address space or execute under
  an independent enclave SRB if processing on behalf of a remote
  application accessing DB2 using DDF and TCP/IP. The enclave
  priority is inherited from the invoking allied address space
  when using a dependent enclave or from the main DDF server
  thread enclave classification when using an independent
  enclave. A portion of the processing running under the enclave
  SRB is redirected to run on an IBM zIIP.
  Infrastructure is being provided for this support. Actual
  support will be provided in another APAR.
  
  The DB2 accounting trace records provide information related to
  application programs including processor resources consumed by
  the application. Accumulated zIIP CPU time is not accumulated
  in the existing class 1, class 2, and class 7 accounting
  fields. New accounting fields are defined to let users know how
  much time is spent on IBM zIIPs, as well as how much time zIIP
  eligible work overflowed to standard processors. CPU time
  eligible for offload to a zIIP processor is provided in the
  accounting records even if a zIIP is not online or DB2 is not
  running on a z9 mainframe.
  
  Changes to IFCIDs 0003, 0231, 0239, 0147 and 0148 as mapped by
  the following macros:
    DSNDQPAC - PACKAGE/DBRM ACCOUNTING DATA MAPPING MACRO
    DSNDQWAC - ACCOUNTING DATA MAPPING MACRO
    DSNDQWHU - IFC CPU HEADER MAPPING MACRO
    DSNDQW01 - IFCID HEADER MAPPING MACRO
    DSNDQW02 - IFCID HEADER MAPPING MACRO
    DSNDQW03 - PARALLEL GROUP TASK TIME TRACE MAPPING MACRO
  
  Any monitor programs using DB2 accounting data will have to be
  changed if they want to support the new zIIP accounting fields.
  
  ž**** PE07/10/03 FIX IN ERROR. SEE APAR PK46171  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK15499

Modules/Macros

• DSNDACE  DSNDLFM5 DSNDQPAC DSNDQWAC DSNDQWHU
  DSNDQWSA DSNDQWUP DSNDQW01 DSNDQW02 DSNDQW04 DSNDROB  DSNDWPKT
  DSNDWWFR DSNLCAIA DSNLIRTR DSNLQACT DSNLQCTL DSNLQINA DSNLTACC
  DSNSQST  DSNVEUS1 DSNVGFAG DSNVIALC DSNVICEU DSNWAACT DSNWACDF
  DSNWDMPS DSNWMCRS DSNWVAPR DSNWVSMT DSNWVSR1 DSNWVZCK DSNWVZIT
  DSNWVZPS DSNWVZSA DSNWVZSS DSNXEET  DSNXEPM  DSNXERT  DSNX9CAL
  DSNX9WCA
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK15499

     UP06/06/30 P F606

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.