A fix is available
APAR status
Closed as program error.
Error description
Incorrect calculation for workload sharing or possibly ABEND0C9 in DSNTTMGR DSNTTTC when IBM System Z9 Integrated D/T2094 Information Processor (IBM ZIIP FLAG is enabled) for CP or SYSPLEX parallelism release preparation level (at PK17422, PK27578 pe). The zIIP hardware does NOT have to be present. Create enclave failures seen in dump(s). KEYWORD: ZIIP/K D/T2096 D/T2094 D/T2817 D/T2818 ************************************************* Additional symptoms and keywords: 0C4 RC00000010 DSNTTTC +0C1E , S013E link stack entry with EB -> EB. ABND04E DSNTTTC +0D5A, ABND0C9 DSNTTTC +0AE0 ABND0C4 RC11 DSNTTTC +0C3E also reported by customers for Parallel Create Task. Check if failing application was bound with Degree=Any, query referencing a remote table at a remove server and abend occurs at the remote server.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 users of query parallelism with zIIP * * processors enabled. * **************************************************************** * PROBLEM DESCRIPTION: ABEND0C4 RC00000010 at * * DSNTTMGR.DSNTTTC +0C1E * * or * * ABEND04E RC00E30001 at * * DSNTTMGR.DSNTTTC +0D5A * * or * * ABEND0C9 RC00000009 at * * DSNTTMGR.DSNTTTC +0AE0 * **************************************************************** * RECOMMENDATION: * **************************************************************** When a query is run under query parallelism with zIIP processors enabled and available, DB2 uses the incorrect information for WLM enclave classification, causing the reported abend.
Problem conclusion
DB2 code has been modified to correctly classify and create a WLM enclave for queries running under parallelism with zIIP processors enabled and available. Additional Keyword: SQLPARALLELISM SQLCPUP D/T2094
Temporary fix
Comments
APAR Information
APAR number
PK30548
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-08-25
Closed date
2006-11-21
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:
UK19937
Modules/Macros
DSNDTMQE DSNTTTC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R810 PSY UK19937
UP06/11/23 P F611
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