ODBC Server Installation and Management Manual

Managing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
4-35
Setting Up Tracing
16 CACHE Number of Hits: 1
16 CACHE Number of Drops: 0
The trace log contains 3 fields:
•
ID. This field is an ID assigned by the NonStop ODBC Server for each user
session. The ID is assigned when the first trace record is written to the trace log.
•
DEBUG_FLAG. This field identifies the type of information being written to the
trace log. The following types are supported:
•
DEBUG_STRING. This field contains the information identified by each
DEBUG_FLAG that appears in the trace log.
Setting Up Tracing
You can set up tracing in one of two ways: by using the NOSUTIL ADD TRACE
statement or by using pass-through statements.
Using the ADD TRACE Statement
The ADD TRACE statement allows you to set up a trace definition, which can then be
referenced by a user profile. See “Managing Customized Catalogs,” in the NonStop
Note. IDs are randomly assigned and duplicates can occur if the same table is used by
many users over a long period of time. Minimize the chances of this happening by using a
different trace table for each profile.
LOGON The logical username supplied in the logon request.
TIME The time that the trace was started.
IN_STREAM Data received from the client. The data is displayed in both
hexadecimal and character format.
OUT_STREAM Data returned by the NonStop ODBC Server to the client. The
data is displayed in both hexadecimal and character format.
INFO An informational message generated by the NonStop ODBC
Server.
ERROR An error message generated by the NonStop ODBC Server.
NSSQL NonStop SQL/MP statements generated by the NonStop
ODBC Server.
CACHE Information about the statement cache. This information is
generated at the end of the session when the client
disconnects from the NonStop ODBC Server.
SP_WRITE The stored procedure IPC request sent from the NonStop
ODBC Server to the stored procedure server.
SP_READ The stored procedure IPC request sent from the stored
procedure server to the NonStop ODBC Server.