SAP Knowledge Base Article - Preview

2281169 - SAP IQ: Delete on SAP IQ 16 sp10.08 taking very long time

Symptom

  • Delete running slowly in SAP IQ 16 sp10.08
  • Pstack samples collected during delete job showed pread64 for s_bArray::CheckColumnEBMCoverage taking lot of time
  • Functions in the pstack: pread64
    • hos_pi_pread
    • hos_svbio::Read2
    • hos_mvbio::Read2
    • s_buf::ReadBufAndVerify
    • s_bufpartition::Find
    • s_blockmap::Find
    • s_pageListCursor::PositionPage
    • v2s_bmcontext::bmlfblkget
    • v2s_bmcontext::bmfndprvelt
    • s_bm::FindLastBit
    • s_bArray::CheckColumnEBMCoverage
    • hs_dp::GetIdentity
    • db_IndexDef::FlushIndexIdentity
    • b_IndexDef::CloseSIndexWithLock
    • db_IndexDef::CloseSIndex
    • hdb_delete_indices::Cleanup
    • hdb_delete_indices::Delete_Indices
    • hdb_hdelete::Delete
    • dfo_DeleteRoot::Complete
    • st_cursorIQtoSA::Complete
    • df_Delete::Complete
    • st_command::DoCmdThroughResourceGate
    • st_iqdml::Delete UIQDML_Delete 


Read more...

Environment

  • SAP IQ 16 sp10.08

Product

SAP IQ 16.0

Keywords

  • "Delete" "poor performance" "SAP IQ 16 sp10.08"
  • "pread6" "hos_pi_pread" "hos_svbio::Read2" "hos_mvbio::Read2""s_buf::ReadBufAndVerify" "s_bufpartition::Find" "s_blockmap::Find" "s_pageListCursor::PositionPage" "v2s_bmcontext::bmlfblkget" "v2s_bmcontext::bmfndprvelt" "s_bm::FindLastBit" "s_bArray::CheckColumnEBMCoverage" "hs_dp::GetIdentity" "db_IndexDef::FlushIndexIdentity" "b_IndexDef::CloseSIndexWithLock" "db_IndexDef::CloseSIndex" "hdb_delete_indices::Cleanup" "hdb_delete_indices::Delete_Indices" "hdb_hdelete::Delete" "dfo_DeleteRoot::Complete" "st_cursorIQtoSA::Complete" "df_Delete::Complete" "st_command::DoCmdThroughResourceGate" "st_iqdml::Delete"" UIQDML_Delete" 
, 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.