DB2 FOR LUW / DB2FORLUW / A10 - DB2

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)

User affected: 
  Users who use  InfoSphere Federation Server 
Problem description and summay: 
  See error description

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was fistly fixed in Version 10.1, FixPak 3. This 
fix should be applied on the federation Server.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.04.2013
21.10.2013
21.10.2013