PH47295: OBJECT COMPARE: DB2_GENERATED_DOCID_FOR_XML IMPLICIT COLUMN NOT BEING IGNORED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare:  DB2_GENERATED_DOCID_FOR_XML implicit
  column not being ignored
  
  
  
  DESCRIPTION:  When comparing tablespaces from 2 catalogs with
  identical columns except for the position of
  DB2_GENERATED_DOCID_FOR_XML column, Object Compare recreates the
  table instead of ignoring the implicit column.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who want to compare tables with              *
  *                 DB2_GENERATED_DOCID_FOR_XML columns          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Comparing tables that differ only in    *
  *                      the column position of an implicit      *
  *                      DB2_GENERATED_DOCID_FOR_XML column      *
  *                      resulted in reordering the              *
  *                      columns.                                *
  ****************************************************************
  * RECOMMENDATION: ............................................ *
  ****************************************************************
  Currently, Db2 Admin Tool includes a DB2_GENERATED_DOCID_FOR_XML
  column when comparing tables. Including this column in the
  comparison causes Db2 Admin Tool to try to reorder the columns
  by dropping and recreating the table, even when the only change
  is the location of the DB2_GENERATED_DOCID_FOR_XML column.
  
  With this APAR applied, Db2 Admin Tool does not include the
  implicitly generated column in the comparison, so dropping and
  recreating the table is not necessary.
  

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:

  UI82698 UI82699

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82698

     UP22/11/18 P F211

• RD10 PSY UI82699

     UP22/11/18 P F211

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.