RE: Logging SQL statements

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