RE: Determine Size of Database
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4795F.17625BB4
Content-Type: text/plain;
charset="iso-8859-1"
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
------_=_NextPart_001_01C4795F.17625BB4
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Determine Size of Database</TITLE>
<META content="MSHTML 5.50.4919.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=022593713-03082004><FONT face=Arial color=#0000ff size=2>My
objective is to get the pages used per each dbspace. Is that
feasible? Thanx.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]<B>On Behalf Of </B>Sam
Gentsch<BR><B>Sent:</B> Monday, August 02, 2004 4:09 PM<BR><B>To:</B> 'Bill
Dare'; 'McCabe-Reed, Barbara SIK'; 'informix-list@iiug.org'<BR><B>Subject:</B>
RE: Determine Size of Database<BR><BR></FONT></DIV>
<P><FONT size=2>Nice little Awkness!</FONT> </P>
<P><FONT size=2>This is great for giving you space allocated to a
database.</FONT> <BR><FONT size=2>You could change the "pages allocated" to
"data pages" and get the actual number of pages used</FONT> <BR><FONT
size=2>from the total allocated.</FONT> </P>
<P><FONT size=2>It all depends on what your intent is. If you just need to
know how much space the instance is using this is overkill</FONT> <BR><FONT
size=2>onstat -d does the job (reported in pages, not K).</FONT> </P>
<P><FONT size=2>Thanks for sharing the awk.</FONT> </P>
<P><FONT size=2>Sam</FONT> </P><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
owner-informix-list@iiug.org</FONT> <BR><FONT size=2>[<A
href="mailto:owner-informix-list@iiug.org">mailto:owner-informix-list@iiug.org</A>]On
Behalf Of Bill Dare</FONT> <BR><FONT size=2>Sent: Monday, August 02, 2004 2:28
PM</FONT> <BR><FONT size=2>To: 'McCabe-Reed, Barbara SIK';
'informix-list@iiug.org'</FONT> <BR><FONT size=2>Subject: RE: Determine Size
of Database</FONT> </P><BR>
<P><FONT size=2>Try:</FONT> </P>
<P><FONT size=2>oncheck -pt DATABASE_NAME | awk '/Number of pages allocated/{
t += $5;</FONT> <BR><FONT size=2>printf("%s %d\\n",$0,t); } END { printf("Total
allocated = %d\\n",t); }'</FONT> </P><BR>
<P><FONT size=2>Regards,</FONT> <BR><FONT size=2>Bill</FONT> </P><BR>
<P><FONT size=2>> -----Original Message-----</FONT> <BR><FONT size=2>>
From: McCabe-Reed, Barbara SIK
[SMTP:BReed@SIKORSKY.COM]</FONT> <BR><FONT size=2>> Sent: Monday, August
02, 2004 12:44 PM</FONT> <BR><FONT size=2>> To:
'informix-list@iiug.org'</FONT> <BR><FONT size=2>>
Subject: Determine Size of Database</FONT>
<BR><FONT size=2>> </FONT><BR><FONT size=2>> Can anyone please instruct
me how to acquire the size of an Informix</FONT> <BR><FONT size=2>>
database? The database version is 7.3 and the AIX operating system is
4.3.</FONT> <BR><FONT size=2>> Thanx.</FONT> <BR><FONT size=2>>
</FONT><BR><FONT size=2>sending to informix-list</FONT>
</P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4795F.17625BB4--
sending to informix-list