DB2 - Problem description
Problem IC71439 | Status: Closed |
DB2 connect server may trap in sqljrGenNewUow for DB2-Coordinated transactions. | |
product: | |
DB2 CONNECT / DB2CONNCT / 950 - 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 User * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 connect server can trap while serving applications * * running * * XA transactions and application using DB2-coordinated * * * * transaction simultaneously. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V 9.5 Fix pack 7. * **************************************************************** | |
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.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.5 Fix Pack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.09.2010 21.12.2010 21.12.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP7 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.7 | |
9.5.0.7 |