SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
xv
About This Manual
The SQL/MP relational database management system (RDBMS) uses the Structured
Query Language (SQL) to create databases and to describe and manipulate data.
SQL/MP is compatible with the American National Standards Institute (ANSI) and
International Organization for Standardization (ISO) standards for SQL. SQL/MP
provides high performance for production of online transaction processing (OLTP)
applications over a full range of centralized or distributed systems.
Audience and Task Analysis
This manual provides comprehensive descriptions of how to perform the tasks of
planning, creating, and managing an SQL/MP database, frequently giving step-by-step
instructions. As a database administrator or manager, you should find this manual
helpful when performing these tasks:
•
Installing SQL/MP
•
Determining the database layout and data dictionary plan
•
Planning for database security, integrity, and recovery
•
Creating the database
•
Querying catalogs for information about the database
•
Managing the database and programs
•
Reorganizing the database
•
Moving the database
•
Managing database applications
•
Performing recovery operations
•
Managing a distributed database
•
Measuring and enhancing performance
You should be familiar with the HP NonStop operating system, the HP NonStop
Transaction Management Facility (TMF), and any specific application environments
you manage, such as the Pathway transaction processing environment.
Prerequisites
Before using this manual, you should read the Introduction to NonStop SQL/MP so that
you are familiar with SQL/MP terminology and concepts. You will need a copy of the
SQL/MP Reference Manual, which documents SQL statements and SQLCI command
syntax and provides detailed information about how SQL/MP works. You will also need
a copy of the SQL/MP Query Guide, which explains how to design and tune database