Re: Who has database open?

klfowler@fohnix.metronet.com (Ken Fowler) writes: >I have Informix-SE running on an HP-UX host with multiple PCs >TCPeering into the database. >How can I tell who has the database open? Is there an Informix >equivalent of "uptime -w"? >Thanks... Ken >-- >Ken Fowler, wa5bru | Real Klingons >klfowler@metronet.com | don't use .signature files. You should be able to run netstat -an and grep for the port assigned to your sqlexecd process. If you know the internet addresses of your pcs you can then determine which pcs have an established connection on that port. Unfortunately, this will not tell you the specific database the user has open. There is a unix command which I cannot remember the name of that will show you who has a specific file open - you may be able to use it for your needs as well. Jim Bentsen jbentsen@delphi.com