17.4.1 About trace levels
You can select which information is output as HADB ODBC driver trace information by specifying a trace level. There are two trace levels. Trace level 1 outputs simple trace information, and trace level 2 outputs information that is more detailed. The following table lists the relationship between trace levels and the information output as HADB ODBC driver trace information.
|
Output information |
Trace level |
|
|---|---|---|
|
Trace level 1 |
Trace level 2 |
|
|
Access type |
N |
Y |
|
Function name |
Y |
Y |
|
Arguments |
N |
Y |
|
Handle |
Y |
Y |
|
Time |
Y |
Y |
|
Execution result |
Y |
Y |
|
SQLSTATE |
Y |
Y |
|
Error message |
Y |
Y |
|
Executed SQL |
Y |
Y |
|
Additional information |
Y |
Y |
- Legend:
-
Y: Output.
N: Not output.
When the trace level is 1, a maximum of 256 bytes of information is output per line. When the trace level is 2, all the information is output. Selecting trace level 2 can impact performance due to the greater amount of information that is output.
The timing with which HADB ODBC driver trace information is output differs for each trace level, as follows:
-
Trace level 1
Information is output immediately before the ODBC function terminates.
-
Trace level 2
Information is output when the ODBC function starts and immediately before it terminates.
- Note
-
To output detailed troubleshooting information, you must select trace level 2. However, be aware of the impact this will have on performance.