PH72882: ABSTRACT: ADD DROP RESTRICT ON DROP TO COMMAND LINE OPTION (PANEL ADB21S)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DESCRIPTION: Add DROP RESTRICT ON DROP to command line option
  (panel ADB21S)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the DROP primary command is issued *
  *                      on panel ADB21S (Table Spaces), the     *
  *                      operation fails if any table in the     *
  *                      selected table spaces has RESTRICT ON   *
  *                      DROP.                                   *
  ****************************************************************
  The DROP primary command on the ADB21S (Table Spaces) panel did
  not check for tables with RESTRICT ON DROP. Attempting to drop a
  table space containing such tables resulted in SQLCODE -672.
  With this APAR, when the DROP command is entered at the command
  line, the system searches for tables with the RESTRICT ON DROP
  attribute. If such tables are found, a confirmation panel is
  displayed. You can either specify that Db2 Admin Tool remove any
  RESTRICT ON DROP attributes and proceed with the DROP operation
  or cancel the DROP operation.
  

Problem conclusion

• The enhancement has been delivered.
  

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:

  UO09437

Modules/Macros

• ADB21S   ADBE1S
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO09437

     UP26/09/17 P F609  

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.