ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-37
Stopping a Trace
Any changes made by using the pass-through mechanism are valid only for the
duration of the current user session. When the session is terminated, by whatever
means, the trace attributes revert to the settings in place when the session was
started.
Stopping a Trace
You can turn off tracing by setting the TRACE_MODE_ON flag in the user profile to
“N,” as shown in the following example:
SELECT “tdm: set trace_mode_on n”
Tracing is then disabled for any future connections using that profile.
Log Tables
The following describes the use of log tables in conjunction with tracing.
Creating Log Tables
Use the CREATE TRA_LOG statement, as described in the NonStop ODBC Server
Reference Manual, to create a trace log table.
Displaying Log Tables
You can display a log table by issuing a normal SELECT statement from the log table,
as shown in the following example:
SELECT * from tess_puma_dc.sql_dave.trace4
Clearing Log Tables
You can clear a log table by deleting all rows from the log table by using a normal DML
statement from the client, as shown in the following example:
DELETE from tess_puma_dc.sql_dave.trace4
Dropping Log Tables
Use the DROP TRA_LOG statement, as described in the NonStop ODBC Server
Reference Manual, to drop a trace log table.
Note. Yo u must not select from the log table from a client logged on under a user ID that has
tracing enabled and the OUTPUT_STREAM option set to Y. To do so causes the NonStop
ODBC Server to enter an infinite loop writing to the log table. If you need to display the
contents of the log table from such a client, you must first issue the pass-through statement to
disable tracing, as follows:
SELECT "tdm:set trace_mode_on n"