RE: Monitoring Sql statments.
Posted in 1999
Topics: Performance & Tuning, Security, Permissions & Auditing, Logging & Checkpoints
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-----------------