ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-49
Configuring Usernames and Attributes
Server user catalogs. You must upgrade manually for each NonStop ODBC Server
user catalog by running
NOSCOM> USERCAT UPGRADE NonStop-SQL/MP-catalog-name
where NonStop SQL/MP-catalog-name corresponds to the NonStop ODBC Server
user catalog. You do not need to upgrade all NonStop ODBC Server user catalogs
immediately, but it is suggested that you upgrade them before referencing any objects
registered in them.
To determine which NonStop ODBC Server catalogs have been upgraded, check the
version number of the catalog. You can do so either by issuing the TSQL SELECT
statement on SYSOBJECTS (look at the VERSION column) or by issuing the SQL/MP
SELECT statement on SQL-System-Catalog.ZVSDB (look at the T_VERSION
column). The version number of the current release is 110; any lower version number
indicates a NonStop ODBC Server catalog that must be upgraded.
Configuring Usernames and Attributes
NonStop ODBC Server clients connect to servers and access SQL objects by using a
logical username. Most NonStop ODBC Server attributes are also associated with
usernames. usernames and their attributes must be configured on the NonStop system
by using the NonStop ODBC Server Configuration Manager or NOSCOM.
The attribute settings determine the logical, performance, and tracing characteristics of
client connections, so their management is a major part of configuration.
Figure 2-3 shows the relationships among the objects and attributes of the NonStop
ODBC Server: