Informix DBA Survival Guide, Second Edition

A Practical Example: Who is Using What Database

Let's begin with a very practical example of the sysmaster database's value. My interest in this database started a couple of years ago, while consulting on a project for a development group where I needed to know who had a database open and which workstation they were using to connect to the database. This was a development environment and there were continual changes to the database schemas. In order to make updates to the database schema, I would have to get the developers to disconnect from the database. The "onstat -u" utility would tell me which users were connected to the server, but not what database and what workstation they were using. Onstat -g ses told me the user and workstation, but ...