Database maintenance tasks
You must monitor and optimize the database server to ensure database availability and performance. Maintaining DB2® and Oracle databases involves updating statistics, monitoring database, server, and space utilization, and planning backup and recovery strategies.
Apply the latest database server and client software fix pack on the database and application server
Always apply the latest fix pack on the database and application server because they contain bug fixes and performance enhancements. Both the database and client are at the same fix pack level to avoid issues that are related to database version mismatch.Tuning the database for performance
You must ensure that the database is tuned properly. Databases are highly adjustable and you can modify them or setup monitoring to increase performance. Tuning the database to improve response time can dramatically decrease the amount of time that users spend waiting for operations to finish running, enable the implementation to keep up with the speed at which business is conducted, and optimize resource usage to ensure that existing hardware investments are used efficiently.Reorganizing and generating database statistics
The database optimizer requires statistical metadata information about its user tables to choose the best way to access data. The optimizer requires up-to-date statistical metadata information, including number of rows and cardinality.The database administrator must manage and organize tables and indexes of your database schema to find and avoid potential problems or issues. Most common issues are data and index fragmentation, row migration, and old statistics.
Managing old object versions
With IBM® Product Master versioning mechanism, many old versions can accumulate in IBM Product Master internal tables over time (especially in icm, ita, itd, itm, nod, noa tables).With increased data volume along with potential fragmentation of data, performance to retrieve data might decrease over time dramatically. It is important to maintain old versions regularly.
Two types of jobs are provided, one that estimates the number of old version rows and other that deletes old version rows.
Managing database connections
You can define the maximum number of connection pools for each of your services to optimize the balance between your resources and the number of required connections that are made to either your Db2 or Oracle Database.Your database must be configured with enough connections to meet the demands of all implementation processes in both typical and clustered environments for each of your services: admin, application server, scheduler service, event processor, queue manager, and workflow engine.