Re: QQRYDEGREE

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Most of the benefit of SMP applies to SQL & other query-ish activity. It 
appears it can be used for CPYFRMIMPF, as well. But not if you need RRNs to 
be the same in the copy.

Native I/O is not assisted much, if at all, IIRC. Please correct me if this 
is not the case.

A good reference is the Performance Mnagement Resource Library at 
<http://www-1.ibm.com/servers/eserver/iseries/perfmgmt/resource.htm>. Also, 
the iSeries DB2 page at <http://www-1.ibm.com/servers/eserver/iseries/db2/>

HTH

Vern

At 08:27 AM 4/18/2003 +0100, you wrote:
> Lyle,
>
> I always change this to *Optimize when I'm tuning clients - though so far
> none has had SMP. It allows parallel pre-fetch of data, and seems to work
> well.
>
> Clare
>
> Clare Holtham
> Director, Small Blue Ltd - Archiving for BPCS
> Web: www.smallblue.co.uk
> IBM Certified AS/400 Systems Professional
> E-Mail: Clare.Holtham@xxxxxxxxxxxxxx
> Mobile: +44 (0)7960 665958
> ----- Original Message -----
> From: <Lyle_Hart@xxxxxxxxxxxxxxxxxx>
> To: <midrange-l@xxxxxxxxxxxx>
> Sent: Thursday, April 17, 2003 8:16 PM
> 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.
> >
> >