Re: Informix Online 5.x database identity

June Tong wrote:- > 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. > Perhaps I can help June out on this one. The row id in tblsnum 1000002 is the entry in the OnLine pseudo table which keeps track of databases. If no databases have been deleted they should be in the order of creation, else you need to know many more specific details. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc