Hello,

is it possible to audit only a few fields in a table? e. g table tccom001. I am not interested to see changes in the fields namc, namf, telp1 and telp2.

How can I get them out of the audit?

My idea was to disable the audit trail in the table definition of tccom001. I let the convert to runtime DD run. Then I made changes with session tccom0101m000 and printed the audit file, but the fields I wanted to leave out are still logged. Did I forget anything?

Thanks in advance for your help.

Germanicus

Hi Germanicus,

your idea is right. We've did this successfully some time ago for tdinv001 (and some more). Currently I don't remember that we've done additional things.
Maybe except of a Baan restart (for new reading of the audit parameter from the runtime DD).

Regards
Christof

Hello Christof,

thanks for the answer. My changes do not become effective. Convert to runtime DD is the only reason I can think of.

Is there any other idea why the excluded table fields are still audited?

Thanks

Germanicus

Hi there,

I am absolutely sure that your approach (disabling audit trail on field level in table definition) is correct and we are using this successfully to monitor changes in the items table ignoring changes on fields like reservations or stock quantity.
Did you restart Baan or did you only do a CTRDD? Which DB do you use?
Another thing might be the use of logical tables.

Good luck

Norbert

Hello Norwim,

yes I executed the CTRDD and restarted the system. Maybe there is something to do on database level -> I don't have access to that because it's under control of an outsourcer our database is Informix.

Greetings

Germanicus

Check $BSE/lib/tabledef6.1. Is there any line started with tccom001?

Yes, there is an entry:

tccom001:720:informix(INFORMIXSERVER=baan,INFORMIXDIR=/infx940,ONCONFIG=onconfig.baan):Y
tccom001:920:informix(INFORMIXSERVER=baan,INFORMIXDIR=/infx940,ONCONFIG=onconfig.baan):Y

Greetings

Germanicus

That means that in comapnies 720 and 920 is audit for table tccom001 still set.

Hello jclju1,

does this mean that I have to disable the audit for table tccom001 to exclude some fields from the audit?

Greetings

Germanicus

Sorry, I didn't understand what you really want to do. Now it is clear to me also. You try to exclude only some fields from auditing changing field definition in Maintain Table Field session.
I didn't test it and don't know how it works.

Hi germanicus,

I will have a look next week when I am back on site.
To my understanding, auditing should be managed by the bshell rather than the informix driver that passes the Baan-3/4GL commands to the DB (has anyone more detailed info here?) - but I really doubt that any action is necessary on the informix part. I would assume that the information stored in the data dictionary control which entries are written to the audit files.
Our suppression of audit for certain fields of tiitm001 works fine, but we are using bisam - still I may not believe that the behaviour should differ with another DB ...

good luck

Norbert

I would assume that the information stored in the data dictionary control which entries are written to the audit files.

I think that last lines in table definition file describe for which fields is audit set. So, in my opinion, if you disable audit for one table field, this field must disappear from line started with AUDT.
Check table definition file in your operational package combination (usually $BSE/../dict/ddpack_comb/dtccom/dtccom001).

Hello,

I have found the reason for the problem.

The convert to Runtime DD was not really executed by the system. I could see that in $BSE dict dtccom001. At the end of this file there is a list which fields are in the audit.

Greetings

Germanicus