Performing database maintenance tasks can improve the performance of IBM® FileNet® P8.
As large amounts of content are added, removed, or changed in a database, the associated tables, and indexes need to be periodically reorganized for optimal performance.
See the database vendor documentation to determine if a REORG is necessary, and if so, how to complete the process.
Memory and disk I/O limitations are the main contributors to database-related performance issues. Use the appropriate operating system tools to monitor memory usage, CPU usage, and disk performance.
Use vmstat and iostat on UNIX-based systems.
As content is added, removed, and changed in a database, it is important to keep database statistics updated for optimal query performance.