How do I monitor database server activity?
- Monitoring database server status
Monitor the status of a specific database server in real time or view the status all the servers in an OAT group at the same time. - Customizing the dashboard
Change the status information that the dashboard displays for a specific database server. - Modify the status thresholds for the dashboard
Modify the thresholds for the status indicators that are displayed on the multiserver dashboard. - Monitoring alerts and event alarms
Monitor event alarms generated by the database server and alerts generated by the Task Scheduler or by built-in tasks and sensors. - Reviewing the admin command history
Review the SQL administration API functions that ran on the database server, including information about the user who ran the command, the time that the command ran, the command, and the message returned by the database server. - Monitoring the online message log
Review the most recent part of the online message log for the database server. - Deleting the online message log
Delete or truncate the online message log file for the database server. - Rotating the online message log
Enable, disable, or modify automatic rotation of the online message log file for the database server. - Monitoring the ON-Bar activity log
Review the ON-Bar activity log for the database server. - Deleting the ON-Bar activity log
Delete or truncate the ON-Bar activity log file for the database server. - Rotating the ON-Bar activity log
Enable, disable, or modify automatic rotation of the ON-Bar activity log file for the database server.
Parent topic: HCL OpenAdmin Tool (OAT) for Informix