What is a QZDASOINIT job? What is its significance?

1005 pts.
Tags:
AS/400 administration
AS/400 jobs
QZDASOINIT
What is a QZDASOINIT job? What is its significance? Do they run under only QSERVER subsystems?

Answer Wiki

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

QZDASOINIT is the jobname for the database SQL server jobs on the System i. These jobs are used to serve SQL to JDBC and ODBC client applications. The jobs run the default QUSRWRK subsystem. iSeries Nav jobs also use this job name when running a query through the SQL window in Operations Navigator.

_______________________________

http://itknowledgeexchange.techtarget.com/itanswers/deleting-pj-qzdasoinit-jobs-after-inactivity/

Hi,

Another thing you need to know about these QZDASOINIT jobs, is that they can slow down your system when there are too much of them active, especially when running batch processing, if for example you notice a difference between similar batch processes where one day the process will run for four hours and then all of a sudden the same process will take up to the double amount of time, there is where you want to get rid of these jobs.

Regards,
Roy

Discuss This Question: 1  Reply

 
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
  • Rajgoaj
    I believe jobs executed through RMTCMD will also execute in QUSRWRK subsystem.
    280 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