RE: Monitoring Sql statments.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thanks Chuck, But I was more interested in can you see the data inserted into the database by scanning the logical logs. More for the security aspect. We use an encryption datablade with our database and I want to see if the data written to the logs is in clear text or encrypted format. Thanks for your help, David Tamburin - -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Chuck Renaud Sent: Friday, June 18, 1999 4:59 PM To: david.tamburin@protegrity.com; informix-list@iiug.org Subject: Re: Monitoring Sql statments. Take a look at I-Spy. It'll capture SQL, but can impact performance. I believe it's intended more for DSS systems, but if you just need to do short-term analysis, it'll work fine. > 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/AwUBN28BQyEUeYIwgiQNEQK+OwCgticyQCf//JW+NrBXx2oV/60vCbcAoJze U/HCjNrQ6dFIzDEKu3L8K8Hq =nWd6 -----END PGP SIGNATURE-----