LOOK Systems Training

Ingres Operations Management


This three day course provides a detailed overview of the Ingres II relational database system. It is designed to enable delegates to manage an Ingres installation: to configure the environment, set up databases and ensure reliability and integrity.

Delegates should be familiar with the appropriate (UNIX) operating system and have experience of systems management and ideally some experience of a relational database.

The course uses a hands on approach. At the end of the course the students should be familiar with Ingres architecture together with the various Ingres commands and facilities available to manage an Ingres installation.



Ingres Product Range and Architecture

Installing Ingres

Contents of the II_SYSTEM directory

The iibuild utility

File locations

Ingres environment variables

iistartup parameters and options

The Ingres server processes

The iishutdown utility

Error logs


The accessdb utility

The iidbdb database

Creating and Destroying Databases


The Transaction Logging System

The Journaling System

Checkpoints and Checkpoint Templates

Database Recovery

The Locking System

Monitoring Ingres with IPM

Terminal Definitions