This IBM Redpaper describes how you can use the IBM Tivoli® Storage Manager (TSM) application programming interface (API) with the ADSMPIPE utility to perform online backups of various databases. This process eliminates dumping data to a file (and consuming disk space) so that the TSM backup and archive client can back up the data.

This paper uses examples of specific databases running on Linux® (MySQL, PostgreSQL, and OpenLDAP); however, the techniques apply equally for these and other databases running on any UNIX® operating system. They are intended for database applications that have no dedicated TSM applications available

This procedure may be used for any database where you can dump the data to STDOUT and pipe it to TSM for storage. The TSM API stores the STDOUT data in your TSM storage hierarchy and optionally compresses the data before sending it to TSM..

Accompanying configuration files are provided to implement the features described in this paper. These can be downloaded from the following URL: ftp://www.redbooks.ibm.com/redbooks/REDP3980.

Introduction

Preparation and requirements

Downloading and building adsmpipe

Backing up MySQL

Backing up PostgreSQL

Backing up OpenLDAP

Building an RPM for adsmpipe