× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



LOL, what could be easier than eight little letters?  <g>  I agree that the 
output is difficult, but I usually run it through Visual Explain to help break 
it down....

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
vhamberg@xxxxxxxxxxx
Sent: Friday, June 09, 2006 10:33 AM
To: Midrange Systems Technical Discussion
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 

-- 
http://www.fastmail.fm - Choose from over 50 domains or use your own 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 



-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.