RE: Sniffer Decode for Informix

Obnoxio The Clown said > Bobby Medus wrote: > > > We are currently running 7.31.UC3XE on an AIX 4.3.3 server. One of > > our goals is to be able to identify all connections/sql > statements and > > log them to a file for security monitoring. I know that I > can capture > > a snapshot of this information from the sysmaster tables > however this > > only tells me what is running at the time the statement(s) > run. If we > > could capture the packet information as it comes across the wire we > > would be able to log that and {hopefully} not be too > intrusive on the > > users. > > Look into sqlidebug and sqliprint. > But make sure you have PLENTY of disk space first, and monitor it continuously, and put it in a none critical partition :-) Or set up a daemon to analyse the files as they come in and then ditches them. Colin Bull sending to informix-list