HCL OpenAdmin Tool (OAT) for Informix

The HCL OpenAdmin Tool (OAT) for Informix® is a web application for administering and analyzing the performance of HCL Informix database servers. 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:
  • Monitor the state of a database server with detailed status reports, alert information, and message logs.
  • Analyze the state of a database server and email results and recommendations by using the HCL Informix Health Advisor Plug-in for OpenAdmin Tool (OAT).
  • Monitor performance statistics over time with detailed charts of the performance history.
  • Monitor data gathered by the Scheduler, which runs administrative tasks and collects information by using SQL statements.
  • Run system validation checks on databases and tables on a database server.
  • Run system reports and onstat commands.
  • Drill down on SQL statements to review the performance details and optimize SQL statements.
You can use OAT to perform these administrative tasks:
  • Manage the database server including the configuration, user privileges, and virtual processors.
  • Create and monitor tasks for the Scheduler.
  • Manage the Auto Update Statistics (AUS) maintenance system, which automatically updates statistics to optimize query performance.
  • Manage database and table objects by using the HCL Informix Schema Manager Plug-in for OpenAdmin Tool (OAT).
  • Manage storage space and manage recovery logs for the database server.
  • Optimize space by compressing and defragmenting tables.
  • Back up the storage spaces for a database server.
  • Run SQL statements and perform standard SQL operations on tables.
  • Monitor and administer high availability clusters.
  • Monitor and administer Enterprise Replication by using the HCL Informix Replication 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 HCL Informix TimeSeries Plug-in for OpenAdmin Tool (OAT).

You can install the HCL OpenAdmin Tool (OAT) for Informix when you install the HCL Informix Client Software Development Kit (Client SDK) or when you install the HCL Informix software bundle and select Client SDK or HCL Informix Connect. This installation program includes OAT, the Health Advisor plug-in, Replication plug-in, Schema Manager plug-in, and TimeSeries plug-in, and all necessary software to run OAT, including pre-configured Apache, PHP, and PDO_informix.

Alternatively, the OpenAdmin Tool Community Edition is available from the HCL Informix Free Product Download page: https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-informixfpd (opens in new window). The OpenAdmin Tool Community Edition includes OAT and the optional plug-ins, but it does not include the supporting software. This edition must be installed manually.

Copyright© 2018 HCL Technologies Limited