|
View previous topic :: View next topic
|
| Author |
Message |
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 |
|
| Back to top |
|
 |
MGIndaco
Active User
Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy
|
|
|
|
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 |
|
|
zatish
New User
Joined: 06 May 2005
Posts: 14
|
|
|
|
| Thanks for your response. |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
|
|
