2379881 - The meaning of Flexible and Inflexible memory in sp_iqstatus and sp_iqsysmon. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

A new, fixed size memory section (“cache”) was added to SAP Sybase IQ 16.
This new area is called IQ Large Memory (Large Memory Allocator or LMA).

> 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

SYBASE, IQ, SAP IQ, IQ16, large memory, sp_iqstatus, sp_iqsysmon, memory, IQ large memory flexible percentage, IQ large memory inflexible percentage, flexible, inflexible , 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.