SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How many triggers

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
How many triggers
Author Message
weaton20



Joined: 18 May 2007
Posts: 2
Country: United States

Post How many triggers Reply with quote
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?
Fri May 18, 2007 8:46 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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.
Fri May 18, 2007 9:52 am View user's profile Send private message
weaton20



Joined: 18 May 2007
Posts: 2
Country: United States

Post Reply with quote
Capturing actual changes, so the second approach.

Thanks, that answers my question.
Fri May 18, 2007 9:55 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.