Data source minimum required settings for Informix

These properties vary according to the database vendor requirements for JDBC driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for Informix® data sources.

You can configure the following types of providers:

Informix JDBC Driver
Informix JDBC Driver (XA)
Informix Using IBM® JCC Driver
Informix Using IBM JCC Driver (XA)
Informix Using IBM DB2 JDBC Universal Driver
Informix Using IBM DB2 JDBC Universal Driver (XA)

Informix JDBC Driver
The Informix JDBC Driver is a Type 4 JDBC driver that provides JDBC access to the Informix database.
Informix JDBC Driver supports one phase data source:
```
com.informix.jdbcx.IfxConnectionPoolDataSource
```
Requires the following JDBC driver files:
```
ifxjdbc.jar
ifxjdbcx.jar
```
Requires the following DataStoreHelper class:
```
com.ibm.websphere.rsadapter.InformixDataStoreHelper
```
Requires a valid authentication alias.
Requires the following properties:
- serverName
  The name of the Informix instance on the server. Example: ol_myserver.
- portNumber
  The port on which the instances listen. Example: 1526.
- ifxIFXHOST
  Either the IP address or the host name of the machine that is running the Informix database to which you want to connect. Example: myserver.mydomain.com.
  
  To support IPv6: On AIX and Solaris, IBM Informix Dynamic Server 10.00 with fix pack 1 supports the IPv6 standard. To enable IPv6 on your WebSphere Application Server connection with one of these Informix releases, input your full IPv6 host name for the ifxIFXHOST property.
- databaseName
  The name of the database from which the data source obtains connections. Example: Sample.
- informixLockModeWait
  Although not required, this property enables you to set the number of seconds that Informix software waits for a lock. By default, Informix code throws an exception if it cannot immediately acquire a lock. Example: 2.
Informix JDBC Driver (XA)
The Informix JDBC Driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access to the Informix database.
Informix JDBC Driver (XA) supports two phase data source:
```
com.informix.jdbcx.IfxXADataSource
```
Requires the following JDBC driver files:
```
ifxjdbc.jar
ifxjdbcx.jar
```
To use SQLJ: This provider also requires driver file ifxsqlj.jar if you plan to use SQLJ for queries.
Requires the following DataStoreHelper class:
```
com.ibm.websphere.rsadapter.InformixDataStoreHelper
```
Requires a valid authentication alias.
Requires the following properties:
- serverName
  The name of the Informix instance on the server. Example: ol_myserver.
- portNumber
  The port on which the instances listen. Example: 1526.
- ifxIFXHOST
  Either the IP address or the host name of the machine that is running the Informix database to which you want to connect. Example: myserver.mydomain.com.
  
  To support IPv6: On AIX and Solaris, IBM Informix Dynamic Server 10.00 with fix pack 1 supports the IPv6 standard. To enable IPv6 on your WebSphere Application Server connection with one of these Informix releases, input your full IPv6 host name for the ifxIFXHOST property.
- databaseName
  The name of the database from which the data source obtains connections. Example: Sample.
- ifxIFX_XASPEC
  Turn on this property when multiple users access the same database. Activating the property enforces tight coupling of XA transactions within the same global transaction ID, and requires the transactions to share lock space.
  
  These parameters help prevent transaction management errors from occurring in the case of multiple client requests.
  
  Turn on the ifxIFX_XASPEC property by assigning it the value of Y or y; either character works because the setting is not case-specific. Turn the property off by assigning it the value of N or n. WebSphere Application Server ignores all other values. Your setting for the property overrides the Informix database system setting.
- informixLockModeWait
  Although not required, this property enables you to set the number of seconds that Informix software waits for a lock. By default, Informix code throws an exception if it cannot immediately acquire a lock. Example: 2.
Informix Using IBM JCC Driver
The Informix IBM JCC Driver is a one-phase commit provider for Informix that uses the IBM Data Server Driver for JDBC and SQLJ. The IBM Data Server Driver is JDBC 4.0 compliant and is the next generation of the Universal JCC driver.

