We are running two Baan4c3 application servers sharing a single Oracle dbs server (clustered). In the past audit was setup on both appl.servers but now the audit reports are useless because each appl.server has it's own audit log and the reports differ. You have to ,somehow, combine the two reports.
Is it possible to setup audit in a 'shared' directory where the two servers write to the same (shared) directory. If so, will this give any locking type of problems ?
I also want to prevent any extra network load when writing the audit to an extra server. Can anyone give me some advise

If you want to have a combined audit file, you will have to have all the audit servers running on the same server in order to preserve the sequence numbers, etc.

You can do this by having one of the servers act as the "audit master" server. This is done by using Baan Net (with remote users) and running the audit server on the remote host (for example one of the app servers or the database server).

bpmdm000:903:oracle7(ORACLE_SID=grommit, ORACLE_HOME=...) &wallace!audit:N

The important values here are after the ampersand (&).

The host name is the first value (in this case "grommit"). This host must be configured to use Baan Net.

The exclamation point ("!") is a seperator followed by the name of the service to launch on the remote server ("audit").

The last value ("N") indicates that you should NOT audit this table on the local server. On the remote server the tabledef6.1 file will have the audit flag set to "Y" and no ampersand (&) values.

Since you are using Baan Net a Baan install will be required on the remote system.

There will be some network load due to running remote audit which cannot be avoided.

Hope this helps...

-- Jim

Jim,

You seem to be quite knowledgeable about the audit setup in Baan. I have posted a question about auditing myself way back and never managed to get a good answer, not even from BGS:

http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7&highlight=audit

If I remember correctly - and I would have to check my notes to be sure - using the remote audit option (& ! markers) doesn't allow you to run bdbpre/bdbpost commands on the local server?

You can most definitely change parameter files with remote audit (on Baan 5.0c). I have not tried it with Baan IV.

I usually run the bdbpre/post from the DB server (so that it will run as fast as possible). Therefore, since this is where I run audit, it is not an issue.

For details see the 7.1b Tools Update manual, appendix on audit for more information.

-- Jim