SYSTRACECLASSES
The systraceclasses system catalog table contains
the names and identifiers of trace classes. The systraceclasses table
has the following columns.
| Column | Type | Explanation |
|---|---|---|
| name | CHAR(18) | Name of the class of trace messages |
| classid | SERIAL | Identifying code of the trace class |
A trace class is a category of trace messages that you can use in the development and testing of new DataBlade® modules and user-defined routines. Developers use the tracing facility by calling the appropriate DataBlade API routines within their code.
To create a new trace class, insert a row directly into the systraceclasses table. By default, all users can view this 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 index on the name column requires each trace class to have a unique name. The database server assigns to each class a unique sequential code. The index on this classid column also allows only unique values.