SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—523723-004
1-19
SQL/MX Database Management Tools
FCHECK Checks internal consistency of structured files and reports consistency
errors.
FUP File Utility Program; reorganizes SQL/MX files while they are in use,
licenses programs, and uses INFO to obtain useful information about
SQL/MX objects and files.
Measure
Product
Collects performance statistics on SQL/MX objects, including information
about processes, SQL/MX statements, and file activity.
mxtool The OSS command line utility from which you can run the FIXUP,
GOAWAY, INFO, and VERIFY OSS command-line utilities.
RESTORE Copies Guardian files and OSS 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.
Subsystem
Control Facility
(SCF)
Performs various operations on peripherals and operating system
resources, including disk volumes, in the SQL/MX database
environment.
Tandem
Advanced
Command
Language
(TACL)
•
Provides the command interpreter for the Guardian environment.
•
Provides an interactive user interface to a NonStop system through
the operating system.
•
Enables users to run various system utilities, such as FUP,
BACKUP, and RESTORE.
VIEWSYS Monitors disk input and output and cache memory use.
Table 1-4. NonStop Tools for SQL/MX Database Management (page 2 of 2)
Program Description