RE: Improving SQL Update perfomance

[vhamberg@xxxxxxxxxxx]

Right, and a pool that is not set to *CALC - best candidate is a private pool, not a shared pool.

Vern

 -------------- Original message ----------------------
From: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
> > SETOBJACC - have not heard it is a NOOP -
>
> It's not, I was smoking dope. :) I had a conversation w/a friend last
> night and we determined that what I was remembering is that SETOBJACC
> does not pin the object in memory, it simply pages it into memory at the
> time the command was run. If you want to emulate pinning it in memory
> then load it into a memory pool that doesn't have contention. Sorry for
> the confusion.
>
> -Walden
>
> -- 
> Walden H Leverich III
> Tech Software
> (516) 627-3800 x3051
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
> -- 
> 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/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.