| By Dave Beulke, on March 16th, 2010 DB2 Version 9 offers a new way to handle testing out a new version of a DB2 application through the Plan Stability enhancements. The Plan Stability enhancements offer a way to save a static DB2 access package for an application and then BIND a new one. If the access package is not as efficient, Plan . . . → Read More: Plan Stability – Version 9 DB2 Performance Features – Part 20 By Dave Beulke, on March 9th, 2010 Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When time is tight . . . → Read More: Many New Index Options in DB2 – Version 9 DB2 Performance Features – Part 19 By Dave Beulke, on February 16th, 2010 New DB2 9 for z/OS UtilitiesWithin the IBM Z Summit road show that was recently in Washington DC, the DB2 presentations highlighted a number of DB2 utilities improvements. All of these DB2 utilities improvements are integrated into the new DB2 10 but there were many that can be incorporated into . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 18 By Dave Beulke, on February 2nd, 2010 New APARs Bring Features into V8 and V9 NOW!Some of the new tablespace partitioning choices and features in DB2 Version 8 and now DB2 Version 9 for z/OS that I talked about last week are getting extra enhancements. During the recent IBM System Z Summit road show that was in . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 17 By Dave Beulke, on January 26th, 2010 DB2 V9 Tablespace and Partitioning ChoicesSome of the new tablespace partitioning choices and features in DB2 Version 8 and Version 9 for z/OS are making everyone realize there are a number of table design choices to fit any application access type. In DB2 V8, the first of the . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 16 By Dave Beulke, on January 19th, 2010 No Locking Issues within DB2Some of the new DB2 performance features in DB2 Version 9 for z/OS are built into the software. To leverage some of these functions and features, system maintenance DBAs and application DBAs need to coordinate their efforts to realize the benefits. A couple of . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 15 By Dave Beulke, on January 11th, 2010 CLONE TablesAs I have talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new DB2 performance features. Many of these features can really benefit your standard application performance; improve application response time and overall availability of your systems and data. Another one of the great features . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 14 By Dave Beulke, on January 5th, 2010 Lucky 13 -Making Buffer Pool Changes with WLMWith all those year-end jobs running and the system already at 100% utilization there are not too many options for improving DB2 performance and getting things to run faster. In DB2 Version 9, one of the new features that can be leveraged to improve DB2 . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 13 By Dave Beulke, on December 22nd, 2009 Happy Holidays – Three Cheers for Online Reorgs!Given the snowstorm and the extra time in airports, I thought it was perfect time to do a blog entry. In the early releases of DB2, we had to work the holidays to do the Reorgs because that was the only time during the year . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 12 By Dave Beulke, on December 3rd, 2009 While talking with clients and friends at the recent conferences, I noticed that everyone seemed to like the blog entries I’ve done about the DB2 performance features of DB2 v9 for z/OS. Some have even implemented some of the features previously mentioned and have already reduced their costs and overall processing elapsed times. So, with . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 11 | |