MVSFORUMS.com

tattva · Beginner Joined: 02 Feb 2005 Posts: 97 Topics: 36

Hi all,
we are running a Cobol program which is currently picking up the num of shares( primary KEY) from DB2 table and comparing it with the num of shares coming from file( file is sorted out on num of shares). If both match then price of share from db2 is written out to output file along with other fields from flat file.

Now my question:-

Can we achieve this just by using any 3rd party tool (SYNCSORT/INSYNC/ICETOOL)?

If Yes, Can any one please let me know how to go about achieving this?

Thanks,
Tattva

kolusu · Posted: Tue Nov 08, 2005 5:56 am Post subject:

tattva · Beginner Joined: 02 Feb 2005 Posts: 97 Topics: 36

Hi Kolusu,

that was the initail requirement. The file has millions of records and the Cycle time is more than 3 hrs. wanted to know if by using any 3rd party tools, we can reduce the cycle/CPU time .

Any help in this regard will be appreciated.

Thanks,
Kolusu

kolusu · Posted: Wed Nov 09, 2005 9:22 am Post subject:

tattva,

cycle time of 3 hours ? I don't think the pgm should take that much cycle time to complete with the requirements you have specified. Unless you are doing something complex , the requirement seems pretty simple.

Did you run an explain on your sql statement?

Are you taking any checkpoints in between the selects ?

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

tattva · Beginner Joined: 02 Feb 2005 Posts: 97 Topics: 36

Kolusu,

Could you please provid some documentation on explain.

Thanks,
Tattva

kolusu · Posted: Thu May 03, 2007 12:48 pm Post subject:

tattva,

Wow ! Close to 2 years and you still working on this ?

tattva · Beginner Joined: 02 Feb 2005 Posts: 97 Topics: 36

Kolusu,

Just that there is one more similar program which I need to look into.

Guess what we ( developer ) always need to do all the dirty work Crying or Very sad

One more question we have SQL explorer at our shop.. any documentation onthat ??

This thing sucks... Exclamation