Is System Log data stored in DB only or in Cache?

[JFHall]

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?

[Darrell Bryant]

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.

[JFHall]

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.

[Darrell Bryant]

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.

[JFHall]

Oh, gotcha now.  Yes, I definitely have System Log data in cache in that case.  Thank you for spelling it out for this newbie.  :-)

[nonix]

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.