SQL/MP Installation and Management Guide

The SQL/MP Database Management Environment
HP NonStop SQL/MP Installation and Management Guide—523353-004
1-10
Database Management Tasks
•
When referring to SQL objects from embedded SQL statements within an SQL
program compiled for the OSS environment, use Guardian names or DEFINEs.
Database Management Tasks
To manage an SQL/MP database, you must perform all 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.
SQL/MP database administrators (DBAs) perform these tasks:
•
Install the SQL/MP software
•
Upgrade to newer versions of SQL/MP software or downgrade to older versions
•
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
Database Management Tools
SQL/MP provides the following types of SQL statements:
•
Data Definition Language (DDL) statements that define and manage database
objects.
•
Data Manipulation Language (DML) statements that query and modify database
tables.
•
Data Control Language (DCL) statements and directives that control performance-
related aspects of SQL/MP such as parallel processing and access paths.