Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Program takes too long to run.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
akatekar

New User


Joined: 17 Oct 2006
Posts: 7
Location: India

PostPosted: Fri Oct 20, 2006 11:26 pm    Post subject: Program takes too long to run.
Reply with quote

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.
Back to top
View user's profile Send private message

MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Fri Oct 20, 2006 11:44 pm    Post subject: Re: Program takes too long to run.
Reply with quote

What do you mean by:
Quote:

But since, it is reading the file partially


Also:
- Do you have Buffers on VSAM file. If not add buffers.
- How big is this VSAM file, is it a single file or multiple files?

If file is one single huge file, consider spliting file by key and code a IO module which will read only particular file based on key. Divide and conquer.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Oct 21, 2006 12:43 am    Post subject:
Reply with quote

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).
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sat Oct 21, 2006 10:52 pm    Post subject: Re: Program takes too long to run.
Reply with quote

See what the manual says...
Back to top
View user's profile Send private message
akatekar

New User


Joined: 17 Oct 2006
Posts: 7
Location: India

PostPosted: Sun Oct 29, 2006 12:59 am    Post subject: Re: Program takes too long to run.
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us