DB2 Configuration Notes
The minimum version of DB2 which is certified on Solaris 10 is DB2 V8.1 fixpack 9 and DB2 V8.2.2. This is what is required for DB2:
Patchid 118822-25 was determined to cause performance degradation on DB2. Move to 118822-27.
Set consistent_coloring=2 in /etc/system
Occasionally tasks in DB2 will be run single threaded. Use psrstat -am to determine if any of the DB2 processes are consuming 100% of a single Hardware Thread.
There are two options:
- Set the INTRA_PARALLEL=YES parameter in DB2 - set the DFT_DEGREE parameter to 3 or 4 depending on the load on the system
- Use the Dynamic Partitioning feature of DB2
Option 1 is the simplest solution to update the above settings:
db2 update dbm cfg using INTRA_PARALLEL YES
db2 update db cfg for mydbname using DFT_DEGREE 4
Documents
