AS/400 Query Job Log

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

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • deepu9321
    Yes, It is possible.
    3,695 pointsBadges:
    report
  • Lambros
    Hi, can you tell me please how?
    25 pointsBadges:
    report
  • CharlieBrowne
    Did you try PRTDFN(*YES) Is that what you are looking for? Or are you looking for something different?
    41,380 pointsBadges:
    report
  • Yorkshireman
    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.
    5,580 pointsBadges:
    report
  • Lambros
    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
    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.
    7,235 pointsBadges:
    report
  • TomLiotta
    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following