Informix/IDS: Monitoring log file

The message file records the activities performed on Informix server instance such as starting, stoping etc.
There are 2 ways you can monitor the message file:

(1)Using onstat –m: Prints message log file
Below is an example output from onstat -m:
***
ids9> onstat -m

IBM Informix Dynamic Server Version 9.40.HC7 — On-Line — Up 212 days 21:16:43 — 105360 Kbytes

Message Log File: /opt/informix/logs/ids9/ids9.log

12:19:44 Maximum server connections 45
12:24:47 Fuzzy Checkpoint Completed: duration was 0 seconds, 161 buffers not flushed.
12:24:47 Checkpoint loguniq 8727, logpos 0x2ff47cc, timestamp: 0xfa89961e

12:24:47 Maximum server connections 45
12:26:23 Logical Log 8727 Complete, timestamp: 0xfa8b79ad.
12:26:24 Process exited with return code 156: /bin/sh /bin/sh -c /opt/informix/run32/etc/log_full.sh 2 23 “Logical Log 8727 Complete, timestamp: 0xfa8b79ad.” “Logical
12:29:50 Fuzzy Checkpoint Completed: duration was 0 seconds, 162 buffers not flushed.
12:29:50 Checkpoint loguniq 8728, logpos 0x257d8, timestamp: 0xfa8bee6b

12:29:50 Maximum server connections 45
12:34:53 Fuzzy Checkpoint Completed: duration was 0 seconds, 163 buffers not flushed.
12:34:53 Checkpoint loguniq 8728, logpos 0x3b7e4, timestamp: 0xfa8c1085

12:34:53 Maximum server connections 45
12:39:56 Fuzzy Checkpoint Completed: duration was 0 seconds, 163 buffers not flushed.
12:39:56 Checkpoint loguniq 8728, logpos 0xdf7e4, timestamp: 0xfa8c1ba9

12:39:56 Maximum server connections 45

***

(2) Using tail –f command
First, find out the MSGPATH variable from $INFORMIXDIR/etc/$ONCONFIG file.
The MSGPATH value looks as below
# Message Files
MSGPATH /opt/informix/logs/ids9/ids9.log #System message log file path

Now, tail –f opt/informix/logs/ids0/ids9.log will help you to monitor the writes into message log file.

Cheers!
RK

Advertisements

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: