SAP Knowledge Base Article - Preview

2290054 - SAP IQ: Insert on SAP IQ 16 sp10.08 taking very long time

Symptom

  • Insert taking very long time  in SAP IQ 16 sp10.08 and sp10.09
  • Functions in the pstack samples collected during insert: pread64 hos_pi_pread hos_svbio::Read2 hos_mvbio::Read2 s_buf::ReadBufAndVerify s_buf::Read s_bufpartition::Find s_blockmap::Find s_pageListCursor::PositionPage v2s_bmcontext::bmlfblkget v2s_bmcontext::bmfndprvelt s_bm::FindLastBit s_bArray::CheckColumnEBMCoverageDBCC hs_dp::CheckIndexConsistency hs_dpInsert::Complete dfiio_FP::PostFetchOpus dfo_IndexInsert::PostFetchOpus dfo_Sequencer::FetchOpus dfo_Root::FetchOpus dfo::Fetch  db_dmlcommand::ExecuteDFOTree db_InsertRoot::Execute st_command::DoCmdThroughResourceGate st_iqdml::Insert UIQDML_Insert


Read more...

Environment

  • SAP IQ 16 sp10.08 and sp10.09

Product

SAP IQ 16.0

Keywords

  • "insert" "poor performance" "SAP IQ 16 sp10.08" "pread64" "hos_pi_pread" "hos_svbio::Read2" "hos_mvbio::Read2" "s_buf::ReadBufAndVerify" "s_buf::Read" "s_bufpartition::Find" "s_blockmap::Find" "s_pageListCursor::PositionPage" "v2s_bmcontext::bmlfblkget" "v2s_bmcontext::bmfndprvelt" "s_bm::FindLastBit" "s_bArray::CheckColumnEBMCoverageDBCC" "hs_dp::CheckIndexConsistency" "hs_dpInsert::Complete" "dfiio_FP::PostFetchOpus" "dfo_IndexInsert::PostFetchOpus" "dfo_Sequencer::FetchOpus"dfo_Root::FetchOpus" "dfo::Fetch"  "db_dmlcommand::ExecuteDFOTree" "db_InsertRoot::Execute" "st_command::DoCmdThroughResourceGate" "st_iqdml::Insert" "UIQDML_Insert"
, 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.