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.
This tutorial describes the locking mechanism in IBM Informix Dynamic Server 11.50. It discusses isolation levels and their effects; and it also introduces you to the monitoring of isolation levels and locks.
At the end of the tutorial, you should be able to:
- Understand the lock management in IDS
- Identify isolation levels and their effects
This tutorial is written for users with basic knowledge of Structured Query Language (SQL).
To understand and test the concepts discussed in this tutorial, you need a running instance of IDS 11.50.