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 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

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