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

Contents
About This Manual......................................................................................12
Supported Release Version Updates (RVUs)................................................................................12
Audience...............................................................................................................................12
Related Documentation............................................................................................................12
New and Changed Information................................................................................................14
Document Organization..........................................................................................................14
Notation Conventions..............................................................................................................15
General syntax notation...........................................................................................................15
Publishing history....................................................................................................................16
HP Encourages Your Comments................................................................................................17
1 Introduction to SQL/MX Database Management...........................................18
SQL/MX Database Features.....................................................................................................19
Distributed Databases.........................................................................................................19
Database Protection and Recovery.......................................................................................19
Data Integrity....................................................................................................................20
Multiple Character Sets......................................................................................................21
Database Security..............................................................................................................21
Parallel Processing.............................................................................................................21
High Availability................................................................................................................22
Naming Database Objects......................................................................................................22
ANSI Logical Names..........................................................................................................22
Guardian Physical Names...................................................................................................23
DEFINE Names.................................................................................................................23
PROTOTYPE......................................................................................................................23
Object Namespaces..........................................................................................................23
Using ANSI Names for SQL/MP Objects..............................................................................23
SQL/MX Metadata.................................................................................................................23
SQL/MX Database Object Types..............................................................................................24
The SQL/MX Environment........................................................................................................26
OSS Environment...............................................................................................................26
Privileges Required to Execute SQL/MX Utilities.....................................................................26
MXCS..............................................................................................................................26
NonStop Server for Java.....................................................................................................26
JDBC/MX Driver................................................................................................................26
Database Management Tasks...................................................................................................27
SQL/MX Database Management Tools......................................................................................27
2 Understanding and Planning SQL/MX Tables...............................................29
Planning Object Naming.........................................................................................................29
Avoid Renaming Nodes......................................................................................................29
Avoid Changing Object Names or Moving Database Objects.................................................29
Understand the Schema Ownership Rule...............................................................................30
Avoid Using Duplicate Catalogs on Multiple Distributed Nodes................................................30
Understanding SQL/MX Table and File Structures.......................................................................30
Using Keys in SQL/MX Tables and Indexes................................................................................31
Primary Key......................................................................................................................31
Clustering Key...................................................................................................................31
SYSKEY............................................................................................................................31
Partitioning Key.................................................................................................................31
Foreign Key.......................................................................................................................31
The Key-Sequenced File Structure..............................................................................................32
Contents 3