May 07, 2013

DB2 11 for z/OS: What's ahead

IBM announced the DB2 11 for z/OS Early Support Program last fall, and a select group of clients are now participating in the program. I want to revisit the announcement letter to show you how IBM is positioning DB2 11.

Here's how IBM highlights the benefits of DB2 11:

  • Helps save money and time how reducing costs.
  • Provides unmatched availability, reliability and security for business critical information.
  • Provides enhanced analytics for business growth.
  • Offers simpler, faster migration for faster ROI.

And here's IBM's list of key features:

  • CPU reductions and performance improvements for certain OLTP, heavy insert, select query workloads, and when running queries against compressed tables.
  • Improved data sharing performance and efficiency.
  • Improved utility performance and additional zIIP eligible workload.
  • Cost-effective archiving of warm and cold data with easy access to both within a single query
  • Intelligent statistics gathering and advanced optimization technology for efficient query execution in dynamic workloads.
  • Additional online schema changes that simplify management, reduce the need for planned outages, and minimize the need for REORG.
  • Productivity improvements for DBAs, application developers and system administrators.
  • Efficient real-time scoring within your existing transaction environment.
  • Enhanced analysis, forecasting, reporting and presentation capabilities, as well as improved storage management, in QMF.
  • Expanded SQL, SQL PL, temporal and XML function for better application performance.
  • Faster migration with application protection from incompatible SQL and XML changes and simpler catalog migration.

DB2 10 for z/OS is one of the most quickly adopted releases ever. Of course a big factor in this was IBM's decision to allow customers to migrate directly from DB2 8 to DB2 10. Still, DB2 10 is also noteworthy because it dramatically reduced CPU usage. IBM is claiming that DB2 11 will offer just as significant CPU savings -- in the range of 5 to 20 percent. This time though, customers will have to migrate to DB2 10 before moving onto DB2 11.

One thing I like about DB2 11 is its support of an extended RBA. Read this Robert Catterall post for a good explanation of this feature.

Some other quick highlights: The addition of DROP COLUMN should continue to improve online schema changes. New online data repartitioning is designed to significantly reduce the need for planned outages. DB2 11 also brings performance enhancements with long running BIND and DDL threads and improved clone table management and more efficient data sharing. Finally, with DB2 11 applications with SQL or XML will be able to run in compatibility mode, even if they're incompatible with the new release.

So is your company planning on adopting DB2 11 for z/OS soon, and if so, what's driving your decision? Please share your thoughts in comments.