LOOK Systems Training
Ingres Operations Management
Ref: LKIOM
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.
|
Topics |
|
|
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 Users |
The accessdb utility The iidbdb database Creating and Destroying Databases infodb The Transaction Logging System The Journaling System Checkpoints and Checkpoint Templates Database Recovery The Locking System Monitoring Ingres with IPM Terminal Definitions |