RE: Performance adjustment:

["Graap, Ken" <keg@xxxxxxxxxxxxxxxxxx>]

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
+---