PI84589: DB2 ADMINISTRATION TOOL - ALTER TABLE ADD LOB COLUMN WHEN LOB COLUMNS ALREADY EXIST - PHASE 2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• follow on APAR PI73893 tracking phase II
  
  Phase II - will be delivered via another INTERNAL APAR, with a
  target date of 9/22/17. In this phase, ALT will display an
  option panel if the user wants to add the LOB column(s)
  explicitly or implicitly. If explicit, the user will be
  presented with a panel flow to create the LOB objects.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the ALT table function to add one    *
  *                 or more LOB columns to a table.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message ADB525E / msgadb525e      *
  *                      is observed when a new LOB column is    *
  *                      added to a table using the ALT function *
  ****************************************************************
  * 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:
  
  ADB525E: 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 the ALT table function, when adding one or more
  new LOB columns, a choice will be presented to either
  create the related LOB objects for the column (LOB
  table space, auxiliary table, and auxiliary index) explicitly,
  or have DB2 create them implicitly, under the following
  conditions:
  
  - there are no existing LOB columns, or all existing LOB
    columns are deleted in the current session
  - the existing LOB columns all have explicit associated
    LOB objects
  
  Please review Technote titled: "Alter table add LOB
  column when LOB columns already exist" for additional
  details."
  

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

•    ADBP01
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI50554

     UP17/09/26 P F709

• RC10 PSY UI50555

     UP17/09/26 P F709

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.