Re: How to tell size of database?
Posted in 2004
Ph. Chantry — — source: Usenet: comp.databases.informix
"Henri" <henri.straforelli@customerworks.net> a 'crit dans le message de
news:4608258a.0401191601.ed9c36d@posting.google.com...
> Is there an "easy" way to find out what is the total size of an
> informix database in gigabytes?
You could run "oncheck -pT <database>", and analyse the output:
- the sum of the lines "number of pages allocated" gives the total space
allocated for the tables and indexes of your database
- the sum of the lines "number of pages used" gives the total space actually
used by the tables and indexes
The size (in K) of one page depends on the operating system.
Philippe