IDAA and IIAS – Enterprise Analytics and Acceleration Options

September 28th, 2018
J Jeffrey Broderick
Enterprise Architect


Since the acquisition of Netezza in 2010 for their SQL accelerator technology, IBM has continued to enhance the ever-evolving technology with a keen focus on delivering enterprise data analytics. What started out as a basic appliance has grown into a powerful analytics enablement technology, dramatically shifting the boundaries of traditional data warehouse-oriented approaches to a real-time, Hybrid Transactional and Analytics Process (HTAP).

A version of the appliance has always been available as a standalone acceleration appliance without Db2-specific interfaces. This version of the accelerator was intended for customers that did not have an IBM Z or did not have IBM Db2 for z/OS, within their environment. The standalone unit, without Db2 integrations, has been called the IBM Integrated Analytics System (IIAS) or often PureData System for Analytics (PDA).

Leveraging Db2 on z/OS

However, at the core of the IBM Db2 Analytics Accelerator has been the deep integration with Db2 for z/OS. Leveraging the existing intelligence of the Db2 Optimizer, along with seamless connectivity with the IBM Data Studio, the IDAA continues to evolve.

In late 2017, IBM announced the next architectural generation of the accelerator. IBM chose to leverage their existing Power and z System hardware chipsets as a means to standardize on an extremely reliable, high availability, high performance, scalable and extensible chipset. The original accelerator technology ran within a Linux environment, so it comes as no surprise that this latest generation would be built on top of the IBM IFL (Integrated Facility for Linux) technology… whether on Power or z System. The IIAS version is based on Power IFLs, while the IBM Db2 Analytics Accelerator for z/OS is deployed on z System IFLs.

Secure Socket Containers

Another major change, with this newest architectural generation (v7.1), is that the accelerator operating system is deployed using a Secure Socket Container. All required components are deployed and installed, including the Linux operation system and the Docker software, as well as the Docker container which contains all the accelerator operating system and all management components.

By deploying the accelerator as a Secure Socket Container, LPARs can be established by the customer, with SSC’s deployed to each, allowing for the instantiation of additional accelerators for test, quality assurance, etc. Since multiple Db2 subsystems can talk to multiple accelerators, and an accelerator can talk to multiple Db2 subsystems, the customer has extensive freedom to build the accelerated analytics environment that best fits their business requirements.

What’s the difference between IIAS and IDAA?

Again, the accelerator can be acquired in three separate methods:

1) IBM Integrated Analytics System (IIAS) – this is the “standalone” appliance, without Db2 connectivity, primarily targeted at distributed analytics workloads. This environment is highly desirable for customers that either do not have a z System within their datacenter, or have very little data, or no Db2 on z/OS. The IIAS (v7.1) is based on Power IFLs, within the IIAS frame. Commonly called “IIAS” or “PDA” (PureData System for Analytics).

2) IBM Db2 Analytics Accelerator for z/OS (v7.1) deployment on IBM Integrated Analytics System (IIAS) – this is the accelerator technology being deployed on a separate, but network attached, physical hardware appliance. This hardware appliance (v7.1) leverages the same Power IFLs, within the IIAS frame, but also has the Db2 for z/OS connectivity. Commonly called “Accelerator on IIAS.”

3) IBM Db2 Analytics Accelerator for z/OS (v7.1) deployment on IBM Z – this is the accelerator technology that deploys on IFLs, within the same z System. Commonly called “Accelerator on IBM Z.” Additional IFLs can be added (up to one drawer), to continue to grow the accelerator environment, providing unprecedented scale and performance. With every hardware upgrade or migration to a new z System, the technology dividend of faster IFLs could certainly make a tremendous difference in future-proofing the accelerator.

Value Proposition for Agile Organizations

The value proposition for the IDAA has far more to do with seamlessly delivering outstanding analytics performance and power to an organization’s business units. Delivering capabilities for real-time analytics results, along with the capability to access historical/archived data seamlessly, without impacting existing OLTP workloads, with minimal IT resource overhead, contributes to substantial value for today’s agile organizations.

Continued development with the IDAA Loader technology, along with real-time asynchronous data replication, have fully enabled a centralized data store with acceleration. Enterprise-level, real-time analytics, without impacting OnLine Transaction Processing (OLTP) systems like CICS and IMS, is now available.

Submit a Comment

Your email address will not be published. Required fields are marked *