Check out this good article on Blu Acceleration in DB2 10.5 LUW..
Check out the IBM DB2 10.5 preview….
Don’t miss the next DB2 tech talk. http://bit.ly/tt2013may8
Big announcements from IBM today, check them out at http://www.ibmbigdatahub.com/big-data-management-insights.
Stay tuned for breaking news on IBM Blu Acceleration and why you want it!
While I am talking about disks, I want to pass this tip along. Remember to consider the impact of utilities on disk capacity and throughput and therefore disk requirements. For example, online reorgs are about 8-10x harder on the disks than normal transaction processing. Therefore you must take this into consideration when determining the number of disks required, along with your utility window and impact on transactions. I can tell you from experience that it is almost always overlooked and always a problem. That’s the view from the real world.
Even though disks haves gotten faster, bigger and cheaper, I find that it is usually always under-sized. Why is that? Probably because it is not understood, but another big reason is that it is not monitored. If you are a DBA you should insist that in addition to DB2 monitoring, that server CPU, Disk, Network and memory resources are monitored. I guarantee you that if you are not doing this now, when you institute it you will be surprised at what you find. There are many free software packages out there that you can use or ensure are used. A couple are Ganglia, MRTG, NMON, and CACTi. Only 1% of clients I have been to do any type of monitoring, except for the network because that is all that CIOs typically focus on. So, get moving.
Effective 1 April 2013 we will provide a free trial of InfoSphere Optim Performance Manager with all of our consulting engagements. We are an IBM Business Partner and Software Reseller and can show you how to tune your databases using Performance Manager. http://www-142.ibm.com/software/products/us/en/performance-manager
Doing a 9.5 to 9.7 HADR ROS cutover this morning, dry run and rehearsal proved out our approach and client is looking forward to being able to use 64GB of RAM with DB2 9.7 WSE, up from 16GB…ROS on the STANDBY works like a champ…
I’ll be presenting “Battle-proven SQL Tuning Techniques” at IDUG Tech Conference in Orlando. I’m the only one that has ever presented DB2 SQL tuning for LUW so you you will only get it at IDUG or one of my custom courses. So go to http://www.idug.org and get registered. i will cover SQL tuning techniques that you won’t get anywhere else.
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 