Hi again. 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
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