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

HP NonStop SQL/MX Installation and Management Guide—544536-007
7-1
7 Creating an SQL/MX Database
When you install and initialize NonStop SQL/MX on a system node, NonStop SQL/MX
creates the system catalog and several system schema. After the installation is
complete, you can create your own user catalogs and schemas. Creating a catalog
updates the system schema. The definition schema for a user catalog is created when
you create the first schema in that catalog. See Creating SQL/MX Metadata on
page 7-6 for more information.
Before you create your SQL/MX database, read:
•
Preparing to Create Your SQL/MX Database on page 7-2
•
SQL/MX Subvolume and File Naming Guidelines on page 7-2
Creating an SQL/MX database involves these basic tasks:
•
Create catalogs and schemas. See Creating Catalogs on page 7-7 and Creating
Schemas on page 7-9.
•
Understand how to assign the appropriate user access privileges for SQL/MX
objects. See Access Privileges for SQL/MX Database Objects on page 7-10
•
Create SQL/MX tables. See Creating SQL/MX Tables on page 7-11.
•
Create partitions for the SQL/MX tables. See Creating and Managing Partitions for
SQL/MX Tables on page 7-16.
•
Create indexes on the tables. See Creating Indexes for SQL/MX Tables on
page 7-33.
•
Create partitions for SQL/MX indexes. See Creating and Managing Partitions for
SQL/MX Indexes on page 7-35.
•
Create constraints on one or more columns of a table. See Creating Constraints on
SQL/MX Tables on page 7-37.
•
Create a view of a table. See Creating Views of SQL/MX Tables on page 7-39.
•
Create triggers. See Creating Triggers on page 7-41.
•
Create stored procedures. See Creating Stored Procedures in Java on page 7-41.
•
Improve database performance in an OLTP environment. See Database Design
Guidelines for Improving OLTP Performance on page 7-41.
For information about creating an SQL/MP database and the objects in that database,
see the SQL/MP Installation and Management Guide.