3481709 - Query running for long time causing high versioning- SAP IQ

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

SAP IQ 16.1

KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement