RE: Performance Monitoring

Posted in 1999

Bernstein, Rick — Tue, 19 Jan 1999 15:53:12 -0800 — source: Informix-list mailing list archive (1991-1998)

You can use something like the following to access another database: SELECT ... FROM sysmaster@<server-name>:syssessions WHERE ... If both databases reside on the same server, you can use SELECT ... FROM sysmaster:syssessions WHERE ... -----Original Message----- From: granta@nospam.student.canberra.edu.au [mailto:granta@nospam.student.canberra.edu.au] Sent: Tuesday, January 19, 1999 14:38 To: informix-list@iiug.org Subject: Re: Performance Monitoring On Tue, 19 Jan 1999 15:01:41 GMT, 4new@mindless.com wrote: >> Any ideas on how to achieve this ??? > >How about sysmaster database ? ;-) > >select * from syslocks >where owner in (select sid from syssessions > where username="user")> >For getting resource see sysseswts,syssesprof,syssessions,syslocks tables. > >Eugene Nechayev Do you know if I can query these tables while connected to another database in Informix. For instance, in Sybase and MS SQL Server, I can reference a table in another db using code like select * from dbname.objectowner.tablename Or do I have to connect to sysmaster to do it? Ciao Fuzzy ;-)