home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC91277 Status: Closed

DB2 APPLICATION MIGHT BE STUCK IN "COMMIT ACTIVE" STATUS.

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 on Linux, Unix and Windows         * 
* platforms                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 10.1 Fix Pack 3 or higher levels.  * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in DB2 LUW Version 10.1 Fix Pack 3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.04.2013
31.10.2013
31.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList