RE: Determine Size of Database
Try this against the sysmaster database:
set isolation dirty read; select d.name[1,10] , trunc (sum(chksize-nfree))
from sysdbspaces d,syschunks c WHERE d.dbsnum = c.dbsnum group by 1 order by2 desc
Bill
> -----Original Message-----
> From: McCabe-Reed, Barbara SIK [SMTP:BReed@SIKORSKY.COM]
> Sent: Tuesday, August 03, 2004 9:39 AM
> To: 'Sam Gentsch'; 'Bill Dare'; McCabe-Reed, Barbara SIK;
> 'informix-list@iiug.org'
> Subject: RE: Determine Size of Database
>
> 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>]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