Before you start
This complimentary series of nine tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11.50 Fundamentals certification exam (555). This certification exam will test your knowledge of entry-level administration of IDS 11.50, including basic SQL (Structured Query Language), how to install IDS 11.50, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and data replication technologies and purposes. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
In this tutorial, learn about backup and restore concepts and processes, and about utilities to back up and restore database server data. The material provided here primarily covers the backup and restore objectives of the exam.
After completing this tutorial, you should be able to gain a basic understanding of:
- Essential backup and restore concepts
- Configure ON-Bar for the storage manager
- Back up database server data with ON-Bar
- Restore database server data with ON-Bar
- Set up configuration parameters for ontape
- Back up database server data with ontape
- Restore database server data with ontape
- Table-level restore with archecker
This tutorial is written for up-and-coming database administrators (DBAs). Basic IDS concepts knowledge is needed.
To complete this tutorial, you do not need a copy of IDS. However, if you have one available to use, you will definitely get more out of the tutorial. If you don't have a copy already, you can download a free trial version (see Resources).