DB2 for i Audit

Overview

DB2 for i within Event Manager is handled by Powertech Database Monitor for IBM i and Visual Message Center Data Monitor and Interactive SQL Monitor data sources.

Powertech Database Monitor for IBM i

Formally known as Data Thread, Powertech Database Monitor for IBM i is a high-performance database monitor that helps you automate and centralize monitoring and user activity reporting for your IBM i servers. When a user accesses a database file, Database Monitor tracks what they see, where they go, and what they do, including changes they make to sensitive information like payroll files.

You can use Database Monitor to:

  • Automatically maintain a complete audit record of all database adds, updates, changes, reads, and deletes.
  • Apply electronic signatures to database changes based on your specifications.
  • Send notifications to users when changes are made based on custom criteria.
  • Create workflow scenarios for routing and approval of changes.
  • Collect records and eSignatures in a secured file outside of the primary database.

Read more about Powertech Database Monitor for IBM i here.

VISUAL Message Center Data Monitor

Data Monitor is an iSeries auditing tool that efficiently collects data from journals and monitors data at field-level, is based on dynamic policies, and is capable of monitoring data in real-time and in multiple database files simultaneously. With Data Monitor you can monitor, for example, unexpected access, malicious modifications and changes that compromise data integrity.

Use Data Monitor to audit your iSeries and make sure you comply with laws regarding data access and protection, such as Sarbanes-Oxley (SOX), and Payment Card Industry (PCI) Data Security Standard.

Read more about VISUAL Message Center Data Monitor here.

VISUAL Message Center Interactive SQL Monitor

The VISUAL Message Center Interactive SQL Monitor provides a means to make the security of your relational database residing on IBM i systems much tighter, by capturing all the SQL statements executed on your systems and partitions.

SQL Monitor only monitors access executed using SQL. It does not monitor accesses performed using native technology.

Read more about VISUAL Message Center Interactive SQL Monitor here.