DB2 Install Next Steps: Part 1

Tuning DB2 LUW systems, databases, and applications can be sometimes a long drawn out research effort requiring examination of every variable involved. Sometimes the key to the performance is examining the DB2 LUW system installation, its configuration, and the database configuration. This why I call this blog “DB2 Install Next Steps” because if the SYSADMIN . . . → Read More: DB2 Install Next Steps: Part 1

DB2 LUW Version 11 Features: 5 More to Improve Performance

The new DB2 LUW Version 11 was released June 15, 2016. The release announcement described many interesting items which are included in the new DB2 LUW 11. Being part of the DB2 LUW 11 Beta program has been exciting. Now that IBM has released it, here are five more ways DB2 LUW Version 11 features . . . → Read More: DB2 LUW Version 11 Features: 5 More to Improve Performance

DB2 LUW Version 11: 5 BLU Performance Improvements for Applications

The DB2 LUW Version 11 announcement described many DB2 BLU performance improvements and below are five important ones that will help your DB2 LUW applications improve performance. What is good about most of these DB2 LUW Version 11 BLU performance improvements is that they are built into DB2 LUW Version 11 and will improve your . . . → Read More: DB2 LUW Version 11: 5 BLU Performance Improvements for Applications

DB2 LUW Version 11 - 5 Great New Features and Many More to Come

DB2 LUW Version 11 was unveiled last Tuesday, April 12th.

The announcement described the many tremendous items which are included in the new DB2 LUW 11. Being part of the DB2 LUW 11 Beta program has been exciting. Now that IBM has announced it, I’ve highlighted some of the new features in DB2 LUW Version . . . → Read More: DB2 LUW Version 11- 5 Great New Features and Many More to Come

DB2 LUW Cancun Release New Explain Information

The DB2 10.5 “Cancun Release” was previously available as DB2 LUW Version 10.5 Fix Pak 4. The short list of prerequisites and summary DB2 10.5 “Cancun Release” features list is here at the IBM DB2 10.5 “Cancun Release” Fix Pak Knowledge Center website. Within the release there are many important features, and some . . . → Read More: DB2 10.5 “Cancun Release” New Explain Information

DB2 10.5 “Cancun Release” Additional Monitoring Capabilities

DB2 10.5 “Cancun Release” was recently released as DB2 LUW Version 10.5 Fix Pak 4. As I wrote about last week, IBM has put a number of impressive features in this new update. Within DB2 10.5 “Cancun Release” Fix Pak 4 there are several new and interesting monitoring elements. These new monitoring elements provide . . . → Read More: DB2 10.5 “Cancun Release” Additional Monitoring Capabilities

6 Reasons Why DB2 10.5 ”Cancun Release” Is So Important

The new DB2 10.5 “Cancun Release” was recently released as DB2 LUW Version 10.5 Fix Pak 4. IBM has done a lot of work and put a number of impressive features in this DB2 LUW Fix Pak 4. All these new DB2 10.5 “Cancun Release” features remove any doubts or restrictions about going to the . . . → Read More: 6 Reasons Why DB2 10.5″ Cancun Release” Is So Important

IBM DB2 BLU Best Database I/O Performance

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 buffer pools to . . . → Read More: IBM DB2 BLU Best Database I/O Performance

DB2 LUW Routines and Views: Document and Improve Your Configuration and 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

DB2 LUW Compression: Be Adaptive for Performance and Storage Savings

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