PH04532: DB2 ADMIN TOOL - CM BATCH COMPARE FOR HISTORY TABLE FAILS WITH ONCODE=520

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A compare for a history table fails with ONCODE=520.
  The base table should be compared which will also compare
  the history table. An error message should be returned
  instead of the ONCODE 520 abend when:
  - the first table in a set is a history table or an archive
    table
  - if the new table on source is a history table or archive
    table (no temporal or archive-enabled pair)
  - if the table on target is a history table or archive table
    (no temporal or archive-enabled pair)
  
  
  IBM0361W ONCODE=350  The STRINGRANGE condition was raised.
           From entry point ADMIN_ALTERED_REPLACECOL at statement
           10239 ....
  IBM0361W ONCODE=350  The STRINGRANGE condition was raised.
           From entry point ADMIN_ALTERED_REPLACECOL at statement
           10239...
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
           From entry point CM30137 at statement 1596 ...
  ERROR condition was raised
  Traceback of user routines:
  Compile Unit
     Entry          Statement  CU offset   Entry offset  Address
     CM30137        1596       +000001CE   +000001CE     21C89886
     GEN_DROPCREATE 18031      +00000BE8   +00000BE8     21CE9D90
     CMR0025        164        +00001608   +00001608     21CAA890
     COMPARE_TABLES 17256      +000776AC   +000776AC     223CA594
     ADB2CMT        4176       +00002FBA   +00002FBA     222E9B32
     COMPARE_TABLES 8636       +00000066   +00000066     2193E62E
     COMPARE_OBJECTS
                    8520       +00000EBC   +00000EBC     2193F504
     COMPARE_FILES  3985       +0000ED08   +0000ED08     219562C8
     ADB2CMF        2829       +00001DD4   +00001DD4     2190A4EC
     ADB2CMP        4953       +0001165E   +0001165E     21BB1576
     COMPAREVFS_CMP 42990      +00000264   +00000264     21DA37B4
     COMPARE_PROCESS
                    39465      +00003D16   +00003D16     21DCA87E
     ADBCCM         8019       +00024D3E   +00024D3E     21D9A1B6
     GOCCCM         3          +000000CC   +000000CC     227DC394
  
  ONCODE350  / ONCODE520
  

Local fix

• Compare the base table instead of the history or archive table.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS who compare history and archive         *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Compare for a history table fails     *
  *                      with ONCODE=520 / ONCODE520. It         *
  *                      appears that AOC is incorrectly         *
  *                      attempting to compare the source        *
  *                      base table with the target history      *
  *                      table.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A Compare for a history table fails with ONCODE=520. It appears
  that AOC is incorrectly attempting to compare the source base
  table with the target history table. The scope of this compare
  is a tablespace containing a history table to a tablespace
  containing a regular table. This compare is not valid because a
  history table must be compared as a set with its temporal table.
  Compare needs to issue an error message when this combination
  occurs and stop the rest of the compare.
  

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:

Modules/Macros

•    ADB2CMF  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI61643

     UP19/03/06 P F903

• RC10 PSY UI61644

     UP19/03/06 P F903

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.