PM90885: ADB27AC MESSAGE 'ADBC200E INTERNAL ERROR. MAX PRIM KEY SEQ ª= #KEY COLS' 13/06/14 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' program ADB27AC issues
  a message:
  ADBC200E Internal error. Max prim key seq ﾪ= #key cols
  for an APPLY job which resulted from a change reported as
  Compare table source(>schema<.>table<) and
  target(>schema<.>table<)
      (D)Field >database< changed from >dbname1< to >dbname2<
    Column >col1<
      (D)Type changed from INTEGER to CHAR(40)
    (D)Column >col2< added
    (D)Column >col3< added
    (A)Drop primary key
    (A)Add  primary key :
  >pkey<(Coln,Coln,Coln,Coln,Coln)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function to delete a column which is not     *
  *                 part of a primary key and is placed before   *
  *                 the last column of the primary key.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the ALT function to delete   *
  *                      a column which is not a part of a       *
  *                      primary key of the table and is placed  *
  *                      before the last column of the primary   *
  *                      key, the ALT APPLY job failed with      *
  *                      RC=1012 and an error message            *
  *                      ADBC200E / msgadbc200e:                 *
  *                                                              *
  *                      ADBC200E Internal error.                *
  *                        Max prim key seq ^= #key cols         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when deleting a column
  which is not a part of a primary key and is placed before the
  last column of the primary key, the ALT APPLY job failed with
  a RC=1012 and an error message ADBC200E / msgadbc200e:
  
  ADBC200E Internal error. Max prim key seq ^= #key cols
  

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

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK96053

     UP13/07/26 P F307 {

• RA20 PSY UK96054

     UP13/07/26 P F307 {

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.