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-18
SQL/MX Database Management Tools
SQL/MX statements, Guardian utilities, and SQL/MX utilities are the basic tools of the
SQL/MX database administrator. For more information about SQL/MX statements,
SQL/MX utilities, and MXCI commands, see the SQL/MX Reference Manual.
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 operating system 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 1-4 summarizes these software products.
Prepared SQL Compiled once and then executed any number of times within the
current session.
Embedded-only
SQL/MX
Embedded in SQL programs written in C, C++, COBOL, or Java.
Resource Control
and Optimization
Locks or unlocks tables and their indexes to limit other accesses
to the tables during DML statement execution.
Control Regulates the execution default options, plans, and performance
of DML statements.
Object Naming Sets the value of the NAMETYPE attribute, which in turn
determines whether object naming is ANSI or Guardian for the
current session.
SQL/MP alias Creates, alters, or deletes an SQL/MP alias for an SQL/MP table.
MXCI commands The SQL/MX extensions that typically affect attributes of an MXCI
session.
SQL/MX utilities Tools that run with NonStop SQL/MX or from the OSS shell and
perform such tasks as importing data, duplicating files, fixing
database discrepancies, and migrating metadata.
Table 1-4. NonStop Tools for SQL/MX Database Management (page 1 of 2)
Program Description
BACKUP Copies Guardian files and OSS files from disk to magnetic tape.
DataLoader/MX Loads and maintains SQL/MX and SQL/MP databases (designed for
large DSS tables).
DCOM Moves disk file extents to yield more usable space on a disk.
DSAP Disk Space Analysis Program; analyzes use of space on disk volumes,
reporting on factors such as free space availability and extent allocation.