Using IBM DB2 Analytics accelerator expedited Batch Processing

Brief introduction

IBM DB2 Analytics Accelerator is a workload-optimized device that enables companies to integrate business insights into processes to advance the implementation of successful strategies. It combines System Z service quality with the hardware acceleration analysis of IBM DB2 Analytics Accelerator to speed up complex queries and provide unprecedented response time in a highly secure and reliable environment.

A key element of DB2 Analytics Accelerator is its transparent integration into DB2, which enables faster response times and fewer mainframe CPU loads while running intact workloads and queries.

Swiss Re has been looking for ways to make its IT environment more cost-effective and performance-efficient. Thus, over the past few years, it has transformed its financial reporting system from the COBOL batch system into a Java batch system on z/OS. This can achieve huge cost savings.

To achieve further breakthroughs, the company introduced IBM DB2 Analytics Accelerator to speed up the execution of batch jobs and migrate workloads to accelerator devices, freeing up capacity for use by other applications.

Solution

The reporting system for Swiss RE is a batch system running on z/OS. In the past few years, data growth has posed some challenges, prompting Swiss Re to work with IBM to implement innovative solutions that enable it to control costs and improve performance to meet new business challenges.

The first step is to convert the batch process from COBOL to Java by leveraging the WebSphere Compute Grid on z/OS. This allows the Swiss Re to unload a large portion of the workload onto System z application Assist Processor, while continuing to use the same application interface, as well as the same database and data model.

Then, the second step is to unload the database processing portion of the workload onto the external device. The introduction of IBM DB2 Analytics Accelerator enables the company to achieve this goal and evolve towards a new era of optimization.

IBM DB2 Analytics Accelerator

IBM DB2 Analytics Accelerator is integrated behind the application layer in DB2 for z/OS environments. This provides complete transparency for end users and applications that submit queries to the DB2 for z/OS subsystem. You can take advantage of IBM DB2 Analytics accelerator without making changes to your connection or application design. This avoids many of the training and integration issues associated with deploying new technologies.

Table-level data must be easily loaded into the Analytics accelerator through a single GUI (IBM data Studio). Starting with V3, keeping the data up to date is automated, and changes to the underlying tables are automatically replicated to the accelerator.

Transparent access to IBM DB2 Analytics accelerator via DB2

With the introduction of IBM DB2 Analytics Accelerator, you now have a number of options available to handle queries in an existing DB2 for z/OS environment.

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/db2/