|
Problem IC71531
|
Status: Closed |
DB2 connect server may trap in sqljrGenNewUow for DB2-Coordinated transactions. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - 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: *
* DB2 Connect Server user *
****************************************************************
* 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/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.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.09.2010
09.05.2011
09.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.7.0.4
|
 |
