Appendix Informix

This Appendix provides a brief description of the automatic en manual database creation and Informix server instance reconfiguration.

Automatic Informix configuration and database creation

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 path names and sizes can be specified in the Database Device Locations and Sizes dialog during installation. The following Informix dbspaces will be created:

  • 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.
Important!

The Installation Wizard does not create files required for the dbspaces. The user needs to touch files on the file system manually. The files need to be owned by informix:informix and requires the permissions read/write (chmod 660).

The current physical log size will be changed according to 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.

The following are additional changes to the Informix onconfig file:

  • 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 and describes 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

Several important 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.
Database creation

The database can be created with Informix dbaccess tool. The user needs to decide what logging the database must use.

Three different ways of logging can be used with ERP LN 6.1:

  • ANSI
  • BUFFERED
  • UNBUFFERED

Best performance can be achieved when BUFFERED logging is used. To get an overview about different logging methods, refer to the Informix documentation

The database name must be set to the database group user name. The dbspace name used for table data is preferred. The following SQL statements can be used to create the database:

CREATE DATABASE ‘<database>’ IN <dbspace> WITH LOG MODE ANSI
CREATE DATABASE ‘<database>’ IN <dbspace> WITH BUFFERED LOG
CREATE DATABASE ‘<database>’ IN <dbspace> WITH LOG