Re: How do I find out which users are connected to a database

Sean Wong wrote: > I wrote couple of scripts which will work togather and terminate all = > sessions which has locked the Informix instance on the environment. As = > I have mentioned above, I don't need to check who has locked which = > database. I also have some scripts which work out the users and process IDS connected to the informix instance, and also I can find the tables and databases actually locked by associating the tblsnum from tbstat -k with a select of hex(partnum) from systables in each database. What I CANNOT do is find a reference to the HDR+S locks with a tblsnum of 1000002 and a rowid within the tbstat -k output. These seem to be the database connections. Does anyone know whther this info can be determined using dbaccess, ESQL/C prog etc. Thanks again in anticipation. John Clutterbuck