SAP Knowledge Base Article - Preview

2262735 - Server unresponsive when using updateable cursors - SAP IQ

Symptom

  • The IQ server can appear to hang when using updateable cursors.
  • Functions in the pstack: hos_condvar::Wait st_fifo::NeedsSync db_BeginSavepoint::Execute st_command::DoCmdThroughResourceGate st_iqtxn::CreateSavepoint UIQTxn_CreateSavepoint st_SAIQInterfaceInfo::callFunction saint_iqthresholdtxn::CreateSavepoint UndoLog::ul_savepoint DualUndoLog::ul_savepoint Connection::start_atomic a_cursor_spec::start_iq_atomic SACursorArray::CloseCursors DB_Fini_db_cursor DB_Fini_db_cursor_and_heap a_plan_cache::CloseCursor a_plan_cache::CloseACursor Connection::CloseACursor do_close dbi_drop_locals a_procedure_context::pop_level


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

  • "SAP IQ server unresponsive" "updateable cursors" "hos_condvar::Wait" "st_fifo::NeedsSync" "db_BeginSavepoint::Execute" "st_command::DoCmdThroughResourceGate" "st_iqtxn::CreateSavepoint" "UIQTxn_CreateSavepoint" "st_SAIQInterfaceInfo::callFunction" "saint_iqthresholdtxn::CreateSavepoint" "UndoLog::ul_savepoint" "DualUndoLog::ul_savepoint" "Connection::start_atomic" "a_cursor_spec::start_iq_atomic" S"ACursorArray::CloseCursors" "DB_Fini_db_cursor" "DB_Fini_db_cursor_and_heap" "a_plan_cache::CloseCursor" "a_plan_cache::CloseACursor" "Connection::CloseACursor" "do_close dbi_drop_locals" "a_procedure_context::pop_level"
, 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 for Me (Login required).

Search for additional results

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