As I talked about database I/O performance the last three weeks here, here, and here, optimizing database I/O performance involves many different factors. When I left off last week I talked about the parameters for pinning your popular objects into DB2’s . . . → Read More: IBM DB2 BLU Best Database I/O Performance
Another one of the benefits to migrating to DB2 LUW for Version 10 are the improvements in the DB2 LUW Routines and Views that can be called for all types of information using simple SQL statements. With over 200+ DB2 LUW Routines and Views available and many new built-in functions within DB2 there is a . . . → Read More: DB2 LUW Routines and Views: Document and Improve Your Configuration and Performance
I did my DB2 LUW migration to DB2 LUW Version 10 and now it’s time to take advantage of all the great DB2 LUW Version 10 features. The one that is on the top of my list is the new Adaptive Compression. Adaptive Compression is the newer, better DB2 LUW compression. The new Adaptive DB2 . . . → Read More: DB2 LUW Compression: Be Adaptive for Performance and Storage Savings
One of the great impacts from attending the IDUG conference is getting the latest DB2 information available from consultants, users and IBM. It is great to talk directly to users that are experiencing DB2 performance and application issues or ease of use of the tools.. Because I’ve been busy working with my clients and presenting . . . → Read More: DB2 10 for LUW Migration
First, I want to thank everyone for their emails regarding the Optim products that I wrote about last week. The reasons the comment sections on the blog are shut down is because I can’t keep up with the all the spammers while I am consulting or teaching. So please keep the emails comments coming I . . . → Read More: DB2 10 for LUW Tools: Love and Hate
Going through the DB2 9.7 Cobra beta was very educational for learning about the new features and functions. In the video below I and several of the other beta customers talk about their companies’ experiences with DB2 Version 9.7 and what features they liked best about the new DB2 release.
There are many reasons to . . . → Read More: Many Reasons to Go to the New DB2 9.7