DB2 - Problembeschreibung
Problem IC89230 | Status: Geschlossen |
QUERY MAY HANG WITH FEDERATED AND DB2_COMPATIBILITY_VECTOR=ORA | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When db2set DB2_COMPATIBILITY_VECTOR=ORA with FEDERATED=YES, query may hang without any output. The query stuck in compile phase, here is two stack traceback stack 1: 0x00002AAAAD248444 _Z17sqlnd_derived_qncP9sqlnq_qncPS0_R17sqlnq_qunElemListRi + 0x009a (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD2488DF _Z22sqlnd_rtype_capabilityP9sqlnq_pidS0_sR17sqlnq_qunElemListRiS 3_P9sqlnq_sat22sqlnd_pid_Context_Flag + 0x010d (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD23C64F _Z20sqlnd_inlist_pad_pdaP9sqlnq_expP9sqlnq_pidR17sqlnq_qunElemLi stiRiRS2_P9sqlnq_sat + 0x215f (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD2157EB _Z20sqlnd_exp_qunset_pdaP9sqlnq_expP9sqlnq_pidR17sqlnq_qunElemLi stiRiRS2_P9sqlnq_sat + 0xb755 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD203907 _Z21sqlnd_prd_qun_vis_pdaP9sqlnq_prdP9sqlnq_qun + 0x0a73 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1ECB3D _Z27sqlnd_oprprd_qunset_vis_pdaP9sqlnq_oprR17sqlnq_qunElemList + 0x0273 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DDF29 _Z13sqlnd_opr_pdaRP9sqlnq_oprRiRP9sqlnq_sati + 0x0421 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DD403 _Z13sqlnd_qtb_pdaRP9sqlnq_qtbS1_ii + 0x0d33 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DC633 _Z13sqlnd_qtb_pdaRP9sqlnq_qtbi + 0x00a7 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DB0C6 _Z17sqlnd_qtb_pda_qrwP9sqlnq_qtb + 0x0176 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE1044F9 _Z21sqlnr_sel_mrg_precondP9sqlnq_qtbP9sqlnq_qunPi + 0x0823 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE104D83 _Z18sqlnr_sel_mrg_condP14sqlnr_progressP10sqlnr_qrwaPi + 0x00ff (/home/db2inst1/sqllib/lib64/libdb2e.so.1) stack 2: 0x00002AAAAD1DC277 _Z16sqlnd_sat_of_qunP9sqlnq_qun + 0x001f (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD25D130 _Z19sqlnd_sat_of_qunsetR17sqlnq_qunElemList + 0x0122 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD248870 _Z22sqlnd_rtype_capabilityP9sqlnq_pidS0_sR17sqlnq_qunElemListRiS 3_P9sqlnq_sat22sqlnd_pid_Context_Flag + 0x009e (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD23C64F _Z20sqlnd_inlist_pad_pdaP9sqlnq_expP9sqlnq_pidR17sqlnq_qunElemLi stiRiRS2_P9sqlnq_sat + 0x215f (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD2157EB _Z20sqlnd_exp_qunset_pdaP9sqlnq_expP9sqlnq_pidR17sqlnq_qunElemLi stiRiRS2_P9sqlnq_sat + 0xb755 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD203907 _Z21sqlnd_prd_qun_vis_pdaP9sqlnq_prdP9sqlnq_qun + 0x0a73 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1ECB3D _Z27sqlnd_oprprd_qunset_vis_pdaP9sqlnq_oprR17sqlnq_qunElemList + 0x0273 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DDF29 _Z13sqlnd_opr_pdaRP9sqlnq_oprRiRP9sqlnq_sati + 0x0421 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DD403 _Z13sqlnd_qtb_pdaRP9sqlnq_qtbS1_ii + 0x0d33 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DC633 _Z13sqlnd_qtb_pdaRP9sqlnq_qtbi + 0x00a7 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAD1DB0C6 _Z17sqlnd_qtb_pda_qrwP9sqlnq_qtb + 0x0176 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE1044F9 _Z21sqlnr_sel_mrg_precondP9sqlnq_qtbP9sqlnq_qunPi + 0x0823 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE104D83 _Z18sqlnr_sel_mrg_condP14sqlnr_progressP10sqlnr_qrwaPi + 0x00ff (/home/db2inst1/sqllib/lib64/libdb2e.so.1) | |
Problem-Zusammenfassung: | |
User affected: Users who use DRDA wrapper of InfoSphere Federation Server Problem description and summay: See error description | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
Problem was fistly fixed in Version 9.7, FixPak 8. This fix should be applied on the federation Server. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC91719 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.12.2012 09.04.2013 09.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |