ULTRIX/SQL Database Adminstrator’s Guide

This "ULTRIX/SQL Database Administrator's Guide," published in June 1990, is designed for ULTRIX/SQL Database Administrators to manage ULTRIX/SQL databases. It covers ULTRIX/SQL Version 1.0, based on INGRES Release 6.2, running on ULTRIX Version 4.0 or higher.

The guide provides comprehensive information on:

• User Roles and Authorization: Describing different user types (Operating System Administrator, ULTRIX/SQL System Administrator, Database Administrator, and End User) and how to authorize and manage user access using utilities like accessdb and user files.
• Database Management: Instructions for creating, maintaining (including using alternate storage locations), and destroying databases using commands like createdb and destroydb, as well as listing database information with accessdb and catalogdb.
• Table and View Operations: How to create, modify (adding, changing, deleting columns, handling duplicate rows), and move tables and views within the database.
• Data Loading and Unloading: Methods for populating tables using the copy statement, and for unloading/reloading entire databases or selected tables using unloaddb and copydb commands, including considerations for data integrity and transferring data between different system architectures.
• Locking System: A detailed explanation of ULTRIX/SQL's locking mechanisms, including lock types, levels, user-controlled locking, and strategies for avoiding deadlocks and improving concurrency, along with tools like lockstat for monitoring.
• Backup and Recovery: Various methods for backing up databases (checkpoints, journaling, operating system backups) and recovering them using commands like ckpdb and rollforwarddb.

The document assumes familiarity with ULTRIX/SQL and the ULTRIX operating system.