ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-110
TRACE Statements
CACHE_STATISTICS { Y | N }
specifies whether cache statistics should be logged, with a log record being written
out at the end of the user session.
SP_WRITE { Y | N }
specifies whether all PATHSEND write messages generated by stored procedures
should be logged.
SP_READ { Y | N }
specifies whether all NonStop SQL/MP results returned from the invocation of
stored procedures should be logged.
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – ADD TRACE
The ADD TRACE statement:
•
Creates a new entry in the ZNSTRA table that defines the trace options
•
Generates an error if trace-name already exists in ZNSTRA
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
•
Generates an error if you are not a privileged user
See the NonStop ODBC Server Installation and Management Manual for information
about using the trace feature.
Example
ADD TRACE trace4 &
TRA_LOGTABLE_NAME newyork_disk2_sqldb.sql_dave.trace4 &
LOG_TO_HOMETERM y TRA_ERROR y UPDATE_SYSTEM_CONFIG