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

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—544536-007
1-13
JDBC/MX Driver
JDBC/MX Driver
To create and execute SPJs in NonStop SQL/MX, you must install the JDBC/MX driver
on a NonStop system. The JDBC/MX driver enables a Java application to use NonStop
SQL/MX to access an SQL/MX or SQL/MP database. For details about this product,
see the JDBC Driver for SQL/MX Programmer’s Reference. For installation
instructions, see the README file on the product CD. For version requirements, see
Table 2-1.
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.
Prepared SQL Compiled once and then executed any number of times within the
current session.
Embedded-only
SQL/MX
Embedded in SQL programs written in C, C++, COBOL, or Java.