Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: How to know transactions performed by a user

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


    bye.
    zxczxczc

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Current transactions can be found with 'onstat -x', you can search for 'old' specific transactions/users with the onlog utility.

    Greetz,

    Rob Prop

  3. #3
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    How to find trans

    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
    zxczxczc

  4. #4
    Join Date
    Aug 2003
    Posts
    68
    onlog is the utility - but it can be very hard to read.

  5. #5
    Join Date
    Sep 2002
    Posts
    51

    Re: How to know transactions performed by a user

    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.
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  6. #6
    Join Date
    Sep 2003
    Location
    Third rock from the sun
    Posts
    15

    Re: How to know transactions performed by a user

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


    bye.
    In IDS, I normally do this

    onstat -g sql


    then look at certain session id.. then perform this

    onstat -g ses <session id>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •