Appendix Informix

There are two ways of creating and configurating Informix. This appendix supplies some extra information about those processes.

Automatic Informix configuration and database creation

This section provides a brief description of the automatic database creation and Informix server instance reconfiguration. The Installation Wizard will use this method in case no LN database is found in Informix Server instance.

The automatic database creation method is the easiest way to install an LN environment. The installer will create the database and reconfigure the Informix Server instance.

The installer will create following Informix dbspaces. The user can specify the path names and sizes in the Database Device Locations and Sizes dialog during installation:

  • bsi_dbs - used for data.
  • bsi_idx - used for indexes.
  • bsi_tmp - used for temporary space.
  • bsi_log - used for logical logs.
  • bsi_phy - used for physical logs.

The current physical log size will be changed according the user input made for physical log size. The log will be moved to the new created bsi_phy dbspace.

In addition the Installation Wizard also creates logical logs of 5 MB each. The number of logical logs created is calculated from the user input for logical log size. For example, if the user types 300 MB as the logical log size, the installer creates 60 (300/5) logical logs in bsi_log dbspace.

Additional changes to Informix onconfig file are carried out:

  • OPTCOMIND is set to 0
  • LOGSIZE is set to 5000
  • SHMVIRTSIZE is set to 32768
  • FILLFACTOR is set to 60
  • LTAPEDEV is set to NUL:
  • TAPEDEV is set to NUL
  • LOCKS is set to 50000
  • CKPTINTVL is set to 300
  • SHMADD is set to 32768
  • NUMAIOVPS is set to 2
  • MULTIPROCESSOR is set to 0.
  • SINGLE_CPU_VP is set to 1.
  • NUMCPUVPS is set to 1.
  • DBSPACETEMP is set to bsi_tmp

The database will be created.

During the configuration of Informix Dynamic Server by the Installation Wizard, the Informix Dynamic Server is stopped and restarted several times for the changes to take effect

Manual Informix configuration and database creation

This section provides a brief description of manual database creation method. Further it describes a few important Informix configuration topics.

If a user choose this way of installation the user is responsible for Informix Server configuration and database creation. The LN installation will fail if bad configuration is carried out.

Informix Server configuration

The user is responsible for the Informix Server configuration. Note the following remarks:

  1. Informix dbspaces
    • 2 GByte for table data required
    • 2 GByte for index data required
    The Installation Wizard uses default dbspace names. (refer to section Automatic Informix configuration and database creation). If you choose other names you need to modify the storage_params in Configuration Files dialog box during the installation.
  2. Informix logical log:
    • Create enough logical logs. (refer to section Automatic Informix configuration and database creation)
  3. Informix physical log:
    • The physical log size must be >= 300 MByte
  4. Informix LOCKS:
    • A minimum of 50000 must be set to your Informix onconfig file.