SAP Knowledge Base Article - Preview

2379881 - The meaning of Flexible and Inflexible memory in sp_iqstatus and sp_iqsysmon.

Symptom

Large Memory area has two distinguished usages, it's Flexible and InFlexible memory. This KBA is to explain what they are.

    > sp_iqstatus

Name,Value
' IQ large memory space:','2048Mb'
' IQ large memory flexible percentage:','50'
' IQ large memory flexible used:','0Mb'
' IQ large memory inflexible percentage:','90'
' IQ large memory inflexible used:','0Mb'
' IQ large memory anti-starvation percentage:','50'

    > sp_iqsysmon '00:00:05', 'lma'


sp_iqsysmon start_monitor,'filemode' , '-section lma' / sp_iqsysmon stop_monitor

Stat,f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14..
'Large Memory Allocator','','','','','','','','',''..
'==============================','','','','','','',..
'','','','','','','','','','','','','','','','','',..
'STATS-NAME ','VALUE ..
'Large Memory Space ','2048 MB','..
'Large Memory Max Flexible ','512 MB','..
'Large Memory Num Flex Allocations ','0 ..
'Large Memory Flexible % ','50 %','','',..
'Large Memory Flexible used ','0 MB','..
'Large Memory Inflexible % ','90 %','','',..
'Large Memory Inflexible used ','0 MB','..
'Large Memory Anti-Starvation % ','50 %','','',..
'Large Memory Num Connections ','0 ..


Read more...

Environment

SAP IQ16

Keywords

"Large memory", "InFlexible memory",  "Flexible memory", "UNlocked InFlexible", sp_iqlmastatus , , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , How To

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.