SQL/MP Installation and Management Guide

The SQL/MP Database Management Environment
HP NonStop SQL/MP Installation and Management Guide—523353-004
1-13
Database Management Tools
Through its Guardian environment, the NonStop OS provides additional utilities and
subsystems for managing an SQL/MP database. Collectively, these utilities and
subsystems are known as the NonStop Tools. You use these tools primarily in recovery
operations, in moving a database, or in reorganizing a database online. Table 1-2 on
page 1-14 summarizes these software products.
Installation CREATE
SYSTEM
CATALOG
Creates the system catalog, including the
CATALOGS table.
DROP SYSTEM
CATALOG
Deletes the system catalog, including the
CATALOGS table, and deletes the SQLCI2
program.
INITIALIZE SQL Prepares a NonStop system to run SQL/MP.
DML DELETE Deletes rows from a table or view.
INSERT Inserts rows into a table or view.
SELECT Retrieves data from tables and views.
UPDATE Updates values in columns of a table or view.
DCL CONTROL
EXECUTOR
Specifies whether to process data by using a
single executor or multiple executors working in
parallel.
CONTROL
QUERY
Specifies optimizing queries either for the first few
rows returned or for all rows returned.
CONTROL
TABLE
Specifies parameters that control locks and other
attributes of tables.
FREE
RESOURCES
Releases locks on nonaudited and some audited
objects and closes cursors.
LOCK TABLE Locks a table or underlying tables of a view and
associated indexes.
SHOW
CONTROL
Displays the values in effect for any options of
CONTROL statements.
UNLOCK TABLE Releases locks held on nonaudited tables or
views.
DSL GET CATALOG
OF SYSTEM
Retrieves the name of a local or remote system
catalog.
GET VERSION Retrieves the version of a specific SQL object,
catalog, or software component.
GET VERSION
OF PROGRAM
Retrieves the PCV, PFV, or HOSV of an SQL
program.
Table 1-1. SQL/MP Statements and Commands for Database
Management (page3of3)
Statement or
Command Type
Statement or
Command Description