Session to database access
Nicole
Try the following select statement I find it more useful than
the onstat command
select sysdatabases.name database,
syssessions.username,
syssessions.hostname,
syslocks.owner sid from syslocks, sysdatabases, outer syssessions
where syslocks.tabname = "sysdatabases"
and syslocks.rowidlk = sysdatabases.rowid
and syslocks.owner = syssessions.sid
order by 1, 2;
Kevin Hayward
hayward_ke@leg.wa.gov
-----Original Message-----
From: Nicole Guffey [mailto:NGuffey@jdriscoll.com]
Posted At: Friday, November 20, 1998 2:44 PM
Posted To: informix
Conversation: matching sessions with databases
Subject: matching sessions with databases
Is there a utility, or a piece of code, that identifies
which
database (or even dbspace) a session is accessing?
Thank You,
Nicole Guffey
Nguffey@jdriscoll.com