Re: Who is logged in?

Joe Trubisz wrote: > > Hi... > > I'm a newbie to Informix and have a question. I want to do a > dbexport, but I'm told I can't because someone is logged in > when I want to do it. > > Is there a way to find out who is currently logged into the > database? First, it's best if you mention the specific products that are relevant to the question, in order that you get the best answer. For example, if you are using Informix Online/Turbo versions through 5.x, you can use the tbstat -u command. Informix Online versions later, through the most current versions use the onstat -u command. The Informix Standard Engine does not come with either of these commands. However, you might be able to derive your answer in another way. For example, if you are using Unix, you could: ps -ef | grep sqlexec assuming there is only one database in use on that machine. Other alternatives may be available. Tim