ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-84
SERVERCLASS Statements
PRIMARY_EXTENT=n SECONDARY_EXTENT=n MAX_EXTENTS=n
specifies values for the primary and secondary extent sizes and the maximum
number of extents used in the creation of SQL tables and indexes. The same
values are used for both tables and indexes. You can specify none, one, two,
or all options.
If you do not specify any options, the NOS process uses the NonStop ODBC
default values as: PRIMARY_EXTENT=16, SECONDARY_EXTENT=64, and
MAX_EXTENTS=940 (allowing tables and indexes up to 123 MB).
If you omit an option, the NOS process uses the SQL default value for that
option as: PRIMARY_EXTENT=16, SECONDARY_EXTENT=64, and
MAX_EXTENTS=160.
These options allow you to create tables and indexes larger than 123 MB. For
example, if PRIMARY_EXTENT=100, SECONDARY_EXTENT=800, and
MAX_EXTENTS=940, you can create a table or index up to 1.54 GB.
AUDITED_TABLES={Y|N}
Y specifies that CREATE TABLE commands executed by the serverclass have
the AUDIT clause appended. Y is the default.
N specifies that CREATE TABLE commands executed by the serverclass have
the NO AUDIT clause appended. (Although the CREATE INDEX and CREATE
VIEW commands have no AUDIT clause, indexes and views are also created
as unaudited objects when this option causes the underlying tables to be
unaudited.)
When N is specified, NOS does not begin or end transactions for DML
commands; for example, INSERT or SELECT will be executed without a
transaction.
GOV_ERROR = { Y | N }
lets you choose between the SQL_SUCCESS_WITH_INFO message and the
SQL_ERROR message when the resource governing limit is reached.
Y specifies that, when the resource governing limit is reached, NOS treats the
situation as an error and replies with a SQL_ERROR message.
N specifies that, when the resource governing limit is reached, NOS treats the
situation as a warning and sends a SQL_SUCCESS_WITH_INFO message.
The text is the same in both the error and the warning messages.
SWAP swap-vol
is an alphabetic character string up to 24 characters in length that specifies the
name of a swap volume for the server class process in the following format:
[\node.]$volume