INFORMIX-OnLine Dynamic Server System Administration: Distributed Systems

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers, database and system administrators, and technical support personnel

Prerequisites

The course INFORMIX-OnLine Dynamic Server System Administration: Managing the Instance; the course Relational Principles and the SQL Programming suite; a knowledge of the UNIX operating system is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To introduce distributed transactions and the process of data replication

Learning Objectives

Discuss distributed transactions. Explain the two-phase and heterogeneous protocols. Describe distributed transaction coordination. Explain distributed transaction recovery. Detect and resolve blocked transactions. Explain heuristic decisions. Configure two database servers for data replication. Access the client application primary and secondary server. Recover the primary and secondary servers in case of failure.

Topics Covered

Multiphase commit protocols - Two-phase commit - Heterogeneous commit Distributed transaction recovery - Multiphase commit recovery - Blocked transactions Data replication - About data replication - Configuring data replication - Hands-on: Setting parameters - Failure recovery