Ingres DBA Handbook Index
The handbook was begun by John Prudhoe in 1998 as a reference aid to Ingres DBA’s. By the end of 2001 when over four hundred pages had been written the work was put on a back burner as it was starting to impinge on his job. Since then Ingres has moved on but since much of the material remains very relevant, we decided to make it available to the Ingres community via the IUA website.
Please note that the handbook, as published, is not yet complete and there will be missing chapters where time has not allowed for these to be started or completed. Anyone who feels they can contribute to completing these chapters can contact John or the webmaster with their contact details to discuss which sections they can contribute to.
Disclaimer: Neither the IUA, John Prudhoe or DBA Handbook contributors take any responsibility whatsoever for an omission or errors in the handbook. Any techniques or scripts used are the sole responsibility of the administrator and any scripts should be thoroughly tested before use in a production environment.
Handbook Index
- Introduction
- Housekeeping
- Ingres Tables
- Isam Tables
- Btree Tables
- Hash Tables
- Heap Tables
- Ingres Tables 2
- Basic Ingres Architecture
- The Optimiser and QEPs
- Transaction Logging System
- The Locking System
- The Database Servers
- Checkpointing
- Rollforward and Recovery
- Disk Arrangements and Ingres
- Users, Security and Integrity
- Time, Dates and Language
Published Index
DBA Handbook Ch0 Trailer
DBA Handbook Ch1-3 Introduction
DBA Handbook Ch100-108
Rollforward Recovery
DBA Handbook Ch123-124 Date
Language
DBA Handbook Ch13-14 Tables
DBA Handbook Ch15-17
Isam Tables
DBA Handbook Ch18-23 Btree
DBA Handbook Ch24-27
Hash Tables
DBA Handbook Ch28 Heap Tables
DBA Handbook Ch29-35
Tables II
DBA Handbook Ch36-47 Basic
Architecture
DBA Handbook Ch48-56
Query QEP
DBA Handbook Ch57-68 Logsys
DBA Handbook Ch68-76 Locks
DBA Handbook Ch94-98 Checkpointing
handbDBA Handbook Ch4-11
Housekeeping