• Subject: Re: QZDASOINIT and ODBC performance
  • From: Larry Bolhuis <lbolhui@xxxxxxx>
  • Date: Mon, 13 Sep 1999 11:52:10 -0400
  • Organization: Arbor Solutions, Inc

Dale,

 I have played with moving this job around with little ill effect. 
Two of my customers use this job very heavily.  We moved the jobs to
their own memory pool at a specific execution priority.  This allowed
the real users (green screens) to out prioritize them at the same time
as not fighting them for memory (this was the biggest problem as the
QZDASOINIT tasks would often swell to well over 10MB PAG size).  It
did slow the ODBC jobs a bit but allowed the rest of the system to run
more smoothly.  

 Eventually both customer went to server boxes and now everybody is
happy!

 - Larry

"Draper, Dale" wrote:
> 
> 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
> +---

-- 
Larry Bolhuis         | What do You want to Reload today?
Arbor Solutions, Inc  |
(616) 451-2500        | 
(616) 451-2571 -fax   | Two rules to success in life:
lbolhui@ibm.net       | 1. Never tell people everything you know.
+---
| 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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.