A fix is available
APAR status
Closed as program error.
Error description
defect 149281. problem occurs when running a V9 package with nested XML functions on V10. Functions might be skipped
Local fix
No Work Around
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of XMLCAST * * bound in DB2 9 for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When running a DB2 V9 package which * * contains an XMLCAST with another XML * * function as the argument, ABEND0C7, * * LOC=DSNXGRDS.DSNXRSN9+711C or incorrect * * output will occur. * **************************************************************** * RECOMMENDATION: * **************************************************************** When running a DB2 V9 package which contains an XMLCAST with another XML function as the argument, ABEND0C7,LOC=DSNXGRDS. DSNXRSN9+711C or incorrect output will occur. For example: In the following query, the XMLCAST has the XMLQUERY function as the argument: EXEC SQL SELECT SUM( XMLCAST( XMLQUERY('/a/b' PASSING XMLPARSE(DOCUMENT '<a><b><c>567.89</c></b></a>')) AS DECIMAL(9,2))) INTO :AMOUNT FROM SYSIBM.SYSDUMMY1; If this query is bound in DB2 V9 and runs on DB2 V10, ABEND0C7, LOC=DSNXGRDS.DSNXRSN9+711C will occur because the XMLCAST was not executed.
Problem conclusion
DB2 is modified to ensure that the XMLCAST is executed. Additional Keyword: SQLXML SQLINCORR INCORROUT SQLINCORROUT DB2INCORR/K XMLALL XMLINCORR
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM37641
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-04-22
Closed date
2011-06-28
Last modified date
2011-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK69247
Modules/Macros
DSNXRXM9
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK69247
UP11/07/13 P F107
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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 August 2011