Skip to end of metadata
Go to start of metadata
Warning: CORE_Options are used internally to force a particular behavior for internal IQ components. Value can change between IQ releases without notification. Before you use any of these values, please contact SAP technical support.


The value for CORE_Options151 is used to prevent these deadlocks. 

Available Values

OFF (default)

Usable Values

Valuewhat it means Usage

Without the waits, or with the option setting to OFF, a deadlock would result immediately.

  • If the setting is ON then the code waits a short time for the locks to resolve themselves. 
  • If after some time the locks do not resolve themselves then the operation is rolled back to prevent the deadlock.  
  • Server may show a connection pausing or taking a longer time during these wait times. 

Related SAP Notes/KBAs

KBA 2826663; "Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock" reported in SAP IQ message log
KBA 2716055; sp_iqcheckdb verify cause IQ_SYSTEM_TEMP full and error s_bufpartition::GetCleanPage is retrying to avert a potential deadlock - SAP IQ
KBA 2723634; sp_iqrebuildindex crash stack contains hs_dp::ConvertMetadataFrom15x - SAP IQ
KBA 2942068; Significant performance degradation of insert .. select statement after upgrading from IQ 15.4 -- SAP IQ
KBA 2223324; Server abort from stcxtlib/st_server.cxx at s_phash::FindFirstInChain - SAP IQ

  • No labels