PM78961: ALT: PANEL ADB21SAR, CHANGE TO DATABASE NOT HONORED AND PANEL ADB27C CHANGE TO DATABASE AND TABLESPACE NOT HONORED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function does not
  honor a database name change on panel ADB21SAR 'Redefine Table
  Space' or a database and tablespace change on panel ADB27C
  'ALTER Table' included via the REL option on panel ADB27CA
  'Alter Objects' during the same change.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who alter a table and table space.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user performs the 'ALT - Alter   *
  *                      Table ALT' command on a table space     *
  *                      and specifies a new database or table   *
  *                      space name, then alter a table within   *
  *                      the table space and specify the same    *
  *                      database name or table space name       *
  *                      again, the CREATE TS statement is       *
  *                      executed and the ADBALTER job ends      *
  *                      with a RC=12 / Return code 12:          *
  *                                                              *
  *                      ADBC025E - Duplicate record was         *
  *                      detected for object DBNAME.TSNAME.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user performs the 'ALT - Alter Table ALT' command on a
  table space and specifies a new database or table space name,
  then alter a table within the table space and specify the same
  database name or table space name again, the CREATE TS statement
  is executed and the ADBALTER job ends with a RC=12 / Return
  code 12.
  

Problem conclusion

• Problem has been resolved. A warning message ADB399W is
  displayed on panel ADB27CA 'Alter Objects':
  
  ADB399W
      This action may lead to an error when you apply changes
  later because the altered table, table_name, requires the
  table space that is created by the altered table space,
  tablespace_name.
  
  Explanation:
       When you alter a table space (ALT TS) by changing the
  DBname or TSname and if the alter table (ALT TB) statement
  specified the same DBname or TSname, the Administration
  Tool checks the catalog before invoking the CREATE TS
  statement. The Administration Tool checks the previous ALT
  TS action to determine whether the same table space will be
  created. If yes, the CREATE TS statement at TB level is
  ignored and the altered table requires the table space that is
  created by the altered table space. When you use an A or D
  line command on the altered TB or altered TS which has a
  dependency relationship, the table space needed by the
  altered table might not be created, which can lead to an
  error when you apply changes later.
  
  System action:
  Processing continues.
  
  User response:
  No action is required.
  

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

•    ADBH7CA  ADB21SAR ADB27C   ADB27CA  ADB27CAA
  ADB27CR  ADB27CX  ADB27C0  ADB39
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK93788

     UP13/04/27 P F304

• RA20 PSY UK93789

     UP13/04/27 P F304

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.