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-17
JDBC/MX
For more information about the NonStop Server for Java 4, see the NonStop Server for
Java Programmer’s Reference. For instructions on how to install NonStop Server for
Java 4, see the README file on the product CD.
JDBC/MX
To develop and execute Java programs that perform SQL operations and SPJs, you
must install the JDBC Driver for NonStop SQL/MX (JDBC/MX), product version 3.1, on
your NonStop system. JDBC/MX 3.1 conforms where applicable to the JDBC 3.0 API
and is the earliest supported product version for Release 2.1 and Release 2.0.
For more information about JDBC/MX, see the JDBC Driver for SQL/MX Programmer’s
Reference. For instructions on how to install JDBC/MX, see the README file on the
NonStop Server for Java product CD.
Database Management Tasks
Managing an SQL/MX database involves the tasks required to create the database,
ensure its availability to users, and perform required changes. Because the database is
an integral part of the application, measuring application performance and tuning the
database configuration to enhance performance are also database management tasks.
The tasks of SQL/MX database administrators (DBAs) include:
•
Install the SQL/MX software
•
Upgrade to later releases of SQL/MX software or downgrade to earlier releases
•
Determine database layouts and data dictionary plans
•
Plan for database security, integrity, and recovery
•
Create and load databases
•
Query catalog tables for information about databases
•
Alter databases
•
Manage databases and programs
•
Reorganize and move databases
•
Manage database applications
•
Perform recovery operations
•
Manage distributed databases
•
Assemble and optimize queries
•
Measure and enhance performance
SQL/MX Database Management Tools
NonStop SQL/MX supports these types of SQL/MX statements:
DDL Creates, deletes, or modifies the definition of a catalog, schema,
or object, or the authorization to use an object.
DML Queries and modifies database tables.
Transaction Control Specifies user-defined transactions and sets attributes for the
next transaction.