SEP sesam Extension for IBM DB2

(C)SEP AG

Copyright 1999-2011 by SEP AG. All Rights reserved.

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

Introduction

SEP sesam online backup for IBM DB2 (sdb2) provides a XBSA interface between DB2 and SEP sesam for saving data of DB2 databases to sesam server. XBSA API specifies the access from DB2 db2 backup utility to a backup application. SEP sesam will manage the whole backup media handling like loading the correct tapes, whereas db2 backup decides which data has to be saved or recovered. This document provides information about the sesam specific parts of DB2 backups. It's not a DB2 backup administration guide. Please read DB2 administration documentation to get familiar with DB2's backup and recovery concepts and tools.

System requirements

• IBM DB2 7/8 on Linux

• SEP sesam Version 2.4 or higher

• SEP sesam Extension for IBM DB2

• the standard SEP sesam Backup Client is already installed

• working SEP sesam file system backups for this client

Installation

The SEP sesam DB2 package only includes one shared library which DB2 server loads dynamically during backup or restore. Please adjust the paths and variables according to your needs.

• <SESAM_ROOT>/opt/sesam/bin/sesam (SEP sesam installation directory)

Installation on Linux or Unix

• First, verify that the standard SEP sesam Backup Client is already installed

• File system backup should work with this SEP sesam Client

• Login as root user

• Unpack tar file to a temporary directory

• Copy db2xbsa.so to <SESAM_ROOT>/bin/sesam directory

Configuration

Configuration on sesam server

Create a new backup task for the DB2 server with task type DB2 UDB. Specifying a backup source is not important because DB2 decides which data has to be saved.

Configuration on DB2 server

To give DB2 the necessary information to connect to SEP sesam, the following options can be set:

Mandatory parameters

• SESAM SERVER Name of SEP sesam server

• SESAM JOB Jobname of DB2 backup name of an already configured task on sesam server with task type DB2 UDB

• SESAM POOL Media pool name of an already configured media pool on sesam server

Optional parameters

• SESAM TAPE SERVER Name of tapeserver to use

• SESAM DRIVE Drive number to use

• XBSA TRACE=<Trace level> (0|1|2)

• XBSA LOGFILE=<Full pathname of trace file sdb2.log>

Although XBSA TRACE and XBSA LOGFILE are not mandatory, they should be set to get information in case of problems during backup or restore. For restore only SESAM SERVER and SESAM JOB are mandatory.

DB2 Backup and Restore Configuration

The following examples show, how backup or restores can be started on DB2 server. They do not cover all functions of DB2, but should give some hints for using DB2 backup and SEP sesam together.

Backup of complete database

Restore of complete database

Install into DB2 default library directory

Instead of copying the shared library into <SESAM_ROOT>/bin/sesam directory and specifying the path by the 'LOAD' command you can put it into the DB2 library directory on the DB2 server, too. Please adjust the paths and variables according to your needs.

• DB2DIR=/opt/IBM/db2/V8.1 (the DB2 product directory)

Then the db2 backup command has to be changed slightly. The 'LOAD' parameter is replaced by 'USE XBSA'.

Trouble shooting

• Check contents of db user's $HOME/sqllib/db2dump/db2diag.log file.

• Check the messages on SEP sesam server.

• More information can be found in the sdb2 logfile. Logfile name is set by XBSA LOGFILE=<Full pathname of sdb2.log> and loglevel by XBSA TRACE=1. All sesam XBSA messages have the prefix XBSA. For more information XBSA TRACE can be set to 2, but then the logfiles can become quite large.

Further Links/Literature

• SEP sesam Extension for DB2
• SEP sesam IBM DB2 Administration Guide
• Data Recovery and High Availability Guide Reference
• System Management: Backup Services API (XBSA)
• Backup Services Application Programmer's Interface