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

HP NonStop SQL/MX Installation and Management Guide—523723-004
1-1
1
Introduction to SQL/MX Database
Management
This section provides an introduction to managing an SQL/MX database. For
information about managing an SQL/MP database, see the SQL/MP Installation and
Management Guide.
Managing an SQL/MX relational database typically involves managing sets of
continuously active programs, as well as the database itself. In this environment, you
will need to add new applications and disk volumes and repair or change existing
applications, all without affecting other applications currently running on your system.
This section addresses these topics:
•
SQL/MX Database Features on page 1-2
•
Naming Database Objects on page 1-7
•
SQL/MX Metadata on page 1-8
•
SQL/MX Database Object Types on page 1-10
•
Versioning Issues on page 1-12
•
SQL/MX Environment on page 1-15
•
Database Management Tasks on page 1-17
•
SQL/MX Database Management Tools on page 1-17
In this manual, the descriptions of managing a database are based on these
assumptions about the database environment at your site:
•
An application includes database components (tables, indexes, and views) and the
programs that access the database. Database definitions, configuration, and
distribution can significantly affect application performance. An SQL/MX database
that contains SQL/MX tables, SQL/MP tables, or both, is an integral part of an
application.
•
The database is a production database, not a test database. The database must
be consistent, accurate, and available.
•
Application development is ongoing. New or changed applications need to be
integrated with existing applications.
•
Central database management is required. The database management tasks might
be performed by groups of people, but these tasks should be administered by a
single person or group.