Program takes too long to run.

akatekar · New User Joined: 17 Oct 2006 Posts: 7 Location: India

Hello All,
I have a program where it is reading a VSAM file to fetch one information for every record fetched from a DB2 table (if the record keys match). But since, it is reading the file partially it takes hell of a time to complete the program. (the number of records is huge). Earlier before this read logic for VSAM file was introduced, the program was completed in 2 mins !!!!
Got to read somewhere, the VIO option might help. I am not sure, what is this and how it can help me here to reduce the time from 2 hrs to 5 mins.

The program run frequently in a business day.

Please help, as its affecting DB2 performance too...to some extent (by holding up some tables).

Thanks in advance.
Amit.

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

What do you mean by:

dbzTHEdinosauer · Posted: Sat Oct 21, 2006 12:43 am

Splitting the VSAM file into parts will only provide you with relief if you:

DECLARE your CURSOR based on the Low-Hi key of the VSAM
run multiple jobs (one job for each VSAM) simultaneously

you mentioned than the run time was only a few minutes before introduction of the VSAM read logic. What was going on before?

Are you updating the VSAM or DB2? or just generating a third file (spool)?

you have not provided enough info in order to receive any good advice except MFRASHEED's suggestion (plus multiple jobs).

priyesh.agrawal · Posted: Sat Oct 21, 2006 10:52 pm

See what the manual says...

akatekar · New User Joined: 17 Oct 2006 Posts: 7 Location: India

Thanks for ur replies everybody. But my question was regarding VIO option, i would like to know more of that VIO stuff. Priyesh will look into the manual. Thanks for the link.