ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to increase the performance of the AS400 Job !!!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to increase the performance of the AS400 Job !!!

    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

  • #2
    Re: How to increase the performance of the AS400 Job !!!

    You might want to post some code to get closer to a viable suggestion.

    Comment


    • #3
      Re: How to increase the performance of the AS400 Job !!!

      I would take your sql and paste it into strsql, start the debugger first, run it, then look at the job log. Create the indexes that it suggests. Sign off and run again. If it ran faster then....

      Now for the ftp, if you have control over the destination (ie you can run a batch file) I would send smaller files at a time instead of one large one. In theory this should not matter, but it does.

      lastly, see if there is data that you can just not send. If this process has been running for years there might have been mods and you are left with sending extra junk characters.
      Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

      Comment


      • #4
        Re: How to increase the performance of the AS400 Job !!!

        Thanks for your suggestions!

        I have further digged into the Job and have identified, that the FTP process to the remote server is taking much time causing the Job to run for a longer time then usual.

        The transfer rate of the data has gone very low, causing this problem. I have asked some network specialist to see any communication problem between the servers to solve this issue.

        Cheers,
        Vinoth

        Comment

        Working...
        X