topic Log Analyzer for Informix Database in Operating System - HP-UX

Log Analyzer for Informix Database

Monte Heeren — Fri, 14 Sep 2007 11:39:54 GMT

Was wondering if there is a log analyzer for an Informix database out there. I have tried onlog, but the data is pretty cryptic.
I was trying to look at a particular log tape for specific info.

I used: onlog -ld /dev/rmt/0m

Monte Heeren.

Re: Log Analyzer for Informix Database

JJ_4 — Sat, 15 Sep 2007 01:55:08 GMT

> onlog ---
Invalid option list.

Usage: onlog [-l] [-q] [-b] [-d ] [-n identifier>-] [-u ]
[-t ] [-x ]

-l Display maximum information about each log record
-q Do not display program header
-b Display information about logged BLOB pages (-d option only)
-d Read from tape device (written by ontape)
-n Display the specified log(s)
-u Display the specified user(s)
-t Display the specified TBLspace(s)
-x Display the specified transaction(s)

What was the "specific info" you were looking for?

Re: Log Analyzer for Informix Database

Monte Heeren — Mon, 17 Sep 2007 10:17:30 GMT

The format is hard to read. The right side of the display is text and the left side looks like hex. I was wondering if there was a product that would display the log information better.

I was looking for a certain PID like E000201. The right side of the screen would show the PID as E0002, and then the next line would show 01. I could not do a find just on the PID E000201.

Monte.