Symptom
Query with long IN list kept running for long time causing high Multiplex versioning.
Cannot drop its connection.
Connection status :
ReqType IQCmdType IQCursors LowestIQCursorState IQthreads IQconnID
FETCH OPENCURSOR 1 PREPARED 15 xxxx
In sqllog :
,<,<connhandle>, PREPARE,select *** where col in( xx, xx,, , )
=,>,<connhandle>,PREPARE,
+295,<,<connhandle>,OPEN,xxx
+1,>,<connhandle>,OPEN,xxx
Related manual stacktrace shows :
===== Thread Number **** (IQ connID: xxxx) =====
pthread_cond_wait
hos_condvar::Wait()
hos_team::StartWork
hos_team::Exec
dfjo_Hash::SourcePreFetch
dfo_Join::SourcePreFetch
dfo_Join::SourcePreFetch
dfo::SourcePreFetch
dfo_Combiner::SourcePreFetc
dfo_Combiner::FetchOpus
dfo_Root::FetchOpus
st_cursorIQtoSA::FetchRows
st_cursorIQtoSA::Execute
df_OpenCursor::Execute
st_command::DoCmdThroughResourceGat
st_iqdml::OpenCursor
UIQDML_OpenCursor
Read more...
Environment
SAP IQ 16.1
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.