RE: Table are getting to large
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_01C07511.E6EE4E48
Content-Type: text/plain;
charset="iso-8859-1"
One way is
update statistics;
select tabname, nrows from systables where tabid > 99 order by nrows;
Mind you the statistics is important - otherwise the row count for each
table will be out of date.
I also have a lovely little script which parses oncheck -pe output and
produces a summarized list of the contents of each dbspace. What version of
the DB are you running?
cheers
j.
-----Original Message-----
From: Shivvers, CC [mailto:CShivvers@hy-vee.com]
Sent: Tuesday, January 02, 2001 3:31 PM
To: informix-list@iiug.org
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.
CC Shivvers
Hy-vee, inc.
------_=_NextPart_001_01C07511.E6EE4E48
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">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff size=2>One
way is </FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff size=2>update
statistics;</FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff size=2>select
tabname, nrows from systables where tabid > 99 order by
nrows;</FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff size=2>Mind
you the statistics is important - otherwise the row count for each table will be
out of date.</FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff size=2>I also
have a lovely little script which parses oncheck -pe output and produces a
summarized list of the contents of each dbspace. What version of the DB
are you running?</FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff
size=2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=307461223-02012001><FONT face=Arial color=#0000ff
size=2>j.</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Shivvers, CC [mailto:CShivvers@hy-vee.com]<BR><B>Sent:</B> Tuesday, January 02,
2001 3:31 PM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> Table are
getting to large<BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV><SPAN class=410300420-02012001><FONT face=Arial size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=410300420-02012001><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=410300420-02012001><FONT face=Arial size=2>CC
Shivvers</FONT></SPAN></DIV>
<DIV><SPAN class=410300420-02012001><FONT face=Arial size=2>Hy-vee,
inc.</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C07511.E6EE4E48--