Re: Finding busy tables
You can fragment your tables in Informix-SE and then watch
their activity using the sar command in unix.
Regards,
Mario Estrada
-----------------------------Reply Separator-----------------
-----Original Message-----
From: Marco Greco <marco@informix.com>
To: informix-list@iiug.org <informix-list@iiug.org>
Date: Domingo 20 de Septiembre de 1998 05:07 PM
Subject: Re: Finding busy tables
>Can't do with SE. Online 4.x, I wouldn't know. What do I know is that on
OL5
>you can have a sort of sysmaster database: to create it, just pass
makeps.sql
>(it's in $INFORMIXDIR/etc) thru dbaccess.
>
>Ciao,
>Marco
>___________________________________________________________________________
___
>Marco Greco <marco@informix.com> Standard disclaimers
apply!
>
>Informix faq
http://www.iiug.org/techinfo/faq/informix.htm
>4glworks
http://www.ctonline.it/~marcog
>Informix on Linux
http://www.ctonline.it/~marcog/ifmxlinux.htm
>
>WF Software wrote:
>>
>> Finding the busy tables on sysmaster based systems is straightforward but
>> how do you do it on the early engines, in particular 4 and Turbo, and SE?
>>
>> If it a RTFM just tell me where to look:-)
>>
>> Paul Watson # I don't suffer from
>> WF Software Ltd. # stress, I'm just
>> Tel. (+44) 1436 674729 # a carrier
>> Fax. (+44) 1436 678693 #
>> www.wfsoftware.co.uk
>