PM12256: DRDA PERFORMANCE IMPROVEMENT USING TCP/IP

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• DB2DDF DDFL09 DB2DRDA DB2TCPIP DB2zIIP
  DRDA performance improvement using TCP/IP.
  **********************************************
  Additional symptoms and keywords:
    ZIIP/K D/T2096 D/T2094 D/T2817 D/T2818
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically where remote clients access     *
  *                 DB2 via DRDA over TCP/IP.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: zIIP related performance improvement    *
  *                      for DRDA over TCP/IP connections from   *
  *                      remote clients.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  zIIP related performance improvement for DRDA over TCP/IP
  connections from remote clients.
  

Problem conclusion

Temporary fix

Comments

• This APAR changes the method used by DB2 for z/OS to control
  the portion of SQL request workloads via DRDA over TCP/IP
  connections ("DRDA workloads") that are authorized to be
  diverted to available zIIP specialty engine(s).  With this
  APAR, IBM has also increased the portion of such DRDA
  workloads that is authorized to run on a zIIP to up to 60%.
  This APAR also provides a performance improvement for the
  processing of such DRDA workloads by reducing processor
  switching overhead for such workloads.
  

APAR Information

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

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

  UK56724 UK56725

Modules/Macros

• DSNDLCBL DSNLIRTR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK56724

     UP10/05/08 P F005

• R910 PSY UK56725

     UP10/05/08 P F005

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.