PH63282: GENERATION OF DDL WITH THE XMLATTRIBUTES FUNCTION RESULTS IN MESSAGE ADB1847E AND UNFORMATTED DDL OUTPUT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A parser error has occurred for the following view. GEN cannot
  complete the request.
  Reason code = 8
  TS9999.VIEW_INFO_MSG
  
  The XMLATTRIBUTES function's attribute-name parameter, when
  specified, is not parsed correctly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who generate DDL statements that have XML    *
  *                 functions                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generated DDL statements that have the  *
  *                      XMLATTRIBUTES function, the XMLFOREST   *
  *                      function, or both might not be properly *
  *                      parsed. This behavior results in        *
  *                      message ADB1847E. Also, the generated   *
  *                      DDL is unformatted.                     *
  ****************************************************************
  When an XMLATTRIBUTE function has the attribute-name parameter,
  or when an XMLFOREST function has the element-name parameter,
  parsing fails to recognize that parameter. This APAR corrects
  this problem, allowing generated DDL to be properly formatted.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI99490

Modules/Macros

• ADB0     ADB27AC  ADB28MC  ADB2CID  ADB2CM1  ADB2CM2  ADB2CM3
  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2CMU  ADB2FMM  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3
  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2REG  ADB2REH  ADB2REM
  ADB2RGC  ADB2WCL  ADB2WIN  ADB2WVL  ADBASW   ADBCCM   ADBCCMM
  ADBCDTS  ADBCEST  ADBCHST  ADBCRCR  ADBCSPG  ADBDAT   ADBDK
  ADBGHV   ADBGMP   ADBGMSP  ADBLI    ADBNSPB  ADBPA    ADBPA1
  ADBTEP2  ADBTEPI  ADBTEPR  ADBTEPU  ADBV99
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI99490

     UP24/12/21 P F412

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.