Ingres® 2006 - System Administrator Guide

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Ingres® 2006 - System Administrator Guide
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Ingres® 2006 - System Administrator Guide
     Copyright © Ingres Corporation



Responsibilities of a System Administrator

The system administrator has all privileges and holds the primary responsibility for installing and maintaining Ingres. The system administrator (often referred to as the installation owner) owns the user ID specified during Ingres installation. Logging in as this user provides permissions that are needed for installation and maintenance.

The system administrator has the following responsibilities:
  •   Installing Ingres (and optional components)
  •   Authorizing users to access Ingres
  •   Defining Ingres variables such as II_DATABASE and II_INSTALLATION
  •   Starting, stopping, configuring, and monitoring servers
  •   Disconnecting or suspending a session connected to a server
  •   Shutting down the Ingres installation (or its components)

Components of an Ingres Installation

The system administrator installs and maintains the following principal components or associated family of compatible components:
  •   DBMS Server
  •   Internet Communication
  •   General Communication Facility
  •   Querying and reporting tools
  •   Visual tools
  •   Logging and locking systems
An Ingres installation also has:
  •   Library files and utilities, provided with the product distribution
  •   Configuration files and error log files, created during installation and at runtime by Ingres
  •   Databases and their associated files: the checkpoint, journal, dump, and work files, also created by Ingres during installation and at runtime
The locations of these files are selected at installation time, together with the  configuration of the Ingres DBMS Servers and the logging and locking systems. For the initial installation, default settings are provided by the system whenever possible.

After the installation is running, all Ingres servers must be monitored to ensure that they are running and that they are configured for top performance. You can also configure selected Ingres parameters.