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 IC62487 Status: Closed

DB2 GET SIGNAL 11 DURING THE ROLLBACK PROCESS WHEN CALLING NESTED
STORE PROCEDURE IN DPF

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
When customer is calling nested store procedure, some errors may 
happen (such as dead lock),  and the transaction may be rolled 
back. 
During the rollback process, DB2 may trap with signal #11 with 
below call stacks: 
... 
(4)  0xe0000001304fe900  ---- Signal 11 (SIGSEGV) delivered ---- 
(5)  0xc0000000180a9a01 
_Z19sqlri_send_dss_msgsP8sqlrr_cbP10sqlri_ssobP23connect_msg_lis 
t_anchorPsi 
+ 0x221 at sqlri_dss.C:2076 
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so] 
(6)  0xc0000000180a5cd0  _Z9sqlri_dssP8sqlrr_cb + 0xcb0 at 
sqlri_dss.C:1219 [/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so] 
(7)  0xc0000000156c6d00 
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x240 
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so] 
(8)  0xc000000015235200 
_Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x640 at 
sqlrr_sql.C:1257 [/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so] 
(9)  0xc00000001529e440 
_Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x740 
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so] 
 
or 
 
5        sqlriecc 
6        sqlra_close_section 
7        sqlra_sqlC_free_section 
8        sqlra_sqlC_free_sibling 
9        sqlra_sqlC_rmv_invoc_siblings 
10       sqlrr_destroy_invocation_cb 
11       sqlrr_chk_destroy_invocation_cb 
12       sqlrr_end_invocation 
 
In the db2diag.log, customer may see below message indicating a 
rollback is happening: 
 
2009-01-01-00.00.00.000000+000 I111111111A111   LEVEL: Severe 
PID     : XXXXX                TID  : 1           PROC : 
db2agent (DBNAME) 0 
INSTANCE: db2inst1             NODE : 000         DB   : DBNAME 
APPHDL  : 0-XXX                APPID: XXXXXXXX 
AUTHID  : DB2INST1 
FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, probe:20 
MESSAGE : Received sqlcode -1229 (rollback) for request 80000017 
(interrupt) from node number 0
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF users.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Abstract: DB2 GET SIGNAL 11 DURING THE ROLLBACK PROCESS      * 
* WHENCALLING NESTED STORE PROCEDURE IN DPF                    * 
* Description:                                                 * 
*                                                              * 
* When customer is calling nested store procedure, some errors * 
* may                                                          * 
* happen (such as dead lock),  and the transaction may be      * 
* rolled                                                       * 
* back.                                                        * 
* During the rollback process, DB2 may trap with signal #11    * 
* with                                                         * 
* below call stacks:                                           * 
* ...                                                          * 
* (4) ---- Signal 11 (SIGSEGV) delivered ----                  * 
* (5)                                                          * 
* _Z19sqlri_send_dss_msgsP8sqlrr_cbP10sqlri_ssobP23connect_msg_l 
* + 0x221 at sqlri_dss.C:2076                                  * 
* (6) _Z9sqlri_dssP8sqlrr_cb + 0xcb0 at sqlri_dss.C:1219       * 
* (7) _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x240     * 
* (8) _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x640 at  * 
* sqlrr_sql.C:1257                                             * 
* (9) _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x740    * 
*                                                              * 
* or                                                           * 
*                                                              * 
* 5        sqlriecc                                            * 
* 6        sqlra_close_section                                 * 
* 7        sqlra_sqlC_free_section                             * 
* 8        sqlra_sqlC_free_sibling                             * 
* 9        sqlra_sqlC_rmv_invoc_siblings                       * 
* 10      sqlrr_destroy_invocation_cb                          * 
* 11      sqlrr_chk_destroy_invocation_cb                      * 
* 12      sqlrr_end_invocation                                 * 
*                                                              * 
* In the db2diag.log, customer may see below message           * 
* indicating a                                                 * 
* rollback is happening:                                       * 
*                                                              * 
* 2009-01-01-00.00.00.000000+000 I111111111A111  LEVEL: Severe * 
* PID    : XXXXX                TID  : 1          PROC :       * 
* db2agent (DBNAME) 0                                          * 
* INSTANCE: db2inst1            NODE : 000        DB  : DBNAME * 
* APPHDL  : 0-XXX                APPID: XXXXXXXX               * 
* AUTHID  : DB2INST1                                           * 
* FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca,       * 
* probe:20                                                     * 
* MESSAGE : Received sqlcode -1229 (rollback) for request      * 
* 80000017                                                     * 
* (interrupt) from node number 0                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.1 fix pack 9 or later.                  * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
This problem is first fixed in version 9.1 fix pack 9.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC62551 IC65710 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.08.2009
19.04.2010
19.04.2010
Problem solved at the following versions (IBM BugInfos)
9.1.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.