Administration Guide

Chapter 10. Application Considerations

There are a number of factors that can impact the runtime performance of your application. This chapter describes the following topics that should be considered when you are designing and coding your application:

• "Concurrency"
• "Locking"
• "Adjusting the Optimization Class"
• "Quickly Retrieving the First Few Rows Using OPTIMIZE FOR n ROWS"
• "Row Blocking"
• "Tuning Queries"
• "Compound SQL"
• "Performance Considerations and Character Conversion"
• "Stored Procedures"
• "Activating a Database"
• "Parallel Processing of Applications".

You should also refer to the Embedded SQL Programming Guide for additional information which can affect the performance of your applications, for example:

• Writing programs using embedded static SQL
• Writing programs using embedded dynamic SQL.

[ DB2 List of Books | Search the DB2 Books ]