AS/400 Query Job Log

Lambros

25 pts.

Tags:

AS/400 jobs

AS/400 Query

Dear all, Its my first time I submit a question so, please forgive me if I do something wrong. My question is if it possible to have a detail job log from a query. I mean if I can see what files I have used or what criteria I have used. Thank you Lambros

Asked: June 21, 2011 1:02 PM Last updated: June 23, 2011 7:55 PM

Answer Wiki

Last updated: June 21, 2011 4:00 PM GMT

CharlieBrowne62,340 pts.
History
Contributors
- Ordered by most recent
- CharlieBrowne62,340 pts.

Thanks. We'll let you know when a new response is added.

If you are using Query 400, you can get a full log if by specifying PRTDFN(*YES).
NOTE: this does not work if your output is *DISPLAY

Discuss This Question: 7 Replies

deepu9321 Jun 22, 2011 3:26 AM GMT

Yes, It is possible.

4,955 pointsBadges:

report
Lambros Jun 22, 2011 11:36 AM GMT

Hi, can you tell me please how?

25 pointsBadges:

report
CharlieBrowne Jun 22, 2011 12:44 AM GMT

Did you try PRTDFN(*YES) Is that what you are looking for? Or are you looking for something different?

62,340 pointsBadges:

report
Yorkshireman Jun 23, 2011 8:07 AM GMT

If you mean that you wish to inspect the run time performance then you need to read the manuals. There is a Query Optimiser which will attempt to improve the performace of queries by using existing acess paths where possible, and all sorts of other automagic. Go to IBM.com and the Information centre, download the PDF manual(s), check the redbooks site, and spend a couple opf hours making yourself the site guru on querie, whether you use the venerable Query./400 or newer query management queries. The information you get from the manuals is complete and accurate. The information you get here is based on users experiences. Both have their place, but you need the one in order to judge the other and arrive at a conclusion which is appropriate to your circumstance.

6,085 pointsBadges:

report
Lambros Jun 23, 2011 4:21 PM GMT

Dear all, Thank you very much for your answers but it seems that there is misunderstanding. What I want is if there is a way to do DSPJOBLOG or something similar and to know what files a user used and if it is possible what criteria. Thank you Lambros

25 pointsBadges:

report
Splat Jun 23, 2011 5:41 PM GMT

Lambros, the information you're looking for doesn't seem to be available via a job log. I just took a regular QUERY/400 query, set the logging level to 4 00 *SECLVL, then ran it in batch. The resulting job log showed nothing along the lines of what you're looking for. Nor did I find anything in the Work with Queries that looked as though it would generate the information you're asking for. As CharlieBrown noted, PRTDFN(*YES) will provide you what you want, but it does so by appending the query definition to the top of the output. If you're trying to monitor your users surreptitiously this could be a problem.

12,270 pointsBadges:

report
TomLiotta Jun 23, 2011 7:55 PM GMT

to know what files a user used and if it is possible what criteria. What tools are being used for the queries? Tom

125,585 pointsBadges:

report