Creating Tracepoints

Each tracepoint has the following parts:

• A trace groups related tracepoints together so that they can be turned on or off at the same time.

  You can either use the built-in trace called _myErrors or create your own. To create your own trace, you insert rows into the systracees system catalog table.

• A trace message is the text that the database server sends to the tracing-output file.

  You can store internationalized trace messages in the systracemsgs system catalog table.

• A tracepoint threshold determines when the tracepoint executes.

By default, the database server puts all trace messages in the trace-output file in the tmp directory with the following filename:

session_num.trc