PH59454: DROP IMPACT ANALYSIS SUMMARY - LOB TS NOT CONSIDERED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using the DROP Impact Analysis Summary report, before dropping a
  base tablespace, the LOB TABLESPACES are not considered in the
  ITEMS to DROP list, even though being affected by the drop. The
  problem is that the LOB table spaces will be dropped when the
  AUX tables are dropped (as a result of dropping the table space
  and therefore also the table).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The number of table spaces listed in    *
  *                      the 'Table spaces' field on panel       *
  *                      ADB2DIP 'DROP Impact Analysis Summary'  *
  *                      is incorrect.                           *
  ****************************************************************
  When using Db2 12 function level 506 or higher, panel ADB2DIP
  'DROP Impact Analysis Summary' reports an incorrect
  number of table spaces that will be dropped,
  because LOB table spaces were not included in the count.
  

Problem conclusion

• The panel ADB2DIP 'DROP Impact Analysis Summary' correctly
  counts and reports LOB table spaces that will be dropped.
  

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:

  UI96702

Modules/Macros

• ADB26DS  ADB2DIP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI96702

     UP24/04/30 P F404

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.