|
Problem IC83094
|
Status: Geschlossen |
CATALOG NODE FAILURE CAN LEAD TO SYSTEM APPICATIONS NOT TERMINATING AND CAUSE SQL1229N ON NON-CATALOG NODES. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
A catalog node failure can lead to a timing issue on non-catalog
nodes where certain system applications are concurrently being
interrupted by a node failure interrupt and a force interrupt
causing the force interrupt to be lost. If the catalog node
failure interrupt happens and the agent does not process it
completely before the force interrupt comes in, (due to the last
user connection on a db forcing off all applications) the force
interrupt will be lost and the system application will return to
its waitpost. The last user connection will be waiting in
TermDbConnect on lastSysApplOut forever. Any other applications
attempting to connect to this db will get -1229.
The stack of the last user connection will be in this state:
thread_wait
sqloWaitEDUWaitPost
TermDbConnect
AppStopUsing
sqlesrspWrp
sqleUCagentConnectReset
sqljsCleanup
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqloEDUEntry
And the fast writer system application will be in this state:
thread_wait
sqloWaitEDUWaitPost
executeFastWriter
sqleIndCoordProcessRequest
RunEDU
EDUDriver
sqloEDUEntry |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 |
First fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84343 IC91384
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.05.2012
20.11.2012
20.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP7
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.7
|
 |
