SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

NonStop SQL/MX imposes these restrictions on the types of operations you can run on SQL/MP
tables:
• DDL and utility operations on SQL/MP tables must be run from NonStop SQL/MP, either from
SQLCI or an SQL/MP application. You cannot invoke DDL or utility operations on SQL/MP
tables from NonStop SQL/MX.
• DML operations on SQL/MP tables can be run from NonStop SQL/MX.
Through its Guardian environment, the NonStop OS provides additional utilities and subsystems
for managing an SQL/MX database. Collectively, these utilities and subsystems are known as the
NonStop Tools. You use these tools primarily in recovery operations, in moving a database, or in
reorganizing a database online. Table 3 (page 28) summarizes these software products.
Table 3 NonStop Tools for SQL/MX Database Management
DescriptionProgram
Copies Guardian files and OSS files from disk to magnetic tape.BACKUP
Loads and maintains SQL/MX and SQL/MP databases (designed for large DSS tables).DataLoader/MX
Moves disk file extents to yield more usable space on a disk.DCOM
Disk Space Analysis Program; analyzes use of space on disk volumes, reporting on factors
such as free space availability and extent allocation.
DSAP
Checks internal consistency of structured files and reports consistency errors. The FCHECK
verifies the integrity of individual SQL/MX data rows, checking row length and field offsets
to make sure they are within acceptable limits.
FCHECK
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. The FUP commands
FUP
INFO, LISTLOCKS, LISTOPENS, and RELOAD support the use of ANSI names for SQL/MX
objects.
Collects performance statistics on SQL/MX objects, including information about processes,
SQL/MX statements, and file activity.
Measure Product
The OSS command line utility from which you can run the FIXUP, GOAWAY, INFO, and
VERIFY OSS command-line utilities.
mxtool
Copies Guardian files from magnetic tape to disk. The files on tape must have been written
by BACKUP.
RESTORE
Protects network and system resources, such as Guardian disk volumes, from unauthorized
access.
Safeguard Product
Performs various operations on peripherals and operating system resources, including disk
volumes, in the SQL/MX database environment.
Subsystem Control
Facility (SCF)
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.
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.
UPDATE STATISTICS
Monitors disk input and output and cache memory use.VIEWSYS
28 Introduction to SQL/MX Database Management