You can use sqldbc_cons to configure and control traces for the MaxDB SQLDBC interface.
sqldbc_cons is an integral part of MaxDB SQLDBC.
sqldbc_cons [<command>] [<option>]
You can only enter one option at a time. They cannot be combined.
Commands
<command> |
Description |
TRACE SQL ON|OFF |
Switches the SQL trace on/off See SQLDBC Traces |
TRACE PACKET ON|OFF |
Switches the PACKET trace on/off |
TRACE SHORT ON|OFF |
Switches the SHORT trace on/off |
TRACE LONG ON|OFF |
Switches the detailed LONG trace on/off |
TRACE OFF |
Switches off all SQLDBC traces |
TRACE FILENAME <file_name> |
Sets the name <file_name> of the trace file If you enter %p in the name, it is then replaced by the process ID of the application for which the trace is written. |
TRACE SIZE <size> |
Defines the size <size> of the trace file ( in bytes) |
SHOW ALL |
Displays the configuration of the traces and current information about the traces. |
SHOW CONFIG |
Displays the configuration of the traces |
SHOW TRACESETTINGS |
Displays current information about the traces |
Options
<option> |
Description |
-f |
Forces the execution of the command |
-h |
Displays the help |
-p <pid> |
Executes the command only for the process with the process ID <pid>. |
-v |
Displays detailed information (verbose) |