Chapter 5. Operating system considerations 363
6. If you are using striped DMS tablespaces (multiple containers) on ESS,
ensure the extent size is a multiple of the rank’s stripe width (normally
7. I/O servers are used by database agents for prefetch I/O or asynchronous I/O
by utilities (for example, backup or restore). Having more than required does
not impose a large load on the system. Configure NUM_IOSERVERS equal to the
number of physical disks used by the database.
8. Asynchronous page cleaners flush dirty pages from the buffer pools to
maintain a certain amount of free spaces. The number of page cleaners can
have a significant impact on performance. Increase the number of page
cleaners (NUM_IOCLEANERS) if the database is heavily update-oriented or has a
large number of buffer pool pages. This is typically set to the number of CPUs
on the server.
For additional information about RAID and IBM ESS exploitation with DB2, refer
to the IBM Redbooks Database Performance on AIX, SG24-5511, and IBM ESS
and IBM DB2 UDB Working Together, SG24-6262.
5.2.4 Monitoring and problem determination tools
This section provides a brief description of UNIX commands available for
monitoring and tuning the performance of the operating system.
Table 5-4 lists tools that are commonly used to monitor various resources of
interest (this is not a comprehensive list).
Table 5-4 Suggested tool usage
This section covers the following topics:
Mapping filesystems to physical disks
Note: In most cases, these commands require root or other privileges only
held by the UNIX sysadmin, and
not by the DBA. Therefore, the DBA will most
likely have to coordinate with the UNIX syadmin to monitor the system
resources of interest.
Performance problem Suggested tools
High CPU utilization vmstat, sar, nmon,
Not enough memory vmstat, vmtune, nmon, svmon
Paging and/or swapping vmstat, vmtune, nmon, lsps, Memory Visualizer
Disk or filesystem iostat, sar, nmon, filemon