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
 

 

Improve runtime of DB2 job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
zatish

New User


Joined: 06 May 2005
Posts: 14

PostPosted: Mon Jul 04, 2005 2:39 pm    Post subject: Improve runtime of DB2 job
Reply with quote

Pls let me know if there are ways to improve the processing time of a DB2 job which runs for long time, more than 3 hours!

Anything to do with Commit!

Appreciate your valuble response.
Thks
Back to top
View user's profile Send private message

MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Mon Jul 04, 2005 9:30 pm    Post subject:
Reply with quote

If you use a Cobol Program:
Try with a reorg or check with a trace which is the big operation that spend so many time and after you will see the answer to your problem. Probably with a correct index your program will run faster.

If your problem happens in qmf TP or Batch check the correct use of join and filters.
Back to top
View user's profile Send private message
zatish

New User


Joined: 06 May 2005
Posts: 14

PostPosted: Mon Jul 04, 2005 10:44 pm    Post subject: Re: Improve runtime of DB2 job
Reply with quote

Thanks for your response.
Back to top
View user's profile Send private message
zatish

New User


Joined: 06 May 2005
Posts: 14

PostPosted: Mon Jul 04, 2005 10:47 pm    Post subject:
Reply with quote

hi,
My program is a batch program and it uses 4 tables to update/insert and select.
Does commit count or modification of Jcl's will effect the run time.
Appreciate your feedback.
Thks
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts Create runtime members (DB2 related) ... Manshadi IBM Tools 1 Sat Jan 10, 2015 9:27 pm
No new posts Deleting the catalog files automatica... Suresh S JCL & VSAM 6 Wed Apr 16, 2014 7:05 am
No new posts Allocation of files at runtime Akatsukami COBOL Programming 1 Tue Aug 14, 2012 9:03 pm
No new posts Trace the dynamic calls at runtime of... Mike 1304 COBOL Programming 20 Sat Jan 14, 2012 2:21 pm


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