SELECT format_units(sum(seg_size)) as ifx_memory_allocated,
       format_units(sum(seg_blkfree),4) as ifx_memory_free,
       (sum(seg_blkfree) * 100) / sum(seg_size) as pct_free
FROM sysmaster:sysseglst

What is wrong ?

example:
ifx_memory_allocated    ifx_memory_free  pct_free
11.0 GB                 4.37 GB          0.0097323743318829246144932703449505

Try this one:

SELECT format_units(sum(seg_size)) as ifx_memory_allocated,
       format_units(sum(seg_blkfree * 4096),4) as ifx_memory_free,
       (100 * sum(seg_blkfree)) / sum((seg_blkused + seg_blkfree)) as
pct_free
FROM sysmaster:sysseglst;

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference.  Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Anyway 4096 its the number i was missing in my query, can i get it form sysmaster too ?

The only 4096 i can find is os_pagesize in sysmachines table.

This is my current full statement then, gives correct values for your system ?

SELECT  format_units(sum(seg_size)) as ifx_memory_allocated,
        format_units(sum(seg_blkused),4) as ifx_memory_used,
        format_units(sum(seg_blkfree),4) as ifx_memory_free,
        format_units(sum(os_mem_total)) as os_memory_total,
        format_units(sum(os_mem_free)) as os_memory_free,
        (((sum(seg_blkfree)/sum(seg_size)) * min(os_pagesize)) * 100) as ifx_free_pct,
        ((sum(os_mem_free)/sum(os_mem_total)) * 100) as os_free_pct
from sysmaster:sysseglst, sysmaster:sysmachineinfo;

Your numbers look ok, only because you are on a 4k page size operating system, and one memory block is always 4k.

I use this to calculate free percent:
seg_blkfree/(seg_blkused+seg_blkfree)*100

I use this to determine the number of bytes in each block:
seg_size/(seg_blkused+seg_blkfree)

HTH,

Jason