Improve runtime of DB2 job

zatish · New User Joined: 06 May 2005 Posts: 14

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

MGIndaco · Posted: Mon Jul 04, 2005 9:30 pm Post subject:

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.

zatish · New User Joined: 06 May 2005 Posts: 14

Thanks for your response.

zatish · New User Joined: 06 May 2005 Posts: 14

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