ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-39
NOSUTIL
•
INSTALL/DEINSTALL/VALIDATE/REFRESH/UPGRADE the NonStop ODBC
Server system catalog
•
INSTALL/DEINSTALL/VALIDATE/REFRESH/UPGRADE a NonStop ODBC Server
user catalog
•
ADD/REMOVE/MODIFY alias and usernames
•
ADD/REMOVE/MODIFY stored procedure names and attributes
•
ADD/REMOVE/MODIFY profile and trace information
•
ADD/REMOVE/MODIFY SQL Communication Subsystem configuration
•
ADD/REMOVE/MODIFY system configuration defaults
•
ADD/REMOVE/MODIFY server class definitions and mapping
•
ADD/REMOVE/MODIFY network service configurations
•
ADD/REMOVE/MODIFY resource governing policies
•
ADD/REMOVE visibility of NonStop SQL/MP indexes and tables
•
ADD/REMOVE stored NonStop SQL/MP CONTROL statements
•
ADD/REMOVE stored NonStop SQL/MP DEFINE statements
•
CREATE/DROP log tables for resource accounting, query status, and tracing
INSTALL is the command to customize a NonStop SQL/MP catalog. Note that
migration from the HP SQL Server Gateway is supported by NOSUTIL. For example, if
INSTALL is called on a NonStop SQL/MP catalog that was previously customized for
the HP SQL Server Gateway, NOSUTIL first automatically deinstalls the HP SQL
Server Gateway catalog.
Executing NOSUTIL
NOSUTIL can be called in one of four ways:
•
By the NonStop ODBC Server Configuration Manager
The NonStop ODBC Server Configuration Manager, a graphical user interface
(GUI) tool, can be run to issue pass-through configuration commands to NOSUTIL.
•
By NOSCOM
NOSUTIL can be run directly to perform the utility functions mentioned previously
under “Catalog Operations.” NOSCOM is the TACL-like command interpreter used
for entering all utility statements.
•
By a NonStop ODBC server
A NonStop ODBC server creates and uses a private NOSUTIL process to support
the SQL statement CREATE DATABASE or DROP DATABASE. For CREATE