DB2 on SPARC T3 Tuning Tips
- by cherry.shu(at)oracle.com
With the new self tuning feature in DB2 V9.x, a lot of database parameters are set to automatic in DB2 v9.7 by default so that DB2 can adjust the values as needed. Most should work fine without manual tweaks. But for transaction workload on SPARC T3 systems, two parameters need to be adjust manually to achieve optimal performance.
DATABASE_MEMORY:…