Ids Cpi Bookmap
Ids Cpi Bookmap
Ids Cpi Bookmap
GC27-4495-00
GC27-4495-00
Note
Before using this information and the product it supports, read the information in Notices on page D-1.
This document contains proprietary information of IBM. It is provided under a license agreement and is protected
by copyright law. The information contained in this publication does not include any product warranties, and any
statements provided in this publication should not be interpreted as such.
When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any
way it believes appropriate without incurring any obligation to you.
Copyright IBM Corporation 1996, 2013.
US Government Users Restricted Rights Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp.
Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
About this Publication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
What's new in installation for IBM Informix client products, Version 4.10 . . . . . . . . . . . . . . vii
Additional documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Compliance with industry standards . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Syntax diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
How to read a command-line syntax diagram . . . . . . . . . . . . . . . . . . . . . . . ix
Keywords and punctuation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x
Identifiers and names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x
How to provide documentation feedback . . . . . . . . . . . . . . . . . . . . . . . . . xi
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Chapter 2. Installing Client SDK and Informix Connect on UNIX and Linux Systems
Installation System Requirements for UNIX and Linux. . . . . . .
The Informix Client Installation Application . . . . . . . . . .
Client Products Installation Application Commands (UNIX and Linux)
Installing Client Products in Console Mode . . . . . . . . .
Installing Client Products in GUI Mode . . . . . . . . . . .
Client Installation Log Files (UNIX and Linux) . . . . . . . .
Alternative Installation Methods . . . . . . . . . . . . . .
Performing a Silent Client Product Installation on UNIX and Linux .
Extracting and Redistributing Client Products with Scripts . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
1-1
1-1
1-2
1-2
1-3
1-3
1-4
2-1
2-1
2-1
2-1
2-3
2-3
2-3
2-4
2-5
2-5
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 4-1
. 4-1
. 4-2
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 5-1
. 5-1
iii
Protocol Requirements . . . .
C Compiler Requirements . . .
Installation Location and Order .
Informix .NET Provider (Windows)
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-1
5-1
5-2
5-2
Chapter 6. Installing Client SDK and Informix Connect on Windows Systems . . . . . 6-1
About Client Product Installation on Windows . . . . . . . . .
Installing Client SDK or Informix Connect in GUI Mode (Windows) .
Performing a Silent Client Product Installation on Windows . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 6-1
. 6-1
. 6-2
Systems
. . .
. . .
. . .
. . .
. . .
. . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
7-1
7-1
7-2
7-3
7-4
7-4
7-5
. . . . . . . . . . . . . 8-1
Uninstalling or modifying Client SDK and Informix Connect in GUI mode (Windows) .
Removing a Client SDK or Informix Connect Installation Using the Command Line . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 8-1
. 8-1
Part 3. Installing the OpenAdmin Tool for Informix with the Client SDK
Chapter 9. Prerequisites for installing the OpenAdmin Tool (OAT) for Informix with the
Client SDK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9-1
Chapter 10. Products that are installed with the OpenAdmin Tool (OAT) for Informix
10-1
Chapter 11. Installing the OpenAdmin Tool (OAT) for Informix . . . . . . . . . . . 11-1
Chapter 12. Upgrading from a previous version of the OpenAdmin Tool (OAT) for
Informix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12-1
Chapter 13. Uninstalling the OpenAdmin Tool (OAT) for Informix after installing it
with the Client SDK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13-1
Part 4. Appendixes
Appendix A. Environment Variables . . . . . . . . . . . . . . . . . . . . . . . A-1
In this Appendix . . .
Environment variables .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. A-1
. A-1
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. B-1
. B-1
. B-1
iv
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C-1
C-1
C-1
C-1
C-1
C-1
Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . D-1
Trademarks .
. D-3
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . X-1
Contents
vi
Introduction
This introduction provides an overview of the information in this publication and
describes the conventions that it uses.
Reference
Additional documentation
Documentation about this release of IBM Informix products is available in various
formats.
You can access Informix technical information such as information centers,
technotes, white papers, and IBM Redbooks publications online at
http://www.ibm.com/software/data/sw-library/.
vii
Syntax diagrams
Syntax diagrams use special components to describe the syntax for statements and
commands.
Table 2. Syntax Diagram Components
Component represented in PDF
viii
Meaning
>>----------------------
Statement begins.
----------------------->
>-----------------------
-----------------------><
Statement ends.
--------SELECT----------
Required item.
--+-----------------+--------LOCAL------
Optional item.
---+-----ALL-------+--+--DISTINCT-----+
---UNIQUE------
---+------------------+--+--FOR UPDATE-----+
--FOR READ ONLY--
.---NEXT---------.
----+----------------+--+---PRIOR--------+
---PREVIOUS-----
Meaning
.-------,-----------.
V
|
---+-----------------+--+---index_name---+
---table_name---
Reference to a syntax
segment.
Table Reference
Syntax segment.
|--+-----view--------+--|
+------table------+
----synonym------
-n
-d device
-D database
-p project
-t
table
(1)
Setting the Run Mode
-S server
-T
target
Notes:
1
This diagram has a segment named Setting the Run Mode, which according to
the diagram footnote is on page Z-1. If this was an actual cross-reference, you
would find this segment on the first page of Appendix Z. Instead, this segment is
shown in the following segment diagram. Notice that the diagram uses segment
start and end components.
Setting the run mode:
Introduction
ix
l
c
-f
d
p
a
To see how to construct a command correctly, start at the upper left of the main
diagram. Follow the diagram to the right, including the elements that you want.
The elements in this diagram are case-sensitive because they illustrate utility
syntax. Other types of syntax, such as SQL, are not case-sensitive.
The Creating a No-Conversion Job diagram illustrates the following steps:
1. Type onpladm create job and then the name of the job.
2. Optionally, type -p and then the name of the project.
3. Type the following required elements:
v -n
v -d and the name of the device
v -D and the name of the database
v -t and the name of the table
4. Optionally, you can choose one or more of the following elements and repeat
them an arbitrary number of times:
v -S and the server name
v -T and the target server name
v The run mode. To set the run mode, follow the Setting the Run Mode
segment diagram to type -f, optionally type d, p, or a, and then optionally
type l or u.
5. Follow the diagram to the terminator.
The following syntax diagram uses variables to illustrate the general form of a
simple SELECT statement.
SELECT column_name FROM table_name
When you write a SELECT statement of this form, you replace the variables
column_name and table_name with the name of a specific column and table.
Introduction
xi
xii
Description
xiii
Description
The following table describes the IBM Informix common database utilities in the
Client SDK.
Table 4. IBM Informix common database utilities
xiv
Component
Description
Documentation Viewer
The viewer lets you see the release and machine notes in text
format.
The ILogin Demo utility lets you quickly test the connection to
IBM Informix. Click File > Run then enter the IBM Informix
connection parameters. You must create the target database
before you connect to it.
Password CSM
Connection Manager
DB-Access
Description
The ConnectTest utility lets you test the connection to the IBM
Informix server. You can start the utility from the shortcut in the
Start menu or from the $INFORMIX/bin directory. The utility
populates the server details from the registry registered by the
Setnet32 utility. You can manually edit the utility to connect to
other servers not listed in the registry, which does not modify the
registry entry. The utility shows the resulting data of the
executed SQL query.
Applications that run on client computers require IBM Informix Connect to access
database servers. Informix Connect is a runtime connectivity product composed of
runtime libraries that are included in Client SDK.
Note: Beginning with Client SDK Version 3.50.xC6, IBM Database Add-Ins for
Visual Studio is no longer installed with Client SDK or Informix Connect. IBM
Database Add-Ins for Visual Studio is available for download at:
https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swgdaivs.
The latest version of IBM Database Add-Ins for Visual Studio supports only the
Data Server .NET Provider and does not support Client SDK Informix .NET
Provider. Information about using the add-ins with the Client SDK Informix .NET
Provider is available at: http://www-933.ibm.com/support/fixcentral/.
Windows only: Client SDK and IBM Informix Connect packages include the Setnet
32 utility for configuring client products. Each package might include online help,
example programs, and support programs.
Related concepts:
IBM OpenAdmin Tool (OAT) for Informix (OpenAdmin Tool (OAT) for
Informix)
xv
IBM Data Server Driver Package installation does not affect an existing installation
of the IBM Informix .NET Provider, which is also included in the Client SDK
installation. You can use either or both of the .NET Providers. For more
information about the differences between the Data Server .NET Provider and the
Informix .NET Provider, see Differences between .NET Providers.
xvi
Protocol support
SQLI
DRDA
4 TB
2 GB
No
Yes
No
Yes
No
Yes
No
Yes
No
Yes
No
Yes
Yes
No
Yes
VSAI Designers to
create tables,
procedures, functions
and triggers, run
procedures and
functions
xvii
v DB_LOCALE
v CLIENT_LOCALE
v EXCLUSIVE
IfxConnection.ServerType property
For this property, the IBM Informix .NET Provider returns the value Informix. The
IBM Data Server .NET Provider returns the value that is received from the
database server to which it is connected. For example, the provider connected to
an Informix database server installed on a UNIX 64-bit system might return
IDS/UNIX64.
xviii
With the IBM Informix .NET Provider, you can select and return the values from
the LIST, MULTISET, and ROW data types.
CLOB, BLOB
Supported
Collection
Supported
Not supported
Interval DayToFraction
Not supported
IntervalMonth
Supported
Not supported
LIST
Supported
Not supported
MONEY
Supported
MULTISET
Supported
Not Supported
ROW
Supported
Not Supported
SET
Supported
Not Supported
xix
Table 7. Differences between .NET provider support for data type classes and structures
Class / Structure
IfxBlob
Supported
IfxClob
Supported
IfxTimeSpan
Supported
Not Supported
IfxMonthSpan
Supported
Not Supported
IfxSmartLOBLocator
Supported
Not Supported
IfxSmartLOB
Supported
Not Supported
IfxDecimal
Supported
IfxDateTime
Supported
Limited Support.
DRDA client supports 6
digits in the fractional part of
DateTime. The Informix
server supports 5 digits of
the fractional value. Because
of this difference, the least
significant digit of the
fraction will be truncated. A
DateTime value read from
the Informix server has a 0
(zero) added to the least
significant digit to match the
DRDA format. This change
affects applications that
access the IfxDateTime type
from the IBM Informix .NET
Provider.
IfxCommand.ExecuteScalar() method
The following query is a sample SELECT query.
Cmd.CommandText = "SELECT COUNT(*) FROM Tab";
The data type that is returned depends on the .NET provider that you use:
xx
IfxDataReader.GetString() method
The IBM Data Server .NET Provider does not allow the IfxDataReader.GetString()
method if the underlying value is null. A null value results in an InvalidCast
exception. This behavior is in contrast to the IBM Informix .NET Provider, which
allows a null value and returns an empty string.
Error messages
Some error messages received by the IBM Data Server .NET Provider might differ
from those received by the IBM Informix .NET Provider. For example, the IBM
Informix .NET Provider has tags such as [Informix .NET provider] in the error
messages. The IBM Data Server .NET Provider has just [IBM] in the error
messages. Additionally, the error codes might be different for the same type of
error.
xxi
xxii
Determine Location
Take note of media location and installation location.
Media Location
The directory where the media files are located is called $MEDIADIR. This can be
on a disk device, such as a CD, or a directory on a file server where the
downloaded source file is uncompressed.
Installation Location
You can install Client SDK or IBM Informix Connect on the computer on which
your applications run.
1-1
2.8x
2.9x
3.x
5.x
Database server
first
Database server
first
Database server
first
Database server
first
7.2x
Database server
first
Database server
first
Database server
first
Database server
first
7.3x
Database server
first
Database server
first
Database server
first
Database server
first
8.5x
Client products
first
Client products
first
Client products
first
Client products
first
9.2x
Database server
first
Database server
first
Database server
first
Database server
first
9.3x
Database server
first
Database server
first
Database server
first
Database server
first
9.4
Client products
first
Database server
first
Database server
first
Database server
first
10.0
Client products
first
Database server
first
Database server
first
Database server
first
11.x
N/A
N/A
Database server
first
Database server
first
You might encounter problems if you install an older product after you install a
new product. For example, if you install an older version of the finderr utility, the
older version overwrites the newer version and you will not have the most current
1-2
listing of error message text and corrective action. If you encounter problems with
the finderr utility, see IBM Informix Error Messages.
Before the Client SDK, Version 2.01 release, clients and servers shared common
message files. In later versions, the common message files for the client have new
names. For more information about how to rename common message files, see the
Client SDK release notes.
If you install more than one IBM Informix product, complete all installation
procedures for one product before you start to install the next product. Do not load
the files from another IBM Informix product onto your computer until you
complete the current installation.
Attention: If you want to use IBM Informix ODBC Driver with an existing DSN
that uses IBM Informix CLI driver or INTERSOLV DataDirect ODBC Driver, see
the information about the DSN Migration Utility in the release notes for IBM
Informix ODBC Driver.
1-3
3. Create the user informix using the useradd utility followed by the group
(informix) and user name (informix) in this format:
useradd -u n -g informix informix
4. Create a password for the user informix. To do this, use the passwd utility and
the following command:
passwd informix
5. If you use a network, propagate the new user name to all the systems on the
network that must recognize the user informix. For example, on some systems,
you (or the network administrator) must run the ypmake utility. Do not add
members to the group informix unless you want those members to have
administrative access to the database server.
1-4
Purpose
The following syntax diagram illustrates the Client SDK and Informix Connect
installation commands for GUI, console, and silent modes. If you do not specify an
installation mode (GUI, console, or silent), then the installation application starts in
console mode. Also, the usage of the -r option to create a response file for later
silent installations is shown.
2-1
Syntax
gui
installclientsdk
installconnect
-i
console
silent -f
path_name
(1)
-r
-help
path_name
Notes:
1
Do not use the -r option with the silent -f option in the same command.
The -r option records the configuration of a GUI or console installation. The
silent -f option starts a silent installation.
Parameters
Table 2-1. Syntax elements
Element
Purpose
Restrictions
path_name
2-2
Option
Meaning
installclientsdk
installconnect
-i gui
-i console
-i silent -f
path_name
-r path_name
-help
Related concepts:
Response file (UNIX and Linux) (Installation Guide (UNIX))
or
./installconnect
2. Read the software license agreement. You must accept the license terms to
install the product.
3. Proceed with the different settings until you receive the message that
installation is complete.
4. When the installation is complete, exit the installation application.
Related concepts:
Non-root installation (Installation Guide (UNIX))
or
./installconnect -i gui
2. Read the software license agreement. You must accept the terms to install the
product.
3. Proceed through the GUI windows until you receive the message that
installation is complete.
Related concepts:
Non-root installation (Installation Guide (UNIX))
Chapter 2. Installing Client SDK and Informix Connect on UNIX and Linux Systems
2-3
When you install Informix products, the installation application generates log files
in $INFORMIXDIR. Log files are also created if you attempt to install any of the
products but the installation application does not complete successfully.
The following log files are commonly generated when you run a client installation
application:
v $INFORMIXDIR/IBM_Informix_Client-SDK_InstallLog.log for a Client SDK
installation
v $INFORMIXDIR/IBM_Informix_Connect_InstallLog.log for an Informix Connect
installation
v $INFORMIXDIR/IBM_Informix_GLS_InstallLog.log for a client installation that
includes Global Language Support (GLS)
Format of Command
Restrictions
Silent
installation
./installclientsdk -i
silent -f path_name
Use to install
Client SDK or
Informix Connect,
with
product-specific
command
Use to install
Client SDK or
Informix Connect
individually.
None
The extraction with
command-line
installation alternative
can be helpful in one of
the following scenarios:
2-4
2-5
3. Copy the contents of the installation directory and place them into the directory
of another computer where you want to redistribute the products. The contents
include the RUNasroot scripts that you use for redistribution.
4. Run the script for the product that you want to deploy on the other computer.
You can deploy either Client SDK or Informix Connect in one location, not
both.
2-6
Option
Description
RUNasroot.installclientsdk
RUNasroot.installconnect
3-1
3-2
4-1
4-2
System Requirements
Before installing an Informix client product on a Windows system, verify that your
computer complies with the minimum hardware and disk space requirements.
The following list describes the system requirements for client products and
Windows XP, Windows Server 2003, Windows Vista, Windows Server 2008, and
Windows 7 systems.
v Hardware: Pentium 3 or higher microprocessor
v RAM: 256 megabytes
v Hard-disk storage: 200 megabytes
Protocol Requirements
IBM Informix client products work with any TCP/IP protocol that complies with
Windows Sockets 1.1.
To configure your client product utilities, select a protocol through the Setnet32
utility. For instructions, see Setting Database Server Information on page 7-2.
C Compiler Requirements
IBM Informix client products are certified with the Microsoft Visual C++ compiler,
Version 8.0. For individual components for other supported compilers, see the
release notes.
Copyright IBM Corp. 1996, 2013
5-1
5-2
6-1
After you click Install, the selected features will be installed. You are given the
option to also install the IBM Data Server Driver Package, and receive notification
of the installation status. If you install the driver package, a new installation
wizard will open after you click Done.
6-2
7-1
Click Load From File to load your environment variables and their values
from a specific file. However, you cannot load environment variables from a
specific file unless the Setnet32 utility has already created that file. (Use the
Save To File option to create a file.)
Click Save To File to save your environment variables and their values to a
specific file.
v Use my settings
The Setnet32 entries are stored under HKEY_LOCAL_MACHINE upon
installation. To save the settings in HKEY_CURRENT_USER and set that as
the default registry to modify the settings, select the Use my settings and
click Apply. All environment settings are then copied over to
HKEY_CURRENT_USER.
To revert to the HKEY_LOCAL_MACHINE entries, clear Use my settings
and click Apply.
The Use my settings check box is an entry stored under
HKEY_CURRENT_USER as DEFAULT_USER_SETTING, and can be either
LM for local machine (default) or CU for current user.
For more information about environment variables, see Appendix A, Environment
Variables, on page A-1 and the IBM Informix Guide to SQL: Reference.
For more information about environment variables for locales, see the IBM Informix
GLS User's Guide.
7-2
7-3
user enters with the login password for the host computer of the
database server. If the passwords are not identical, the user cannot
connect to that database server across a network.
v Password
This field, which the Password option activates, displays asterisks ( * ) that
represent the account password. When this field is enabled, it accepts a
password value with a maximum length of 18 characters. The value is
case-sensitive and cannot contain any spaces.
To enter a new password, place the cursor inside the Password text box and
type the new password. Asterisks ( * ) represent the characters that you type.
v Delete Host
Click Delete Host to delete the name of the currently selected host computer
from the Windows registry and the user name, password option, and
password that is associated with that host computer.
For more information about host parameters, see your IBM Informix Administrator's
Guide.
Overriding Information
You can use a set of environment variables with the function call ifx_putenv to
override the information that was entered in the Server Information and Host
Information pages of the Setnet32 utility.
To use these environment variables, set the INFORMIXSERVER environment
variable to a valid database server name. Overrides affect only that database
server.
Client SDK, Version 4.10, supports the following WIN32 override environment
variables. For more information about these environment variables, see the IBM
Informix ESQL/C Programmer's Manual.
Table 7-1. WIN32 Override Environment Variables
Environment Variable
WIN32HOST
WIN32USER
WIN32PASS
WIN32ASKPASSATCONNECT
WIN32SERVICE
WIN32PROTOCOL
7-4
1.
2.
3.
4.
5.
7-5
7-6
8-1
8-2
Supported platforms
OAT can be installed and run on these platforms:
Linux
v
v
v
v
v
RHEL 5, x86
RHEL 5, x86_64
RHEL 6, x86
RHEL 6, x86_64
SuSE SLES 11, x86
Windows
v Windows 2003 SP2, 32-bit
v Windows 2003 SP2, 64-bit
v Windows 2008, 32-bit
v Windows 2008, 64-bit
v Windows 2008 R2, 64-bit
v
v
v
v
v
Windows
Windows
Windows
Windows
Windows
2012 Server
7, 32-bit
7, 64-bit
8
Vista, 32-bit
System requirements
For Linux and Mac OS X, OAT requires these system resources:
v RAM: 40 MB
Copyright IBM Corp. 1996, 2013
9-1
9-2
v
v
v
v
v
v
v
libc.so.6
libcom_err.so.2
libcrypt.so.1
libcrypto.so.6
libdl.so.2
libexpat.so.0
libfreebl3.so (RHEL 6 only)
v
v
v
v
libgssapi_krb5.so.2
libk5crypto.so.3
libkeyutils.so.1
libkrb5.so.3
v
v
v
v
v
libkrb5support.so.0
libm.so.6
libnsl.so.1
libpcre.so.0
libpng12.so.0
v
v
v
v
v
v
v
libpthread.so.0
libresolv.so.2
librt.so.1
libselinux.so.1 (RHEL 5 and RHEL 6 only)
libsepol.so.1 (RHEL 5 only)
libssl.so.6
libuuid.so.1
v libxml2.so.2
v libz.so.1
libaprutil-1.0.dylib
libexpat.1.dylib
libgcc_s.1.dylib
libiconv.2.dylib
libsqlite3.0.dylib
v libSystem.B.dylib
Chapter 9. Prerequisites for installing the OpenAdmin Tool (OAT) for Informix with the Client SDK
9-3
9-4
PDO
pdo_sqlite
pdo_informix
Reflection
session
SimpleXML
v soap
v sockets
v SPL
Copyright IBM Corp. 1996, 2013
10-1
v
v
v
v
v
standard
xml
xmlreader
xmlwriter
zip
mod_auth_basic
mod_authn_default
mod_authn_file
mod_authz_default
mod_authz_groupfile
v mod_authz_host
v mod_authz_user
v mod_autoindex
v
v
v
v
mod_cgi
mod_dir
mod_actions
mod_env
v mod_filter
v mod_include
v mod_isapi
v mod_log_config
10-2
v
v
v
v
v
v
mod_mime
mod_negotiation
mod_php5
mod_setenvif
mod_so
mod_ssl (Linux only)
v
v
v
v
v
mod_status
mod_userdir
mod_win32 (Windows only)
mpm_winnt (Windows only)
prefork
11-1
11-2
12-1
12-2
13-1
13-2
Part 4. Appendixes
Environment variables
Client SDK, Version 4.10, supports the following environment variables. For more
information about these environment variables, see their descriptions in the
respective publications.
Publication reference and possible
values
Environment variable
Purpose
CC8BITLEVEL
CLIENT_LOCALE
COLLCHAR
DB_LOCALE
DBALSBC
DBANSIWARN
DBAPICODE
DBASCIIBC
DBCENTURY
DBCODESET
A-1
Environment variable
Purpose
DBCONNECT
DBCSCONV
DBCSOVERRIDE
DBCSWIDTH
DBDATE
DBFLTMASK
DBLANG
DBMONEY
DBMONEYSCALE
DBPATH
DBSS2
Maximum size is four characters. Provided for IBM Informix ESQL/C Programmer's
backward compatibility with ALS products.
ManualValues: 0x000xff or 0255
DBSS3
Maximum size is four characters. Provided for IBM Informix ESQL/C Programmer's
backward compatibility with ALS products.
Manual Values: 0x000xff or 0255
DBTEMP
A-2
Environment variable
Purpose
DBTIME
DELIMIDENT
Indicates whether (y) or (n) to interpret strings IBM Informix Guide to SQL:
in double quotation marks as delimited
Reference Default is n.
identifiers.
ESQLMF
FET_BUF_SIZE
GL_DATE
GL_DATETIME
IFX_DISABLE_IPV6
IFX_FLAT_USCQ
Default is 0.
INFORMIXCONRETRY
INFORMIXCONTIME
INFORMIXDIR
INFORMIXSERVER
INFORMIXSQLHOSTS
LANG
LC_COLLATE
A-3
Environment variable
Purpose
LC_CTYPE
LC_MONETARY
LC_NUMERIC
LC_TIME
NODEFDAC
OPTMSG
OPTOFC
Enables optimize-OPEN-FETCH-CLOSE
functionality in an IBM Informix ESQL/C
application that uses DECLARE and OPEN
statements to execute a cursor.
TMP
A-4
DataBlade API
B-1
v By installing specific components (for example, you can redistribute only the
files that are required by IBM Informix OLE DB Provider)
Attention: Do not copy single files or directories from any IBM Informix client
API into your application installation; doing so violates your Technical Support
agreement or contract.
B-2
Appendix C. Accessibility
IBM strives to provide products with usable access for everyone, regardless of age
or ability.
Accessibility features
The following list includes the major accessibility features in IBM Informix
products. These features support:
v Keyboard-only operation.
v Interfaces that are commonly used by screen readers.
v The attachment of alternative input and output devices.
Keyboard navigation
This product uses standard Microsoft Windows navigation keys.
C-1
Certain words and symbols are used next to the dotted decimal numbers to add
information about the syntax elements. Occasionally, these words and symbols
might occur at the beginning of the element itself. For ease of identification, if the
word or symbol is a part of the syntax element, the word or symbol is preceded by
the backslash (\) character. The * symbol can be used next to a dotted decimal
number to indicate that the syntax element repeats. For example, syntax element
*FILE with dotted decimal number 3 is read as 3 \* FILE. Format 3* FILE
indicates that syntax element FILE repeats. Format 3* \* FILE indicates that
syntax element * FILE repeats.
Characters such as commas, which are used to separate a string of syntax
elements, are shown in the syntax just before the items they separate. These
characters can appear on the same line as each item, or on a separate line with the
same dotted decimal number as the relevant items. The line can also show another
symbol that provides information about the syntax elements. For example, the lines
5.1*, 5.1 LASTRUN, and 5.1 DELETE mean that if you use more than one of the
LASTRUN and DELETE syntax elements, the elements must be separated by a comma.
If no separator is given, assume that you use a blank to separate each syntax
element.
If a syntax element is preceded by the % symbol, that element is defined elsewhere.
The string following the % symbol is the name of a syntax fragment rather than a
literal. For example, the line 2.1 %OP1 refers to a separate syntax fragment OP1.
The following words and symbols are used next to the dotted decimal numbers:
C-2
repeated. For example, if you hear the line 5.1* data-area, you know that
you can include more than one data area or you can include none. If you
hear the lines 3*, 3 HOST, and 3 STATE, you know that you can include
HOST, STATE, both together, or nothing.
Notes:
1. If a dotted decimal number has an asterisk (*) next to it and there is
only one item with that dotted decimal number, you can repeat that
same item more than once.
2. If a dotted decimal number has an asterisk next to it and several items
have that dotted decimal number, you can use more than one item
from the list, but you cannot use the items more than once each. In the
previous example, you can write HOST STATE, but you cannot write HOST
HOST.
3. The * symbol is equivalent to a loop-back line in a railroad syntax
diagram.
+
Appendix C. Accessibility
C-3
C-4
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
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:
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.
19-21, Nihonbashi-Hakozakicho, Chuo-ku
Tokyo 103-8510, 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 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.
D-1
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 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,
D-2
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.
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.
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.
Notices
D-3
D-4
Index
Special characters
.app file 3-1
.dmg file 3-1
.iem file extension A-1
.NET Provider xiii
.NET providers xvi, 5-2
A
Accessibility C-1
dotted decimal format of syntax diagrams C-1
keyboard C-1
shortcut keys C-1
syntax diagrams, reading in a screen reader C-1
Apache modules installed with OAT 10-1
C
CC8BITLEVEL environment variable A-1
Client Installation
Windows 6-1
Client SDK
Environment Variables A-1
installation 6-1
Runtime components B-1
uninstall 8-1
uninstalling 4-1
Client SDK using a
GUI 8-1
Uninstalling 8-1
CLIENT_LOCALE environment variable A-1
coledbp.sql script 7-4
COLLCHAR environment variable A-1
commands
uninstalling client products 4-1
uninstalling Client SDK 4-1
uninstalling Informix Connect 4-1
commandsinstallconnect
installclientsdk 2-1
compliance with standards viii
Configuring
Informix products 7-1
the environment 7-1
Connect, redistribution guidelines B-1
Connection Manager xiii
Connections A-1
D
Data Server .NET Provider xvi
Data Server Driver, IBM
See IBM Data Server Driver
Database Add-Ins for Visual Studio xiii
Database Server requirements
Windows 5-1
Database servers
identifying A-1
setting parameters in Setnet32 7-2
DATE data type A-1
Copyright IBM Corp. 1996, 2013
E
Enterprise Replication 6-1
Environment configuration 7-1
environment variables 7-4
Environment variables
CC8BITLEVEL A-1
CLIENT_LOCALE A-1
COLLCHAR A-1
Database locale, setting language features A-1
Database servers
default A-1
DB_LOCALE A-1
DBALSBC A-1
DBANSIWARN A-1
DBAPICODE A-1
DBASCIIBC A-1
DBCENTURY A-1
DBCODESET A-1
DBCONNECT environment variable A-1
DBCSCONV A-1
DBCSOVERRIDE A-1
DBCSWIDTH A-1
DBDATE A-1
DBFLTMASK A-1
DBLANG environment variable A-1
DBMONEY A-1
DBMONEYSCALE A-1
DBPATH A-1
DBSS2 A-1
DBSS3 A-1
DBTEMP A-1
DBTIME A-1
X-1
F
FET_BUF_SIZE environment variable
File extensions, .iem A-1
files 2-5, 6-2
response 2-5, 6-2
A-1
H
HKEY_CURRENT_USER 7-1
HKEY_LOCAL_MACHINE 7-1
Host information, setting 7-3
Host parameters 7-3
I
IBM Data Server Driver xv
IBM OpenAdmin Tool (OAT) for Informix
See OAT
IFX_FLAT_USCQ environment variable A-1
ILogin utility xiii
industry standards viii
Informix .NET Provider xvi, 5-2
Informix Connect
definition xiii
installation 6-1
redistribution guidelines B-1
uninstalling 4-1
INFORMIXCONRETRY environment variable
Install medium 2-1
installation
silent 2-5, 6-2
unattended 2-5, 6-2
Installation
determining directory location 1-1
language compiler 5-2
order 5-2
order of 1-2
problems 7-5
running scripts for 2-1
using a GUI 6-1
installation, order 1-2
installclientsdk command 2-1
installconnect command 2-1
installing
by extracting media with script 2-5
Installing
OAT 11-1
L
Language compiler 5-2
legacy installation support
Linux installation 1-1
Log files 2-4
M
Mac OS X
installing client products 3-1
Mac OS X installation 1-1
Message file A-1
Microsoft .NET Framework 5-2
Microsoft Visual C++ compiler 5-2
MONEY data type A-1
MTS xiii
G
GL_DATE environment variable A-1
GL_DATETIME environment variable A-1
GLS. xiii
group informix 1-3, 3-1
X-2
2-5
N
NLS environment A-1
non-root installation 1-3
A-1
OAT
installation with the Client SDK 11-1
prerequisites 9-1
products included with 10-1
uninstalling 12-1, 13-1
Object Interface for C++ xiii
ODBC-MTS xiii
OLE DB Provider xiii, 7-4
OpenAdmin Tool (OAT) for Informix
See OAT
Order of installation 5-2
overriding information 7-4
Overriding Information 7-4
unattended installation
see also silent installation
Uninstallation
using a GUI 8-1
Uninstalling
OAT 12-1, 13-1
UNIX installation 1-1
user informix 1-3, 3-1
P
Password CSM xiii
PHP modules installed with OAT 10-1
Prerequisites for installing OAT 9-1
Processor, storing temporary files A-1
Product configuration 7-1
Protocols
Windows 5-1
2-5, 6-2
V
Visual disabilities
reading syntax diagrams
C-1
W
Windows
database server requirements
installing Client SDK 6-1
system requirements 5-1
Windows Registry 7-2, 7-3
5-1
R
redistributing
Informix products 2-5
response file 2-5, 6-2
Runtime components
Client SDK B-1
S
Screen reader
reading syntax diagrams C-1
scripts
for installing by extracting media
Server parameters 7-2
services file 7-2
Setnet32 utility
product configuration 7-1
Setting environment variables 7-1
Shortcut keys
keyboard C-1
silent installation 2-5, 6-2
SQL scripts
coledbp.sql 7-4
doledbp.sql 7-4
standards viii
Syntax diagrams
reading in a screen reader C-1
System requirements
Windows 5-1
2-5
T
TCP/IP protocol
Windows 5-1
Troubleshooting
common installation problems
7-5
Index
X-3
X-4
Printed in USA
GC27-4495-00