Hi. My boss wants me to make him a little graph showing (1) how much space we have allocated for our informix database (2) how much is actually in use and (3) how much is free. We run informix on AIX/RS6000s with a raw disk configuration.

Knowing just a little about how tables are allocated chunks and extents, I think you dont really allocate space to the database, but instead dole it out to tables...right?Ddoes this request make sense? I mean can you really know something meaningful at the database level or do we really need to be looking at least down to the table level?

I am perfectly willing to be wrong here and seek enlightenment.

Also, if anyone has any good queries that will help me measure our space utilization that would be wonderful.
*thanks!*

Hi there,

you can try out the below query -

-- What is the total size of the database

database sysmaster;
select sum(ti_nptotal) Total, sum(ti_npused) Used
from systabnames, systabinfo
where partnum = ti_partnum
order by 1

Alternatively you can visit the foll. link -

http://www.oninit.com/database/index.html

Regards,

lloyd