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

Describes how to add, alter, and drop objects from an
SQL/MX database.
“Adding, Altering, and Dropping SQL/MX Database
Objects” (page 150)
Describes how to reorganize SQL/MX tables and maintain
the data.
“Reorganizing SQL/MX Tables and Maintaining Data”
(page 178)
Describes how to manage SQL/MX applications.“Managing Database Applications” (page 212)
Describes how to perform recovery operations on an
SQL/MX database.
“Performing Recovery Operations” (page 235)
Describes methods for managing an SQL/MX distributed
database.
“Managing an SQL/MX Distributed Database” (page 266)
Describes how to measure SQL/MX database performance.“Measuring Performance” (page 284)
Describes how to enhance database performance.“Enhancing SQL/MX Database Performance” (page 293)
Describes how to use MXTOOL to obtain Guardian names
for the NonStop Transaction Management Facility (TMF),
the Remote Database Facility (RDF), and Measure.
“Using Guardian Names with TMF, RDF, and Measure”
(page 309)
Notation Conventions
General syntax notation
This list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS. Uppercase letters indicate keywords and reserved words.
Type these items exactly as shown. Items not enclosed in brackets are required. For
example:
MAXATTACH
lowercase italic letters. Lowercase italic letters indicate variable items that you
supply. Items not enclosed in brackets are required. For example:
file-name
computer type. Computer type letters within text indicate C and Open System
Services (OSS) keywords and reserved words. Type these items exactly as shown.
Items not enclosed in brackets are required. For example:
myfile.c
italic computer type.Italic computer type letters within text indicate C and
Open System Services (OSS) variable items that you supply. Items not enclosed in
brackets are required. For example:
pathname
[ ] Brackets. Brackets enclose optional syntax items. For example:
TERM [\system-name.]$terminal-name
INT[ERRUPTS]
A group of items enclosed in brackets is a list from which you can choose one item
or none. The items in the list can be arranged either vertically, with aligned brackets
on each side of the list, or horizontally, enclosed in a pair of brackets and separated
by vertical lines. For example:
FC [ num ]
[ -num ]
[ text ]
K [ X | D ] address
{ } Braces. A group of items enclosed in braces is a list from which you are required
to choose one item. The items in the list can be arranged either vertically, with
Notation Conventions 15