IBM FileNet P8, Version 5.2.1            

Maintaining IBM FileNet P8 database operations

Performing database maintenance tasks can improve the performance of IBM® FileNet® P8.

Reorganizing indexes and tables

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.

Monitoring memory and disk I/O

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.

Computing statistics for optimal performance

As content is added, removed, and changed in a database, it is important to keep database statistics updated for optimal query performance.



Last updated: March 2016
p8ppt101.htm

© Copyright IBM Corporation 2016.