General Tuning Tips
Some tuning issues are relevant to workloads generally. Some of the most important of these are discussed below.
Balancing Tablespace Activity
In Chapter 21 we discussed ways of monitoring disk activity with Solaris tools. It can be useful, though, to monitor the I/O activity for each DB2 tablespace to assist in data layout. DB2 provides a command to monitor tablespace activity:
db2 “get snapshot for tablespaces on dbname”
The output from this command shows the number of physical reads and writes as well as the bufferpool activity for each tablespace.
If the database configuration “index sort flag” parameter (INDEXSORT) is set to YES, then index creation will require sort activity. This is advisable for performance reasons. ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
