IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
This blog is part of a blog series around Analytics on IBM Z and has been created by
Jane, Tom’s colleague, creates so called multi-step reports consisting of reports which include several subsequent queries. She has e.g. a report with 3 queries Query1, Query2 and Query3 which are run subsequently. Query2 uses temporary results delivered by Query1. Jane can also leverage the accelerator to accelerate her report. The result set of Query1 can be stored on the accelerator as Accelerator only tables (AOT) and can then be used by Query2. An AOT table only exists on the accelerator, but its definition is still available and controlled by Db2. The AOT feature opens up additional usage like using data transformations from existing ETL processes and applying those transformations on the accelerator using the in-database transformation functionality.
Jane can also enrich her analytics reports by including non Db2 sources in the report. This is namely possible by loading data from e.g. MS SQL Server, Oracle, IMS, VSAM or other data sources into the accelerator using the Db2 Analytics Accelerator Loader.
The Db2 Analytics Accelerator provides a cost-effective solution and takes advantage of the superior IBM z quality of service, including availability, reliability and security.
The first version of the Db2 Analytics Accelerator was built on Netezza technology and was a dedicated hardware appliance. The latest version of the Db2 Analytics Accelerator is built on Db2 Warehouse on IBM Integrated Analytics System (a Power platform) as a dedicated hardware appliance or it is also delivered as a software appliance as a secure Docker container that can run on mainframe. The two deployment options of the Db2 Analytics Accelerator are functionally identical. The main difference is the capacity and resources available.
Both of these deployment options are based on the premier IBM analytical engine, Db2 Warehouse software. This guarantees a uniform experience that allows IBM z clients to invest once to enable their applications and workloads for the Accelerator and then to transition easily between deployment options.
Db2 Warehouse includes latest analytics technology innovations. It represents IBM’s premier analytics engine across many solutions and offers better SQL compatibility across all IBM products as well as a high degree of concurrent users and queries.
Outside of the container, the accelerator solution includes physical compute resources, a server that includes multi-core CPUs, large memory and a shared filesystem to persist the data
On top of the physical hardware there is a Docker supported Linux operating system that is just used to launch the Docker container and manage the Hardware resources.
The Accelerator based on IBM Integrated Analytics System is a pre-configured offering that includes hardware (compute, storage, and networking) and software for easy deployment, management, and high performance. It offers secure, flexible and elastic data storage that is both easy to deploy and easy to manage.
The new option consists of a “software appliance” directly on IBM z. This provides far deeper integration into an existing mainframe environment – no additional, external hardware is required, management of the whole Db2 Analytics Accelerator setup, configuration, resources and problem handling using IBM z system management, and so on.
Now it is really easy to get started with the Db2 Analytics Accelerator and take advantage of the query acceleration and analytics capabilities it provides for Db2 for z/OS. The Accelerator on IBM Z simplifies deployments dramatically to a true download & go experience.
The new deployment option presents a great opportunity for both clients with small scale analytical workloads requirements based on Db2 for z/OS data as well as clients who run massive Analytical workloads without needing any additional hardware for Accelerator.
Part 1: Is there a future for Analytics on IBM Z?
Part 2: IBM Db2 Analytics Accelerator
Part 3: Machine Learning on z/OS
Part 4: Operational Decison Manager
Part 5: Modernizing Applications by using API’s
Add a Comment