Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unanswered: Trace Log of Insert, Update and Delete

    Hi, I'm new to the Pervasive and our company's using Pervasive 2000i engine.
    We want to find out how to monitor the Insert, Update and Delete records of the users. Is there any function that we can use? or is there any 3rd party program for this purpose?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    You can turn on MKDE tracing but that is going severely impact performance.
    There aren't any third party tools but there is AuditMaster. It doesn't work with 2000i though. You'd need to upgrade to v9 or v10.

    What are you trying to accomplish with this monitoring?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Mar 2009
    Posts
    3
    We need to monitor unusal activity like big numbers of Inserts or Deletes to alert the management.
    It seems no luck in finding any tools for this purpose.
    Will upgrade to v9 or v10 any help?

    Quote Originally Posted by mirtheil
    You can turn on MKDE tracing but that is going severely impact performance.
    There aren't any third party tools but there is AuditMaster. It doesn't work with 2000i though. You'd need to upgrade to v9 or v10.

    What are you trying to accomplish with this monitoring?

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    With v9 or v10, you can purchase AuditMaster (Pervasive Software - Pervasive AuditMaster Overview) that can monitor all PSQL database operations and send alerts.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Mar 2009
    Posts
    3
    Thanks much for the info.

    Quote Originally Posted by mirtheil
    With v9 or v10, you can purchase AuditMaster (Pervasive Software - Pervasive AuditMaster Overview) that can monitor all PSQL database operations and send alerts.

Posting Permissions

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