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