A fix is available
APAR status
Closed as program error.
Error description
ABEND0C4 RC00000004 in DSNIBNRF offset 1C6C / 1C68 / 1CB4 / 1CB0 and DB2 DOWN during XML VALIDATE
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS users of DSN_XMLVALIDATE * **************************************************************** * PROBLEM DESCRIPTION: DB2 is terminated abnormally with * * ABEND0C4 RC00000004 in DSNIBNRF at * * offset 1C6C/1C68/1CB4/1CB0 during * * DSN_XMLVALIDATE. * **************************************************************** * RECOMMENDATION: * **************************************************************** ABEND0C4 RC00000004 in DSNIBNRF at offset 1C6C/1C68/1CB4/1CB0 occurred as a result of a memory overlay caused by a logic error when validating an XML document that is bigger than 128K using the DSN_XMLVALIDATE user-defined function. Below is an example query which may cause an abend when the input XML document, first parameter to DSN_XMLVALIDATE, is bigger than 128K. SELECT 1 FROM ( SELECT XMLPARSE(DOCUMENT SYSFUN.DSN_XMLVALIDATE( CAST(? AS BLOB(1M)), CAST(? AS VARCHAR(20)))) FROM SYSIBM.SYSDUMMYU ) XMLOK;
Problem conclusion
DB2 code has been fixed to prevent the memory overlay caused by validating the XML document that is bigger than 128K. Additional keywords: SMCOVERLAY
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM10455
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
2010-03-23
Closed date
2010-05-27
Last modified date
2010-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK57385
Modules/Macros
DSNNORES
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK57385
UP10/06/13 P F006
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:
01 July 2010