onstat -m

Use the -m option to display the 20 most-recent lines of the system message log. You can use the onstat -m option with the database server in any mode, including offline.

Output from this option lists the full pathname of the message-log file and the 20 file entries. A date-and-time header separates the entries for each day. A time stamp prefaces single entries within each day. The name of the message log is specified as MSGPATH in the ONCONFIG file.

Example Output

Figure 104. onstat -m Output

IBM Informix Dynamic Server Version 10.00.UC1  -- On-Line -- Up 03:55:41 -- 15360 Kbytes

Message Log File: /work/9.40/dbspaces/star3.log
14:41:00  Fuzzy Checkpoint Completed:  duration was 0 seconds, 1 buffers not flushed,
timestamp: 56447.
14:41:00  Checkpoint loguniq 6, logpos 0x17004c, timestamp: 56447

14:41:00  Maximum server connections 1 
15:36:00  Fuzzy Checkpoint Completed:  duration was 0 seconds, 1 buffers not flushed,
timestamp: 56477.
15:36:00  Checkpoint loguniq 6, logpos 0x17104c, timestamp: 56477

15:36:00  Maximum server connections 1 
16:31:00  Fuzzy Checkpoint Completed:  duration was 0 seconds, 1 buffers not flushed,
timestamp: 56512.
16:31:00  Checkpoint loguniq 6, logpos 0x17204c, timestamp: 56512

16:31:00  Maximum server connections 1 
17:26:00  Fuzzy Checkpoint Completed:  duration was 0 seconds, 1 buffers not flushed,
timestamp: 56542.
17:26:00  Checkpoint loguniq 6, logpos 0x17304c, timestamp: 56542

17:26:00  Maximum server connections 1