RE: Determine Size of Database
Barbara,
I often use the sysmaster database to do this. You
can find out for each table how many rows, how many
pages, and by joining systabnames and systabinfo to
sysextents you can determine which extents are in
which dbspace. I have even toyed with the idea of
using an ACE report to do this. But I am sure there
must be better tools out there.
regards
Malcolm
--- "McCabe-Reed, Barbara SIK"
<BReed@sikorsky.com> wrote:
> My objective is to get the pages used per each
> dbspace. Is that feasible?
> Thanx.
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On
> Behalf Of Sam Gentsch
> Sent: Monday, August 02, 2004 4:09 PM
> To: 'Bill Dare'; 'McCabe-Reed, Barbara SIK';
> 'informix-list@iiug.org'
> Subject: RE: Determine Size of Database
>
>
>
> Nice little Awkness!
>
> This is great for giving you space allocated to a
> database.
> You could change the "pages allocated" to "data
> pages" and get the actual
> number of pages used
> from the total allocated.
>
> It all depends on what your intent is. If you just
> need to know how much
> space the instance is using this is overkill
> onstat -d does the job (reported in pages, not K).>
> Thanks for sharing the awk.
>
> Sam
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [ mailto:owner-informix-list@iiug.org
> <mailto:owner-informix-list@iiug.org>
> ]On Behalf Of Bill Dare
> Sent: Monday, August 02, 2004 2:28 PM
> To: 'McCabe-Reed, Barbara SIK';
> 'informix-list@iiug.org'
> Subject: RE: Determine Size of Database
>
>
> Try:
>
> oncheck -pt DATABASE_NAME | awk '/Number of pages
> allocated/{ t += $5;
> printf("%s %d\\n",$0,t); } END { printf("Total
> allocated = %d\\n",t); }'>
>
> Regards,
> Bill
>
>
> > -----Original Message-----
> > From: McCabe-Reed, Barbara SIK
> [SMTP:BReed@SIKORSKY.COM]
> > Sent: Monday, August 02, 2004 12:44 PM
> > To: 'informix-list@iiug.org'
> > Subject: Determine Size of Database
> >
> > Can anyone please instruct me how to acquire the
> size of an Informix
> > database? The database version is 7.3 and the AIX
> operating system is 4.3.
>
> > Thanx.
> >
> sending to informix-list
>
>
sending to informix-list