FP2: Audit improvements allow replay of past database activities

DB2® V9.7 Fix Pack 2 adds auditing capability that gives security administrators the ability to replay past database activities.

As part of a comprehensive security policy, a company might require that they retain the ability to retroactively go back a set number of years and analyze the effects of any particular request against certain tables in their database. To do this, they can institute a policy of archiving their weekly backups and associated log files such that they can reconstitute the database for any chosen moment in time. The database audit now captures sufficient information about every request made against the database to allow for the replay and analysis of any request against the relevant, restored database. This requirement covers both static and dynamic SQL statements.