OpenAdmin Tool for Informix (OAT)

OpenAdmin Tool is a PHP-based Web browser administration tool for managing one or more Informix database servers. The OpenAdmin Tool for Informix provides the ability to monitor and administer multiple Informix database server instances from a single location. Some features in the OpenAdmin Tool include:

  • Compression: Utilizes the Storage Optimization functionality in Informix 11.50xC4 to save disk space by compressing tables and table fragments, consolidate free space in tables and fragments through a repack operation, and return free space to the dbspace through the shrink operation. OAT also helps you to decide which tables or fragments to compress by graphically showing you the estimated the amount of space that compression will save. (Available only in OAT 2.24, Informix 11.50xC4 and above)

  • Enterprise Replication: The Enterprise Replication plugin can now be used to do remote graphical setup, administration, and monitoring of replication - on the domain level, on the node level, and on the replication level. Provides complete control over replication servers, replication sets and provides failed transaction recovery options. (Available only in OAT 2.24, Informix 11.50xC4 and above)

  • Schema Manager: The Schema Manager plugin can be used to view database and table objects. It can also be used to create, drop, and truncate tables, as well as load and unload data from external tables.

  • Health Center: Allows you to analyze the current state of the server with detailed statistics and alert information.

  • Logs: View previous administration commands, recent messages from the online log, and the latest back up and recovery information from the ON-Bar Activity log.

  • Task Scheduler: View and update Scheduler tasks to be run at the current server.

  • Space Administration: Manage server space for your system with tools to administer dbspaces, chunks, checkpoints, and the physical and logical logs.

  • Server Administration: Configure and validate your servers, as well as administer high availability clusters (MACH clusters).

  • Performance Analysis: Get high quality and detailed performance statistics about your databases with the SQL exploration of each table, statement, or transaction. Query drill down and session exploration provide detailed information about every aspect of transactions and statement types. View over 20 system performance reports, such as memory pools, the five slowest transactions, and server memory usage.

  • SQL Toolbox: Explore your databases, view table statistics, browser schemas, run queries, and view query plans.

  • Help: View online resources for using the OpenAdmin Tool for Informix. You can easily plug in your own extensions to OpenAdmin to create the functionality you need. OpenAdmin is an open-source program that you can download.