ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-109
TRACE Statements
ADD TRACE
The ADD TRACE statement adds and configures a new trace entity. To execute ADD
TRACE, you must be a privileged user.
trace-name
specifies the trace to create; trace-name is an alphanumeric string up to 60
characters in length and must be unique.
TRA_LOGTABLE_NAME log-tablename
specifies the name of the trace log table, stored as a fully qualified three-part
logical name in the format database.owner.name. The default is NULL.
LOG_TO_HOMETERM { Y | N }
specifies whether trace records should be written to the terminal used to start the
NonStop ODBC Server. Trace records can be written to the current server process
home terminal only when the server is manually started. The setting has no effect
on logging to a designated trace log.
INPUT_STREAM { Y | N }
specifies whether input records should be recorded as they are read from the SQL
Communication Subsystem before decoding (values are written in hexadecimal).
OUTPUT_STREAM { Y | N }
specifies whether output records should be recorded as they are written to the SQL
Communication Subsystem after decoding (values are written in hexadecimal).
NSSQL { Y | N }
specifies whether all SQL should be recorded as it is generated by the server and
sent to NonStop SQL/MP (both client SQL and server catalog management SQL
are logged).
TRA_ERROR { Y | N }
specifies whether all errors generated or detected by the server should be logged.
ADD TRACE trace-name
[ TRA_LOGTABLE_NAME log-tablename ]
[ LOG_TO_HOMETERM { Y | N } ]
[ INPUT_STREAM { Y | N } ]
[ OUTPUT_STREAM { Y | N } ]
[ NSSQL { Y | N } ]
[ TRA_ERROR { Y | N } ]
[ CACHE_STATISTICS { Y | N } ]
[ SP_WRITE { Y | N } ]
[ SP_READ { Y | N } ]
[ UPDATE_SYSTEM_CONFIG ]