8.3.2 Examples of starting output of the SQL trace information
This subsection explains how to start output of the SQL trace information.
During this step, you can also change the type of SQL trace information to be output and the output level of the SQL trace information.
For items that are not changed, the following operation takes place:
-
When the adbchgsqltrc command is executed for the first time following HADB server startup, the specification values in the server definition are followed.
-
In all other cases, the states that were in effect the previous time the SQL trace information was output are inherited without any change.
- Note
-
To check the current status of the type of SQL trace information to be output and its output level, see 8.3.1 Checking the output status of the SQL trace information.
- Organization of this subsection
(1) To start output of the SQL trace information
Start output of the SQL trace information.
Do not change the type of SQL trace information to be output or the unit in which the SQL trace information is output.
adbchgsqltrc -s
(2) To output dynamic parameter information and access-path-related information
Start output of the SQL trace information.
During this step, change the type of SQL trace information to be output as follows:
-
Output dynamic parameter information.
-
Output access path information and access path statistical information.
Do not change the unit in which the SQL trace information is output.
adbchgsqltrc -s -y param,accesspath
(3) To output access-path-related information without outputting dynamic parameter information
Start output of the SQL trace information.
During this step, change the type of SQL trace information to be output as follows:
-
Do not output dynamic parameter information.
-
Output access path information and access path statistical information.
Do not change the unit in which the SQL trace information is output.
adbchgsqltrc -s -n param -y accesspath
(4) To output the SQL trace information for each call without outputting access-path-related information
Start output of the SQL trace information.
During this step, do not output access path information or access path statistical information. Do not change whether to output dynamic parameter information.
Additionally, change the unit in which the SQL trace information is output to call.
adbchgsqltrc -s -n accesspath -l call
(5) To output the SQL trace information for each SQL statement
Start output of the SQL trace information.
During this step, change the unit in which the SQL trace information is output to an SQL statement.
Do not change the type of SQL trace information to be output.
adbchgsqltrc -s -l sql