Setting run priority on prestart jobs

60 pts.
Tags:
AS/400 jobs
AS/400 performance
ODBC
We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application's queries can have a higher priority than another application's queries? Since each application's queries always use the same user ID, can we set the run priority for a user ID in a prestart job?

Answer Wiki

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

I believe the run priority and time slice are defaulted by the job “class”. So, do a WRKSBSD on the subsystem these jobs run in, use the option to display the prestart jobs and find the class. Then take a look at the class (WRKCLS) to see how it is defined. Personally, I would not modifiy an IBM supplied class – but you could create a new one. Did you mean QZDASOINIT? It uses class QPWFSERVER, which already runs Priority 20 and a timeslice of 3000.

You don’t really want to run lower than 20…

Of course, my gut feeling is don’t muck around with the settings – but take a look at the queries. There may be some way to make your queries more efficient.

Regards
Mike

Your information about the class controlling the run priority is correct, but our problem is that we want to be able to run QZDASOINIT at different priorities, depending on the application that is submitting the query, and there is no way to dynamically change the class (and the run priority) that I can see.

One thought I had was to create additional prestart jobs by cloning QZDASOINT and using different classes with different run priorities, but how do I get ODBC to use these new prestart jobs?

Regards
Gary

Discuss This Question: 2  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
  • mcl
    You might be able to find some answers in this article. Other than that I'm not sure what you can do. Regards Mike
    2,740 pointsBadges:
    report
  • GaryF
    Mike, The article you cited was exactly what we were looking for. I had to create a new subsystem to segregate the queries where we wanted to change the run priority, but that is easy to do. Thanks for your help, GaryF
    60 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