Home > IT Answers > AS/400 > AS/400 Query Job Log
Lambros
25 pts.
 AS/400 Query Job Log
AS/400 job logs, AS/400 Job Queue, 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

Software/Hardware used:
ASKED: June 21, 2011  1:02 PM
UPDATED: June 23, 2011  7:55 PM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  June 21, 2011  4:00 pm  by  CharlieBrowne   32,905 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,905 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Yes, It is possible.

deepu9321
 3,370 pts.
 

Hi, can you tell me please how?

Lambros
 25 pts.
 

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

CharlieBrowne
 32,905 pts.
 

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.

Yorkshireman
 5,505 pts.
 

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

Lambros
 25 pts.
 

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.

Splat
 5,670 pts.
 

to know what files a user used and if it is possible what criteria.

What tools are being used for the queries?

Tom

TomLiotta
 108,260 pts.