Re: Unix SVR4 Accounting

BGarrett1 wrote: > > I need an accounting system to keep track of transactions, I/O, etc. for > bill-back purposes to work on Unix System V Release 4. Especially if it > can keep track of "Informix" I/O's going against raw space (I know, I'm > dreaming). Anyway, I'm open to anything anyone has to say about a daily, > weekly, monthly tracking system which will report downtime, computer hogs, > etc. -- AND how it has worked in your organization. > Thanks!! > Barbara Garrett > Sarasota County > BGarrett1@aol You may want to look into the Informix SMI tables that keep track of much of what you are looking for. We have set up a system that uses the SYSSESPROF table to keep track of user activity in an online database. The problem with this table is that when a user disconnects from the database server, his SYSSESPROF data disappears. We have solved this by creating another table to log this info. When the user enters an application, a log record is created. A cron job runs at regular intervals that updates the log records. Write for more... Best regards, -- ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html