System Log database table

The System Log database table contains one row for each message that Content Manager OnDemand generates. Table 1 lists the fields, data types, and descriptions of the fields of the records in the System Log database table.
Table 1. System Log database table
Column Name Data Type Size Description
time_stamp Date/Time (TZ) 4 The time stamp of the log record in the Content Manager OnDemand internal date format. For more information, see the ARSDATE program reference.
userid VARCHAR 128 The user ID of the user that generated the log record.
severity CHAR 1 The severity of the log record.
1
Alert
2
Error
3
Warning
4
Information
5
Debugging
msg_num SMALLINT 2 The message number of the log record.
msg_text VARCHAR 2000 The message text of the log record.
appl_id CHAR 1 Determines whether Content Manager OnDemand overhead information is valid.
A
Not applicable. The overhead information does not apply to the log record. However, the overhead information may be useful for other purposes. For example, a log record created when a document is retrieved contains overhead information about the document.
N
No. The overhead information does not contain useful information.
Y
The overhead information contains information about the document belonging to this particular log record.
log_id INTEGER 4 The identifier for the Content Manager OnDemand client connection.
account VARCHAR 60 The user's accounting information.
doc_name VARCHAR 11 The name of the object.
doc_off INTEGER 4 The offset of the document within the compressed object.
doc_len INTEGER 4 The length of the document within the compressed object. A 0 means all of the data.
comp_off INTEGER 4 The offset of the document within the compressed object.
comp_len INTEGER 4 The length of the document within the compressed object. A 0 means all of the data.
annot CHAR 1 Determines whether annotations exist for the document. Applies only if the annotation flag is set (YES) for the application group.
comp_type CHAR 1 The method used to compress document data.
resource INTEGER 4 The resource identifier for the document.
pri_nid SMALLINT 2 The primary storage node identifier.
sec_nid SMALLINT 2 The secondary storage node identifier.