Re: Free space in an extent
update statistics;
select tabname, npused from systables;
cheers
j.
----- Original Message -----
From: "Bronson Tubb" <btubb@rotech.com>
To: <informix-list@iiug.org>
Sent: Monday, May 19, 2003 1:57 PM
Subject: Free space in an extent
> Hello,
> I am trying to find out how much room is left in dbspace. The output
> from an onstat -d shows all chunks for that dbspace as full ( 0 free
> pages) however the next extent size was set rather large so I know we
> have some room left, I just don't know how much. I am trying the
> sysextents table in the sysmaster db without much to show for my
> efforts. Any ideas?
> Thanks.
>
> ---
> W. Bronson Tubb, Jr.
> Rotech Systems Group
> btubb@rotech.com
> 321.235.3100
> ---
>
>
>
>
>