Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6968
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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us