RE: QqryDegree system value

In 1996 I was one of the authors of redbook "Database Parallelism on the
AS/400, SG24-4826-00",
available here: http://www.redbooks.ibm.com/abstracts/sg244826.html

It has a chapter on database SMP support and what it can do for you
(including performance measurements).
There were multiple enhancements since that time, but most of it is valid.
You might want to have a look.

    Alexei Pytel

"If on a tiger's cage you see a sign - 'Buffalo' - do not believe your
eyes"
Classical Russian aphorism.



"Marion, Bob" <Bob.Marion@ps.net> on 07/12/2000 08:23:01 AM

Please respond to MIDRANGE-L@midrange.com

To:   "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
cc:
Subject:  RE: QqryDegree system value




Has anyone on this list benchmarked the improved proformance using SMP.  If
so how much did it improve performance?


Bob Marion
Phone:  972/461-3186
Fax:  972/461-3010
EMail:  bob.marion@ps.net


-----Original Message-----
From: Al Barsa, Jr. [mailto:barsa2@ibm.net]
Sent: Wednesday, July 05, 2000 12:47 PM
To: MIDRANGE-L@midrange.com
Subject: Re: QqryDegree system value


At 12:46 PM 07/05/2000 -0400, you wrote:

You need an n-way system (which you have), and option 26 of OS/400 which is
an optional, billable feature.

IMHO, anyone with an n-way system should purchase this feature.  Retail
price is $15,000.

Al



>I have read just about everything I can get my hands on and cannot grasp
>the right answer.
>
>In order for you to be able to utilize this system value, or in CHGQRYA,
do
>you NEED to
>have SMP installed on the system?
>
>My take is that if you don't have SMP installed then setting this value to
>*optimize cannot hurt.
>I am dealing with a 4 way 730.
>
>Bryan Dietz
>
>
>
>+---
>| 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
>+---



+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.
400 > 390

Phone:         914-251-1234
Fax:      914-251-9406
http://www.barsaconsulting.com
http://www.taatool.com

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

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



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