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.
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: