IBM Support

LI74540: UNABLE TO DROP TABLESPACE DUE TO TABLESPACE ACCESS IS NOT ALLOWED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After a tablespace restore, tablespace could not be dropped as
    tablespace access is not allowed and dropping a table inside the
    tablespace wll also return the below error.
    
    SQL0290N  Table space access is not allowed.  SQLSTATE=55039
    

Local fix

  • Issue a tablespace restore to bring the tablespace to normal
    state.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 Version 9.5 GA through Fix Pack 5 servers onLinux,   *
    * Unix, and Windows issuing DROPTABLESPACE on a tablespace in  *
    * a bad state.                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After a tablespace restore, tablespace can't be dropped      *
    * astablespace access is not allowed and the access to a       *
    * tableinside the tablespace returns the error SQL0290N        *
    * Tablespace access is not allowed.  SQLSTATE=55039            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.5 FP6 or later.                     *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

  • Issue a tablespace restore to bring the tablespace to normal
    state.
    

Comments

  • * Fix Release: DB2 V9.5 fp 6
    * Fix Commitment Level:  "999"
    

APAR Information

  • APAR number

    LI74540

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-27

  • Closed date

    2010-06-30

  • Last modified date

    2010-06-30

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

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

    IC61622 IC68424

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 June 2010