I have a job which extracts the data from the iSeries into physical files and sends the files to the DW server using FTP. The extraction is done using the SQL rpgle program.
The job runs for almost 6 to 7 hours everyday due to the size of the data. From the log, could see that the FTP process is taking more time resulting the job to run for a longer time.
Request all of you to provide me suggestion to increase the performance of this job,
thanks everyone in advance!
Cheers,
Vinoth
The job runs for almost 6 to 7 hours everyday due to the size of the data. From the log, could see that the FTP process is taking more time resulting the job to run for a longer time.
Request all of you to provide me suggestion to increase the performance of this job,
thanks everyone in advance!
Cheers,
Vinoth
Comment