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

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—544536-007
1-15
SQL/MX Database Management Tools
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. For SQL/MX Release 2.3.1, the FUP
commands INFO, LISTLOCKS, LISTOPENS, and RELOAD support the
use of ANSI names for SQL/MX objects.
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 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.
UPDATE
STATISTICS
Updates histogram statistics for one or more groups of columns in an
SQL/MX table and physical statistics for table partitions. The histogram
statistics are used to devise optimized access plans.
VIEWSYS Monitors disk input and output and cache memory use.
Table 1-3. NonStop Tools for SQL/MX Database Management (page 2 of 2)
Program Description