|
Problem IC89230
|
Status: Closed |
QUERY MAY HANG WITH FEDERATED AND DB2_COMPATIBILITY_VECTOR=ORA |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
User affected:
Users who use DRDA wrapper of InfoSphere Federation Server
Problem description and summay:
See error description |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem was fistly fixed in Version 9.7, FixPak 8. This
fix should be applied on the federation Server. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91719
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.12.2012
09.04.2013
09.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
