Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Ultrix SQL_1.0/mips

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Anchors

Section 1sql

Section 8sql

Manual — Ultrix SQL_1.0/mips

33 entries

Section 1sql (intro)

auditdbprint changes recorded in database journal files
catalogdblist databases, database locationnames and extensions, and user capabilities. 
ckpdbcheckpoint (back up) a database. 
copydbcreates command files to copy out a database and restore it. 
createdbcreate a database. 
destroydbdestroy an existing database. 
introIntroduction to ULTRIX/SQL commands in Section 1
isqlinvoke the forms-based, interactive-only version of the ULTRIX/SQL terminal monitor
rollforwarddbrecover an ULTRIX/SQL database from the last checkpoint and the current journal. 
sqlinvoke the ULTRIX/SQL terminal monitor
unloaddbcreate command files for complete unloading and reloading of a database. 

Section 8sql (intro)

accessdbauthorize access to a database and modify database locations, extensions, and user authorization. 
cscleanupdeallocates shared memory and semaphore resources used by ULTRIX/SQL
csinstallallocates shared memory and semaphore resources for use by ULTRIX/SQL
csreportdisplays information about shared memory and semaphore resources used by ULTRIX/SQL
finddbsrecover ULTRIX/SQL when iidbdb is corrupted, or when an entry for a user-defined database is missing. 
iibuildinitializes and starts up the ULTRIX/SQL system
iimonitormonitors and administers database management system servers for an ULTRIX/SQL system
iinamudisplays information about and manages different types of ULTRIX/SQL servers and starts and stops the name server
iirunstart up ULTRIX/SQL archiver and recovery processes
iirungccstart up ULTRIX/SQL communications server processes
iirungcnstart up ULTRIX/SQL name server process
iishutdownshut down all or some elements of ULTRIX/SQL installation
iistartupstart up all or some elements of ULTRIX/SQL installation
introIntroduction to ULTRIX/SQL commands in Section 8
lockstatdisplay information about ULTRIX/SQL locking status
logstatdisplay information about ULTRIX/SQL logging (recovery) system
netuULTRIX/SQL network management utility
optimizedbgenerate statistics for use by the optimizer. 
rcpconfigconfigures or shuts down the ULTRIX/SQL logging and locking facilities
statdumpprint statistics available through the iistats and iihistograms views of the Standard Catalog Interface. 
syscheckChecks the ULTRIX/SQL system configuration for minimum memory, semaphores, and swap space requirements
sysmodmodify system tables to predetermined storage structures. 

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026