System Administrator Guide : 1. Introducing Vector System Administration
 
Share this page                  
Introducing Vector System Administration
 
Audience
System Administrator Responsibilities
System Administration Summary
Special Considerations
Query Language Used in this Guide
System-specific Text in this Guide
Path Notation in this Guide
Terminology Used in this Guide
Syntax Conventions Used in this Guide
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.
Task
Command or Utility
Start Vector
ingstart
Stop Vector
ingstop
Set Vector configuration parameters in config.dat
cbf, iisetres
List, set, or unset Vector installation variables
ingprenv
ingsetenv
ingunset
Monitor the installation
vwinfo, ipm
Configure Ingres Net
netutil
Grant installation privileges
(For details, see the Security Guide.)
GRANT...ON CURRENT INSTALLATION
Display information on process and system resources
syscheck
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:
Convention
Usage
Monospace
Indicates key words, symbols, or punctuation that you must enter as shown
Italics
Represent a variable name for which you must supply an actual value
[ ] (brackets)
Indicate an optional item
{ } (braces)
Indicate an optional item that you can repeat as many times as appropriate
| (vertical bar)
Separates items in a list and indicates that you must choose one item