PI73893: DB2 ADMIN TOOL ALTER TABLE TO ADD LOB COLUMN WHEN EXISTING LOB COLUMNS EXIST AND ALL HAVE EXPLICIT LOB TABLE SPACES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALTER TABLE to add an additional LOB column not allowed when a
  LOB column already exists, returns error ADB525E/msgadb525e:
     A new LOB column cannot be added to a table when existing
     LOB columns exist and all have explicit LOB table spaces.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who add a new LOB column to             *
  *                 a table using the ALT function when          *
  *                 LOB columns exist and also contain           *
  *                 an explicit LOB table spaces.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message ADB525E / msgadb525e      *
  *                      is observed when a new LOB column is    *
  *                      added.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A new LOB column cannot be added through the ALT function to
  a table with existing LOB columns for which explicit LOB
  objects exist. Error message ADB525E / msgadb525e is generated:
  
  A new LOB column cannot be added to a table when existing LOB
  columns exist and all have explicit LOB table spaces.
  

Problem conclusion

• In a future enhancement the fix will allow the user to append
  an additional LOB column without providing a way to create
  new explicit LOB objects for the added column.
  The user will have to create the necessary LOB TS, AUX TB
  and Index for the new LOB column to make the table definition
  complete.
  

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:

  UI48737 UI48738

Modules/Macros

•    ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM2  ADB2CM3  ADB27C   ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI48737

     UP17/07/14 P F707

• RC10 PSY UI48738

     UP17/07/14 P F707

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.