home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC62487 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
This problem is first fixed in version 9.1 fix pack 9.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC62551 IC65710 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.08.2009
19.04.2010
19.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP9
Problem behoben lt. FixList in der Version
9.1.0.9 FixList