DB2 - Problembeschreibung
Problem IC70570 | Status: Geschlossen |
DB2 connect server may trap in sqljrGenNewUow for DB2-Coordinated transactions. | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 910 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC71439 IC71531 IC71532 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.08.2010 08.05.2011 08.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |