Backing Up Databases Using ADSMPIPE and the TSM API: Examples Using Linux
An IBM Redpaper publication
Note: This is publication is now archived. For reference only.
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.
Preparation and requirements
Downloading and building adsmpipe
Backing up MySQL
Backing up PostgreSQL
Backing up OpenLDAP
Building an RPM for adsmpipe