Re: Monitor table growth
Posted in 1998
In article <6a0osc$ctv@inferno.mpx.com.au>, "Information Systems,
Maroochy Shire Council" <mscinfosys@peg.apc.org> writes
>We are running Informix 5.03 on DGUX 4.11. We monitor the growth of our
>database by running tbcheck -pT.
>
>Does anybody know of a strategy or automated process/commands to track table
>growth and indicate, for example, if a certain table has suddenly increased
>in size?
>
Parse the output of tbcheck -pe?
Or try
select tabname,nrows from systables
and see if it changes. Of course you will need to do updte statistics
first..
>Thanks,
>
>Darren Fuller.
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care