DB2 Tuning Tables
Posted by: DBA DB2,
on 19 Dec 2011 |
View original | Bookmarked: 0 time(s)
Find bottlenecks in DB2 performance is part of maintaining good response times. Here's a useful approach to locating slow query response times. Focusing on scans
1) Run a user level workload and check get snapshot for database . Add Rollback statements attempted and Commit statements attempted results in Number of Transactions attempted
2) Multiply the Number of Transactions Attempted by 5. Call it Transaction Threshold
3) Based on the...