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.

Overview

The value for CORE_Options151 is used to prevent these deadlocks. 

Available Values

OFF (default)

Usable Values

Valuewhat it means Usage
OFF

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

SET OPTION PUBLIC.CORE_Options151 = 'OFF'; 
ON
  • 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. 
SET OPTION PUBLIC.CORE_Options151 = 'ON'; 


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