Monitoring Sql statments.

Posted in 1999

David Tamburin — Sat, 19 Jun 1999 04:42:52 -0400 — source: Informix-list mailing list archive (1991-1998)

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello all, Is there a way to have all sql statements and data that are run against the database logged? I have tried to use onlog to see sql statments and data in the logs and cannot seem to get it to work. If someone could please explain how to use this, I would be most grateful. Thank you david.tamburin@protegrity.com -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.0.2 iQA/AwUBN2tYDCEUeYIwgiQNEQJZrACePbs1M6ALBEUq9SuwdSHS30Y+4BcAoMBg vCnmm6NVv1AtbHaCogXEuZ3C =yTJZ -----END PGP SIGNATURE-----

↪ replying to David Tamburin

Randy Reiter — Tue, 22 Jun 1999 15:51:07 -0400 — source: Informix-list mailing list archive (1991-1998)

Refer to the Zero Impact Sql and Service Level Monitor at www.sqlpower.com. The product line non-intrusively analyzes the SQL network packet flow to the database server for end-user SQL and service level performance monitoring. The product does NOT have to run on the database server, NOR on client workstations connected to the server. The products require NO intrusive database server agents, monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations. The products require NO impact upon the database servers, network or end-users. The products require no connections to the database server and end-users connect directly to the database server (not the monitor). Product installation is a three step process that can be completed in a few minutes. Scales to thousands or users! David Tamburin wrote in message <7ked0s$ic1$1@news.xmission.com>... > >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >Hello all, >Is there a way to have all sql statements and data that are run >against the database logged? >I have tried to use onlog to see sql statments and data in the logs >and cannot seem to get it >to work. If someone could please explain how to use this, I would be >most grateful. > >Thank you >david.tamburin@protegrity.com > >-----BEGIN PGP SIGNATURE----- >Version: PGP Personal Privacy 6.0.2 > >iQA/AwUBN2tYDCEUeYIwgiQNEQJZrACePbs1M6ALBEUq9SuwdSHS30Y+4BcAoMBg >vCnmm6NVv1AtbHaCogXEuZ3C >=yTJZ >-----END PGP SIGNATURE----- >