Audit database changes
Related topics
By auditing Db2 log activity, you can generate detailed reports for compliance, security investigations, and operational transparency.
Log Master provides comprehensive reporting formats and supports filters by user, table, plan, column, and values.
The benefits include:
- Producing filterable, standardized audit reports for regulators and internal governance
- Investigating incidents quickly by using targeted log scans and report views
- Documenting completed and in-flight transactions within defined time frames
Workflow for auditing database changes
| Task | Product | Role | Action | Reference |
|---|---|---|---|---|
| 1 | BMC AMI Log Master for Db2 | Security or compliance analyst | Define a log scan for the audit window and apply filters. | Log Master and tasks associated with auditing |
| 2 | BMC AMI Log Master for Db2 | Security or compliance analyst | Select Report output and choose a standard presentation (by user, job name, plan name). | Log Master and tasks associated with auditing |
| 3 | BMC AMI Log Master for Db2 | Security or compliance analyst | Submit the job and review completed and in-flight transaction reporting. | Log Master and tasks associated with auditing |
| 4 | BMC AMI Log Master for Db2 | Db2 DBA | Optionally generate a logical log for permanent audit records. | LOGSCAN logical log output definition |
| 5 | BMC AMI Log Master for Db2 | Security or compliance analyst | Archive audit artifacts to governed libraries. | Log Master and tasks associated with auditing |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*