Re: Shared pool vs Private Pool for SQL -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Re: Shared pool vs Private Pool for SQL
From: DrFranken <midrange@xxxxxxxxxxxx>
Date: Thu, 8 Dec 2016 23:20:00 -0500
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

I do not think there were PTFs but it is a customer's machine, so...

Auto tune is certainly off here. Customer is 100 against it. Ever. As you note it often does cause a lot of wasted time in the optimizer.

- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 12/8/2016 11:07 PM, Rob Berendt wrote:

Depends on your definition of "bring it back up". An IPL might have
applied some ptfs you had loaded on "for later". On rare occasions there
are immediate PTF's which may have some steps you need to run if you don't
want to IPL. Often they're about as drastic as"just end TCP/IP and start
it again". You've done at least that.

Sometimes the slightest thing will throw off the whole query optimizer.
Hence the reason many people do not use auto tuning, since every retune
means that your query needs to be reoptimized.

IBM answer: Just build the freaking indices.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Shared pool vs Private Pool for SQL , Rob Berendt

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.