IBM Support

PK10523: MESSAGE EXEC ADB2BSFT FAILED: > TOO MANY TABLES WITH RESTRICT ON DROP

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DB2 Administration Tool a DROP DATABASE command can
    experience error message:
    .
    EXEC ADB2BSFT failed: >Too many tables with RESTRICT ON DROP
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool,  who  use  *
    *                 the Drop Database command with the Restrict  *
    *                 On Drop Tables in it, may be affected.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: EXEC ADB2BSFT  fails on  DROP RESTRICT  *
    *                      when using the  DROP  line  command in  *
    *                      panel ADB26DDR.                         *
    *                      .*                                      *
    *                      a DROP DATABASE command can experience  *
    *                      error message:                          *
    *                      EXEC ADB2BSFT failed: >Too many tables  *
    *                      with RESTRICT ON DROP                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • Apply the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK10523

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-08-17

  • Closed date

    2006-04-12

  • Last modified date

    2006-05-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK13524 UK13525

Modules/Macros

  •    ADB26DD  ADB26DDR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R510 PSY UK13524

       UP06/04/19 P F604

  • R710 PSY UK13525

       UP06/04/19 P F604

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 May 2006