RE: Monitoring Sql statments.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I tried using onlog on an unencrypted column and still could not find any text data in the log. I of course may be using onlog completely wrong and any help in this area would be apreciated. Thanks David Tamburin david.tamburin@protegrity.com - -----Original Message----- From: Mark Collins [mailto:mcollins@us.dhl.com] Sent: Monday, June 21, 1999 3:30 PM To: david.tamburin@protegrity.com; informix-list@iiug.org Subject: RE: Monitoring Sql statments. So, have you tried onlog to look at the contents of the log directly? Or is that utility not available in 9.x? Mark Collins mcollins@us.dhl.com - ------------------------ From: David Tamburin <david.tamburin@protegrity.com> Subject: RE: Monitoring Sql statments. Date: Mon, 21 Jun 1999 23:21:39 -0400 To: crenaud@informix.com, informix-list@iiug.org > -----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----- > - ---------------End of Original Message----------------- -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.0.2 iQA/AwUBN281jSEUeYIwgiQNEQKpJwCg5Cah7VND6Szr0XqNlr84cTJnTJ4AoJ7L /bPZcXsAPyW8rO/a9ZjtUuRD =jYBb -----END PGP SIGNATURE-----