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?
Asked: Last updated:
Related Questions
1

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.

_______________________________

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: 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.
  • Rajgoaj
    I believe jobs executed through RMTCMD will also execute in QUSRWRK subsystem.
    280 pointsBadges:
    report
  • ToddN2000
    These are started when a remote job access the database. You will see these from web services and other accessing the DB2 data remotely. They will sometime remain open in order to improve performance. It keeps this connection open in case it is needed again to prevent re-establishing the connection for every data request.
    132,840 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: