IC84352: DB2 ABEND ON DROP TABLESPACE COMMAND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 will abend if a DROP TABLESPACE command is issued after the
    SMS table space file SQLTAG.NAM has been renamed. The error
    message below is the symptom of the crash:
    
    $ db2 drop tablespace SYSTOOLSTMPSPACE
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it returned:
    SQL1224N  The database manager is not able to accept new
    requests, has terminated all requests in progress, or has
    terminated the specified request because of an error or a forced
    interrupt.  SQLSTATE=55032
    
    The trap file generated during the abend will contain a stack
    trace similar to the one below:
    
    sqlbAdjustPathsForReleasedContainers
    sqlbSMSFreePoolContainers
    sqlbSMSDropPool
    sqlbDropPoolAct
    
    The root cause of the problem is the renaming of the SQLTAG.NAM
    file. Note that it is not allowed to manipulate database control
    files manually. The database should be considered inconsistent
    in this case as at least one table space is damaged.
    

Local fix

  • Rename the SQLTAG.NAM file back, or perform a table space level
    restore if this file cannot be recovered otherwise.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 v9.10 GA                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v10 FP1                                       *
    ****************************************************************
    

Problem conclusion

  • The fix was made to DB2 v10 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC84352

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-13

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

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

    IC81307

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC84352

Modified date:

2012-11-13

Translate my page

Machine Translation

Content navigation