Release Notes for OpenAdmin Tool for IDS

2.27, December 2009

Contents

OpenAdmin Tool for IDS
New features for OAT Version 2.27
OAT user interface in multiple languages
Enhanced configuration options in the Connection Manager
The onstat utility in OAT
Enhancements to the Schema Manager plug-in
Enhancements to the Enterprise Replication plug-in
Fixed defects
Known defects
Notices
Trademarks

OpenAdmin Tool for IDS

The OpenAdmin Tool (OAT) for IDS provides a graphical interface for IBM® Informix® Dynamic Server administration and performance analysis tools. A PHP-based Web browser administration tool, OAT provides the ability to administer multiple database server instances from a single location. Some of the tasks that you can perform with OAT include:

You can add your own extensions to OAT to create the functionality that you need. OAT is an open source program.

New features for OAT Version 2.27

The OpenAdmin Tool Version 2.27 has the following new features:

OAT user interface in multiple languages

The OAT user interface is available in multiple languages: Czech, Brazilian Portuguese, English, German, Hungarian, Italian, Japanese, Korean, Polish, Russian, Simplified Chinese, Slovak, Spanish, and Traditional Chinese. Earlier versions were available only in English.

Attention: OAT supports viewing and modifying data only in databases with the U.S. English locale. For example, if you access a database with an Italian or a Japanese locale, the data might not appear accurately.

Enhanced configuration options in the Connection Manager

The High Availability Clusters page (Server Administration > MACH) has the following enhancements to the Connection Manager wizard:

The onstat utility in OAT

You can display performance and status information for a database server by using the onstat utility in OAT.

Enhancements to the Schema Manager plug-in

The Schema Manager plug-in Version 1.2 has the following enhancements:

See the Schema Manager plug-in for OAT help, for more information.

Enhancements to the Enterprise Replication plug-in

The Enterprise Replication (ER) plug-in Version 2.4 has the following enhancements:

See the ER plug-in for OAT help, for more information.

Fixed defects

The following fixes were made for OAT Version 2.27:

Table 1. Defects fixed for Version 2.27
Problem Description Resolution
The installation process fails when OAT is installed on a drive other than the C drive. Fixed.
The IDS protocol is configured once for all OAT connections on the OAT Admin > OAT Config page. Fixed. The protocol is configured for each connection on the OAT Admin > Add a Connection or Admin > Edit a Connection page.
OAT plug-ins must be enabled after they are installed or upgraded. Fixed. OAT plug-ins are automatically enabled after they are installed or upgraded.
If the DELIMIDENT environment variable is set, modifying a task parameter through the Task Scheduler> Task Details page results in an error. Fixed.
If the DELIMIDENT environment variable is set, accessing the Performance Analysis > SQL Explorer page results in an error. Fixed.
On the Space Administration > DBSpaces page, when a dbspace is created, OAT makes the page size 2 KB regardless of the selected page size. Fixed.
OAT does not work properly with PHP 5.3.0 because it uses deprecated functions. Fixed.
If the DBSPACETEMP configuration parameter uses colons (:) as separators, the Server Administration > Configuration page incorrectly flags the parameter for not following the OAT recommendation. Fixed.
On the Space Administration > Compression page, the Estimate button is enabled for read-only groups. This action should be disabled for read-only groups. Fixed.
The SQL ToolBox > SQL Editor page does not support creating functions or procedures. Fixed.
Changing an external directive that is attached to an SQL statement by using the Performance Analysis > SQL Explorer pages results in an error. Fixed.
The Server Info box displays Primary as the server type for a standalone server. Fixed. The Server Info box now displays Standard as the server type.
Accessing the SQL ToolBox > SQL Explorer page can result in error -310 from the server. Fixed.
When a user who does not have user informix privileges attempts to connect to a database on the SQL ToolBox > Schema Manager page, OAT displays a PHP error. Fixed. OAT displays the error message returned from the server that explains that the user does not have privileges on the database.
On the Performance Analysis > System Report page, the SQL with the Most IO Time report is not correct. Fixed.
On the High Availability Clusters page (Server Administration > MACH), settings for a new service level agreement (SLA) are not applied. Fixed.
On the Space Administration > Compression page, running compression on a table for the first time creates an unnecessary error in the online.log file. Fixed.
On the High Availability Clusters page (Server Administration > MACH), in the list of servers for the cluster, the lag time for remote standalone (RS) secondary servers is displayed incorrectly as "0.00000s". Fixed. When the lag time is not being updated, it is displayed as "Not updating".
On the High Availability Clusters page (Server Administration > MACH), in the list of servers for the cluster, the workload information for RS secondary servers that are inactive and disconnected is displayed incorrectly. Fixed. When a server is inactive and disconnected the workload column displays a dash (-).
An IDS server problem can cause the Find Clusters button on the High Availability Clusters page (Server Administration > MACH) to fail. Fixed.
On the SQL ToolBox > Schema Browser > Table Browser page, when the option to display all the table rows is selected for a large table, an error occurs. Fixed. The option to display all the rows for a table is available only in tables with 500 or fewer rows. The options to view 50, 100, or 500 rows at one time were added.

See the Release Notes for the OpenAdmin Tool for IDS: Enterprise Replication Plug-in (releasenotes_er.html) to view the fixed defects for the plug-in.

Known defects

The following defects are known for Version 2.27:

Notices

This information was developed for products and services offered in the U.S.A.

IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user’s responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

IBM Director of Licensing
IBM Corporation 
North Castle Drive 
Armonk, NY 10504-1785
U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:

Intellectual Property Licensing
Legal and Intellectual Property Law
IBM Japan Ltd.
1623-14, Shimotsuruma, Yamato-shi
Kanagawa 242-8502 Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:

IBM Corporation 
J46A/G4 
555 Bailey Avenue 
San Jose, CA 95141-1003 
U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

All statements regarding IBM’s future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

All IBM prices shown are IBM’s suggested retail prices, are current and are subject to change without notice. Dealer prices may vary.

This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.

COPYRIGHT LICENSE

This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. The sample programs are provided "AS IS", without warranty of any kind. IBM shall not be liable for any damages arising out of your use of the sample programs.

Each copy or any portion of these sample programs or any derivative work, must include a copyright notice as follows:

If you are viewing this information softcopy, the photographs and color illustrations may not appear.

Trademarks

IBM, the IBM logo, and ibm.com® are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at “Copyright and trademark information" at http://www.ibm.com/legal/copytrade.shtml.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

Microsoft® and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.

Other company, product, or service names may be trademarks or service marks of others.

© Copyright IBM Corp. 2007, 2009