|
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
|
 |
