8.3.3 Examples of changing the output content of the SQL trace information
When the SQL trace information is being output, you can change the type of SQL trace information that is output and the unit in which it is output.
- 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 output dynamic parameter information and access-path-related information
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 -y param,accesspath
(2) To output access-path-related information without outputting dynamic parameter information
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 -n param -y accesspath
(3) To output the SQL trace information for each call without outputting access-path-related information
Stop output of access path information and 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 -n accesspath -l call
(4) To output the SQL trace information for each SQL statement
Change the unit in which the SQL trace information is output to sql.
Do not change the type of SQL trace information to be output.
adbchgsqltrc -l sql