Troubleshooting
Problem
This document is a short list of recommended reading and education related to the query optimizer used in IBM i5/OS
Resolving The Problem
This document is a short list of recommended reading and education related to the query optimizer used in IBM i5/OS
To understand more about how the IBM i5/OS query optimizer works, refer to the following:
| o | Query Engine Overview, from Database Performance and Query Optimization section of the IBM i and System i Information Center http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzajq/rzajqkickoff.htm?lang=en |
| o | White paper entitled Indexing and Statistics Strategies for DB2 UDB for iSeries. https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_ast_sys_wp_db2_i_indexing_methods_strategies |
| o | Presentation entitled SQE Overview Presentation (February 2006). http://www-03.ibm.com/systems/i/software/db2/sqe.html |
| o | Use the SQL performance analysis tools by following guidance given in the IBM Redbooks, SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries. http://www.redbooks.ibm.com/abstracts/sg246654.html?Open |
| o | Class entitled, DB2 for i5/OS SQL and Query Performance Tuning and Monitoring Workshop. http://www-03.ibm.com/systems/power/software/i/db2/education/performance.html |
| o | Tips & Technical papers for IBM DB2 for i http://www-03.ibm.com/systems/power/software/i/db2/support/tips/ |
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]
Historical Number
469804463
Was this topic helpful?
Document Information
Modified date:
11 November 2019
UID
nas8N1013992