Hi,

I would like to know if anyone has turn on audit trail?
My question is:-
1) How is it done?
2) What is the impact on operation?
3) What is the best practise?

Thank you so much!

Best Wishes,
Zaid

Everybody has turned on audit trail because you need them on the parameter tables.

We have turned them also on for specific tables. Issues are performance, it can create a lot more I/O and disk space. So you need to be carefull and have a good reason to turn it on. Disk space shouldn't be an issue since you can specify how many files maximal should be used.

Turning it on depends on you version: within BaanIV you have to assign the table to the database definition that has audit turned on, within V you have to add the table and turn the audit option on on the same level.

Han

In Baan IV add table to list in session Assign Tables to Database ttaad4111m000, assigning table against audit database.

Convert to runtime in this session and audit should start for specified table on next login.

We have added tiitm001 and tccom020 to the audit without any noticable impact upon operation.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hi,

In the session "assign Tables to databases (ttaad4111m000), you can load the mandatory tables for audit. For other speific tabeles, you have to insert the required tables and link to the database where audit trial is turned "on"

Also you have to log in as root and run the session "Assign Audit security to users (ttaad4162m000) under audit management to log the audit of a particulr user

w.r.t to the performance, if the table which you are assiging to Audit has more transactions and more I/O, then your system performance will be affected to some extent

Regards

thank you!!