| By Dave Beulke, on March 20th, 2012 There are many great features in DB2 10 and as the system migrations happen more companies are experiencing improved performance. The clients doing migrations from DB2 Version 8 to DB2 10 are especially happy experiencing the performance improvements in DB2 Version 9 once they make it to Version 10. There are many areas where performance . . . → Read More: DB2 10 Performance Improvements By Dave Beulke, on September 27th, 2010 DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications 2008 DB2 Magazine article shows how DB2 on the System Z platform supports cost efficiencies and DB2 performance for DB2 business intelligence applications. By Dave Beulke, on September 27th, 2010 Better DB2 Business Intelligence Performance Management 2003 DB2 Magazine article shows how to get better DB2 business intelligence performance by taking advantage of DB2 views, especially a DB2 materialized view. By Dave Beulke, on September 27th, 2010 DB2 9 Provides a DB2 Performance Boost 2007 DB2 Magazine provides specific examples of DB2 SELECT, DB2 FETCH and more to show how DB2 9 for DB2 zos can improve DB2 performance. By Dave Beulke, on August 17th, 2010 This last week was very interesting in that I read a number of articles about databases other than DB2. It is always good to learn what the other vendors are up to. The first thing you learn is that fast and performance are a relative terms. Loading tens of millions of rows through ETL processes . . . → Read More: Performance is Relative By Dave Beulke, on September 22nd, 2009 As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations; improve application performance and overall availability of your systems and data. There are many new enhancements with DB2 9 for z/OS that are especially . . . → Read More: Performance features in DB2 V9 for z/OS — Part 10 By Dave Beulke, on September 8th, 2009 ORDER BY and FETCH FIRST n ROWS in a Sub-Select Another one of the new enhancements, ORDER BY and FETCH FIRST n ROWS in sub-select and full-select, is especially great for web and Java application programmers. You may be surprised because your programmers have been using ORDER BY and FETCH FIRST n ROWS for some time, but in DB2 Version 9 for z/OS . . . → Read More: Performance features in DB2 V9 for z/OS — Part 9 By Dave Beulke, on September 1st, 2009 Skip Uncommitted Inserts zParm Another one of the enhancements with DB2 Version 9 for z/OS that helps with your very robust tables and their locking is the new zParm, Skip Uncommitted Inserts – SKIPUNCI. If your applications . . . → Read More: Performance features in DB2 V9 for z/OS — Part 8 By Dave Beulke, on August 18th, 2009 As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations and improve application performance and overall availability of your systems and data. FETCH WITH CONTINUE SQL Another one of the enhancements . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 6 By Dave Beulke, on August 11th, 2009 As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations and improve application performance and overall availability of your systems and data. . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 5 | |