SAP Knowledge Base Article - Preview

2379881 - Meaning of Flexible and Inflexible memory in sp_iqstatus and sp_iqsysmon - SAP IQ 16.x

Symptom

What is Flexible and InFlexible memory in the Large Memory area?

    > 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 IQ 16.0
  • SAP IQ 16.1

Keywords

unlocked, 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.