Re: The sysmaster tables

dmaxwell@netcomuk.co.uk wrote: :We have found some tables in the sysmaster database but can not find :documentation for them. : :For example, how could we trace from a record in sysuserthreads back :to the database being accessed by the user? Is this the best way to :find the databases being used by different users? : :Other selects on sysmaster tables appear to perform poorly. For :example 'select * from syslocks' takes 10 seconds to retrieve one row :on a very lightly loaded system . Can anything be done to improve :this or are we 'misusing' the tables? : :Our system is Online 7.12 on NT4.0. In addition to the other excellent explanations you should also be aware that ver. 7.12 is fairly old. You should definitely upgrade to a newer version. The performance will be much better and several defects have been fixed. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org