Just a quick note to let you know you can save $100 off your IBM IOD 2009 Conference registration by using Promotion Code G09BOND. This promo code is valid for a long as IOD registrations are open and available.
[ more.. ]
Save $100 off IBM IOD '09 Registration with Promo Code G09BOND
July 31, 2009, 12:45 pm
Hello DB2 LUW Performance fans,
by Scott Hayes
in General
DB2 LUW Index Design Best Practices
July 8, 2009, 3:44 pm
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.. ]
Page :
1