Configuring tape-based backup with IBM Tivoli Storage Manager

Tivoli Storage Manager (TSM) is a storage management application you can use across your network. Backup and restores, archiving are available by means of a server usually dedicated to this task. DB2 has an interface that uses the TSM Application program interface (API), which integrates tape backup/restore facilities. Please refer to the documentation for your platform.

Getting ready

Since DB2 V9.7 comes only in 64-bit version, make sure Tivoli Storage Manager is also a 64-bit version. We will assume the TSM server is ready and configured and that the TSM client is installed. DB2 supports TSM, so the only step required is installing and configuring the API for TSM. If the .profile is not set, allow for an instance restart.

How to do it...

1. Install Tivoli Storage Manager API:

   Install as per operating instructions.

2. Create the dsm.opt configuration file for TSM:

   Replace TSM_DB2 with your server name, and save in /usr/tivoli/tsm/client...