RE: Database server jobs and SQL tuning

Were all 4 jobs actually processing the request, can be seen by looking at
the job log.  My guess is that only 1 was actually processing your request.
These jobs are prestarted jobs and they have parameters such that when the
number available reaches a threshold value then they start a certain number
of new jobs.  It could be that your request caused the available threshold
to be reached and the number of new jobs to be started was set to 3, which I
believe is the default.  You can see these parameters in the subsystem
description under Prestart job entries.  You can sometimes help ODBC
performance by adjusting these parameters.


Scott Mildenberger

> -----Original Message-----
> From: Colin Williams [SMTP:colin.williams@technocrats.co.uk]
> Sent: Thursday, May 18, 2000 2:10 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Database server jobs and SQL tuning
> 
> I was running an ODBC request from Excel(Took the Data, Get External
> Data option and created a query). 
> 
> Looking in QSERVER it ran 4 QZDASOINIT jobs to process this request. Why
> so many?
> 
> 
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---