RE: QZDASOINIT and ODBC performance

["Allen, Stuart" <sallen@xxxxxxxxxxxx>]

Change the QPWFSERVER class to have a lower priority - it defaults to 20.
We set ours at 50 - yeah the odbc queries take longer but it doesn't kill
the system!

Regards,

Stuart


> -----Original Message-----
> From: Draper, Dale [SMTP:dale.draper@seu.sega.com]
> Sent: Monday, September 13, 1999 2:41 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      QZDASOINIT and ODBC performance
> 
> We have developed a very nice Access DB interface for our Execs and
> Salesmen
> (god forbid they have to use green screen) which uses ODBC to link to
> files
> on our 400. I have noticed some perfomance issues related to this in the
> *interact pool. The ODBC job uses job QZDASOINIT to run, under the QSERVER
> subsystem.
> Would changing the QZDASOINIT to a batch job have any unforseen
> consequences? As far as I can tell this job controls ODBC and file
> transfer
> only.
> 
> 
> Dale Draper
> Sega Enterprises, Inc. (USA)
> Dale.Draper@seu.sega.com
> 
> 
> 
> > -----Original Message-----
> > From:       Don [SMTP:dr2@cssas400.com]
> > Sent:       Sunday, September 12, 1999 8:40 PM
> > To: midrange-l@midrange.com
> > Subject:    EVENTS listserver....
> > 
> > 
> > Greetings all...
> > 
> > This is to introduce the debut of the EVENTS@MIDRANGE.COM listserver.
> > This will be a moderated listserver for use of the general midrange
> > community to announce events of general relevance to the world.
> > 
> > This list is open to all Local User Groups, Common, industy, IBM and any
> > other groups that has a midrange related event that they wish to
> announce.
> > 
> > 
> > However, to recieve the announcements, one must obviousely be SUBSCRIBED
> > to events@midrange.com.
> > 
> > Please allow 24-36 hours for your event to be posted.  My
> > personal resources are becoming paper thin to the point that I'm
> > regretfully having to let a few slide, but I feel this is important
> enough
> > to get rolling...
> > 
> > Users can sign up by going to www.midrange.com and taking the selection
> > button to signup.  This option will be on the web page shortly, so look
> > for it.  
> > 
> > People wishing to spam or harvest email addresses from this list will be
> > stomped on as hard as they are on the midrange-l, etc...sans question or
> > apology....
> > 
> > Also, let me take the opportunity to remind you of the www.events400.com
> > web page.  Between this web page and listserver, the industry now has
> the
> > resources to make its events known...
> > 
> > Folks, these are resources for you to use.  Make the best use of them.
> > 
> > BTW, spam is not allowed....:)  No appologies...:)
> > 
> > Don Rima, events@midrange.com list moderator and sleep deprived Packer's
> > fan...
> > 
> > +---
> > | 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
> > +---
> +---
> | 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
> +---
+---
| 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
+---