You are currently on IBM Systems Media’s archival website. Click here to view our new website.

Bookmark and Share

Recent Posts

Thoughts on DB2 12

October 11, 2016

Last week IBM announced DB 12 for z/OS and its Oct. 21 general availability. Of course there's a lot to dissect -- and I'll certainly be getting into specifics of DB2 12 features in the weeks and months ahead -- but for now, here are some of my initial reactions.

One key takeaway I see in DB2 12 is the capability to deliver critical new features at a much faster pace. With continuous delivery, you will no longer have to wait three years to get a feature needed for your business.

Customers in the early support program have been pleased with the simplified installation process. With DB2 12, you no longer need to go from compatibility mode (CM) to enable new function mode (ENF) to new function mode (NFM). Now it's simply a matter of installing and then activating new functionality. Coupled with the application compatibility feature added in DB2 11, it's much easier and faster to move to new functionality and then let application teams determine the testing and migration path.

Another area that's been lacking in support is the capability to manage dynamic SQL access paths like we do with static SQL. Customers have sustained major business impacts when dynamic SQL applications that had always run well required a minute or more to execute due to access path issues. However, DB2 12 brings dynamic SQL plan stability, which allows customers to avoid a high risk outage by storing access paths in the catalog for dynamic SQL -- just as it is with static SQL.

Another DBA pain point that DB2 12 resolves comes with the capability to resize partitions and change the DSSIZE for selected partitions. Now with DB2 12, DSSIZE can be changed at the partition level, a great convenience for customers that may not have the available disk storage to REORG an entire tablespace.

Some other highlights:
  • Improved business insight: highly concurrent queries run up to 100x faster.
  • Faster mobile support: 6 million transactions per minute via RESTful API.
  • Enterprise scalability, reliability and availability for IoT apps: 11.7 million inserts per second, 256 trillion rows per table.
  • Reduced cost: 23 percent lower CPU cost through advanced in-memory techniques?
If you're looking for still more details, here's the announcement letter.

With DB2 12, DB2 is officially recognized as an in-memory database. The capability to do more in memory will provide a great deal of cost savings through the avoidance of CPU usage. Believe me, adding memory to your box to exploit the greater efficiency DB2 12 brings to real memory is well worth the investment.

For as long as I've been around DB2, I can't think of any previous release that compares to the innovation found in DB2 12. I look forward to learning more about these new features, and, as always, I'll share my findings with you.

Posted October 11, 2016| Permalink