[KLUG Members] Informix ODBC Gehenna

[Adam Tauno Williams]

> >9.4 is SWEET!
> Yes we are considering buying it, except the other admin is making
> management think they want to pitch the whole system.

Hopefully sanity prevails. I love those "we gotta pitch everything"
guys.

> >Can you ssh/telent to the server to see the output of "onstat -m"
> >immediatly after trying this to see if there is a message about an
> >unauthtorized client?
> Here is the output:
> Message Log File: /i/informix/online.log
> 08:14:40  Checkpoint Completed:  duration was 0 seconds.
> 08:19:43  Checkpoint Completed:  duration was 0 seconds.
> 08:24:46  Checkpoint Completed:  duration was 0 seconds.
> 08:29:49  Checkpoint Completed:  duration was 0 seconds.
> 08:34:52  Checkpoint Completed:  duration was 0 seconds.
> 08:39:55  Checkpoint Completed:  duration was 0 seconds.
> 08:44:58  Checkpoint Completed:  duration was 0 seconds.
> 08:50:01  Checkpoint Completed:  duration was 0 seconds.
> 08:55:04  Checkpoint Completed:  duration was 0 seconds.
> 09:00:07  Checkpoint Completed:  duration was 0 seconds.
> 09:05:10  Checkpoint Completed:  duration was 0 seconds.
> 09:10:13  Checkpoint Completed:  duration was 0 seconds.
> 09:15:16  Checkpoint Completed:  duration was 0 seconds.
> 09:20:19  Checkpoint Completed:  duration was 0 seconds.
> 09:25:22  Checkpoint Completed:  duration was 0 seconds.
> 09:30:25  Checkpoint Completed:  duration was 0 seconds.
> 09:35:28  Checkpoint Completed:  duration was 0 seconds.
> 09:40:31  Checkpoint Completed:  duration was 0 seconds.
> 09:45:34  Checkpoint Completed:  duration was 0 seconds.
> 09:50:37  Checkpoint Completed:  duration was 0 seconds.

Ok, no connection refused messages.  

BTW, your checkpoints are basically instantaneous (I'm assuming your
business is open when this was taken),  you might be able to move
CKPTINTVL up a little and increase write throughput.  It looks like the
default value of 300 seconds.  Just make sure CLEANERS is set to the
number of physical drives (assuming that number is less than 10).  

> >Cab you telnet to the online sevice port (1526?) on the server and get
> >a connection?  (Then just close the telnet client).
> No. connection refused.

Wow.  I'd guess that someone shutdown network connectivity to the
engine.  

Does your onconfig file have a NETTYPE soctcp entry?  Or just an ipcshm
entry?

Does "netstat -ap" on the server show a line like -

tcp        0      0 *:online                *:*                    
LISTEN