|
Problem IC70549
|
Status: Geschlossen |
DB2 INSTANCE ON SOLARIS CAN BECOME INACCESSIBLE AND ENTER A HUNG STATE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to DB2 9.7 Fixpack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.08.2010
28.04.2011
28.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
