A fix is available
APAR status
Closed as program error.
Error description
When attempting to produce a SQL statement that involves an XML column, if the DOCID associated with the XML column is a large value then an 0C9 abend will occur in module ALADTL1 when attempting to process the field. This APAR will correct the handling of the BIGINT field to allow the large values to be successfully processed. Additional symptom that can occur when generating a load file: ALAA470E-Loadfile record too long; beyond DB2 32k pagesize limit.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of ALA 350 * **************************************************************** * PROBLEM DESCRIPTION: When attempting to produce a SQL * * statement that involves an XML * * column, if the DOCID associated with * * the XML column is a large * * value then an 0C9 abend will occur in * * module ALADTL1 when * * attempting to process the field. This * * APAR will correct the * * handling of the BIGINT field to allow * * the large values to be * **************************************************************** * RECOMMENDATION: Apply the PTF * ****************************************************************
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PI97303
Reported component name
DB2 LOG ANALYSI
Reported component ID
5655E6601
Reported release
350
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-26
Closed date
2018-06-27
Last modified date
2018-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI56903
Modules/Macros
ALAFRMTR ALAGEN1 ALAGLOAD ALALF1 ALALF1A ALALF1B ALALF3W ALALLB ALALXP ALAREC3W ALARXML
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R350 PSY UI56903
UP18/06/29 P F806
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.5.0"}]
Document Information
Modified date:
18 March 2021