<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/install/unix/Pre_Unix_Appendix_C_informix" xml:lang="en">
   <Header>
      <Title>Appendix Informix</Title>
      <Keyword type="header" order="d1e1082644">
         <Level1>Informix appendix</Level1>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph>This Appendix provides a brief description of the automatic en
		manual database creation and Informix server instance reconfiguration.</Paragraph>
   </AimSection>
   <GeneralSection>
      <SectionTitle>Automatic Informix configuration and database
		creation</SectionTitle>
      <Paragraph>The Installation Wizard will use this method in case no LN database is
		found in Informix Server instance.</Paragraph>
      <Paragraph>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.</Paragraph>
      <Paragraph>The path names and sizes can be specified in the <GUIRef href="" role="manual">Database Device Locations and Sizes</GUIRef> dialog during
		installation. The following Informix dbspaces will be created:</Paragraph>
      <List>
         <ListItem>bsi_dbs - used for data.</ListItem>
         <ListItem>bsi_idx - used for indexes.</ListItem>
         <ListItem>bsi_sbs – used for Smart BLOB objects.</ListItem>
         <ListItem>bsi_tmp - used for temporary space.</ListItem>
         <ListItem>bsi_log - used for logical logs.</ListItem>
         <ListItem>bsi_phy - used for physical logs.</ListItem>
      </List>
      <Paragraph>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 <GUIRef href="" role="manual">bsi_phy</GUIRef> dbspace.</Paragraph>
      <Paragraph>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 <GUIRef href="" role="manual">bsi_log</GUIRef> dbspace.</Paragraph>
      <Paragraph>The following are additional changes to the Informix onconfig
		file:</Paragraph>
      <List>
         <ListItem>FILLFACTOR is set to 60</ListItem>
         <ListItem>LOCKS is set to 50000</ListItem>
         <ListItem>SHMADD is set to 32768</ListItem>
         <ListItem>DBSPACETEMP is set to <GUIRef href="" role="manual">bsi_tmp</GUIRef>
         </ListItem>
         <ListItem>SBSPACETEMP is set to <GUIRef href="" role="manual">bsi_tmp</GUIRef>
         </ListItem>
      </List>
      <Paragraph>The database will be created.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Manual Informix configuration and database
		creation</SectionTitle>
      <Paragraph>This section provides a brief description of manual database
		creation method and describes important Informix configuration
		topics.</Paragraph>
      <Paragraph>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.</Paragraph>
      <GeneralSection>
         <SectionTitle>Informix Server configuration</SectionTitle>
         <Paragraph>Several important remarks:</Paragraph>
         <ProcedureList>
            <ListItem>Informix dbspaces <List>
                  <ListItem>4 GByte for table data required</ListItem>
                  <ListItem>4 GByte for index data required</ListItem>
               </List> 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.</ListItem>
            <ListItem>Informix logical log: <List>
                  <ListItem>Create enough logical logs. (refer to section Automatic
				  Informix configuration and database creation)</ListItem>
               </List>
            </ListItem>
            <ListItem>Informix physical log: <List>
                  <ListItem>The physical log size must be &gt;= 300 MByte</ListItem>
               </List>
            </ListItem>
            <ListItem>Informix LOCKS: <List>
                  <ListItem>A minimum of 50000 must be set to your Informix onconfig
				  file.</ListItem>
               </List>
            </ListItem>
         </ProcedureList>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Database creation</SectionTitle>
         <Paragraph>The database can be created with Informix dbaccess tool. The
		  user needs to decide what logging the database must use.</Paragraph>
         <Paragraph>Three different ways of logging can be used with LN:</Paragraph>
         <List>
            <ListItem>ANSI</ListItem>
            <ListItem>BUFFERED</ListItem>
            <ListItem>UNBUFFERED</ListItem>
         </List>
         <Paragraph>Best performance can be achieved when BUFFERED logging is
		  used. To get an overview about different logging methods, refer to the Informix
		  documentation</Paragraph>
         <Paragraph>The database name must be set to the <GUIRef href="" role="manual">database group user</GUIRef> name. The dbspace name used for table data is preferred. The
		  following SQL statements can be used to create the database:</Paragraph>
         <CodeBlock space-and-orientation="indented-estimated">CREATE DATABASE ‘&lt;database&gt;’ IN &lt;dbspace&gt; WITH LOG MODE ANSI
CREATE DATABASE ‘&lt;database&gt;’ IN &lt;dbspace&gt; WITH BUFFERED LOG
CREATE DATABASE ‘&lt;database&gt;’ IN &lt;dbspace&gt; WITH LOG
</CodeBlock>
      </GeneralSection>
   </GeneralSection>
</ManualTopic>