Re: Improving SQL Update perfomance

Are there any logical files or SQL indexes based on these fields? You could set MAINT(*DLY) on all of them and on the physical file before doing the update, then change back to MAINT(*IMMED) - check what the values are first.

An even surer way to eliminate index updates is to remove all members of the LFs and delete the indexes and add the members back afterwards and recreate the indexes - not sure if you can remove members from indexes.

HTH
Vern

-------------- Original message ----------------------
From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>

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


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions



________________________________________________________________________________
____
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
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.