SAP Knowledge Base Article - Preview

2757185 - A query with very large nested SQL expressions causes server hang - SAP IQ

Symptom

SAP IQ 15.4 hang when running a query with very large nested SQL expressions.

We can see lots of threads like below when IQ becomes non-responsive for a period of 20 minutes to few hours:

-----------------  lwp# 287 / thread# 287  --------------------
lwp_park 
cond_wait_queue 
cond_wait 
pthread_cond_wait 
__1cIUnixTaskEwait6MH_H_ 
__1cHCondVarEwait6MrnFMutex__v_ 
__1cGWorkerTyield_to_forbidding6M_v_ 
__1cOContext_switch6FI_I_ 
__1cIdfo_ScanHDoFetch6MnUa_cursor_orientation__nDdfoGStatus__ 
__1cIdfo_BaseFFetch6MnUa_cursor_orientation__nDdfoGStatus__ 
__1cIdfo_RootHDoFetch6MnUa_cursor_orientation__nDdfoGStatus__ 
__1cIdfo_BaseFFetch6MnUa_cursor_orientation__nDdfoGStatus__ 
__1cIdfo_RootPDoFetchRelative6Mipi_nPa_search_status__ 
__1cIdfo_RootNFetchRelative6Mipi_nPa_search_status__ 
__1cJdbi_fetch6FpnLa_db_cursor_iHIIIII_I_ 
__1cRdo_cursor_execute6FpnKConnection_pnGa_stmt__v_ 
__1cTdb__execute_any_imm6FpnKConnection_pnSan_sqlpres_receive__v_ 
__1cQRequestProcedureEcall6M_v_ 
__1cHContextEcall6MpnJProcedure_pp0_v_ 

Read more...

Environment

SAP IQ 15.4

Product

SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.