| # 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_sbs – used for Smart BLOB objects. 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 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: FILLFACTOR is set to 60 LOCKS is set to 50000 SHMADD is set to 32768 DBSPACETEMP is set to bsi_tmp SBSPACETEMP is set to bsi_tmp The database will be created. 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: Informix dbspaces 4 GByte for table data required 4 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. Informix logical log: Create enough logical logs. (refer to section Automatic Informix configuration and database creation) Informix physical log: The physical log size must be >= 300 MByte 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