Introduction to NonStop Operations Management

Operations Management Tools
Introduction to NonStop Operations Management–125507
14-13
NonStop SQL/MP SQLCI
NonStop SQL/MP SQLCI
SQLCI is the primary interface through which database administrators create and
change structures to manage data. SQLCI provides SQL data description language
(DDL) statements to define the database, SQL data manipulation language (DML)
statements to query and modify database tables, installation commands to install
NonStop SQL/MP, a set of database-management utilities, and a report-writer facility.
SQL statements operate on database objects. A database object is an entity that is
created, manipulated, and dropped by SQL statements. Examples of SQL objects
include tables, indexes, views, constraints, and collations.
NonStop Transaction Manager/MP (NonStop
TM/MP)
The NonStop Transaction Manager/MP (NonStop TM/MP) product is the Tandem
system transaction manager. NonStop TM/MP is an integral part of Tandem’s massively
parallel approach to OLTP.
NonStop TM/MP maintains database consistency during processing. The database can
be distributed over multiple nodes of an Expand network, or it can be centralized to
reside on a single Tandem system. In either case, NonStop TM/MP ensures that the
database remains consistent in the event of a program failure, a single component
failure, or the total loss of communications between nodes.
Using NonStop TM/MP, you can also perform online dumps and audit dumps to a
remote system, thus enabling you to maintain a copy of the database at a remote backup
site.
NonStop TM/MP is the transaction manager for NonStop TUXEDO applications, PTP
applications, and Pathway applications. Because applications in all the environments use
the same transaction manager, transactions can span multiple environments and multiple
databases (the NonStop SQL/MP relational database and the Enscribe database).
Each Tandem NonStop system contains one, and only one, NonStop TM/MP subsystem,
which can accommodate concurrent mixed workloads of OLTP, query, and batch
applications. For all databases on a system, NonStop TM/MP maintains a single
transaction log, which greatly simplifies system management operations.
NonStop TM/MP ensures that the following requirements for high-volume transaction-
processing applications are met:
•
Transaction protection and concurrency control
•
Database consistency through transaction protection and recovery procedures
NonStop TM/MP can monitor thousands of complex transactions sent by hundreds of
users to a common database. The database can consist of tables and views created by the
NonStop SQL/MP relational-database-management system, files created by the Enscribe
record manager, or a combination of tables, views, and files. The database can be
distributed among many disks on a system and across many nodes in an Expand
network. NonStop TM/MP manages all the complex operations for concurrent