A fix is available
APAR status
Closed as program error.
Error description
Incorrect or Missed CLASSIFICATION ON INDEPENDENT ENCLAVEs that are Created FOR ZIIP OFFLOAD when workload enclaves exist under the subsystem type "DB2" for parallel tasks. Note: This involves joint cooperation with WLM APAR OA26104. DB2PARALL/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 users that exploit CP query * * parallelism in remote stored procedurs * * and UDFs. * **************************************************************** * PROBLEM DESCRIPTION: System slowdown while running remote * * stored procedures and UDFs with CP * * query parallelism. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 incorrectly assigned high priority to child tasks for remote stored procedures, causing system slowdown.
Problem conclusion
DB2 has been enhanced to use work-dependent enclaves while creating parallel tasks in a stored procedure or UDF. Work-dependent enclaves will be considered a part of the underlying enclave's transaction. For more information regarding work-dependent enclaves, please refer to the closing text of WLM APAR OA26104.
Temporary fix
Comments
ž**** PE09/12/09 FIX IN ERROR. SEE APAR PM03139 FOR DESCRIPTION
APAR Information
APAR number
PK87913
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-03
Closed date
2009-08-28
Last modified date
2011-05-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK49700
Modules/Macros
DSNDTMT DSNTTRUN DSNTTTC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK49700
UP09/09/15 P F909
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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 May 2011