ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-8
Database and Object Mapping
Database and Object Mapping
Table 8-3 and Table 8-4 are summary tables that provide the location and description
of each database and object mapping table.
For a summary of system mapping tables, see System Table Mapping on page 8-60.
Table 8-3. Mapping Tables Residing Only With the System Catalog (page 1 of 2)
File Name
Object
Type Description
ZNSALT Table Maps alternate usernames to logical usernames.
ZNSALTI1 Index Ensures that alternate usernames for this system are unique.
ZNSCON Table Describes the NonStop SQL/MP CONTROL statements that
must be executed at initialization or reinitialization time.
ZNSCONI1 Index
Ensures that the lookup key relating one or more CONTROL
option(s) to a user profile is unique.
ZNSDB Table Maps ODBC or SQL Server database names to NonStop
SQL/MP catalog names.
ZNSDBI1 Index Ensures that any database ID in ZNSDB is unique.
ZNSDBI2 Index
Is created on the T_DBID column of ZNSDB.
ZNSDEF Table Defines settings for process entities.
ZNSDUMMY Table Static table used for DLIB API.
ZNSGOV Table Contains accounting profile settings.
ZNSMSG Table Contains all error messages that could be generated by the
NonStop ODBC Server.
ZNSNET Table Describes network service attributes.
ZNSPROF Table Contains user profile information for configuration and trace
characteristics.
ZNSPROT Table Contains user permission information.
ZNSSCFG Table Contains system-wide configuration values.
ZNSSCS Table Describes SCS process attributes.
ZNSSER Table Describes NonStop ODBC Server server class attributes.
ZNSSMAP Table Describes mapping between SCS and server class
ZNSTRA Table Contains the user profile information for trace values.
ZNSUMAP Table Describes mapping between username and profile to server
class.
ZNSUS Table Maps logical usernames to their assigned Guardian usernames.