ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-36
Setting Up Tracing
ODBC Server Reference Manual for a detailed description of the ADD TRACE
statement.
The tracing options available through the ADD TRACE statement are as follows:
The following is a sample ADD TRACE statement:
NOSCOM> ADD TRACE trace4 tra_logtable_name tess_puma_dc.sql_dave.trace4
trace_mode_on y input_stream y nssql y
This statement sets up tracing of the input stream and generated NonStop SQL/MP
statements to the SQL table TESS_PUMA_DC.SQL_DAVE.TRACE4.
It is important to note that the value specified for TRA_LOG_TABLENAME must be of
the form database.owner.table-name, where database is a valid user catalog or
the system catalog. Tracing cannot occur if this table name is incorrect.
Using Pass-Through Statements
You can use pass-through statements from the client to specify the setting of any of the
trace attributes described in the preceding tracing options table. Trace attribute values
specified in a pass-through statement have the same settings and the same meanings
as when they are used in an ADD TRACE statement.
The following is an example of a pass-through statement used to set trace attributes:
SELECT "tdm:set tra_log_tablename tess_puma_dc.sql_dave.trace4 input_stream y
nssql y"
Option Value Description
TRA_NAME Y or N Name of the trace definition.
TRA_LOGTABLE_NAME table
name
Name of the SQL table to be used for logging.
LOG_TO_HOMETERM Y or N Set to Y to log to terminal.
INPUT_STREAM Y or N Set to Y to trace client input.
OUTPUT_STREAM Y or N Set to Y to trace NonStop ODBC Server
output.
NSSQL Y or N Set to Y to trace NonStop SQL/MP statements
generated by the NonStop ODBC Server.
TRA_ERROR Y or N Set to Y to trace all messages generated by
the NonStop ODBC Server.
CACHE_STATISTICS Y or N Set to Y to dump cache statistics at the end of
a session.
SP_WRITE Y or N Set to Y to trace stored procedure execution
requests sent to a stored procedure server.
SP_READ Y or N Set to Y to trace replies from a stored
procedure server.
LAST_UPDATED date & time Date and time this row was last updated.