Checking data consistency with the operation log

You can use the operation log to verify that Db2 is operated reliably and to reveal unauthorized operations and overrides. The operation log consists of an automated log of Db2 operator commands, such as those for starting and stopping the subsystem, and Db2 abends.

About this task

The operation log records the following information:

Command or condition type
Date and time when the command was issued
Authorization ID that issued the command
Database connection code

You can obtain this information from the system log (SYSLOG), the SMF data set, or the automated job scheduling system. To obtain the information, use SMF reporting, job-scheduler reporting, or a user-developed program. As a good practice, review the log report daily and keep a history file for comparison. Because abnormal Db2 termination can indicate integrity problems, implement an immediate notification procedure to alert the appropriate personnel (DBA, systems supervisor, and so on) of abnormal Db2 terminations.