PM89018: DB2 OBJECT COMPARISON TOOL FOR Z/OS INCORRECTLY GENERATES ALTER TABLE ALTER PARTITION STATEMENT FOR XML TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS incorrectly generates
  ALTER TABLE ALTER PARTITION statement for XML Tablespace
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who run the Compare function to change  *
  *                 the limit key of partitions as well as add   *
  *                 partitions.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool for z/OS     *
  *                      incorrectly generates an ALTER          *
  *                      TABLE ... ALTER PARTITION ...           *
  *                      statement for a table which has         *
  *                      XML columns when changing the           *
  *                      limit key of some partitions,           *
  *                      as well as adding partitions            *
  *                      to the table space with                 *
  *                      table-controlled partitioning in        *
  *                      the target.  An SQLCODE -109 /          *
  *                      SQLCODEN109 occurs during the           *
  *                      execution because ALTER TABLE ...       *
  *                      ALTER PARTITION ... is not allowed      *
  *                      for tables having XML columns.          *
  *                                                              *
  *                      ADB5044I *** INPUT STATEMENT:           *
  *                         ALTER TABLE >table-name<             *
  *                              ALTER PARTITION >integer<       *
  *                              ENDING AT (>limitkey<) ;        *
  *                      sqlerror on ALTER command, EXECUTE      *
  *                      function                                *
  *                                                              *
  *                      DSNT408I SQLCODE = -109, ERROR:         *
  *                      ALTER PARTITION CLAUSE IS NOT           *
  *                      PERMITTED                               *
  *                      DSNT418I SQLSTATE = 42601               *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Object Comparison Tool for z/OS incorrectly generates an
  ALTER TABLE ... ALTER PARTITION ... statement for a table which
  has XML columns when changing the limit key of some partitions,
  as well as adding partitions to the table space with
  table-controlled partitioning in the target.  An SQLCODE -109 /
  SQLCODEN109 occurs during the execution because ALTER TABLE ...
  ALTER PARTITION ... is not allowed for tables having XML
  columns.
  

Problem conclusion

• 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:

  UK98530 UK98531

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK98530

     UP13/10/22 P F310

• RA20 PSY UK98531

     UP13/10/22 P F310

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.