Introducing Vector System Administration
Audience
The System Administrator Guide is designed for the system administrator who has overall responsibility for the operation of the Vector installation. The system administrator must have a solid working knowledge of operating system management or be in close contact with the operating system administrator.
System Administrator Responsibilities
The system administrator has all privileges and holds the primary responsibility for installing and maintaining Vector. The system administrator (often referred to as the installation owner) owns the user ID specified during installation. Logging in as this user provides permissions that are needed for installation and maintenance.
The system administrator has the following responsibilities:
• Installing Vector (and optional components)
• Authorizing users to access Vector
• Defining Vector 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 installation (or its components)
System Administration Summary
The following table is a quick reference to the commands or utilities used to perform system administration tasks. Refer to the appropriate chapter or guide for details. Many of these tasks can be also performed using Actian Director or the Visual Tools on Windows.
Special Considerations
Before using this guide, you should be aware of the following issues.
Vector installations can be administered in compliance with the C2 security standard.
Vector is compliant with ISO Entry SQL92. In addition, numerous vendor extensions are included. For details about the settings required to operate in compliance with ISO Entry SQL92, see the SQL Language Guide.
Query Language Used in this Guide
The industry standard query language, SQL, is used as the standard query language throughout this guide.
System-specific Text in this Guide
Generally, Vector operates the same way on all systems. When necessary, however, this guide provides information specific to your operating system. For example:
Linux: Information is specific to the Linux environment.
Windows: Information is specific to the Windows environment.
When necessary for clarity, the symbol
is used to indicate the end of system-specific text.
For sections that pertain to one system only, the system is indicated in the section title.
Path Notation in this Guide
The directory structure of a Vector installation is the same regardless of operating system. Rather than showing path examples for all environments, this guide uses Linux notation only.
For example: When describing the location of the collation sequence file, the guide shows: $II_DATABASE/ingres/data/vectorwise/vectorwise.conf
where $II_DATABASE is the value of the Vector environment variable II_DATABASE displayed by the ingprenv command.
On Windows, the location is: %II_DATABASE%\ingres\data\vectorwise\vectorwise.conf
Terminology Used in this Guide
This guide uses the following terminology:
• A command is an operation that you execute at the operating system level. An extended operation invoked by a command is often referred to as a utility.
• A statement is an operation that you embed within a program or execute interactively from a terminal monitor.
Note: A statement can be written in Ingres 4GL, a host programming language (such as C), or a database query language (such as SQL).
Syntax Conventions Used in this Guide
This guide uses the following conventions to describe syntax: