Running AS/400 query in Specific job queue

190 pts.
Tags:
AS/400
AS/400 jobs
AS/400 Query
Is there a way to restrict user(s) to submit their queries to a specific job queue instead of going into qbatch?


Software/Hardware used:
as400,query400
1

Answer Wiki

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

as per mu understanding jobq is taken from the jobd if externally not defined/given . so if you maintain the  jobd with respect to user profiles they all would get submitted in specified queue. 

Discuss This Question: 6  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.
  • Splat
    What job queue does their job description specify?
    12,885 pointsBadges:
    report
  • deepu9321
    Yes, Configure your JOBD with required JOBQ.

    You can remove access to QBATCH to restricted users.
    4,980 pointsBadges:
    report
  • ToddN2000
    AS mentioned, check the user profile for the correct JOBD. Then change that to the JOBQ you want them to be submitted to. Remember if you do change this EVERYTHING they submit will go to this JOBQ not just queries.
    132,840 pointsBadges:
    report
  • Msatbh
    I only want to submit all queries from all users to a specific jobq. Don't want to change the jobq in jobd, that will submit all the jobs to new jobq.
    190 pointsBadges:
    report
  • ToddN2000
    Check out the info here on the IBM site.

    Look for SA54605 in the doc...
    Then follow the instructions
    132,840 pointsBadges:
    report
  • Msatbh
    Thanks ToddN2000. This is what I was looking for.
    190 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.

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

Following

Share this item with your network: