ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

pc, as400, sw in Omnis

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

  • pc, as400, sw in Omnis

    We have a net with as400 and several pc.

    We have installed in the client pc (with windows 2000 or XP )
    a program write in Omnis language where AS400 works as database server.

    The performance of this software are very slow.

    The supplier of this program says that AS400 is not tuned.

    How can I tune As400?. Are there a web site where I can learn how tune AS400?

    Anyone have a idea or know a program that can monitor the perfomance of AS400 with odbc?

  • #2
    Re: pc, as400, sw in Omnis

    Hi....
    Try this website, Hope it will help you
    Find answers to Performance Tuning 9406 720 206A running V5R3M0 - Ran fine on V5R1M0 but when scratch installed with V5R3M0 running like a lame horse from the expert community at Experts Exchange

    Comment


    • #3
      Re: pc, as400, sw in Omnis

      A few things to check.
      1. What ODBC driver are you using? Some perform much better than others.
      2. What version of OS on the AS400 are you using?
      3. Assuming you are using SQL to request data from the AS400, see if you can copy the statement and run it directly on the AS400. Try using the "Run SQL script" in iSeries Navigator. This will give you an idea if the problem is on the AS400 side.
      4. Try running the script thru Visual Explain and see if building indexes on the AS400 will help.

      Comment

      Working...
      X