PI40660: ALT PANEL ADB27CA MESSAGE ADB200W 'NO CHANGES' AFTER CHANGING 'RESTART WITH' VALUE ON PANEL ADB26CTQ 'IDENTITY COLUMN OPTION'.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function issues a
  message 'No changes' / 'ADB200W No further action necessary
  since no changes were made.' on panel ADB27CA 'Alter Objects'
  after a change is made to the 'RESTART WITH' field on panel
  ADB26CTQ 'Identity Column Option'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the 'ALT Alter              *
  *                 Table' (ALT) function..                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ALT function issues a message       *
  *                      ADB200W 'No changes' / 'ADB200W No      *
  *                      further action necessary since no       *
  *                      changes were made.' on panel ADB27CA    *
  *                      'Alter Objects' after a change is       *
  *                      made to the 'RESTART WITH' field on     *
  *                      panel ADB26CTQ 'Identity Column         *
  *                      Option'.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The ALT function issues a message  ADB200W 'No changes' /
  'ADB200W No further action necessary since no changes were
  made.' on panel ADB27CA 'Alter Objects' after a change is
  made to the 'RESTART WITH' field on panel ADB26CTQ 'Identity
  Column Option'.
  

Problem conclusion

• Problem has been resolved.
  
  A new field:
  
  RESET MAXASSIGNED . .              (Yes/No)
  
  has beed added to panel ADB26CTQ.
  
  This field can be set to 'YES' only when the user does not
  update the 'RESTART WITH' field, and DB2 Admin will generate
  the ADMIN ALTER TABLE table_name ALTER COLUMN col_name RESET
  MAXASSIGNEDVAL statement in the ALT job to continue the ALT
  process.
  
  Otherwise, if the user set the 'RESET MAXASSIGED' field to
  'YES' and also update the 'RESTART WITH' field, panel ADB26CTQ
  will display the following error message:
  
  1 - ADB298E for DB2 Administration Tool for z/OS, Version 10,
  Release 2:
  
  ADB298E   RESET MAXASSIGNED cannot be YES if the RESTART
  WITH value is changed.
  Explanation
  RESET MAXASSIGNED must be NO if the RESTART WITH value is
  changed.
  System action
  Processing stops.
  User response
  Set RESET MAXASSIGNED to NO if you change RESTART WITH.
  
  2 - ADB813E for DB2 Administration Tool for z/OS, Version 11,
  Release 1:
  
  ADB813E   RESET MAXASSIGNED cannot be YES if the
  RESTART WITH value is changed.
  Explanation
  RESET MAXASSIGNED must be NO if the RESTART WITH
  value is changed.
  System action
  Processing stops.
  User response
  Set RESET MAXASSIGNED to NO if you change RESTART WITH.
  
  3 - ADB818E for DB2 Administration Tool for z/OS, Version 11,
  Release 2:
  
  ADB818E   RESET MAXASSIGNED cannot be YES if the RESTART
  WITH value is changed.
  Explanation
  RESET MAXASSIGNED must be NO if the RESTART WITH value
  is changed.
  System action
  Processing stops.
  User response
  Set RESET MAXASSIGNED to NO if you change RESTART WITH.
  
  The RESET MAXASSIGNED cannot be set to 'YES' if the
  RESTART WITH value is changed.
  

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:

  UI35221 UI35222 UI35223

Modules/Macros

•    ADBCDTS  ADBH6CTQ ADB2CMP  ADB2CMT  ADB2PA5
  ADB2PA6  ADB26CTQ ADB26Q   ADB27C   ADB27CA  ADB27CAA ADB27CMR
  ADB27CU  ADB27C0  ADB29    ADB81
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI35221

     UP16/02/11 P F602

• RB10 PSY UI35222

     UP16/02/11 P F602

• RB20 PSY UI35223

     UP16/02/11 P F602

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.