Using ADSM to Back Up Databases

This book is written for IBM, customer, vendor, and consultant personnel who want to understand how to use ADSTAR Distributed Storage Manager (ADSM) to back up databases or learn how to integrate ADSM with database and operating system backup utilities. It is organized in four parts that describe techniques
for backing up Oracle, Informix, Sybase, DB2/6000, and DB2/2 databases. The techniques are also applicable to other database products. Part 1 is a primer on ADSM and databases. It provides an overview of ADSM, relational databases, and basic techniques for database backup and recovery. Part 2 focuses on backup and recovery of Oracle7 and Oracle8 databases. It provides detailed examples of using the Oracle7 Enterprise Backup Utility (EBU) and Oracle8 Recovery Manager (RMAN) products with IBM's ADSMConnect Agent, SQL-BackTrack from BMC Software, and IBM's BACKINT/ADSM product for Oracle databases in a SAP R/3 environment. Part 3 covers backup and recovery of Sybase and Informix databases using ADSM. Part 4 covers backup and recovery of DB2/2 and DB2/6000 with ADSM. It also covers backup and recovery with IBM's DataHub product. ADSMPIPE, a tool used to pipe raw device data directly to ADSM, is described for use in backing up databases installed on UNIX raw logical partitions.

Chapter 1. Introduction to ADSM 1.1
Chapter 2. Relational Databases 1.2
Chapter 3. Relational Database Backup 1.3
Chapter 4. Exploiting ADSM 1.4
Chapter 5. Automating Database Backups 1.5
Chapter 6. Oracle Backup Basics 2.1
Chapter 7. Oracle7 Enterprise Backup Utility 2.2
Chapter 8. Oracle8 Recovery Manager 2.3
Chapter 9. SQL-BackTrack 2.4
Chapter 10. SAP R/3 Oracle and BACKINT/ADSM 2.5
Chapter 11. ADSM and INFORMIX-OnLine 3.1
Chapter 12. ADSM and Sybase 3.2
Chapter 13. ADSM and DB2/6000 4.1
Chapter 14. ADSM and DB2/2 4.2
Chapter 15. ADSM and DataHub 4.3
Appendix A. Database Configuration Files A.0
Appendix B. AIX and OS/2 Backup Utilities B.0
Appendix C. ADSMPIPE: Raw Logical Volume Backups with the API C.0
Appendix D. ADSM Database Matrices D.0
Appendix E. ADSM API Files: Location and Environment Variables E.0
Appendix F. Special Notices F.0
Appendix G. Related Publications G.0

Publish Date
05 August 1998

Rating: Not yet rated

Rate this book

Author(s)
Tim Mortimer
Dale McCurdy
Malkit Hayun
Frank Sarstedt
Georg Ember
Cyndie Behrens

ISBN
0738400343

IBM Form Number
SG24-4335-03

Number of pages
616