Unanswered: What is your experience with audit trail logging in DB2 9.7?
I have so far implemented audit logging using triggers, so when a column in a table is deleted/updated/inserted, then you create a new audit row as defined in our system. These audit rows can then be displayed to the user, etc.
DB2 9.7 has some auditing features, can it do what I have been doing in my above statement? I checked DB2 v. 10 and it seemed to have a more flexible auditing approach? E.g. one seems to be able to define straight in the schema what tables/columns to be logged...