Re: Calculate database space
Talma
There is one in the IIUG (http://www.iiug.org) software repository which
combines oncheck with awk to produce what you want.
HTH
Sujit
Talma.Rodrigues@oami.eu.int on 06/02/99 02:40:18 AM
Please respond to Talma.Rodrigues@oami.eu.int
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: Calculate database space
I need a script to calculate the space used for each of my databases.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Here is a query that I developed.
select
systabnames.dbsname,
systabnames.tabname,
sysptnhdr.nrows,
sysptnhdr.nptotal,
sysptnhdr.npused,
sysptnhdr.npdata,
sysptnhdr.fextsiz,
sysptnhdr.nextsiz
from
systabnames,
sysptnhdr
where
systabnames.partnum = sysptnhdr.partnum
and systabnames.tabname not matches "sys*"
group by
systabnames.dbsname,
systabnames.tabname,
sysptnhdr.nrows,
sysptnhdr.nptotal,
sysptnhdr.npused,
sysptnhdr.npdata,
sysptnhdr.fextsiz,
sysptnhdr.nextsiz
order by
systabnames.dbsname,
systabnames.tabname
On Thu, 3 Jun 1999 11:44:26 -0500, Sujit.Pal@BankAmerica.com wrote:
>
>
>
>Talma
>
>There is one in the IIUG (http://www.iiug.org) software repository which
>combines oncheck with awk to produce what you want.
>
>HTH
>Sujit
>
>
>
>
>
>Talma.Rodrigues@oami.eu.int on 06/02/99 02:40:18 AM
>
>Please respond to Talma.Rodrigues@oami.eu.int
>
>To: informix-list@iiug.org
>cc: (bcc: Sujit Pal)
>Subject: Calculate database space
>
>
>
>
>I need a script to calculate the space used for each of my databases.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
>
>
>
>
>