Additional sources of audit information
In addition to the audit trace, Db2 offers other sources of audit information for you to use.
- Additional Db2 traces
- Db2 accounting, statistics, and performance traces are also available. You can also use IBM® OMEGAMON® for Db2 Performance Expert on z/OS® to print reports of these traces.
- Recovery log
- Although the recovery log is not an all-purpose log, it can be useful for auditing. You can print information from the log by using the DSN1LOGP utility. For example, the summary report can show which table spaces have been updated within the range of the log that you scan. The REPORT utility can indicate what log information is available and where it is located.
- Image copies of table spaces
- Typical recovery procedures generate image copies of table spaces. You can inspect these copies, or use them with the RECOVER utility to recover a table space to a particular point in time. If you recover to a point in time, you narrow the time period during which a particular change could have been made.
- z/OS console log
- The z/OS console log contains messages about exceptional conditions that are encountered during Db2 operation. Inspect this log for symptoms of problems.