ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-24
ZNSPROF (For Profile Values)
DEFAULT_LOCATION
––
VARCHAR (60) Default location for the creation
of objects. When a user creates
an object, it appears by default in
the same subvolume as the
NonStop ODBC Server
customized catalog. The
DEFAULT_LOCATION entry
causes the object to be created
on the specified volume instead.
The value is defined as a disk
volume name on the local node.
DEFAULT_SECURITY
––
CHAR (4) Default security vector used
during object creation.
TRA_MODE_ON
––
CHAR (1) Flag indicating whether tracing is
performed.
TRA_NAME
––
VARCHAR (60) Trace configuration.
ACC_MODE_ON
––
CHAR (1) Flag indicating whether resource
accounting is performed.
ACC_LOGTABLE_
NAME
––
VARCHAR (182) NonStop ODBC Server table
object name.
ACC_LEVEL
––
CHAR (60) Indicates accounting recording
frequency:
SESSION Summarize
session
SQL_STATEMENT Record
each
statement
GOV_MODE_ON
––
CHAR (1) Flag indicating whether resource
governing is performed.
GOV_NAME
––
VARCHAR (60) Governing configuration.
QST_MODE_ON
––
CHAR (1) Flag indicating whether query
status is enabled.
Table 8-12. Description of ZNSPROF (page2of4)
Column Name
Primary Key Unique Index
Data Type Description
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index