ULTRIX/SQL Operations Guide

This document is the "ULTRIX/SQL Operations Guide" (June 1990, Version 1.0, based on INGRES Release 6.2), published by Digital Equipment Corporation. It serves as a comprehensive manual for System Administrators responsible for the installation, operation, and maintenance of the ULTRIX/SQL relational database management system running on ULTRIX Version 4.0 or higher (VAX or RISC environments).

The guide covers essential topics for managing ULTRIX/SQL, including:

• System Architecture: An introduction to ULTRIX/SQL's core components, such as the Logging and Locking System, General Communications Facility (GCF), and Database Management System (DBMS) Server.
• Installation and Configuration: Detailed procedures for initializing (iibuild), starting (iistartup), and shutting down (iishutdown) the system. It outlines critical system requirements (disk space, memory, semaphores, swap space) and configuration decisions, including setting up the transaction log file (regular or raw device).
• Maintenance Utilities: Descriptions and usage of various tools for monitoring and administering the installation, such as iimonitor (for DBMS server), iinamu (for Name Server), csreport (for shared memory/semaphores), lockstat (for locking status), and logstat (for logging status).
• Performance Tuning: Parameters and settings for optimizing the DBMS server, logging, and locking systems.
• Troubleshooting: Guidance on identifying and resolving problems by examining ULTRIX/SQL processes, reviewing various log files (error, archiver, recovery logs), and understanding system messages.
• User Access and Database Management: Instructions for authorizing user access to ULTRIX/SQL and specific databases using the accessdb utility, managing the system database (iidbdb), and defining terminal settings.
• System Recovery: Procedures and commands (rollforwarddb, finddbs) for restoring the system and databases after failures.
• Environment Variables: A comprehensive list and explanation of ULTRIX/SQL environment variables that control system behavior.
• Network File System (NFS) Integration: Specific configuration scenarios and considerations for running ULTRIX/SQL in an NFS environment, including shared installations for diskless clients and clients with local disks.
• Operating System Commands: A quick reference for ULTRIX/SQL-related commands used by the System Administrator.