Minimize disk I/O contention in DB2

Disk I/O contention within an IBM DB2 database is minimized by properly arranging the components of the database throughout the file system. Ultimately, the database administrator must reduce the possibility of one process waiting for another to complete its I/O request. This is often referred to as waiting on I/O.

The following are recommendations to help you avoid disk I/O contention.

Even after tuning your database to reduce disk I/O contention, there may still be times when you run into deadlocks. For information on deadlocks, see Deadlocks in a DB2 database.


8/19/2013