Operating system tuning
For best results, you should examine the operating system regularly and monitor system load using vmstat and iostat. You can also collect this information in a table that you can access later.
Here are the major components of an operating system to consider:
|
O/S component |
Things to look out for/monitor |
|---|---|
|
Kernel parameters |
The kernel parameters should be set before installing DB2; this requires root access. |
|
Paging |
One way to achieve this is to plan carefully for memory allocations for all the products installed on a machine. If you have databases from Oracle and IBM DB2 on the same machine, a backup server, web server, and so on, you must take into account all the memory required. |
|
Input/Output |
The next item to look for is Input/Output activity, to make sure there are enough spindles to handle the database workload. Locate potential hot spots, that is, busy disks. |
|
CPU |
Check for abnormal CPU usage, and make sure CPU load is balanced. |
|
Network |
Check for abnormal... |
