Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC61821 Status: Closed

DB2 INSTANCE CRASH DURING CURSOR LOAD FROM NICKNAME ON A
DB2_TWO_PHASE_COMMIT ENABLED SERVER

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
DB2 instance crashes during load cursor from a nickname on a 
DB2_TWO_PHASE_COMMIT enabled server.  The trapping callstack is 
similar to the below: 
-------Frame------ ------Function + Offset------ 
0x0900000179E530CC 
pGetCatalogInfo__26sqluCLoadRequestDescriptorFv + 0xC 
0x0900000179E531D8 sqluSetLoadQueryTableState__FUi + 0x98 
0x090000017A413ABC sqluCommitCallBack__Fv + 0x2FC 
0x09000001777441C8 
sqlrrcom_dps__FP8sqlrr_cbiT2P15SQLXA_CALL_INFO + 0x6A8 
0x0900000177744DC0 sqlrrcom__FP8sqlrr_cbiT2 + 0x500 
0x0900000177CC9164 sqlrr_commit__FP14db2UCinterface + 0x1A4 
0x0900000179C25034 sqluv_commit__FP8sqeAgentPiP5sqlcai + 0x274 
0x0900000179E50EBC sqluqagt__FP12SQLE_DB2RA_T + 0x8FC 
0x09000001768C045C sqlesrvr__FP14db2UCinterface + 0x14FC 
0x09000001768F36F8 sqleMappingFnServer__FP5sqldaP5sqlca + 0xFF8 
0x0900000176FDE54C 
sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5 
sqlca 
+ 0x140C 
0x0900000176F977B4 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 
0x1554 
0x090000017C251718 
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x458 
0x090000017C21AA98 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
+ 0x1D8 
0x090000017C219A14 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4 
0x090000017C20944C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 
0x3EC 
0x090000017C20AABC 
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C 
0x090000017C21074C 
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC 
0x090000017C210C60 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x100 
0x0900000176690F0C RunEDU__8sqeAgentFv + 0x3AC
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who load from cursor from a nickname on a              * 
* DB2_TWO_PHASE_COMMIT enabled server                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 instance crashes during load cursor from a nickname on a * 
*                                                              * 
* DB2_TWO_PHASE_COMMIT enabled server.  The trapping callstack * 
* is                                                           * 
* similar to the below:                                        * 
*                                                              * 
* -------Frame------ ------Function + Offset------             * 
*                                                              * 
* 0x0900000179E530CC                                           * 
*                                                              * 
* pGetCatalogInfo__26sqluCLoadRequestDescriptorFv + 0xC        * 
*                                                              * 
* 0x0900000179E531D8 sqluSetLoadQueryTableState__FUi + 0x98    * 
*                                                              * 
* 0x090000017A413ABC sqluCommitCallBack__Fv + 0x2FC            * 
*                                                              * 
* 0x09000001777441C8                                           * 
*                                                              * 
* sqlrrcom_dps__FP8sqlrr_cbiT2P15SQLXA_CALL_INFO + 0x6A8       * 
*                                                              * 
* 0x0900000177744DC0 sqlrrcom__FP8sqlrr_cbiT2 + 0x500          * 
*                                                              * 
* 0x0900000177CC9164 sqlrr_commit__FP14db2UCinterface + 0x1A4  * 
*                                                              * 
* 0x0900000179C25034 sqluv_commit__FP8sqeAgentPiP5sqlcai +     * 
* 0x274                                                        * 
* 0x0900000179E50EBC sqluqagt__FP12SQLE_DB2RA_T + 0x8FC        * 
*                                                              * 
* 0x09000001768C045C sqlesrvr__FP14db2UCinterface + 0x14FC     * 
*                                                              * 
* 0x09000001768F36F8 sqleMappingFnServer__FP5sqldaP5sqlca +    * 
* 0xFF8                                                        * 
* 0x0900000176FDE54C                                           * 
*                                                              * 
* sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgent 
* sqlca                                                        * 
*                                                              * 
* + 0x140C                                                     * 
*                                                              * 
* 0x0900000176F977B4                                           * 
* sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo +                 * 
* 0x1554                                                       * 
*                                                              * 
* 0x090000017C251718                                           * 
*                                                              * 
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject +    * 
* 0x458                                                        * 
* 0x090000017C21AA98                                           * 
*                                                              * 
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2 
* interface                                                    * 
*                                                              * 
* + 0x1D8                                                      * 
*                                                              * 
* 0x090000017C219A14                                           * 
*                                                              * 
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4       * 
*                                                              * 
* 0x090000017C20944C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb * 
* +                                                            * 
* 0x3EC                                                        * 
*                                                              * 
* 0x090000017C20AABC                                           * 
*                                                              * 
* sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C     * 
*                                                              * 
* 0x090000017C21074C                                           * 
*                                                              * 
* sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC      * 
*                                                              * 
* 0x090000017C210C60 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * 
* +                                                            * 
* 0x100                                                        * 
*                                                              * 
* 0x0900000176690F0C RunEDU__8sqeAgentFv + 0x3AC               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.5 FP5 or newer                             * 
****************************************************************
Local Fix:
Disable two phase commit for the server.
available fix packs:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Workaround
Disable two phase commit
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC61822 IC61856 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.07.2009
21.12.2009
21.12.2009
Problem solved at the following versions (IBM BugInfos)
9.5.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.5 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.