Db2

 View Only

Using IBM InfoSphere Optim High Performance Unload as part of a Recovery Strategy

By Indira Kumar posted Tue December 06, 2022 10:24 AM

  

Executive Summary

This paper is targeted at those involved in planning, configuring, designing, implementing, or administering a data warehouse based on DB2® Database for Linux®, UNIX, and Windows® software. The examples in this paper apply generally but are focused on the IBM ®Smart Analytics System based on System x® and Power SystemsTM servers.

IBM InfoSphere Optim® High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows V4.2 is a highspeed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. HPU is designed to extract data from DB2 incremental and delta backup images and from DB2 table space containers. HPU has additional uses in data migration and repartitioning that will be dealt with in future paper.

The focus of a database backup and recovery strategy should be the recovery plan. The paper Building a Recovery Strategy for an IBM Smart Analytics System discusses best practice recommendations for backup and recovery using the native DB2 software commands. Although not recommended for full database recovery, HPU can be effective in speedily recovering discrete pieces of data from tables and table spaces.

The database is not affected by the HPU process and table spaces do not need to be placed in an offline state. HPU can therefore offer advantages over other recovery methods in data availability and processing speed. Incorporating HPU into your recovery strategy for scenarios involving data loss or corruption can help achieve service level objectives for data availability and data recovery.

Using the recommendations in this paper can help you develop a strategy that uses HPU to complement your existing recovery strategy.


Introduction

This paper describes best practices for incorporating the use of HPU into your recovery strategy and implementing HPU for an IBM Smart Analytics System data warehouse. The paper covers how to unload data from backup images.

To use this paper, you should have a basic knowledge of HPU software as well as DB2 software as implemented in an IBM Smart Analytics System. The further reading section in this paper contains links to product documentation and papers referenced throughout the paper.

The first section of the paper discusses how to incorporate HPU into a recovery strategy and when to use HPU to meet your recovery objectives.

The second section contrasts the use of output files and named pipes and discusses introducing parallelism.

The third section reviews the HPU command and control file and recommends best practices for creating control files.

The fourth section of the paper details how to install and configure HPU in an IBM Smart Analytics System.

The appendixes outline the configuration of the test system used in developing this paper and also contain examples of using HPU in common recovery scenarios.

This paper builds on and complements a series of best practices papers that discuss aspects of a DB2 data warehouse. Refer to these papers for further information.

Download the report to get started! 


#Db2
0 comments
1 view

Permalink