MSG_DATE

As of Informix version 11.50, there is a simple but cool onconfig parameter – MSG_DATE. It puts a date at the beginning of each online log message. That’s a real relief for all us parsing our online logs to get some kind of daily report or similar. It was much harder to determine where the messages of the actual day start before MSG_DATE was introduced, but now you can simply grep the log for the date.

The only not-so-great thing about it is that the date is always in MM/DD/YY format. It doesn’t depend on localization settings. Date formats in log messages could be different from one log to another (e.g. online log and onbar activity log), which makes the parsing of several logs more demanding (or should I say, kind of pain in the a..). Nevertheless, very useful parameter, which IMHO, should be defaulted to 1. It can be changed online using onmode -wf or -wm.

Advertisements

,

  1. #1 by Eric Vercelletto on July 2, 2014 - 15:34

    Effectively I got thru it, and the bad news is that you can’t navigate in the log with a parser, for instance between 2 timestamps unless you rewrite the file with the yyyy-mm-dd HH:MM:SS format
    It also bring more weight to the log file…

    I solved this issue long time ago with an ifmx log parser that builds the timestamp with a usable format, and allows you to display line before, after or between 2 timestamps, with very useful additional filters options (errors, crashes, logical logs, checkpoitns, backups, exclude etc….)
    and using powerful regular expressions.

    It works great even with x Gb log files

    Can be provided for free if kindly requested to me 🙂
    Eric

    • #2 by ognjen on July 2, 2014 - 16:05

      Eric, may I suggest open-sourcing it? I can provide information and help on doing it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: