PI97303: S0C9 ABEND IN MODULE ALADTL1 WHEN PROCESSING AN XML STATEMENT WITH A VERY LARGE DOCID

Obtain the fix for this APAR.

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 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.