602SQL Documentation Index  

_IV_RECENT_LOG System Query

The system query _iv_recent_log returns the records that were recently appended to the 602SQL Server defined logs. Each record in the query corresponds to one log entry.

Column description

Log_name CHAR Name of the log this entry originates from (empty for the basic log)
Seq_num INT The ordinal number of the log entry
Log_message CLOB Text of the entry
Log_message_w NCLOB Text of the entry in UNICODE

All users may query the basic log as follows:

SELECT * FROM _iv_recent_log WHERE Log_name=''

Only a configuration administrator (see 602SQL Server administration) may execute queries on other logs.

The amount of information the query is able to return is set by the TraceLogCacheSize server property.