8.3.1 Checking the output status of the SQL trace information
This command outputs the status of SQL trace information output to standard output.
adbchgsqltrc -d sqltrace param accesspath level ACTIVE ACTIVE INACTIVE SQL
Explanation of the output items
- sqltrace
-
Displays whether the SQL trace information is output.
-
ACTIVE: The SQL trace information is output.
-
INACTIVE: The SQL trace information is not output.
-
- param
-
Displays whether dynamic parameter information is output to the SQL trace information.
-
ACTIVE: Dynamic parameter information is output to the SQL trace information.
-
INACTIVE: Dynamic parameter information is not output to the SQL trace information.
-
- accesspath
-
Displays whether access path information and access path statistical information are output to the SQL trace information.
-
ACTIVE: Access path information and access path statistical information are output to the SQL trace information.
-
INACTIVE: Access path information and access path statistical information are not output to the SQL trace information.
-
- level
-
Displays the unit in which the SQL trace information is output.
-
CALL: The SQL trace information is output for each call.
-
SQL: The SQL trace information is output for each SQL statement.
-