Database optimization

To improve the DB2® database search performance, you can optimize the database and update DB2 statistics for the database tables.

You can use Configuration Tool or the idsrunstats command to optimize DB2 database. You must run the DB2 optimization operation periodically or after the database updates, such as after data import operations.

When you run database optimization, the tool collects statistics on all indexes that are defined on tables and updates it. The DB2 query optimizer uses these statistics to determine the optimum path to access the data.

You cannot run DB2 optimization, if the instance is a proxy server or the instance is not configured with a DB2 database.

For more information about the idsrunstats command, see Command Reference.