|
Problem IC76656
|
Status: Closed |
DB2 INSTANCE MAY TRAP WHILE DOING TWO PHASE COMMIT WHILE INSERTING ROWS AND APPLICATION IN INDOUBT STATE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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> |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.05.2011
20.12.2011
20.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
