A fix is available
APAR status
Closed as program error.
Error description
ABEND0C4 RC00000011 DSNB1GIO +08D2 due to invalid buffer I/O pointer caused by error in parallelism clean up during implicit cursor close. ADDITIONAL SYMPTOMS : SQLCODE433 ABEND0C4 DSNXPDST 1B6A ABND=04E-00E50098,M=C8 ,C=101.ASMC-DSNVEUS1,M=DSNVEUS1, LOC=DSNVGEPL.DSNVEUS1+1ECC ADDITIONAL KEYWORDS : 0C4 RC11 OFFSET08D2 SQLPARALLELISM DB2PARALL/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Users of CPU and Sysplex Query * * Parallelism * **************************************************************** * PROBLEM DESCRIPTION: ABEND0C4 RC00000010 or RC0000003B from * * DSNXPMGR . DSNXPDST +1DAA or * * DSNBBM . DSNB1GIO +083A or * * DSNXGRDS . DSNXECLN +0924 * * when executing an SQL statement that * * participates in CPU or Sysplex Query * * Parallelism * **************************************************************** * RECOMMENDATION: * **************************************************************** SQL statements that participate in CPU or Sysplex Query Parallelism get additional resources allocated to them in order to execute in parallel and these extra resources need to be cleaned up when the query is finished running. . An error in DB2 code caused some of these resources to be either cleaned up too aggressively or not aggressively enough. The result is that these resources were either cleaned up too soon or too late, respectively. This inconsistent state leads to the subject abends in the parallelism resource clean up paths or at a later point in the workload. . The error is most frequently exposed when the parallel-bound statement runs inside of a stored procedure. However, it may be exposed without stored procedures.
Problem conclusion
DB2 code has been changed to clean up CPU or Sysplex Query Parallelism resources appropriately. . . ADDITIONAL KEYWORDS: sqlcpup sysplex sqlsysplexp sqlparallelism DB2PARALL/K sqlsp sqlstoredproc
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM48926
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-09-28
Closed date
2012-02-23
Last modified date
2012-06-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK76499 UK76500 UK76501
Modules/Macros
DSNXECG DSNXECL DSNXECLF DSNXECLN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK76499
UP12/03/11 P F203 ½
R810 PSY UK76500
UP12/03/11 P F203 ½
R910 PSY UK76501
UP12/03/11 P F203 ½
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:
20 June 2012