SQL/MP Installation and Management Guide

The SQL/MP Database Management Environment

HP NonStop SQL/MP Installation and Management Guide—523353-004

1-14

Database Management Tools

Table 1-2. NonStop Tools for Database Management

Program Description

BACKUP Copies Guardian files from disk to magnetic tape.

DataLoader/

Loads and maintains SQL/MP databases (designed for large decision

support system (DSS) tables).

DSAP Disk Space Analysis Program: analyzes use of space on disk volumes,

reporting on factors such as free space availability and extent allocation.

FILCHECK Checks internal consistency of structured files and reports consistency

errors.

FUP File Utility Program: reorganizes key-sequenced files while they are in use,

licenses programs, and obtains information about SQL objects and files.

Measure

Product

Collects performance statistics on SQL objects, including information about

processes, SQL statements, and file activity.

PERUSE Invokes the PERUSE utility program.

PUP Peripheral Utility Program: A utility used in D-series and earlier RVUs to

manage disks and perform various operations on disk volumes in the

SQL/MP database environment. In G-series RVUs, PUP functions are

performed by the SCF.

RESTORE Copies Guardian files from magnetic tape to disk. The files on tape must

have been written by BACKUP.

Safeguard

Product

Protects network and system resources, such as Guardian disk volumes,

from unauthorized access.

SCF Subsystem Control Facility: An interactive interface for configuring,

controlling, and collecting information from a subsystem and its objects. SCF

enables you to configure and reconfigure devices, processes, and some

system variables while your HP NonStop S-series server is online.

TACL Tandem Advanced Command Language, the command interpreter for the

Guardian environment; provides an interactive user interface to a NonStop

system through the operating system; enables users to run SQLCI and

various system utilities, such as FUP, BACKUP, and RESTORE; and

enables users to start SQL/MP processes.

TEDIT

EDIT

Tandem PS Text Edit and EDIT text editor programs: used to create OBEY

command files, generate SQLCI command strings, and read SQLCI log files.

VIEWSYS Monitors disk input and output and cache memory use.