Install IBM Informix and create a database - database
configuration/design tasks
Install the IBM® Informix® database software
(IDS for example) on your database server.
Install the IBM Informix Software Development
Kit (SDK) on your application server. With some IBM
Informix distributions (IDS 11), this package is
included in the server bundle. You should check the IBM
web site for SDK upgrades or patches. Genero BDL is certified with IBM
Informix SDK version 3.50 or higher.
Setup the IDS server (onconfig file, etc)
Starting with IDS version 11, the TEMPTAB_NOLOG is set to 1 by
default.
Consider setting this parameter to 0, if you want to log temporary table changes. This
can affect the behavior of programs expecting that a ROLLBACK WORK cancels changes done on a
temporary table.
Define a database user dedicated to your application: the application administrator. This user will manage the database schema
of the application (all tables will be owned by it). With IBM Informix, database users reference Operating
System users, and must be part of the IBM Informix group. See IBM Informix documentation.
Connect to the server as IBM
Informix user (for example with the dbaccess tool)
and give all requested database administrator privileges to the application
administrator.
GRANT CONNECT TO appadmin;
GRANT RESOURCE TO appadmin;
GRANT DBA TO appadmin;
Define the database locale before creating the database.
According to the language(s) supported in your application, consider using UTF-8 locale by
setting the Informix environment variables defining the locale for the database server and
data: CLIENT_LOCALE, DB_LOCALE, SERVER_LOCALE.
Connect as application administrator and create an IBM Informix database entity, for example with
the following SQL statement: