|
Problem IC79533
|
Status: Geschlossen |
DB2 AGENT HANG IN SQLPGWAITFORLRECONDISK DUE TO MISSING POST. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
In rare conditions, a db2agent may be stuck in following call
stacks due to missing post during writing log records into disk.
sqlpgWaitForLrecOnDisk + 0x330
sqlpWriteToLog + 0x7D8
sqlpWriteLR + 0x418
The above stacks should be observed in a stack file(use db2pd
-stack all to generate stack files) for several rounds for a
long time.
If this db2agent had obtained some latches, then there is a
chance to hang database due to latch wait cascaded. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* In rare conditions, a db2agent may be stuck in following *
* call stacks due to missing post during writing log records *
* into disk. *
* *
* sqlpgWaitForLrecOnDisk + 0x330 *
* sqlpWriteToLog + 0x7D8 *
* sqlpWriteLR + 0x418 *
* *
* The above stacks should be observed in a stack file(use *
* db2pd -stack all to generate stack files) for several rounds *
* for a long time. *
* *
* BTW, if this db2agent had obtained some latches, then there *
* is a chance to hang database due to latch wait cascaded. *
****************************************************************
* RECOMMENDATION: *
* Update to version 9.7 fixpack 3 or later fixpacks. *
**************************************************************** |
| Local-Fix: |
No known work around. |
| verfügbare FixPacks: |
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 |
This problem is first fixed in version 9.7 fixpack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC82267
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 31.10.2011
03.11.2011
04.04.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
