Re: Improving SQL Update perfomance

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

Eric,

Thanks for the link. 

Walden,
Thanks for your answer. Don't know about any particular
weed, but I don't remember anything about SETOBJACC being
deprecated. In fact, I worked as a consultant for a
customer who liked to use SETOBJACC for their ennding of
month processes. Thay had this iSeries with LOTS of memory
and if the pools we were only a little out of memory
everything went down the drain. 

Elvis, this is a small 520, but I'll check your idea for
the smaller files. Thanks.

Thanks to all,

Luis




--- midrange-l-request@xxxxxxxxxxxx wrote:

> ------------------------------
>
> message: 4
> date: Wed, 28 Nov 2007 16:31:37 -0600
> from: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
> subject: RE: Improving SQL Update perfomance
>
> I'd be surprised to hear that....  Perhaps you're
> thinking of Expert Cache, which manages storage pool
> paging (*CALC in the stoarge pool paging option)..... 
> Here's an article I found:
>
> http://www.itjungle.com/fhg/fhg121306-story03.html
>
> Eric
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> Walden H. Leverich
> Sent: Wednesday, November 28, 2007 4:15 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Improving SQL Update perfomance
>
>
> I recall hearing somewhere (from an IBMer?) that
> SETOBJACC is
> effectively a No-Op these days. That is to say, you can
> call it (so
> existing code doesn't go boom) but it doesn't do
> anything. IIRC, this
> was V5R2-ish time. 
>
> Then again, I could be smoking dope.
>
> -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.)
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Elvis Budimlic
> Sent: Wednesday, November 28, 2007 4:08 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Improving SQL Update perfomance
>
> If you have lots of main memory consider using SETOBJACC
> command to
> prebring
> the entire file into memory prior to running the UPDATE.
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence on IBM
> i5/OS and
> OS/400
> www.centerfieldtechnology.com
>  
> -----Original Message-----
>  Subject: Improving SQL Update perfomance
>
>  Hi list,
>  
>  What would be the best way to improve the performance of
>  a SQL Update statement executed with RUNSQLSTM?
>  
>  I need to run the following SQL for several tables:
>  
>  UPDATE LIBNAME/TABLE  SET
>  	Field1 = round(field1 / 1000, 2),
>  	Field2 = round(field2 / 1000, 2),
>          ...
>  	Fieldn = round(fieldn / 1000, 2);
>  
> Each one of these tables can have several thousands of
> records. One of them has 15 million of records, and the
> process is VERY slow.
>  
> Thanks in advance,
>  
> Luis
>
> -- 
> 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.


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


      ____________________________________________________________________________________
Be a better pen pal. 
Text or chat with friends inside Yahoo! Mail. See how.  http://overview.mail.yahoo.com/