Install IBM Informix and create a database - database configuration/design tasks

  1. Install the IBM® Informix® database software (IDS for example) on your database server.
  2. 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.
  3. Define a database user dedicated to your application: the application administrator, referenced as appadmin elsewhere in this documentation. 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.
  4. 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; 
  5. Connect as application administrator and create an IBM Informix database entity, for example with the following SQL statement:

    CREATE DATABASE dbname WITH BUFFERED LOG;

  6. Create the application tables.