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_01C478CC.2210238C
Content-Type: text/plain
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
------_=_NextPart_001_01C478CC.2210238C
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>RE: Determine Size of Database</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Nice little Awkness!</FONT>
</P>
<P><FONT SIZE=3D2>This is great for giving you space allocated to a =
database.</FONT>
<BR><FONT SIZE=3D2>You could change the "pages allocated" to =
"data pages" and get the actual number of pages used</FONT>
<BR><FONT SIZE=3D2>from the total allocated.</FONT>
</P>
<P><FONT SIZE=3D2>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=3D2>onstat -d does the job (reported in pages, not =
K).</FONT>
</P>
<P><FONT SIZE=3D2>Thanks for sharing the awk.</FONT>
</P>
<P><FONT SIZE=3D2>Sam</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: owner-informix-list@iiug.org</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:owner-informix-list@iiug.org">mailto:owner-informix-list@=
iiug.org</A>]On Behalf Of Bill Dare</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, August 02, 2004 2:28 PM</FONT>
<BR><FONT SIZE=3D2>To: 'McCabe-Reed, Barbara SIK'; =
'informix-list@iiug.org'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Determine Size of Database</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Try:</FONT>
</P>
<P><FONT SIZE=3D2>oncheck -pt DATABASE_NAME | awk '/Number of pages =
allocated/{ t +=3D $5;</FONT>
<BR><FONT SIZE=3D2>printf("%s %d\\n",$0,t); } END { =
printf("Total allocated =3D %d\\n",t); }'</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Bill</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: McCabe-Reed, =
Barbara SIK =
[SMTP:BReed@SIKORSKY.COM]</FONT>
<BR><FONT SIZE=3D2>> Sent: Monday, August 02, 2004 12:44 PM</FONT>
<BR><FONT SIZE=3D2>> To: 'informix-list@iiug.org'</FONT>
<BR><FONT SIZE=3D2>> Subject: =
Determine Size of Database</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Can anyone please instruct me how to acquire =
the size of an Informix</FONT>
<BR><FONT SIZE=3D2>> database? The database version is 7.3 and the =
AIX operating system is 4.3.</FONT>
<BR><FONT SIZE=3D2>> Thanx.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>sending to informix-list</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C478CC.2210238C--
sending to informix-list