Memory tuning in DB2

IBM DB2 offers the db2pd utility you can use to collect statistics on your DB2 instances and databases to help you troubleshoot problems, monitor your databases, and tune database performance. For information on how to use this utility, consult the DB2 online documentation.

DB2 also offers a tool—the Configuration Advisor, provided with the Control Center—that is designed to capture specific information about your database environment and recommend changes to configuration parameters based on the information you provide.

At DB2 9, the default settings for buffer pools and the package cache size parameter may be sufficient. If you are not using the default settings, here are some recommendations on tuning the memory of your DB2 database to work with ArcSDE.