Re: The sysmaster tables

Jon, Good questions. I did a presentation at the user conference on using the sysmaster database. An articule on the talks and some example scipts are on my web site at www.advancedatatools.com. > We have found some tables in the sysmaster database but can not find > documentation for them. The best documentation is to look at the script that builds the tables located in $INFORMIXDIR/etc/sysmaster.sql > 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? One of the scripts I use is dbwho, which shows who is using which database. > 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. > > Thanks in advance ! > > Jon Doe > jo.doe@wxs.nl Regards - Lester ############################################################################# # Lester Knutsen lester@advancedatatools.com # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: www.advancedatatools.com # # Washington Area Informix User Group: www.iiug.org/~waiug/ # #############################################################################