The purpose of these release notes for IBM® Informix® Client Software Development Kit and IBM Informix Connect Connect Version 3.70 is to:
These release notes are not intended to be all-inclusive; they should be used as an addendum to the product manuals.
You should read these release notes if you are:
When you install the IBM Informix Client Software Development Kit (Client SDK), Version 3.70, you have an option to install the IBM OpenAdmin Tool (OAT) for Informix. The OAT option is also available if you install the IBM Informix software bundle and you select either IBM Informix Connect or IBM Informix Client Software Development Kit (Client SDK). OAT is a web application for administering and analyzing the performance of IBM 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 IBM Data Server Driver to install and evaluate the common client drivers with IBM Informix. The current Data Server Driver package available is Version 9.7 FP4.
The ConnectTest utility is included in IBM Informix Client Software Development Kit (Client SDK), Version 3.70. The utility is installed with Client SDK or Informix Connect on the Windows 32-bit and 64-bit platforms. The ConnectTest utility is a user interface that can execute SQL queries and display the resulting data of the executed SQL query.
This feature is documented in the IBM Informix Client Products Installation Guide.
Some installation commands changed to take advantage of new and changed functionality and to improve consistency across products and operating systems.
You can remove specific products by using the following commands, which are in new subdirectories relative to the root directory:
This feature is documented in the IBM Informix Installation Guide for UNIX, Linux, and Mac OS X, IBM Informix Installation Guide for Windows, IBM Informix JDBC Driver Programmer's Guide, and IBM Informix Client Products Installation Guide.
New editions and product names
IBM Informix Dynamic Server editions were withdrawn and new Informix editions are available. Some products were also renamed. The publications in the Informix library pertain to the following products:
For more information about the Informix product family, go to http://www.ibm.com/software/data/informix/.
The IBM Informix Client Software Development Kit (Client SDK) and IBM Informix Connect products have distinct functionalities:
To help you prepare for installing or upgrading Client SDK or Informix Connect, follow these steps:
Most component products have their own release and machine notes that are available in the /doc directory of the product media before installation. The following table lists the component products in IBM Informix Client Software Development Kit (Client SDK) and IBM Informix Connect and the release notes and machine notes file names.
The release notes and machines are available after installation in the /release/locale directory of the Client SDK or Informix Connect installation (except where noted). Release notes file names are shorter after installation.
| Component product | Notes files |
|---|---|
| IBM Informix Object Interface for
C++
A C++ interface to develop object-oriented client applications for use with all IBM Informix and client-side value objects for IBM Informix |
libcpp_release_notes_3.70.html, libcpp_release_notes_3.70.txt
CPP_3.7.txt |
| IBM Informix ESQL/C
An SQL embedded-language product that is used to create custom C applications |
esqlc_release_notes_3.70.html, esqlc_release_notes_3.70.txt
ESQLC_3.7.txt |
| IBM Informix GLS
An interface that allows IBM Informix. |
glsapi_release_notes_5.00.html, glsapi_release_notes_5.00.txt
GLSAPI_5.0.txt |
| IBM Informix ODBC Driver
An IBM Informix. |
odbc_release_notes_3.70.html, odbc_release_notes_3.70.txt
INFODBC_3.7.txt |
| IBM Informix .NET Provider (Windows only)
A .NET assembly that lets .NET applications access and manipulate data in Informix databases. Requires .NET Framework, Version 2.0 The .NET Framework Version 1.1 is not supported in Client SDK Version 3.70. |
dotnet_release_notes_3.70.html, dotnet_release_notes_3.70.txt
NET_3.7.txt |
| IBM Data
Server Driver
The IBM Data Server .NET Provider is a .NET assembly that lets .NET applications access and manipulate data on IBM data servers |
No notes available |
| IBM Informix OLE DB Provider
A client-side, native OLE DB provider that implements full functionality for base-level providers and contains extensibility support for Informix |
oledb_release_notes_3.70.html, oledb_release_notes_3.70.txt
OLEDB_3.7.txt |
| IBM Informix Connection Manager | cmsm_release_notes_3.70.html, cmsm_release_notes_3.70.txt |
| LIBMI Client API
The DataBlade® API for client applications |
No notes available |
| Simple Password Communication Support Module (SPWDCSM)
Provides password encryption for client applications |
No notes available |
| Generic Security Services Communication Support
Module (GSSCSM)
Provides single sign-on authentication for client applications |
No notes available |
| IBM Informix Setnet32 utility (Windows only)
A utility for setting environment variables and configuring connections to the database server |
No notes available |
| DSN Migration utility (Windows only)
A utility for migrating or restoring an Intersolv ODBC DSN to an IBM Informix. |
No notes available |
| Ilogin Demo (Windows only)
A utility to test connections to IBM Informix. |
No notes available |
| finderr (UNIX) and Find Error (Windows)
A utility to find information about IBM Informix. |
No notes available |
| Documentation Viewer (Windows only)
A utility to view client release and machine notes in text format |
No notes available |
| IBM OpenAdmin Tool (OAT) for
Informix
OpenAdmin Tool (OAT) for Informix is a web application for administering and analyzing the performance of IBM Informix database servers. |
oat_relnotes_2.74.html, oat_relnotes_2.74.txt |
In addition, some APIs have demonstration programs and examples.
Founded in 1995, International Informix Users Group (IIUG) is the most influential user group representing the users of IBM Informix products. Thousands of IIUG members around the world network with each other and share knowledge and other resources. Visit the IIUG website (http://www.iiug.org) which, amongst other things, supports a Software Archive (http://www.iiug.org/software). The Software Archive contains the source code for a lot of utilities that might be of interest to you as you use IBM Informix. Note, however, that these utilities are not supported by IBM.
IIUG membership is free.
All components except for the Global Language Support (GLS) libraries have the same version number as the IBM Informix Client Software Development Kit (Client SDK) and IBM Informix Connect that they are a part of. The GLS libraries are version 5.0 for this release of Client SDK and Informix Connect.
For information about which database servers each IBM Informix Client Software Development Kit (Client SDK) and IBM Informix Connect component supports, see the individual release notes files for those components.
You can find the answers to many of your questions on the IBM Informix Support Portal: http://www.ibm.com/software/data/informix/support.
You can use the IBM Informix Support Portal to conduct any of the following tasks:
The IBM Informix Version 11.70 information center integrates the entire IBM Informix Version 11.70 and IBM Informix Client Software Development Kit Version 3.70 documentation sets. The information center provides full text search, logical categories, easy navigation, and links to troubleshooting and support files.
The web address for the Informix Version 11.70 information center is http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp.
You are encouraged to send your comments about IBM Informix user documentation.
Use one of the following methods:
Feedback from all methods is monitored by the team that maintains the user documentation. The feedback methods are reserved for reporting errors and omissions in the documentation. For immediate help with a technical problem, contact IBM Technical Support at http://www.ibm.com/planetwide/.
We appreciate your suggestions.
This section describes installation issues.
Before you begin, ensure the following:
When you upgrade the operating system of a Mac OS X 10.5 computer hosting Client SDK and Informix Connect, Snow Leopard often takes ownership of the user identifier (UID), the group identifier (GID), or both that was assigned to the user and group informix as part of the product installation. This causes initialization or startup of the IBM Informix product to fail, with a message that the required user informix or group informix is not present.
To enable startup of the IBM Informix client in this situation, you must restore the user and group informix without overwriting the UID and GID with which Snow Leopard completes internal OS operations. A script is available in the installation media that assigns user and group informix to an available UID and GID that Snow Leopard does not use. You might need to perform additional steps before and after running the script to fix your IBM Informix client setup correctly.
To initialize or start Client SDK or Informix Connect with a new UID and GID on Snow Leopard:
If you have multiple installations in different directories, change environment variables accordingly and run the script with the different INFORMIXDIR value.
The IBM Informix Client Software Development Kit and IBM Informix Connect installation program provides a JRE to use during installation. Alternatively, you can specify to use a JRE that is already installed on your computer.
Installing IBM Informix Client Software Development Kit and IBM Informix Connect using RedHat Package Manager is no longer supported.
The default directory install location was changed in IBM Informix Client Software Development Kit (Client SDK) and IBM Informix Connect 2.90.TC3 on Windows. After upgrading to this release on Windows, you must restart your computer if all of the following conditions are true:
All other applications do not require a restart after upgrading.
IBM Informix Client Software Development Kit and IBM Informix Connect Version 3.70 were built with the Visual Studio 2008 compiler.
The C++ runtime system is necessary to use IBM Informix 9.40.xC1 or later. See the Informix machine notes for the C++ requirement.
You cannot install IBM Informix Client Software Development Kit and IBM Informix Connect in a directory with more than 215 characters in the full path name.
Do not install the 32-bit and the 64-bit editions of the same versions of IBM Informix Client Software Development Kit and IBM Informix Connect on the same system.
To enable connections between database servers on the Microsoft Windows Vista operating system, you must enable network discovery and NetBIOS over TCP/IP.
To enable connections:
If you create applications with Visual Studio 2005, you must embed the manifest in the executable files and DLLs.
Use this command to embed a manifest file in a DLL:
mt.exe -manifest manifest_filename -outputresource:dll_name;2
Use this command to embed a manifest file in an executable file:
mt.exe -manifest manifest_filename -outputresource:dll_name;1
For more information about manifests, see the Microsoft website.
Client APIs used to query the version of the server can return the incorrect string of "9.50.UC1" when used against IBM Informix Version 10.00.UC1.
| Platform/OS | BSTP | IPSP | IPSM | TLTP | TLIX | MAXC | SSL |
|---|---|---|---|---|---|---|---|
| AIX®-32 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| AIX-64 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| HP Itanium 64 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| HPUX-32 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| HPUX-64 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| Linux 32-bit | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| Linux AMD 64 | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| Linux pSeries | onsoctcp | onipcstr | onipcshm | onsocimc | drsocssl
onsocssl |
||
| Mac OS X | onsoctcp | onipcstr | onipcshm | onsocimc | |||
| Solaris-32 | onsoctcp | onipcstr | onipcshm | ontlitcp | ontlispx | ontliimc | drsocssl
onsocssl |
| Solaris-64 | onsoctcp | onipcstr | onipcshm | ontlitcp | ontliimc | drsocssl
onsocssl |
|
| Solaris Operton | onsoctcp | onipcstr | onipcshm | ontlitcp | onsocimc | drsocssl
onsocssl |
BSTP - Berkeley sockets using TCP/IP
IPSP - IPC using stream pipe
IPSM - IPC using shared memory
MAXC - MaxConnect
SSL - Secure Sockets Layer
TLTP - TLI using TCP/IP
TLIX - TLI using IPX/SPX
Notes:
This section describes the known corrections and changes that need to be made to the IBM Informix Client Products Installation Guide.
No corrections or changes are necessary at this time.
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 other 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 grant you any license to these patents. You can send license inquiries, in writing, to:
For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
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 websites are provided for convenience only and do not in any manner serve as an endorsement of those websites. The materials at those websites are not part of the materials for this IBM product and use of those websites 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:
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 document 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 is for planning purposes only. The information herein is subject to change before the products described become available.
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:
© (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs.
© Copyright IBM Corp. _enter the year or years_. All rights reserved.
If you are viewing this information softcopy, the photographs and color illustrations may not appear.
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.
Adobe, the Adobe logo, and PostScript are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries.
Intel, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft, Windows, and Windows NT are trademarks of Microsoft Corporation in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, or service names may be trademarks or service marks of others.
Contact support: http://www.ibm.com/support/entry/portal/
© Copyright IBM Corp. 1996, 2011