Re: SMI query for onstat - g opn (open tables)

Jeff Larsen wrote in message <35c9d33b.9018097@news.usinternet.com>... >I'm trying to write an SMI query similar to >"onstat - g opn" which shows open tables for >each user thread. But, I want to see the >username, database name, and tablename instead >of thread ID and table partnumber in hex!!! > >I can't seem to track down the columns that I >need in the SMI tables to do this. I can link >the thread ID, session ID, and username easily >enough, but where are the open tables coming from? > >Thanks in advance, > >Jeff Larsen On the IIUG web site http://www.iiug.org in the software repository, there is a program called lockrep that George Jayakumar has written. It is an awk/ksh script that prints out a list of tables that a particular user has locked, It contains some functions and a routine to convert the hex numbers. I use his name only to give him credit for the script, I do not know him, but I downloaded the script, and it has saved me countless hours of work. Thanks George! Clint G. Kunz DBA: Utah State Courts