8.5 Notes

1. In the following cases, any change made by the adbchgsqltrc command takes effect together with the transaction that follows the transaction currently being executed:

   • The adbchgsqltrc command is used to start output of the SQL trace information.

   • The adbchgsqltrc command is used to start output of information that was not output to the SQL trace information.

   • The adbchgsqltrc command is used to change the unit (output level) in which the SQL trace information is output.

2. In the following cases, any change made by the adbchgsqltrc command takes effect immediately after this command is executed:

   • The adbchgsqltrc command is used to stop output of the SQL trace information.

   • The adbchgsqltrc command is used to stop output of the information that was being output to the SQL trace information.

3. When you specify the -y and -n options concurrently for the adbchgsqltrc command, you cannot specify the same information for the SQL trace information whose output is to start, and for the SQL trace information whose output is to stop. If the same information is specified for both, an error message is output and the adbchgsqltrc command terminates.

4. You cannot specify the -d option concurrently with any other option. If the -d option is specified concurrently with any other option, an error message is output and then the adbchgsqltrc command terminates.

5. You cannot specify the -e option concurrently with any other option. If the -e option is specified concurrently with any other option, an error message is output and the adbchgsqltrc command terminates.

6. Only one adbchgsqltrc command can be executed at a time. If multiple adbchgsqltrc commands are executed concurrently, an error message is output and the adbchgsqltrc commands terminate.

7. Even if you execute the adbchgsqltrc command to change whether to output the SQL trace information, or to change the output content of the SQL trace information, the values specified in operands of the server definition file are not changed. To use the change made by the adbchgsqltrc command at the next and subsequent startup of the HADB server, you need to change 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.

8. If you execute the adbchgsqltrc command while the HADB server is stopped, an error message is output. If the HADB server is stopped, change the value specified for the operand of the server definition related to SQL tracing.

To Page Top