SYSTRACEMSGS

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.