IBM BPM, V8.0.1, All platforms > Tuning > Advanced tuning
Database: DB2 for z/OS specific tuning
A few general rules can assist in improving the performance of DB2 environments.
Comprehensive DB2 performance tuning information is also available in the 
DB2 Information Center, and can be found by searching for performance tuning.
- Update database statistics
It is important to update the statistics so that DB2 can optimize access to key tables. Statistics are maintained on tables and indexes, and are used by the DB2 query optimizer to determine the access plan for evaluating a query. - Set buffer pool sizes correctly
A buffer pool is an area of memory into which database pages are read, modified, and held during processing. Buffer pools improve database performance. - Maintain proper table indexing
Although the Business Process Management products create a set of database indexes that are appropriate for many installations, additional indexes are required in some circumstances. - Size log files appropriately
To improve log write performance, size log files appropriately.