Creating Tracepoints

Tracepoints are useful in debugging user-defined routines written in C. You can create a user-defined tracepoint to send special information about the current execution state of a user-defined routine.

Each tracepoint has the following parts:

• A trace class 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 class called _myErrors or create your own. To create your own trace class, you insert rows into the systraceclasses 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

For more information on tracing user-defined routines, see the IBM Informix DataBlade API Programmer's Guide.