OpenAdmin Tool (OAT) for Informix

Use this page to view real-time status information about the database server, including space allocations, locks, memory usage, and the number of transactions.

You can administer multiple database server instances from a single OAT installation on a web server. You can access the web server through any browser to administer all your database servers. You can use OAT to monitor and analyze the performance of a database server and to perform administrative tasks.

The Health Center > Dashboard page is the home page for the OpenAdmin Tool (OAT) for Informix®. You can change the dashboards on the page or add dashboards by using the Admin > Dashboard Manager page.

From the OAT menu, you can access the following features:

Health Center: Monitor the state of a database server with detailed status reports, alert information, and messages. Analyze the state of a database server and email results and recommendations by using the IBM® Informix Health Advisor Plug-in for OpenAdmin Tool (OAT).
Logs: View previous administration commands, recent messages from the online log, and the latest backup and recovery information from the ON-Bar Activity log.
Task Scheduler: Monitor data gathered by the Scheduler, which runs administrative tasks and collects information by using SQL statements. Create and monitor tasks for the Scheduler.
Space Administration: Manage storage space and recovery logs for a database server. Optimize space by compressing tables. Back up the storage spaces for a database server.
Server Administration: Manage a database server, including the configuration, user privileges, and virtual processors. Run system validation checks on databases and tables on a database server. Manage the Auto Update Statistics (AUS) maintenance system, which automatically updates statistics to optimize query performance.
Replication: Monitor and administer high availability clusters. Monitor and administer Enterprise Replication by using the IBM Informix Replication Plug-in for OpenAdmin Tool (OAT). Create and administer grids of interconnected replication servers in a domain.
Performance Analysis: Drill down on SQL statements to review the performance details and optimize SQL statements. Monitor performance statistics over time with detailed charts of the performance history. Run system reports and onstat utility commands.
JSON: View information about databases and collections.
SQL ToolBox: Run SQL statements and perform standard SQL operations on tables. Manage database and table objects by using the IBM Informix Schema Manager Plug-in for OpenAdmin Tool (OAT). Monitor and administer database objects related to a time series, including tables, indexes, and virtual tables, and TimeSeries subtypes, containers, and calendars by using the IBM Informix TimeSeries Plug-in for OpenAdmin Tool (OAT).
Help: View online resources for using OAT.
Admin: Go to the Admin pages to configure OAT.