Symptom
SAP IQ Cockpit could display 100% for Main cache in use and alerts are constantly triggered.
IQ uses 100% of its main and temp cache for fast query execution and this is a normal behavior.
The main cache needs adjustment only when it is used less than around 95%.
See IQ manual, Buffer Cache Performance
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
alert threshold settings trigger range configuration , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement
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.