ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-111
TRACE Statements
MODIFY TRACE
The MODIFY TRACE statement changes the configuration of an existing trace entity.
To execute MODIFY TRACE, you must be a privileged user.
trace-name
specifies the trace to modify. For a description of the other MODIFY TRACE
parameters, see the ADD TRACE statement.
Considerations – MODIFY TRACE
The MODIFY TRACE statement:
•
Modifies the configuration options for the specified trace in ZNSTRA
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
•
Generates an error if you are not authorized to modify the system catalog
Example
MODIFY TRACE trace4 CACHE_STATISTICS Y UPDATE_SYSTEM_CONFIG
REMOVE TRACE
The REMOVE TRACE statement removes a configuration entry from ZNSTRA. To
execute REMOVE TRACE, you must be a privileged user.
trace-name
specifies the trace to remove.
Considerations – REMOVE TRACE
The REMOVE TRACE statement:
MODIFY 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 ]
REMOVE TRACE trace-name [ UPDATE_SYSTEM_CONFIG ]