|
Problem IC86290
|
Status: Closed |
DB2 APPLICATION MIGHT BE STUCK IN "COMMIT ACTIVE" STATUS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When doing COMMIT to finish a transaction, DB2 agent receives
SIGSEGV (segmentation violation) and then is stuck in signal
handler.
Following symptoms can help you identify the problem:
1. The corresponding application stays in "Commit Active" status
and can not be forced off.
2. "FODC_Trap" directory is created with trap files and dump
files, and the stack traces would be similar to the following:
===========================================
sqlpgild
sqlpWriteToLog
sqlpWriteLR
sqlptlog
sqlpxcm1
sqlrrcom_dps
sqlrrcom
sqlrr_commit
===========================================
3. If a core dump file can be obtained for the 'db2sysc'
process, the stack trace might be similar to the following:
===========================================
sqlmStartIntervalWrapper
pdLogInternal
pdLogInternal
pdLog
sqleagnt_sigsegvh
sqloEDUCodeTrapHandler
sqlpgild
sqlpWriteToLog
sqlpWriteLR
sqlptlog
sqlpxcm1
sqlrrcom_dps
sqlrrcom
sqlrr_commit
===========================================
4. In 'db2pd -edu' output, the USR time continually increases
indicated the EDU is looping.
Since the application is holding log space and can not be forced
off, a transaction log full (SQL0964C) error may ultimately be
raised.
The source of the issue is unclear from the existing diagnostic
data. This APAR will enhance the available diagnostic data and
will attempt to avoid the trap at the expense of some accurate
time-spent monitor elements for the EDU. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of version 9.7 on Linux, Unix and Windows *
* platforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 LUW Version 9.7 Fix Pack 8 or higher levels. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
First fixed in DB2 LUW Version 9.7 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91277
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.09.2012
06.05.2013
06.05.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
