RE: sysmaster slow

Floyd Logical Log location will also have some bearing, as will the default location of any databases. Keith -> -----Original Message----- -> From: Neil Truby [mailto:neil.truby@ardenta.com] -> Sent: Friday, January 21, 2005 7:37 AM -> To: informix-list@iiug.org -> Subject: Re: sysmaster slow -> -> -> -> "Floyd Wellershaus" <fwellers@yahoo.com> wrote in message -> news:1106269813.b17fb35d3b6cac456eec0d6b608d49c8@teranews... -> > -> > --0-1676693089-1106265736=:84859 -> > Content-Type: text/plain; charset=us-ascii -> > -> > Can anyone tell me why my rootdbs is being hit so hard ? -> > Below is a partial output, sorted by io, of an onstat -g iof. -> > -> > When I try and query tables in sysmaster, it takes forever, and am -> > wondering if the heavily used rootdbs has something to do -> with it. Is -> > there a way of finding out what is going on in that rootdbs ? -> -> Please don't post MIME. -> Where is your physical log placed, and do you have separate -> temp dbspaces? -> oncheck -pe will show you the contents of each dbspace: -> running this at slow -> time may give some clues. -> -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list