Author Topic: Is System Log data stored in DB only or in Cache?  (Read 2250 times)

JFHall

  • Jr. Member
  • **
  • Posts: 14
    • View Profile
Is System Log data stored in DB only or in Cache?
« on: June 15, 2021, 10:24:41 PM »
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

  • Full Member
  • ***
  • Posts: 104
  • Sed fugit interea fugit inreparabile tempus-Virgil
    • View Profile
Re: Is System Log data stored in DB only or in Cache?
« Reply #1 on: June 16, 2021, 07:19:50 AM »
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.
#IBMi #iSeries #PDF #XML #400 Indexer #ASM

JFHall

  • Jr. Member
  • **
  • Posts: 14
    • View Profile
Re: Is System Log data stored in DB only or in Cache?
« Reply #2 on: June 16, 2021, 10:22:48 PM »
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

  • Full Member
  • ***
  • Posts: 104
  • Sed fugit interea fugit inreparabile tempus-Virgil
    • View Profile
Re: Is System Log data stored in DB only or in Cache?
« Reply #3 on: June 17, 2021, 05:32:41 AM »
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.
#IBMi #iSeries #PDF #XML #400 Indexer #ASM

JFHall

  • Jr. Member
  • **
  • Posts: 14
    • View Profile
Re: Is System Log data stored in DB only or in Cache?
« Reply #4 on: June 17, 2021, 10:42:58 PM »
Oh, gotcha now.  Yes, I definitely have System Log data in cache in that case.  Thank you for spelling it out for this newbie.  :-)

Norbert Novotny

  • Jr. Member
  • **
  • Posts: 46
    • View Profile
Re: Is System Log data stored in DB only or in Cache?
« Reply #5 on: June 21, 2021, 08:08:53 AM »
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.
Norbert Novotny
Legal archiving - Swisscom AG

Mobile:  +41-On-request

Dev: #SQL, #Perl, #Java, #C

Interests: #CMOD, #Multiplatforms, #DB2, #Oracle, #TSM, #ERM, #Performance