|
If you have the SMP feature (5769SS1 Option 26 OS/400 - DB2 Symmetric Multiprocessing) installed one very effective way to limit how many CPU's a particular job uses is to utilize the CHGQRYA command... I'd recommend - CHGQRYA DEGREE(*NBRTASKS 2) This will limit the number of CPU this job can use to two... I was able to reduce the impact of jobs performing huge index rebuilds due to SQL file joins, from using 80% of the system to 25%. The job will run longer, but it doesn't impact the system nearly as much... Kenneth **************************************** Kenneth E. Graap IBM Certified Specialist AS/400 Professional Network Administrator NW Natural (Gas Services) keg@nwnatural.com Phone: 503-226-4211 x5537 FAX: 603-849-0591 **************************************** -----Original Message----- From: Matt Patee [mailto:mpatee@abm.com] Sent: Thursday, June 29, 2000 11:28 AM To: MIDRANGE-L@midrange.com Subject: Performance adjustment: +--- | 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 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.
midrange.com
