Results 1 to 3 of 3

Thread: AS400 SQL Package and Performance

  1. #1

    AS400 SQL Package and Performance

    I have noticed that UBE's run back to back increase in speed. For instance, if I run the R9410 for 5 business units, it takes about 10 seconds. Immediate consecutive runs take about 5 seconds. If I wait a while to run it, it goes back to 10 seconds. I have seen the same behavior with our external reporting product. For instance, if a random report (written in ANSI-SQL for DB2) takes 2 minute the first time. Immediately re-running it will take let's say, 1 minute. Waiting a while and re-running it gets you back to 2 minutes.

    I'm much more familiar with the SQL optimizer as opposed to DB2, but shouldn't SQL packages on the AS/400 be storing the query path after the first run and making all subsequent runs quicker....no matter the time interval in between runs?

    Thanks

    Ryan Hunt

    E1 9.1.3
    WebLogic on Win2k8
    AS400 Enterprise Server (V7R1)
    Win2k8 Deployment Server

  2. #2
    Member Tom_Davidson's Avatar
    Join Date
    Nov 2000
    Location
    Wisconsin, USA
    Posts
    771

    Re: AS400 SQL Package and Performance

    Ryan,

    I can't tell for sure without running performance tools, but I'd bet that the better performance you are seeing has to do with the records you need already being in memory and thus you don't have to do the disk I/O each time.

    This is more likely to be true if you have a dedicated memory pool for batch, and a light batch load at the time.

    HTH.

    Tom Davidson
    Cleindori Consulting
    8.12/8.98.4.14, 9.1/9.1.5.3, 9.2/9.2.0.5/6
    IBM i, WebLogic on Windows, DBCS, Global installations.

  3. #3

    Re: AS400 SQL Package and Performance

    Tom, that makes perfect sense.

    Thanks!

    Ryan
    E1 9.1.3
    WebLogic on Win2k8
    AS400 Enterprise Server (V7R1)
    Win2k8 Deployment Server

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.