Toad World® Forums

DB2 audit performance impact

Client requested to audit all user SQL statements to check who is accessing the data. We are going to implement `execute’ audit policy. How much it will impact performance of the database??

Hello,

my experience with many db and a subset of table from every db, say that there no high impact on CPU, what can encrease

is the I/O when write data in execute file when buffer is full.

Note that in my case that I/O encrease less then 1% and take note the audit files are in common directioy shared via NFS in

another server.