home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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

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 FixList