This provider is configurable in version 7.0 and later nodes.
The following one-phase data source is supported:
```
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
```
The following JDBC driver files are required:
```
db2jcc4.jar
db2jcc_license_cu.jar
db2jcc_license_cisuz.jar
```
as well as the following DataStoreHelper class:
```
com.ibm.websphere.rsadapter.InformixJccDataStoreHelper
```
This provider requires a valid authentication alias.
The following properties are required:
- serverName - The TCP/IP address or host name for the Informix server.
- portNumber - The TCP/IP port number where the Informix server resides.
- databaseName - The name of the database from which the data source obtains connections. Example: Sample.
Informix Using IBM JCC Driver (XA)
The Informix IBM JCC Driver (XA) is a two-phase commit provider for Informix that uses the IBM Data Server Driver for JDBC and SQLJ. The IBM Data Server Driver is JDBC 4.0 compliant and is the next generation of the Universal JCC driver.

This provider is configurable in version 7.0 and later nodes.
The following two-phase data source is supported:
```
com.ibm.db2.jcc.DB2XADataSource
```
The following JDBC driver files are required:
```
db2jcc4.jar
db2jcc_license_cu.jar
db2jcc_license_cisuz.jar
```
as well as the following DataStoreHelper class:
```
com.ibm.websphere.rsadapter.InformixJccDataStoreHelper
```
Avoid trouble: If you plan to use SQLJ for queries, this provider also requires driver file ifxsqlj.jar.

This provider requires a valid authentication alias.
The following properties are required:
- serverName - The TCP/IP address or host name for the Informix server.
- portNumber - The TCP/IP port number where the Informix server resides.
- databaseName - The name of the database from which the data source obtains connections. Example: Sample.
Avoid trouble: You cannot use Informix XA data sources with ANSI databases if SQL statements are issued in local transactions instead of global transactions. This scenario might occur within the application code or within a component of Application Server such as scheduler. The following message might be logged if you are experiencing this problem:
```
java.sql.SQLException: Already in transaction.
       at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:398)
       at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3247)
       at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3556)
       at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2382)
       at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:120)
       at com.informix.jdbc.IfxSqli.X(IfxSqli.java:7926)
       at com.informix.jdbc.IfxSqli.a(IfxSqli.java:854)
       at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:749)
       at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:293)
       at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1269)
       at com.informix.jdbc.IfxStatement.b(IfxStatement.java:423)
       at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:277)
       at com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2565)
```
To avoid this issue:
- Switch to a non-ANSI database.
- If the error is triggered by an application, update the application such that it always runs in a global transaction.
Informix Using IBM DB2 JDBC Universal Driver
The Informix JDBC Driver is a Type 4 JDBC driver that is JDBC 3.0 compliant and provides access to the Informix database.
This provider supports the following one-phase data source:
```
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
```
The following JDBC driver files are required:
```
db2jcc.jar
db2jcc_license_cu.jar
db2jcc_license_cisuz.jar
```
as well as the following DataStoreHelper class:
```
com.ibm.websphere.rsadapter.InformixJccDataStoreHelper
```
This provider requires a valid authentication alias.
The following properties are required:
- serverName - The TCP/IP address or host name for the Informix server.
- portNumber - The TCP/IP port number where the Informix server resides.
- databaseName - The name of the database from which the data source obtains connections. Example: Sample.

Informix Using IBM DB2 JDBC Universal Driver (XA)

The Informix Using JDBC Driver (XA) is a Type 4 JDBC driver that is JDBC 3.0 compliant and provides XA-compliant JDBC access to the Informix database.

This provider supports the following two-phase data source:

com.ibm.db2.jcc.DB2XADataSource

The following JDBC driver files are required:

db2jcc.jar
db2jcc_license_cu.jar
db2jcc_license_cisuz.jar

as well as the following DataStoreHelper class:

com.ibm.websphere.rsadapter.InformixJccDataStoreHelper

This provider requires a valid authentication alias.

The following properties are required:

serverName - The TCP/IP address or host name for the Informix server.
portNumber - The TCP/IP port number where the Informix server resides.
databaseName - The name of the database from which the data source obtains connections. Example: Sample.

Avoid trouble: You cannot use Informix XA data sources with ANSI databases if SQL statements are issued in local transactions instead of global transactions. This scenario might occur within the application code or within a component of Application Server such as scheduler. The following message might be logged if you are experiencing this problem:

java.sql.SQLException: Already in transaction.
       at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:398)
       at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3247)
       at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3556)
       at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2382)
       at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:120)
       at com.informix.jdbc.IfxSqli.X(IfxSqli.java:7926)
       at com.informix.jdbc.IfxSqli.a(IfxSqli.java:854)
       at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:749)
       at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:293)
       at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1269)
       at com.informix.jdbc.IfxStatement.b(IfxStatement.java:423)
       at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:277)
       at com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2565)