Trace Facility

You will use the trace facility only if you are working with technical support and they require the additional information provided in this file.

Turn on tracing for all sessions by specifying the property:

derby.drda.traceAll=true

While the network server is running, you can use the following command to turn on the trace facility:

java org.apache.derby.drda.NetworkServerControl trace on [<connection number>] 
[-h <host>][-p <portnumber>] 

If the <connection number> is specified tracing is turned on only for that connection.

Specify the location of the tracing files by specifying the property:

derby.drda.traceDirectory=<directory for tracing files>

Note:

Specify the directory where the tracing files will reside. The file name itself is defined by the system.

If the trace directory is not specified, the traces are placed in derby.system.home.

While the network server is running, using the following command to set the trace directory:

java org.apache.derby.drda.NetworkServerControl traceDirectory 
<directory for tracing files>[-h <host>] [-p <portnumber>]  

Tracing can be turned off with the following command:

java org.apache.derby.drda.NetworkServerControl trace off [<connection number>] 
[-h <host>] [-p <portnumber>] 

The tracing files are named Server.trace