Despite all the hype about AUTOMATIC tuning, a remarkably large number of DB2 LUW customers are still suffering from inadequate and sub-optimal performance. AUTOMATIC tuning can provide some benefits, BUT it only works well when the database is free of significant physical design defects.
We have heard from DB2 LUW users that their ETLs take too long. Index changes were the solution.
We have heard that response times were too slow. Index changes were the solution.
We have heard that CPU utilization is too high, or that there are periodic spikes in CPU utilization. Index changes were the solution.
We have seen OLTP applications appear to "seize up" or "stall". Index changes were the solution.
We have seen DB2 users struggle to complete year end and quarter end reports on a timely basis. Again, Index changes were the solution...
[
more .. ]