Re: QQRYDEGREE

["Al Barsa" <barsa@xxxxxxxxxxxxxxxxxxx>]

QQRYDEGREE applies to any access path building activity,  including LF's,
OPNQRYF's S/38 Query and OS/400 query.

Al - in Florida for Easter

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com





                                                                                
                                                               
                      Vern Hamberg                                              
                                                               
                      <vhamberg@xxxxxxxxxxxxxxx        To:       Midrange 
Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>               
                      nology.com>                      cc:                      
                                                               
                      Sent by:                         Subject:  Re: QQRYDEGREE 
                                                               
                      midrange-l-bounces@xxxxxx                                 
                                                               
                      ge.com                                                    
                                                               
                                                                                
                                                               
                                                                                
                                                               
                      04/18/2003 10:00 AM                                       
                                                               
                      Please respond to                                         
                                                               
                      Midrange Systems                                          
                                                               
                      Technical Discussion                                      
                                                               
                                                                                
                                                               
                                                                                
                                                               




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


_______________________________________________
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.