Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Unanswered: list of changes to the tables/structure

    How do I get a system generated report for a list of changes to tables/structure in Informix.

    Thanks

  2. #2
    Join Date
    Mar 2006
    Posts
    2
    Also looking for a way generate a report to determine the date/time stamp of changes implemented .

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    I suggest you that daily run dbschema -d databasename -t all -f all -q
    Then compare this files.

    Gustavo.

  4. #4
    Join Date
    Jan 2004
    Posts
    28
    hi

    you can turn on the feature called AUDITING for all
    the databases.

    there are specific auditing events are there like ACTB,INRW,DIRW

    you can set those events to monitor who are all accessing
    the datbase/tables.

    userid,timestamp,everything you can see inside the log file

Posting Permissions

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