Trace Log of Insert, Update and Delete

p28 · #1 (**permalink**) 03-26-09, 09:15

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?

mirtheil · #2 (**permalink**) 03-26-09, 09:36

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?

p28 · #3 (**permalink**) 03-26-09, 09:47

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?

mirtheil · #4 (**permalink**) 03-26-09, 11:54

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

p28 · #5 (**permalink**) 03-26-09, 12:13

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech