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.