Does anyone know if the System Log data is stored in the DB only? Or does index information get stored in the DB and data in a cache file system like with a normal report application?
Any System Log message that has View = Yes has an associated data object in Cache. You should always cache the System Log for at least 1 day so that it can append multiple data objects together in cache.
I searched for %View% in the Message of the System Log for the last 6 months and got no hits. I guess I can reasonably assume, therefore, that my installation stores all the System Log messages in the DB alone, with no data in the cache file systems.
When you open the system log in the OnDemand client, there is a column named View. If the value in that column is Yes, the message has a document associated with it.
Oh, gotcha now. Yes, I definitely have System Log data in cache in that case. Thank you for spelling it out for this newbie. :-)
Just a side note: as Darrell mentioned: "Log message that has View = Yes". and this concern only the output information, not the complete system log record. Probably the most common is output of "arsload -v" or "arsmaint", but there are others as well.
However, all other (complete) information found in System log is *DB only*.
With a help of "arslog - OnDemand User Exit Logging Facility" you could push the messages to a file.
Cheers,
N.