Before you start
This tutorial teaches you about planning for an IDS installation. This planning consists of key questions that need to be answered, as well as where to get information about the product, its capabilities on your machine, and any pre-setup that might be needed.
After planning for the installation comes the actual installation. This tutorial talks about the different installation options available on each operating system and continues past installation into configuration of your first IDS instance, as well as how to start and stop that instance once it is configured.
With this knowledge you should be able to plan, install, and start an instance of Informix Dynamic Server that you can then use going forward with the rest of this series of tutorials. You should also be prepared to answer the types of questions asked in Section 1 of the certification exam.
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.
This tutorial is dedicated to covering the topics in Section 1 of the exam, titled "Planning and Installing IDS".
When you finish this tutorial, you should be able to perform the following:
- Explain the differences between IDS editions
- Describe different database applications
- Describe user setup and control, including role separation
- Understand the data types available in IDS, including both built-in and extensible types
- Explain and execute the different installation methods available on your platform
- Explain and execute the steps to configure an IDS instance
- Explain the different states of an IDS instance
- Execute commands to change the state of an IDS instance
This tutorial is written for up-and-coming database administrators (DBAs). Although some basic database concept knowledge may help, it is not necessarily 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).