Hi,
I am working on informix Xps on HP-UX machine. The database server is configured for 16 max queries. I have a small doubt regarding the memory allocation for the queries. When i give onstat -g rgm command the output is as follows.



DS_ADM_POLICY: FAIR
DS_MAX_QUERIES: 16
MAX_PDQPRIORITY: 100
DS_TOTAL_MEMORY: 4718592 KB
DS_TOTAL_TMPSPACE: NO QUOTA

Coserver Capabilities
-----------------------------------------------------------
Number cosvrs Active/Enabled
Total cosrvs 1 1
Compute Capable cosvrs 1 1
TempData Capable cosvrs 1 1
-----------------------------------------------------------

DS Total Memory Across Coservers: 4718592 KB

Queries: Waiting Active
0 11

Memory: Total Free
(KB) 4718592 2831168

RGM Wait Queue: (len = 0)
---------------
No waiting queries.

RGM Active Queue: (len = 11)
-----------------
Lvl Session Plan PdqPrio Memory (KB) #Cosvrs Local Cosvr
50 1.62 60 10.00-10.00 471856 1 1
50 1.70 69 10.00-10.00 471856 1 1
50 1.82 89 10.00-10.00 471856 1 1
50 1.90 99 10.00-10.00 471856 1 1
50 1.102 117 10.00-10.00 0 1 1
50 1.106 124 10.00-10.00 0 1 1
50 1.108 126 10.00-10.00 0 1 1
50 1.112 132 10.00-10.00 0 1 1
50 1.114 139 10.00-10.00 0 1 1
50 1.116 140 10.00-10.00 0 1 1
50 1.118 141 10.00-10.00 0 1 1

It shows me 11 active queries and the memory is allocated for 4 of them only. For the remaining queries it shows memory is 0. I want to know why this is showing 0 for these queries.


Bye.