Re: CPU Percentage Flex, Lies, and Usage Measuring Tape

Neil,

In a message dated 97-07-30 09:28:58 EDT, you write:

I'll ask TS about the possibility of the *CALC option.

> Ahh - SQL - all bets are off !
>  I constantly see PTF's for query optimization.  It seems they make some
>  major changes with each release, then spend the next several months
>  issuing multiple PTF's to 'fine tune' the performance.
>  You may want to order the SF97320 / SF97370 'shopping list' PTF cover
>  letters and scan the downloaded file member for QUERY, SQL, OPTIMIZE
>  etc. to see if you can find PTF's that may relate.  I've found that
>  these type of PTF's don't necessarily appear on the next cum package -
>  there could be a long delay from release until that happens.

Don't I know it!  Under V3R1, we had stuff that was just plain WRONG that we
needed PTF's for (of course, we also had a problem with generating multiple
trigger records under 3.1 for a while -- not to mention several others).
 Just TRY getting help from IBM on SQLCBL!

>  Also, check sysval QQRYDEGREE, which I believe was introduced at the
>  same time as QQRYTIMLMT.

These were already addressed under V3R1, and are set correctly now.  I just
wish that I could get them to quit brushing off the SMP possibilities...

Thanks!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"Great moments in science:  Einstein discovers that time actually IS money."
-- Gary Larson, "Far Side" caption.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *