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

DB2 connect server may trap in sqljrGenNewUow for DB2-Coordinated
transactions.

product:
DB2 CONNECT / DB2CONNCT / 910 - DB2
Problem description:
DB2 connect server can trap while serving applications running 
XA transactions and application using DB2-coordinated 
transaction simultaneously. 
 
 
0x0000002A978CF4BF _Z14sqljrGenNewUowP14db2UCinterface + 0x0391 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A978C0A24 _Z15sqljrDrdaArXregP14db2UCinterface + 0x0370 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A9790E7B6 
_Z18sqljsSqlPreProcessP13sqljsDrdaAsCbP14db2UCinterfaceb + 
0x011e 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A97929794 
_Z19sqljs_ddm_excsqlsetP14db2UCinterfaceP13sqljDDMObject + 
0x0084 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A97902539 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface 
+ 0x0349 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A9790335F 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x01a3 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A978FB315 address: 0x0000002A978FB315 ; dladdress: 
0x0000002A95781000 ; offset in lib: 0x000000000217A315 ; 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A978FC58B address: 0x0000002A978FC58B ; dladdress: 
0x0000002A95781000 ; offset in lib: 0x000000000217B58B ; 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A978F9B59 address: 0x0000002A978F9B59 ; dladdress: 
0x0000002A95781000 ; offset in lib: 0x0000000002178B59 ; 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A978F97A5 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x01ed 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A975E85D5 _ZN8sqeAgent6RunEDUEv + 0x0361 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A9A3FAA95 _ZN9sqzEDUObj9EDUDriverEv + 0x00dd 
 
(/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/vbs 
/INST/lib/libdb2e.so.1) 
0x0000002A9A3FA226 _Z10sqlzRunEDUPcj + 0x0026
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User of DB2 Connect Server                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 connect server can trap while serving applications       * 
* running                                                      * 
* XA transactions and application using DB2-coordinated        * 
*                                                              * 
* transaction simultaneously.                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* The stack trace looks like follows.                          * 
*                                                              * 
*                                                              * 
* 0x0000002A978CF4BF _Z14sqljrGenNewUowP14db2UCinterface +     * 
* 0x0391                                                       * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A978C0A24 _Z15sqljrDrdaArXregP14db2UCinterface +    * 
* 0x0370                                                       * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A9790E7B6                                           * 
*                                                              * 
* _Z18sqljsSqlPreProcessP13sqljsDrdaAsCbP14db2UCinterfaceb +   * 
*                                                              * 
* 0x011e                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A97929794                                           * 
*                                                              * 
* _Z19sqljs_ddm_excsqlsetP14db2UCinterfaceP13sqljDDMObject +   * 
*                                                              * 
* 0x0084                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A97902539                                           * 
*                                                              * 
* _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db 
* Cinterface                                                   * 
*                                                              * 
* + 0x0349                                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A9790335F                                           * 
*                                                              * 
* _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x01a3     * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A978FB315 address: 0x0000002A978FB315 ; dladdress:  * 
*                                                              * 
* 0x0000002A95781000 ; offset in lib: 0x000000000217A315 ;     * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A978FC58B address: 0x0000002A978FC58B ; dladdress:  * 
*                                                              * 
* 0x0000002A95781000 ; offset in lib: 0x000000000217B58B ;     * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A978F9B59 address: 0x0000002A978F9B59 ; dladdress:  * 
*                                                              * 
* 0x0000002A95781000 ; offset in lib: 0x0000000002178B59 ;     * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A978F97A5                                           * 
* _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +                 * 
* 0x01ed                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A975E85D5 _ZN8sqeAgent6RunEDUEv + 0x0361            * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A9A3FAA95 _ZN9sqzEDUObj9EDUDriverEv + 0x00dd        * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/akaushik_db2_v95fp7_linuxamd64_n100830_v95fp7_defect1/v 
* /INST/lib/libdb2e.so.1)                                      * 
*                                                              * 
* 0x0000002A9A3FA226 _Z10sqlzRunEDUPcj + 0x0026                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 4.                       * 
****************************************************************
Local Fix:
Use separate db2 connect server for XA and DB2 Coordinated 
transactions. Application using DB2-coordianted transactions can 
directly connect to DB2 for zOS.
available fix packs:
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
Problem was first fixed in Version 9.7 Fix Pack 4.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71439 IC71531 IC71532 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.08.2010
08.05.2011
08.05.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 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.