|
Problem IC76656
|
Status: Geschlossen |
DB2 INSTANCE MAY TRAP WHILE DOING TWO PHASE COMMIT WHILE INSERTING ROWS AND APPLICATION IN INDOUBT STATE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 Instance may trap while performing two phase commit while
inserting rows and may put application in INDOUBT state.
If we review the stack traces for this case,We will see DB2
agent has trapped with a sig 11 while writing a log-record in
sqlpgWaitForLrecOnDisk
and the relevant stack make look like following
Stack trace
sqlpgWaitForLrecOnDisk__FP9SQLP_DBCBUl
sqlpWriteToLog.fdpr.clone.289
sqlpWriteLR
sqlpxprp
sqlrr_xprepare
sqljsSyncPrepare
sqljs_ddm_syncctl
sqljsParseRdbAccessed
sqljsParse.fdpr.clone
qeAgentb
@sqljsSqlam
@sqljsDriveRequests
@64@sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqloEDUEntry
</StackTrace> |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 users in AIX *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 Instance may trap while performing two phase commit *
* while *
* inserting rows and may put application in INDOUBT state. *
* *
* If we review the stack traces for this case,We will see DB2 *
* agent has trapped with a sig 11 while writing a log-record *
* in *
* sqlpgWaitForLrecOnDisk *
* *
* and the relevant stack make look like following *
* *
* Stack trace *
* *
* sqlpgWaitForLrecOnDisk__FP9SQLP_DBCBUl *
* sqlpWriteToLog.fdpr.clone.289 *
* sqlpWriteLR *
* sqlpxprp *
* sqlrr_xprepare *
* sqljsSyncPrepare *
* sqljs_ddm_syncctl *
* sqljsParseRdbAccessed *
* sqljsParse.fdpr.clone *
* qeAgentb *
* @sqljsSqlam *
* @sqljsDriveRequests *
* @64@sqljsDrdaAsInnerDriver *
* sqljsDrdaAsDriver *
* RunEDU *
* EDUDriver *
* sqloEDUEntry *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* first fixed in fixpack v9.7 fixpack 5. *
**************************************************************** |
| Local-Fix: |
|
| 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 |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.05.2011
20.12.2011
20.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
