PH49831: Admin Tool: Adding a ROWID or LOB column followed by ALTER to tablespace PAGENUM fails with SQL -20385

APAR status

• Closed as program error.

Error description

• ABSTRACT:  Adding a ROWID or LOB column followed by ALTER to
  tablespace PAGENUM fails with SQL -20385
  
  
  DESCRIPTION:   Altering a tablespace after adding a ROWID or LOB
  column to a table due to AREO* status results in SQLCODE -20385
  when trying to run the ALTER on the tablespace without creating
  the dependent objects. The ALTER on the tablespace must be
  executed either before the ALTER TABLE statements or after all
  dependent objects are created.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ALTER TABLESPACE statement that      *
  *                      changes the table space PAGENUM         *
  *                      attribute to RELATIVE is set to execute *
  *                      before all dependent objects are        *
  *                      created, resulting in SQLCODE -20385.   *
  *                                                              *
  *                      SQLCODE -20385:                         *
  *                      THE STATEMENT CANNOT BE PROCESSED       *
  *                      BECAUSE THERE ARE PENDING DEFINITION    *
  *                      CHANGES FOR OBJECT.                     *
  *                      REASON CODE 8:                          *
  *                      A pending option is not allowed if      *
  *                      the table contained in the table        *
  *                      space or associated with the            *
  *                      index is in an incomplete state.        *
  ****************************************************************
  If ALTER TABLESPACE PAGENUM RELATIVE is part of the same changes
  as ALTER TABLE ADD ROWID or LOB columns, the resulting order of
  changes causes SQLCODE -20385. The alter to PAGENUM should be
  done either before the columns are added or after all dependent
  objects pertaining to the ROWID or LOB columns are created.
  

Problem conclusion

• The 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:

  UI91584 UI91586

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI91584

     UP23/06/01 P F305

• RD10 PSY UI91586

     UP23/06/01 P F305