This chapter describes maintenance tasks that you can perform to improve the performance of Siebel Business Applications on DB2 for z/OS after you have completed the Siebel application installation.

This chapter consists of the following topics:

• DB2 Statistics for Siebel Business Applications
• About Reorganizing Table Spaces, Partitions, and Indexes
• About Cursor Close
• Database Connection Pooling
• Dynamic SQL in the Siebel Application
• Using odbcsql to Submit SQL Statements
• Enabling DB2 Dynamic Statement Caching
• Tracing the Source of a Query
• About Coordinated Universal Time and DB2 for z/OS