25 November 2013

DB2 11 is here





DB2 11: The Database for Critical Transactions & Analytics


Speed, Simplicity, Savings


DB2 11 for z/OS delivers new innovations: Save money, save time, reduce cost Enhanced continuous availability, scalability, and security for business-critical information Sophisticated Critical business analytics Simpler, faster migration for faster ROI Deep integration between DB2 and System z

IBM DB2 11 overview video:





 So what’s new in DB2 11 that is causing so much excitement? Here is a quick summary of some of the exciting new features and business benefits of DB2 11, about which this book will give you deeper insight:



• Even more out-of-the-box CPU savings


    10 percent complex OLTP

    10 percent update intensive batch

    40 percent queries

    25 percent uncompressed tables and 40% compressed tables



• Enhanced resiliency


    Fewer planned outages, fewer REORGs, faster recovery

    Cost-effective archiving, access warm/cold data in single query

    Business-critical analytics

    DB2 Analytics Accelerator performance enhancements

    Big data integration

    In-transaction real-time scoring

    Advanced QMF analytic capabilities with mobile support



• Simpler, faster upgrades for faster ROI


    6x faster catalog migration

    Protection from incompatible changes

    Repeatable testing with real workloads and integrated cloning



Big Data, IBM DB2 Accelerators:


Join Dan Wardman, VP of Information Management Mainframe Software, as he discusses Big Data and System z and explains why zEnterprise systems are a key data source for Big Data and Business Critical Analytics.

Big data can address a multitude of problems if you know how to use it. The insights gleaned from big data can help organizations deepen customer engagement, optimize operations, prevent threats and fraud, and capitalize on new sources of revenue. But to be successful, you need a clear understanding of the characteristics of big data and the skills required to manage it.





IBM Business Analytics and Optimization






Delivers extremely fast query results for critical business insight


IBM® DB2® Analytics Accelerator for z/OS is a high-performance appliance that integrates IBM Netezza and zEnterprise technologies. The solution delivers extremely fast results for complex and data-intensive DB2 queries on data warehousing, business intelligence and analytic workloads.



DB2 Analytics Accelerator for z/OS helps you:



  •     Query data at high speeds—to significantly improve response times for unpredictable, complex and long-running query workloads.
  •     Extend the capabilities of DB2 for z/OS—to support a cost-effective analytics solution for data warehousing, business intelligence and predictive analytics.
  •     Lower operating costs—by reducing System z disk requirements and offloading query workloads to a high-performance platform.


Offers improved, broader analytics queries with latest release


IBM® DB2® Analytics Accelerator for z/OS delivers new features to support a broader set of applications and provide acceleration capabilities for most DB2 for z/OS customers. The software includes enhancements to support more data, queries, systems and applications, which can offer greater business benefits and cost savings.

The latest version of DB2 Analytics Accelerator for z/OS provides these features and benefits:


  •     Accelerates a broader spectrum of queries with support for Static SQL, multiple-row FETCH and multiple encodings on the same accelerator.
  •     More robust and scalable for the enterprise through enhanced workload balancing, improved incremental update performance and improved monitoring.
  •     Storage saver performance improvements including built-in restore, better access control for archived partitions and protection of moved partitions.
  •     Supports DB2 11 and PureData Analytics N2001 hardware.



DB2 10.5 with BLU Acceleration:





Accelerating Analytics with BLU:





IBM DB2 10.5 Optimized for SAP Software:






IBM DB2 Analytics Accelerator or IDAA


DB2 for z/OS has a new cool feature: the IBM DB2 Analytics Accelerator or IDAA. The IDAA is a marriage of DB2 for z/OS and Netezza technology to accelerate complex queries in a highly secure and available environment. This 60 minute video will explain what it is exactly, how it works and why you would want such an accelerator. Click on the link below to start the presentation (opens new window). Enjoy! - See more at: http://www.db2-symposium.com/articles/category/the-wall/#sthash.Gz1T3zjm.dpuf

How IDAA Accelerators work and Why would want IBM IDAA Accelerators


Look at this article to get a quick introduction into DB2 UDB trace facility:

DB2 Basics: An introduction to the DB2 UDB trace facility


More information on what's new in DB2 11 can be found here:

DB2 11: The Database for Critical Transactions & Analytics

DB2 Information Management Tools and DB2 11 for z/OS Compatibility

from IBM Champion Craig Mullins

from Robert Catterall

from Willie Favero

IBM Data Management on TUMBLR

Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics

DBI Smarter Tools for Smarter People

DB2 10.5 with BLU Acceleration New Dynamic In-Memory Analytics for the Era of Big Data

SQL Tips for DB2 LUW by Serge Rielau (瑞赛奇) and Rick Swagerman

Discover DB2 for yourself



For more information please contact me at:


Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 
Share:

0 reacties:

Post a Comment