SAP Knowledge Base Article - Preview

2946609 - Behavior change to get 'Current' value of 'IQ Dynamic Memory' in sp_iqstatus -- SAP IQ

Symptom

Comparing to prior version, IQ16.1 SP04.02 returns different 'IQ Dynamic Memory ..'Current: ... Max: ' from sp_iqstatus.

Following is example,

  * In SP04 PL01 

>> sp_iqstatus

    ...
    ' IQ Dynamic Memory:','Current: 2240mb, Max: 3598mb'
    ...

>> Select stat_name, stat_value from sp_iqstatistics() ... 

          ---------------------------   -----------
          MemoryAllocated                 2240     
          MemoryMaxAllocated           3598

  * In SP04 PL02 

     >> sp_iqstatus

          ...
          ' IQ Dynamic Memory:','Current: 137mb, Max: 233mb'
          ...

     >> select stat_name, stat_value from sp_iqstatistics() ... 

          ---------------------------   -----------
          MemoryAllocated                   137     
          MemoryMaxAllocated             233

As well as sp_iqstatus, 'sp_iqstatistics()' also retrieves same value.  Also above 'Current' memory size is referenced by IQ CockPit's 'IQ Memory'.


Read more...

Environment

SAP IQ16.1 SP04 PL02 and higher

Product

SAP IQ 16.1

Keywords

'IQ Dynamic Memory' , 'Current' , 'IQ Memory' , IQCockPit' , 'IQ CockPit', MemoryAllocated , MemoryMaxAllocated , , KBA , BC-SYB-IQ , Sybase IQ , 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.