Re: database size
Try the following SQL-statement (e.g. using DBACCESS)
in the sysmaster-database:
SELECT dbsname, sum(size) FROM sysextents
GROUP BY dbsname
Hope this helps,
Peter
watjep@emspo01.hasting.com ("Watje, Paul") wrote:
>
>
> To all informix/shell script guru's
>
> Is there a way to quickly tell how much space a database is taking up? We
> have multiple
> databases in a single instance and would like to copy one of the databases
> to a development
> machine, but space is tight on that system. How do you tell how much space
> is used by a single database?
>
> Any help will be greatly appreciated.
>