There is no problem in the COBOL program. I am looking for performance improvement. currently COBOL programs takes 24 CPU time. if i change that to handle with in DB2, will it improve the performance and save CPU time?
Can you just post the DB2 quires and let us know how many row are getting deleted on daily basis.
One of the suggestion is that u can schedule the job on weekly of monthly basis. This wont affect the system much. We too have such jobs in our system we trigger them of month basis.