Re: Improving SQL Update perfomance

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/