PH37554: COMPARE WITH TARGET DDL AS SOURCE CAUSES COMPARE FAILURE ADB7955E DUE TO NON-EXISTENT DIFFERENCES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare with target DDL as source may cause Compare to
  fail with ADB7955E ('GOC2CMP - Error(s) found. Please review
  output') due to differences that do not exist.
  
  The problem can be easily reproduced by implementing DDL
  for a tablespace and table that contains a primary key and
  partitioning keys, and then performing a compare using the same
  DDL as source.  The compare output shows datatype changes and
  unsupported conversions, instead of reporting that no changes
  were found.
  
  Keywords: MSGADB7955E;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Comparison Tool may mistakenly   *
  *                      report differences for partition key    *
  *                      and primary key columns                 *
  ****************************************************************
  Differences may be reported for partition key and primary key
  columns when no differences exist. In this case, the target DDL
  was used as the source for a comparison with the Db2 catalog for
  objects that were created with the same DDL.
  
  The Object Comparison Report may contain entries such as the
  following:
  
  (A)Drop primary key
  (A)Add  primary key : (>columname<)
  Tables have identical column lists
  
  Conversion not supported for Col >columname< (CHAR to DISTINCT)
  (D)Type changed from Distinct type SYSIBM."CHAR" to Distinct
    type
  (E)This type change is not supported
  (D)Nulls/default changed from NOT NULL to WITH DEFAULT NULL
  
  D)Partitioning key has changed from (XXXX) to (XXXX, )
  Table >tablename< is partitioned and will be dropped by dropping
  tablespace >tsname<
  Table will be recreated
  Table data conversion jobstep will not be generated
  Conversion will fail because of datatype mismatch
  Run stopped because conversion(s) not supported
  

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:

  UI76350

Modules/Macros

• ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76350

     UP21/08/09 P F107

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.