Re: Informix Online 5.x database identity

Tomasz Frydryk (tomekf@sylaba.poznan.pl) wrote: : How can I determine on Informix 5.x OnLine users using an appropriate database (if many) ? : Which database is currently using by an user? Each database which is opened by a user will show up as a lock held by that user in the tbstat -k output. It will show up as something like: Locks address wtlist owner lklist type tblsnum rowid size 8146ebe8 0 814652f4 0 HDR+S 1000002 202 0 The tblsnum will always be 1000002; the rowid determines the database. Off the top of my head, I don't know an easy way to tell which database is which; I think the easiest way is for you to just connect to each database in turn, and see what shows up in the tbstat -k output. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.