RE: Logging SQL statements

["Luis Rodriguez" <luisrodriguez@xxxxxxxxxxx>]

Thanks for your answer.

I had forgotten about the STRDBMON command (Joe is not the only one
whose mind is entering in a "degraded" state? :-) )

In fact, I think that is the solution to my problem. Rob's answer (job
log) would have been ok. if my analysts used only 5250. As they have
access to iSeries Nav (although they don't use it yet) I?m sure that
STRDBMON will work fine (Rob: Thanks anyway!!).

STRDBMON is an easy and, of course, no cost solution.

Thanks again to all. Regards,

Luis Rodriguez


> ------------------------------
> message: 2 date: Fri, 09 Jun 2006 15:32:54 +0000 from:
> vhamberg@xxxxxxxxxxx subject: RE: Logging SQL statements
>
> He DID say easy!
>
> Actually STRDBMON and ENDDBMON are the way to go, but the resulting
> data file is a bear to work with. Lots of fields overloaded to mean
> different things based on different values in other fields - highly
> not normalized. There is a paper somewhere at www.iseries.ibm.com/db2
> that gives you lots of queries to help you.
>
> Centerfield Technology is perhaps the main resource for software
> that does this kind of thing - www.centerfieldtechnology.com - Elvis
> Budimlic there often has posts on this list. I used to work there,
> as well.
>
> You say you want to log it from emulation - emulation has nothing
> to do with SQL directly, so there would be no exit for it - there
> are exits for ODBC kinds of access where you could log some stuff,
> IIRC. Navigator uses JDBC, I think, so that would probably go
> through the exit.
>
> HTH Vern -------------- Original message -------------- From: "DeLong,
> Eric" <EDeLong@xxxxxxxxxxxxxxx>
>
> > STRDBMON?
> >
> > Eric DeLong Sally Beauty Company MIS-Project Manager (BSG) 940-297-
> > 2863 or ext. 1863
> >
> >
> >
> > -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-
> > bounces@xxxxxxxxxxxx]On Behalf Of Luis Rodriguez Sent: Friday, June
> > 09, 2006 8:38 AM To: Midrange Subject: Logging SQL statements
> >
> >
> > Hi,
> >
> > Is there any (easy!!) way to log SQL statements when they are
> > entered thru 5250 emul. and/or iSeries Navigator? An exit point,
> > perhaps?
> >
> > Thanks for your help,
> >
> > Luis Rodriguez
> > ----------------------------
> > Luis Rodriguez IBM Certified Systems Expert eServer i5 iSeries
> > Technical Solutions
----------------------------
Luis Rodriguez
IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions