Hello,
informix related user accounting isn't very easy, but one answer is
getting very close to be somewhat like a solution (thank you George
Guethlein):
originale question:
we've got a bunch of users who log in to an informix database
on a DEC Alpha 2100 via "odbc-driver" (MS-Access
Frontend!). Is there a way to do any accounting of logins. i.e.
to see how much users a connecting to the database during
the day?
answer(s):
try the Informix "onstat -u" command. The last line reports the
connections as follows :
"7 active, 128 total, 20 maximum concurrent"
This isn't exact, but gives a close approximation (especially if
you cycle your database daily).
one more answer just came in:
If logins are all you need, use "last" and count unique occurences
of login names. Or maybe you can use "acctcom -n progname".
didn't ried out this yet, but surely later!! (thank you)!
mit freundlichen Gruessen
Reimund Willig
------------------------------------------
e-mail: willig.reimund_at_gdr.de
tel: +49-5205-941747
fax: +49-5205-941725
** Schwer ist leicht was **
-----------------------------------------
Received on Mon Sep 21 1998 - 07:00:41 NZST