RE: QQRYDEGREE

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

Give it a try, see what happens.... If you find that the system is
allocating too many resources for queries and index rebuilds (two things
that SMP is great for) you can specify *IO for the system value and then use
the CHGQRYA command within the jobs you want to multithread, specifying the
number of tasks you want to allow. Here is an example of the command to use:

 CHGQRYA DEGREE(*NBRTASKS 2)  

 Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist 
AS/400e Professional System Administrator
NW Natural (Gas Services)
keg@xxxxxxxxxxxxx
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************


-----Original Message-----
From: Lyle_Hart@xxxxxxxxxxxxxxxxxx [mailto:Lyle_Hart@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, April 17, 2003 12:17 PM
To: midrange-l@xxxxxxxxxxxx
Subject: QQRYDEGREE


We are looking at changing the sysval QQRYDEGREE  to *OPTIMIZE .  We have
DB2 Symmetric Multiprocessing on one system.  We have multiple systems with
as many as 12 processors.

Seems to me I looked at this system value a couple of years ago and there
was a down side or it didn't help us because of the type of processing we
do.  I am drawing a blank, any help?

I looked in the archives, didn't find anything.

============================================================================
=========== 

 >   This message contains information which may be confidential and
privileged.  Unless you are the addressee (or authorized to receive for the
addressee), you may not use, copy or disclose to anyone the message or any
information contained in the message.  If you have received this message in
error, please advise the sender by reply email, and delete or destroy the
message.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.