IBM Support

IC74846: THE INSTANCE MAY CRASH WHEN TRYING TO ADD A TABLE SPACE CONTAINER THAT HAS BEEN USED PREVIOUSLY BY THE SAME DATABASE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When attempting to add a table space using a file or path
    container, and the container has previously been used by the
    same database, the instance may crash a similar stack as below:
    
    
    0      sqlbDMSAddContainerRequest
    1      sqlbDMSCreatePool
    2      sqlbSetupPool
    3      sqlbCreatePool
    4      sqldPoolCreate
    5      sqlrlcts
    6      sqlnq_create_tablespace_end
    7      sqlnq_create_tablespace_stmt
    8      sqlnp_smactn
    9      sqlnp_parser
    10      sqlnp_main
    
    This happens when the user attempts to use either a path
    containing a stale container tag file (SQLNAM.TAG), or a file
    container that has previously been used by the database, but is
    not in use any longer (for example old tablespace container
    restored from a filesystem backup).
    

Local fix

  • For path containers, remove the old tag file (SQLTAG.NAM). For
    file containers, avoid using old container files containing a
    stale tag. Use a brand new file instead.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any adding containers to a tablespace                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When attempting to add a table space using a file or path    *
    * container, and the container has previously been used by the *
    * same database, the instance may crash                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.5 fixpack 8 or later                           *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in V9.5 Fixpack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74846

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-04

  • Closed date

    2011-07-12

  • Last modified date

    2011-07-12

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

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

    IC75205

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5

Reference #: IC74846

Modified date: 12 July 2011