If the directory/file paths specified in this guide do not exist in your WSO2 product, see Directory Structure of WSO2 Products to locate the paths applicable to your product.

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following sections describe how to set up IBM Informix to replace the default H2 databases with IBM Informixdatabase in your WSO2 product:

Table of Contents



Do the following changes to the default database when creating the Informix database.

  • Define the page size as 4K or higher when creating the dbspace as shown in the following command (i.e. denoted by -k 4) :

    Code Block
    onspaces -c -S testspace4 -k 4 -p /usr/informix/logdir/data5.dat -o 100 -s 3000000
  • Add the following system environment variables.

    Code Block
    export DB_LOCALE=en_US.UTF-8
    export CLIENT_LOCALE=en_US.UTF-8
  • Create a an sbspace other than the dbspace by executing the following command:

    Code Block
    onspaces -c -S testspace4 -k 4 -p /usr/informix/logdir/data5.dat -o 100 -s 3000000
  • Add the following entry to the <INFORMIX_HOME>/etc/onconfig file, and replace the given example sbspace name (i.e. testspace4) with your sbspace name:

    Code Block
    SBSPACENAME testspace4



Use Informix JDBC driver version 3.70.JC8, 4.10.JC2 or higher.

What's next

By default, all WSO2 products are configured to use the embedded H2 database. To configure your product with IBM Informix, see Changing to IBM Informix.