Maintaining Siebel CRM Applications on DB2 for z/OS

This chapter describes maintenance tasks that you can perform to improve the performance of Siebel CRM applications on DB2 for z/OS after you have completed the Siebel CRM installation. This chapter includes the following topics:

• DB2 Statistics for Siebel CRM

• About Reorganizing Table Spaces, Partitions, and Indexes

• About Cursor Close

• Database Connection Pooling

• Dynamic SQL in the Siebel Application

• Using the odbcsql Utility to Submit SQL Statements

• Enabling DB2 Dynamic Statement Caching

• Tracing the Source of a Query

• About Coordinated Universal Time and DB2 for z/OS