Downloads and Release History
The latest download is always available at the following website:
IBM Informix Free Product Downloads
Milestones and Changes in Recent Releases
2.28 - Released July 2010
- Support for non-English database locales
You can use OAT to view and modify data in any database locale that is supported for Informix database servers.
- Schema Manager Plug-in Version 1.3
The Schema Manager plug-in now includes a Create Index wizard as well as further external table enhancements./p>
- Automated installer support for Microsoft Windows 7
2.27 - Released December 2009
- UI Translations in 13 languages
Brazilian Portuguese, Chinese Simplified, Chinese Traditional, Czech, German, Hungarian, Italian, Japanese, Korean, Polish, Russian, Slovak, and Spanish
- Connection Manager Proxy Support
Use OAT to configure the Connection Manager as a proxy server when clients connect to Informix data servers from outside a firewall (11.50.xC6 and up).
- Schema Manager Plug-in Version 1.2
The Schema Manager plug-in has been enhanced to include various schema management actions, including
- Create tables, including external tables.
- Drop and truncate tables
- Load or unload data from external tables
- Monitor the status of load and unload tasks.
- Enterprise Replication Plug-in Version 2.4 (11.50xC4 and up)
ER plug-in version 2.4 rounds out the suite of ER administration commands supported in OAT as well as adding a number of usability enhancements.
- Improve the performance of the consistency check and synchronization tasks, using WHERE clauses and parallelism options.
- Change the master replicate server for a replicate.
- Instiate a template on multiple ER servers simulatenously.
- Delete ER objects including servers, replicates, replicate sets, and templates. Also delete information about completed check and synchronization tasks.
2.26 - Released July 2009
- Enterprise Replication Plug-in Version 2.3 (11.50xC4 and up)
Enhancements to the ER plug-in include:
- the ability to modify ER servers and replicates
- the ability to start, stop, suspend, resume, disconnect, reconnect, and cleanstart ER servers
2.25 - Released June 2009
- Schema Manager Plug-in Version 1.0
Introducing a new plug-in for OAT: the Schema Manager. Use this plug-in for a dashboard-like of view databases and tables on your Informix database server. For databases, see stored procedures, functions, sequences, UDTs, privileges, DataBlades, aggregetes, casts, and opclasses from one single view. For tables, views, and synonyms, the Schema Manager shows you information about its columns, indexes, references, constraints, privileges, UDTs, fragments, and triggers. The Schema Manager also provides you with ability to drill-down on any of its pods for more detailed information.
- Enterprise Replication Plug-in Version 2.2 (11.50xC4 and up)
The ER plug-in is now at version 2.2. This version includes all previous functionality and additionally now allows the following:
- Can now add and delete replicates from replicate sets.
- Can now change the replication frequency for the replicates in the set
2.24 - Released May 2009
- Compression (Informix 11.50xC4 and up)
- Enterprise Replication Plug-in Version 2.1 (11.50xC4 and up)
- Define ER servers
- Define replicates and replicate sets
- Define and realize templates
- Start, stop, suspend, and resume replicates and replicate sets
- Check replicates and replicate sets for data inconsistencies
- Repair data inconsistencies in replicates and replicate sets
- Synchronize data to repair inconsistencies in replicates and replicate sets
- Repair failed transactions by using Aborted Transaction Spooling (ATS) and Row Information Spooling (RIS) files
The Storage Optimization feature is new to Informix in 11.50.xC4. 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.
2.23 - Released December 2008
- SQL Explorer
- Filters and search fields for viewing SQL tracing data.
- Support for different SQL trace levels - global or user - so you can manage what kinds of SQL information are traced for Informix V11.50.xC1 servers.
- Support for suspending and resuming history tracing, without releasing resources, on Informix V11.50.xC1 servers.
- Enterprise Replication Plug-in Version 2.0
- Added Replicate Explorer - to monitor replicates and replicate sets
- Can now edit ER configuration parameters on the Node Details -> Configuration page
SQL Explorer has been newly redesigned. New features include:
Version 2.0 of OpenAdminTool’s Enterprise Replication plug-in includes a new Replicate Explorer and becomes the first step in supporting ER administration graphically through OAT.
2.22 - Released August 2008
- Enterprise Replication Functionality Enhancements
- Added ability to monitor the entire Enterprise Replication domain from a single screen.
- The Routing Topology page is enhanced to display thresholds, alerts, and profile data without having to drill down on each node.
- View errors for the ER domain and for the current node from the new Errors page, in the Node Details pages. Two filters help to customize the list of errors.
- Find out what the Enterprise Replication configuration parameters are set to from the new Configuration page.
- Improved User Authentication Security for SQLToolbox
2.21 - Released June 2008
- Automated Installer for Apple Platform
- Enterprise Replication Plug-in Version 1.0
- Disk usage
- Send and Receive queues
- Receiving/Apply statistics
- Routing Topology
- Node details
- ..and much more.
- Plug-in Support
- Custom Menu Builder
Automatically setup Apache, PHP, I-Connect and OAT on Mac OS X. For users who want to use or install their own Apache/PHP configurations, OAT is also released as a standalone package.
Enterprise Replication plug-in allows domain monitoring of:
OAT Enterprise Replication is provided as a separate plug-in. You can simply place the ER plug-in zip file under the OAT plugin_install directory and install it with the plug-in manager.
A simple way to customize OAT functionality. You can download customized OAT plug-ins and install them with the plug-in manager. Sample plug-in code is also provided and you can follow the sample in creating your own plug-ins. Should allow more ISVs to explore adding additional functionality as needed.
Now add your own menus to the OAT interface. Use this along with the new plug-in functionality to tailor OAT to your specific needs!
2.20 - Released May 2008
- Automated Installer for Windows and Linux
- New User Interface
- The interface has been overhauled and is now easier to use and more intuitive.
- New Dynamic Reconfiguration and Onconfig parameter recommendations
- New Performance Statistics
- Automatic Update Statistics
- Historical Data Graphs
- Operating system specific statistics
- Usability Improvements
- Improved documentation and FAQ
- New menu highlighting and restructuring
- New Task Scheduler Wizard
- New Virtual Processor Administration
- New Mach11 server controls (Start/Stop), enhanced security (IDSD) and setup wizards
- HOWTO.html help guide added
- Reliability Improvements
- Perform regular system integrity checks
- Security Improvements
- New Privileges Manager and Read-Only ACL
- Other
- Environment variable support on server connections
- RSS support was removed
Automatically setup Apache, PHP, I-Connect and OAT on Windows and Linux. For users who want to use or install their own Apache/PHP configurations, OAT is also released as a standalone package.
