Re: Table are getting to large
This is a multi-part message in MIME format.
------=_NextPart_000_037A_01C07597.8D02B410
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This would give you total no of rows.
select sum(nrows) from systables where tabid > 99;
or=20
for individual tables:
select tabname,nrows from systables where tabid > 99;
Vivek
----- Original Message -----=20
From: CShivvers@hy-vee.com=20
To: informix-list@iiug.org=20
Sent: Tuesday, January 02, 2001 1:31 PM
Subject: Table are getting to large
I need a simple way to monitor flow of data through all of my tables. =
Is
there a command to tell me how many records are in all tables or do I =
have
to specify each table? Right now I have approx. 750 tables. onstat -d =
tells
my chunk size but not the table names that have grown to large. =20
=20
CC Shivvers
Hy-vee, inc.
-------------------------------------------------------------------------=
-----
I need a simple way to monitor flow of data through all of my tables. =
Is there a command to tell me how many records are in all tables or do I =
have to specify each table? Right now I have approx. 750 tables. onstat =
-d tells my chunk size but not the table names that have grown to large. =
=20
=20
CC Shivvers
Hy-vee, inc.
------=_NextPart_000_037A_01C07597.8D02B410
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>This would give you total no of =
rows.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>select sum(nrows) from systables where =
tabid >=20
99;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>or </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>for individual tables:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>select tabname,nrows from systables =
where tabid=20
> 99;</FONT></DIV></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Vivek</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:CShivvers@hy-vee.com"=20
title=3DCShivvers@hy-vee.com>CShivvers@hy-vee.com</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:informix-list@iiug.org"=20
title=3Dinformix-list@iiug.org>informix-list@iiug.org</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, January 02, 2001 =
1:31=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Table are getting to =
large</DIV>
<DIV><BR></DIV>I need a simple way to monitor flow of data through all =
of my=20
tables. Is<BR>there a command to tell me how many records are in =
all=20
tables or do I have<BR>to specify each table? Right now I have approx. =
750=20
tables. onstat -d tells<BR>my chunk size but not the table names =
that=20
have grown to large. <BR> <BR>CC Shivvers<BR>Hy-vee, =
inc.<BR>
<P>
<HR>
<P></P><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<DIV><SPAN class=3D410300420-02012001><FONT face=3DArial size=3D2>I =
need a simple=20
way to monitor flow of data through all of my tables. Is there a =
command=20
to tell me how many records are in all tables or do I have to specify =
each=20
table? Right now I have approx. 750 tables. onstat -d tells my =
chunk=20
size but not the table names that have grown to=20
large. </FONT></SPAN></DIV>
<DIV><SPAN class=3D410300420-02012001><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D410300420-02012001><FONT face=3DArial size=3D2>CC=20
Shivvers</FONT></SPAN></DIV>
<DIV><SPAN class=3D410300420-02012001><FONT face=3DArial =
size=3D2>Hy-vee,=20
inc.</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_037A_01C07597.8D02B410--