The systracemsgs system catalog table stores internationalized trace messages that you can use in debugging user-defined routines.

The systracemsgs table has the following columns.
Table 1. SYSTRACEMSGS table column descriptions
Column Type Explanation
name VARCHAR(128) Name of the message
msgid SERIAL Identifying code of the message template
locale CHAR(36) Locale with which this version of the message is associated (for example, en_us.8859-1)
seqno SMALLINT Reserved for future use
message VARCHAR(255) The message text

DataBlade® module developers create a trace message by inserting a row directly into the systracemsgs table. After a message is created, the development team can specify it either by name or by msgid code, using trace statements that the DataBlade API provides.

To create a trace message, you must specify its name, locale, and text. By default, all users can view the systracemsgs table, but only users with the DBA privilege can modify it.

The database cannot support tracing unless the MITRACE_OFF configuration parameter is undefined.

A unique composite index is defined on the name and locale columns. Another unique index is defined on the msgid column.