PH16953: DB2 OBJECT COMPARE ANALYZE INDEX DIFFERENT PARTITIONS ADBC024E MSGADBC024E;TABLE DIFFERENT COLUMNS ONCODE=520 CHECK_DROP_COL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  
  1) Analyzing a change resulting from comparing a
  a target index that has only one partition with
  a source index that has more than one partition
  may result in the following errors:
  
  ADBC024E - Unexpected catalog row on
  source file. Expected:TP or LK found:IP
  ADB7380E Module ADB2CMP -
  Severe error Compare has been stopped.
  
  2) Comparing two tables, where columns have been appended
  and deleted, may result in the following errors:
  
  
  IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition was raised.
  From entry point CHECK_DROP_COL at statement 17877
  at compile unit offset >offset< at entry offset >offset<
  at address >address<.
  
  ADB7350E Module : ADB2CMT detected an ONCODE condition 520
  in CHECK_DROP_COL at 17877
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 Z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      Analyzing a change resulting from       *
  *                      comparing a target index that has only  *
  *                      one partition with a source index that  *
  *                      has more than one partition may result  *
  *                      in errors:                              *
  *                                                              *
  *                      ADBC024E - Unexpected catalog row on    *
  *                      source file. Expected:TP or LK found:IP *
  *                      ADB7380E Module ADB2CMP -               *
  *                      Severe error Compare has been stopped.  *
  *                                                              *
  *                      Issue 2:                                *
  *                      Compare may result an ONCODE=520        *
  *                      when there is a column difference       *
  *                      between the source and target tables.   *
  ****************************************************************
  Issue 1:
  Compare does not support the case of a target index having
  one partition while the source index has more than one. The
  result is that Compare generates an incorrect change file
  which contains two add partition statements for the index.
  Analyzing this change may result in the following errors:
  
  ADBC024E - Unexpected catalog row on source file. Expected:TP
  or LK found:IP
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  Issue 2:
  Comparing two tables, where columns have been appended
  and deleted, may result in the following errors:
  
  IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition was raised.
  From entry point CHECK_DROP_COL at statement 17877
  at compile unit offset >offset< at entry offset >offset<
  at address >address<.
  
  ADB7350E Module : ADB2CMT detected an ONCODE condition 520
  in CHECK_DROP_COL at 17877
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  Note: Statement numbers are approximate, and may vary somewhat,
         depending on release or other maintenance applied.
  Note: After adding a partition to a Table and running a REORG on
        its tablespace will propagate the partition addition to
        the index.
  

Problem conclusion

• The issues have 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

• ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB7000  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67441

     UP20/01/21 P F001

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.