We have audit turned on on table tdpur032. We also have a customized program that uploads data in tdpur032, and when running this with +/- 70000 records as input data, we get an error : "Log_mesg: Reached maximum audit records/table per transaction. Session tdpur0232m00c, table tdpur032910 Limit = 32767. ABORT !!!" And also : "Log_mesg: Error 254 (Commit transaction has failed in the audit server) on tdpur032910 in SELECT"
Has anyone got any info on the AUDIT_MAX_ROWS variable ? Where can it be set ? Can we put it to any required value or is 32767 a "hard" limit (smells like 32768, doesn't it) ?

Well, AUDIT_MAX_ROWS if it exists as a variable (and it may) would be settable in the environment or in $BSE/lib/defaults/all as
"audit_max_rows:"

Of course, the easy fix would be to commit once every 30k records.

Dave