Run the jobs in a different Sub-System.  TFRJOB, or STRSBS QUERYSBS, and be sure it allocates the devices to be used.  Then tune the new sub ssystem as needed to prevent impact on production.
 
 
-----Original Message-----
From: John P. Walsh <john_walsh@icdc.com>
To: MIDRANGE-L@midrange. com <MIDRANGE-L@midrange.com>
Cc: Steve Augustin <saugusti@vansystems.com>; Stephan_H_Augustin@Vansystems. com <Stephan_H_Augustin@vansystems.com>; Sgt. John Walsh <sgt.walsh@icdc.com>
Date: Sunday, March 21, 1999 10:07 PM
Subject: Query Performance

Please advivse how to best minimize the performance degradation of interactive queries on QINTER .  V3R7 on my machine.  I intend to conduct a Query class this week and need to solve this issue if i can.  I have essential operations working 24/7 so there is no downtime to take advantage of.
 
 

GIF image


This thread ...


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

This mailing list archive is Copyright 1997-2019 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].