Re: How to determine number of users/sessions?

Bob Gorman wrote: > > How can I query the Informix Dynamic Server inorder to determine the > number of users/sessions connected to a particular database environment? Use 'onstat -g ses' or 'onstat -u' to just look at connected sessions. To see who is connected to what database use 'onstat -g sql' but beware! On a busy server with more than a few dozen users this command may hang forever because the sysmaster tables that it queries are changing so fast the onstat will chase the tail of the table until the end of time. Less of a problem on a single CPU machine more so on SMP or Numa machines. Art S. Kagel