Hitachi

Hitachi Advanced Database Command Reference


8.1 Description

The adbchgsqltrc command specifies whether to output SQL trace information, or changes the output content of the SQL trace information while the HADB server is active. It also displays the output status of the SQL trace information.

When the multi-node function is used, the adbchgsqltrc command changes whether to output the SQL trace information of the node on which the command is executed. It also displays the output status of the SQL trace information of the node on which the command is executed.

For details about SQL trace information, see Running SQL tracing in Scheduled Operations in the HADB Setup and Operation Guide.

When you use the adbchgsqltrc command to specify whether to output SQL trace information or change the output content of the SQL trace information, the change made by this command is lost when the HADB server is terminated. To maintain the change at the next startup, apply the change to the server definition.

For details about how to modify the server definition, see the topic Modifying the server definition in Creating and modifying a server definition in Building a System in the HADB Setup and Operation Guide.