How many triggers

If I use DBAudit to audit changes in a DB2 database, does it add a trigger for each column being audited, or is there a single trigger containing all audited columns?

If you use choose to use system auditing to monitor change events (user activity in the database), it doesn't create any triggers - triggers are not used for that type of auditing

If you need to capture actual changes for SOX compliance (or similar) and store audit trail of changed data then it creates a single trigger for all columns for each operation type - 1 trigger for all inserts, 1 trigger for all deletes and 1 trigger for all updates.

Now when I said all columns I meant the default option. You can choose to audit only certain columns and/or setup column change filters that trigger the auditing, for example, only if SSN and name columns change.

Capturing actual changes, so the second approach.

Thanks, that answers my question.