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.

thumbnail 

Published on March 11, 2005

  1. .PDF (0.4 MB)

Share this page:   

IBM Form #: REDP-3980-00


Authors: Deon George

    menu icon

    Abstract

    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.

    Table of Contents

    Introduction

    Preparation and requirements

    Downloading and building adsmpipe

    Backing up MySQL

    Backing up PostgreSQL

    Backing up OpenLDAP

    Building an RPM for adsmpipe

     

    Others who read this also read