RE: QqryDegree system value

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

This particular diamond can turn to coal if you aren't careful.

This product has value to you if you CANNOT prevent queries from arriving
for which you cannot build an index.  Two legitimate reasons for CANNOT are:
it would destroy some application functionality that is worth the cost and
the tables must be scanned and they are large.

SMP Query can kill a system if not carefully tuned.

Richard Jackson
mailto:richardjackson@richardjackson.net
www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Marion, Bob
Sent: Wednesday, July 12, 2000 7:23 AM
To: 'MIDRANGE-L@midrange.com'
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
+---