left outer join cind2 p
where substr(C.name,1,1) between ' ' and 'A'
The unload is done using DSNTIAUL with IKJEFT01.
This job is running for a long time and using excessive CPU and DB2 resource.Can you help me optimise the job?
I can change the job to any other improved utility suggested for unloading these 3 huge join tables.
Yes..this job runs for 5-6hrs to complete.Moreover after running for 4 hours it abends with -904(resource unavailable) and when restarted completes successfully.This process then takes 10hrs to complete.