Administration Guide

Chapter 22. 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"
• "Restrictions on Result Sets to Improve Performance"
• "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 Application Development Guide and the CLI Guide and Reference 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
• Writing programs using DB2 Call Level Interface (CLI).