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.?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.