A fix is available
APAR status
Closed as program error.
Error description
ABEND0C4 in DSNXRCSF+8A2 at PTF level UK44120. R4 and R5 are both X'40404040'. Note that is error is caused by UK44120.
Local fix
A REBIND will not fix this.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS users of aggregate * * or scalar functions and PK76100 / UK44120 * * is applied. * **************************************************************** * PROBLEM DESCRIPTION: An ABEND0C4 at DSNXRCSF +08A2 may * * occur when a query contains an * * aggregate function or the MIN or MAX * * scalar function and PK76100 is * * applied. * **************************************************************** * RECOMMENDATION: * **************************************************************** An ABEND0C4 at DSNXRCSF+08A2 may occur when a query contains an aggregate function or MIN/MAX scalar function and PK76100 is applied. The problem occurs because the internal structures are interpreted incorrectly. Following is an example of failing query: INSERT INTO T1 (C1, C2, ...) SELECT MAX('01', CHAR(DECIMAL(C1,2,0)-1)), C2, ... FROM TA WHERE ...
Problem conclusion
DB2 is fixed to interpret the aggregate function and the MIN/MAX scalar function correctly. Additional keywords: SQLSETFUNCTION SQLSCALAR SQLMIN SQLMAX
Temporary fix
Comments
APAR Information
APAR number
PK92405
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-27
Closed date
2009-09-11
Last modified date
2009-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK50056
Modules/Macros
DSNXRCSF DSNXRGBJ DSNXRISF DSNXRSFJ DSNXRSFN DSNXRSGB DSNXRSJ
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK50056
UP09/09/29 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:
02 October 2009