Home > IT Answers > AS/400 > Progress/400 with DB2/400
Help

Question

  Asked: Jun 22 2008   4:20 PM GMT
  Asked by: SILVARB

Progress/400 with DB2/400


AS/400, Progress/400, GeneXus, 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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 28 2008  2:31 AM GMT  by Graybeard52




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 ?
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

SILVARB  |   Jul 1 2008  11:56AM GMT

GRAYBEARD52, thanks for Your help.

The version is V5R3M0.

Regards,
SILVARB

 

Graybeard52  |   Jul 1 2008  5:45PM GMT

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.