PK45524: PANEL ADB26CTQ INPUT PARMS IGNORED FOR ALC / UP OPERATION CHANGING PRIMARY KEY TO AN IDENTITY COLUMN, TYPE J OBJECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool, using ALC to alter a column, using
  UP line command to change primary key column to an IDENTITY
  column by choosing type J , the first table update in Admin
  session loses the input values for the IDENTITY column.
  .
  Panel ADB26CTQ requires all values to be entered, but resulting
  DDL does not reflect values entered for: START INCREMENT
  MINVALUE MAXVALUE and NO CACHE .
  .
  Resulting DDL appears to be DB2 default values:
   GENERATED BY DEFAULT AS IDENTITY
            (START WITH   1,
             INCREMENT BY 1,
             NO CYCLE, CACHE 20)
  .
  Furthermore, attempting to change resulting type J object to
  type I object, panel adb27c continues to reflect type J even
  after the type has been changed to type I in panel ADB26CTU .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin Tool  who use ALC        *
  *                 to change  a column to be an identity        *
  *                 column.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When changing column to  be an identity *
  *                      column,  the ALC dialog  displays panel *
  *                      ADB26CTQ  where  the  values for START, *
  *                      INCREMENT,  MAXVALUE, MINVALUE,  CYCLE, *
  *                      CACHE and ORDER can be specified. Under *
  *                      certain circumstances,these values were *
  *                      not  being used  in the DDL produced by *
  *                      the ALC function.                       *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Logic was incorrectly setting the variables for the identity
  column attributes to blank.
  

Problem conclusion

• The problems have been fixed.
  

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

•    ADB27A
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK30219

     UP07/10/25 P F710

• R720 PSY UK30220

     UP07/10/25 P F710

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.