RE: How to optimize COPY *ADD

Fortunately, we have no problem with resources. The HW we have - is 840 with
24 cpu and a lot of RAM & Disk memory, 4V5 OS

So I'm trying muliple copy right now.

Thanks to everybody 
        and 
                have a nice weekend!

Dmitri Efimov
Banco Wiese Sudameris
Peru, End of the world



-----Mensaje original-----
De: Alexei Pytel [mailto:pytel@us.ibm.com]
Enviado el: Viernes, 27 de Julio de 2001 04:08 p.m.
Para: MIDRANGE-L@midrange.com
Asunto: RE: How to optimize COPY *ADD



When you run your copy process, observe CPU usage.
If you are close to 100%, I doubt that splitting it in parallel will give
you any benefit.
On the other hand, if you have more than one procesor on system, this is
certainly worth a try.
To have benefit from splitting some work to several parallel processes,
there should be underutilized system resources you hope to use better.

You may also want to look at 5722SS1 option 26 - DB2 Symmetric
Multiprocessing. It can process index update in parallel even for one job.
But again, to benefit from any sort of parallelism, you first need some
unused resourcs to spare.

    Alexei Pytel

"The better is the worst enemy of the good"

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---