A fix is available
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 number
PM12256
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-14
Closed date
2010-05-05
Last modified date
2011-07-21
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 July 2011