Progress/400 with DB2/400

440 pts.
Tags:
AS/400
DB2/400
Firstly I would like to thank to all that helped me on my doubt with AS/400. We migrated of Progress/400 version 9 for Progress/400 version 10, and now the access to the db2/400 is from ODBC. Can I improve the performance of AS/400 knowing that the tables generated by Genexus version 9 doesn't have primary key.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t know either of these packages well, but I can give you some generic SQL improvments. The real goal is to make sure the system uses the SQE engine instead of the older CQE engine.

(1) Find file QUSRSYS/QAQQINI. If it doesn’t exist, use CRTDUPOBJ to duplicate the one in QSYS. Look for an entry IGNORE_DERIVED_INDEX and make sure its set to *YES. This prevents the SQE engine from rejecting the query (and sending it back to CQE) just becuase one index can’t be used.

(2) Take a common query and paste it into Visual Explain. It will suggest and help you build any indexes that may improve performance.

These suggestions are for V5r4. What release of the OS are you on ?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SILVARB
    GRAYBEARD52, thanks for Your help. The version is V5R3M0. Regards, SILVARB
    440 pointsBadges:
    report
  • graybeard52
    I think both option can be used at V5R3, but I'm sure sure. If the QAQQINI file exists, check for that entry. Visual Explain at V5R3 does help, although it has been improved since.
    3,115 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following