PH33320: DB2 ADMIN TOOL - ADB8067E ALTER INCONSISTENCY ERROR WHEN REDUCING PARTITIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: When using CM Batch to compare an object, an
  ADB8067E error occurred. The target object needed to have a
  number ofpartitions reduced to match source.
  
  
  Example:
  
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  ADB8068I Partial statement at the point of error:
  
          ALTER INDEX indexname PARTITION 1 ENDING AT(xxxxx)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Change Management (CM) function         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message ADB8067E is incorrectly         *
  *                      reported when analyzing a change        *
  *                      with an ALTER INDEX statement.          *
  ****************************************************************
  Error message ADB8067E is returned when analyzing a change that
  includes an ALTER INDEX statement that changes the highest
  value of the index key for the identified partition of the index
  column. This error message should not be returned in this case.
  
  For example:
  
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  ADB8068I Partial statement at the point of error:
  ALTER INDEX A.T1X PARTITION 1 ENDING AT(980129)
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB8067E
  

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:

  UI75243

Modules/Macros

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75243

     UP21/06/02 P F105

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.