Db2 for z/OS and its ecosystem

 View Only

Leverage IBM Db2 Analytics Accelerator for z/OS as THE Data Hub for your Enterprise

By Patric Becker posted Thu August 13, 2020 03:55 PM

  

Leverage IBM Db2 Analytics Accelerator for z/OS as THE Data Hub for your Enterprise

Companies around the globe have embraced IBM Db2 Analytics Accelerator for z/OS to gain more and faster insights into data available to them to make better business decisions. IBM Db2 Analytics Accelerator for z/OS enables Db2 for z/OS to become a truly hybrid DBMS that can handle all incoming SQL workloads in the best possible way – either by running queries with OLTP characteristics in Db2 for z/OS or by routing queries with analytical characteristics to an accelerator for faster execution.

Out of the box, IBM Db2 Analytics Accelerator for z/OS is capable to store data that originally resides in Db2 for z/OS.  However, in today’s world, most companies use more database management subsystems than just Db2 for z/OS. Prominent examples to store data assets on the mainframe include but are not limited to IMS DB, VSAM, Adaptable Database System (ADABAS©) or Integrated Database Management Systems (IDMS©). These technologies are used in numerous mainframe shops across the globe. In the distributed world, Oracle© or Microsoft SQL Server© can be found in many installations that store data in addition to existing mainframe data sources.

With IBM Db2 Analytics Accelerator for z/OS, technology to accelerate the analysis of large amounts of available data is deployed in Db2 for z/OS only. Now all of these additional database management subsystems that were mentioned before can contain important data assets that are available in your company. Would you want to benefit from query acceleration technology on more than just Db2 for z/OS data to even get more value out of your existing investment ? Then keep reading.

IBM Db2 Analytics Accelerator Loader for z/OS enables you to add and load data from non-Db2 for z/OS data sources to IBM Db2 Analytics Accelerator for z/OS. Once data is available inside an accelerator, your query workload can now benefit from the query acceleration capabilities that your accelerator provides both for DB2 for z/OS and non-Db2 for z/OS data. Joining data from DB2 for z/OS, IMS, VSAM and Oracle within a single query that runs on an accelerator ? Of course. Accessing IMS data via SQL in an accelerator ? Sure. Analyze SMF data using SQL ? No-brainer.

See Figure 1 for an illustration of the previously discussed concept.

Figure 1: Illustration of IBM Db2 Analytics Accelerator Loader for z/OS

   Figure 1: Illustration of IBM Db2 Analytics Accelerator Loader for z/OS


In addition to these capabilities, Loader can help to simplify your operational processes by

  • loading the same data into multiple accelerators at the same time
  • loading data into Db2 for z/OS and one or more accelerators in one step, saving you the additional effort to invoke the ACCEL_LOAD_TABLES stored procedure once data has been loaded into Db2 for z/OS
  • loading data consistently into multiple tables as they were at a prior point in time for point-in-time analysis

If you’re interested to find out more or explore the technology by yourself, please contact your IBM Technical Sales representative.

 



#Db2forz/OS
#IDAA
0 comments
10 views

Permalink