Please help!!!

Posted in 1999

Krupa Shankar — Wed, 24 Mar 1999 08:51:27 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi All, I need the following information about the users who have logged into informix : 1. User name 2. Time logged in 3. Time when looged out. 4. Databases used Should the DBA enable the accounting facility for informix to trap all these details. If it is required, how can we enable this? Is there any SQL for this? Thanks, __Krupa

↪ replying to Krupa Shankar

Randy Reiter — 24 Mar 1999 14:45:36 GMT — source: Informix-list mailing list archive (1991-1998)

Refer to the Sql Power SniFFFer at www.sqlpower.com. The Sql Power SniFFFer product line non-intrusively reverse engineers the SQL network packet flow to the database server for SQL transaction performance monitoring. The product does NOT have to run on the database server, NOR on any client workstations connected to the database server. The Sql Power SniFFFer products require NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations. The Sql Power SniFFFer products have NO impact upon the database servers, network or end-users. The Sql Power SniFFFer requires NO installation of middleware, ODBC, Informix client connectivity software and MINIMAL on going DBA support. Product installation is a three step process that can be completed in a few minutes. The 'Sql Power SniFFFer' captures, analyzes and monitors the performance of all SQL transactions to the database server. The product monitors at the SQL transaction level elapsed time, data base server run time, network send and receive time, rows returned, and SQL transaction errors -- by individual user or group of users. Real-time alerts by SQL transaction may be setup. The SQL transaction flow to a database server can be reconstructed from any time period. For high volume (1000+ transactions/second) production, datamart, WWW, test or development database server environments. Sql Power Tools 201.825.9511 info@sqlpower.com www.sqlpower.com Krupa Shankar wrote in message <7das3f$c06$1@news.xmission.com>... > >Hi All, > >I need the following information about the users who have logged into >informix : >1. User name >2. Time logged in >3. Time when looged out. >4. Databases used > >Should the DBA enable the accounting facility for informix to trap all >these details. If it is required, how can we enable this? Is there any >SQL for this? > >Thanks, >__Krupa >