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 ONE Support launchpad (Login required).

Search for additional results

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