DB2 10 Performance Improvements

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

DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications

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.

Better DB2 Business Intelligence Performance Management

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.

DB2 9 Provides a DB2 Performance Boost

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.

Performance is Relative

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

Performance features in DB2 V9 for z/OS – Part 10

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

Performance features in DB2 V9 for z/OS – Part 9

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

Performance features in DB2 V9 for z/OS – Part 8

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

Performance Features in DB2 V9 for z/OS – Part 6

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

Performance Features in DB2 V9 for z/OS – Part 5

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