Performance issue in a process. Cant identify where

Madhusmita Patnaik · New User Joined: 18 Dec 2006 Posts: 14 Location: bangalore

hi

i am looking at a ongoing process where files are received from different LPARS to my lpar. here a run task is executed which in turn triggers many JCLs which run cobol db2 programs to insert the data into tables of database.

i am unable to find out where and which part of this process leads to the major part of performance.?

dick scherrer · Posted: Thu Mar 15, 2007 7:37 pm

Hello,

Depending on your specifics and the volume of data received from the other lpars, the inserts (if done individually) may be where you spend much time. Inserting a single row is expensive - especially it there are multiple alternate keys.

I'd suggest looking into loading a batch of rows, rather than individual inserts.

If your input is hundreds of millions of rows, it will take time regardless of how they are put into DB2.