IBM DB2 - The Ultimate Database for Cloud, Analytics & Mobile
If you are a Db2 for z/OS DBA, you know that good performance relies on good statistics, which you collect by running the RUNSTATS utility. If you ever collect frequency statistics for single-column column groups, you may have wished that these jobs would run faster and cost less than they do.
Customers have been telling us that they lack adequate safeguards to protect data in Db2 for z/OS from viewing by unauthorized internal personnel. In Db2 11 for z/OS, we address that problem by introducing enhancements that provide a simple, transparent, and consumable approach to enabling pervasive encryption of data at rest. This same function is also available as a base release enhancement to Db2 12 for z/OS.
Db2® 12 for z/OS® takes Db2 to a new level, both extending the core capabilities and empowering the future. Db2 12 extends the core with new enhancements to scalability, reliability, efficiency, security, and availability. Db2 12 also empowers the next wave of applications in the cloud, mobile, and analytics spaces.
New Db2® capabilities and enhancements are continuously delivered in a single maintenance stream as the code becomes ready. You can activate the new capabilities in a data sharing group or Db2 subsystem after a function level is delivered.
Do you ever wish you could just ask a Db2 expert about something? Maybe about how to do something with Db2 that you've never done before? Or maybe about problems that occur during migration from an older version of Db2 to Db2 12 or Db2 11? If having an expert available sounds appealing to you, then IBM's recent announcement about Enterprise Advisor for Db2 for z/OS is very good news.
If you’re involved in supporting Db2 for z/OS environments, you probably wish there were a simpler way to deal with preventive maintenance. The good news is that the IBM zServiceAdvisor can now make your life easier and, more importantly, improve the health and stability of your IBM Z environment.
If you run the CHECK LOB utility in Db2 12 or Db2 11 for z/OS, you will be happy to learn that performance has just gotten better. The IBM Db2 Development team has recently changed the code so that the CHECK LOB utility now uses more prefetch than before. This can result in a dramatic reduction in synchronous read I/O and a significant reduction in CPU and elapsed times.