|
Problem IC70549
|
Status: Closed |
DB2 INSTANCE ON SOLARIS CAN BECOME INACCESSIBLE AND ENTER A HUNG STATE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| 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 *
**************************************************************** |
| Local Fix: |
Disable ASYNC IO
db2set DB2LIOAIODISABLED=true
then db2stop & db2start instance. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 9.7 Fixpack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2010
28.04.2011
28.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
