IBM Support

IC70549: DB2 INSTANCE ON SOLARIS CAN BECOME INACCESSIBLE AND ENTER A HUNG STATE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 instance on solaris can become inaccessible and
    enter a hung state.
    
    After a period of activity a DB2 instance became inaccessible
    and entrered a hung state.
    
    
    Looking at the DB2 threads they can been seen to be on async I/O
    requests.  However the Solaris async I/O worker threads all
    appear to be idle and waiting on requests.
    
    
    This can be due to a solaris defect 6972029 close(-1) cancels
    all aio for all open file descriptors.
    

Local fix

  • Disable ASYNC IO
    db2set DB2LIOAIODISABLED=true
    then db2stop & db2start instance.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Solaris                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 instance on solaris can become inaccessible and          *
    *                                                              *
    * enter a hung state.                                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * After a period of activity a DB2 instance became             *
    * inaccessible                                                 *
    * and entrered a hung state.                                   *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * Looking at the DB2 threads they can been seen to be on async *
    * I/O                                                          *
    * requests.  However the Solaris async I/O worker threads all  *
    *                                                              *
    * appear to be idle and waiting on requests.                   *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * This can be due to a solaris defect 6972029 close(-1)        *
    * cancels                                                      *
    * all aio for all open file descriptors.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 Fixpack 4                                 *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 9.7 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70549

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-16

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

    IC70546

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70549

Modified date: 28 April 2011