Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Improving embedded SQL performance

This Search400.com memer wonders if a licensed program will improve performance for embedded SQL. DB2 expert Kent Milligan offers some advice.

Does the following license program improve performance for embedded SQL? 5722ST1 *COMPATIBLE DB2 Query Mgr and SQL DevKit

When this license program expired the performance of an RPG program with embedded SQL was degraded dramatically.

The license program 5722ST1,DB2 Query Manager and SQL Development Kit, is only needed if you want to do interactive SQL (STRSQL) or precompile embedded SQL (in RPG and COBOL programs). There is no reason why your program performance would degrade as a result of this LPP expiring. I would suggest running the database monitor to help determine the reasons for the performance degradation.


Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.