Hi,
Is there any way to know what are all the tranasactions performed by a users.


bye.

Current transactions can be found with 'onstat -x', you can search for 'old' specific transactions/users with the onlog utility.

Greetz,

Rob Prop

Hi,

If i do a insert into table test; can i trace out this statment from the logical log and know whether the insert is commited or not.


there is a utility in oracle called LOGMINER, which shows all the queries made by the user. Is there any such utility in informix.

bye

onlog is the utility - but it can be very hard to read.

You could try using the trusted facility stuff. Its Informix's audit mechanism and you would have to turn it on and do some (pretty simple) configuration to get it going.

Might be easier than trying to read the l-logs unless you really need to get that deep.

Just checkout the onmonitor documentation.

In IDS, I normally do this

onstat -g sql


then look at certain session id.. then perform this

onstat -g ses <session id>