Creating an Informix database server for UNIX

Before creating the database, see "Database server and engine machine requirement" and "Prepare the database server." These topics are in the UNIX® section of the Installing and upgrading section of the Rational® Synergy Information center. You can create a database server on the installation machine or on a remote host. Installers often create a database server on the installation machine. However, you are not required to do so. You can make any host a database server if the machine meets the system requirements and a valid installation directory for that platform is visible (for example, local or NFS-mounted).

About this task

For example, the installation directory for Solaris is /usr/local/ccm75 on the solaris1 machine and you want to create a database server on solaris2, You can NFS-mount the installation directory on solaris2. Then, create a database server on solaris2. Creating the database server automatically adds an entry for solaris2 to the sqlhosts file in the Solaris installation directory.

You can allow a database server to run server processes for a different type of platform. For example, to make an AIX® database server, aix1, available as a database server for Solaris 9 or 10 machines, add the aix1 entry manually to the Solaris 9 or 10 installation directory sqlhosts file.

Note: When creating the database server on a different machine than the installation machine, ensure that the database server is configured correctly. See Modifying database server parameter values.

Procedure

To create the database server for UNIX:

  1. Log on to the database server as user root.

    If your database server is the same as your installation machine, you are logged in already as root.

  2. Create a directory for the Informix® dbspace (chunkfiles).

    Replace informix_chunkfiles with the path to your Informix chunk files. When you create chunk files:

    • Place the chunk files where no one can remove them.
    • Create the chunk file directory (for example, /data/informix_chunkfiles) on the machine where the database server will run.
    • For the best performance and reliability, use raw partitions for Informix chunk files. (In the rare event of file system corruption, cooked files are affected but raw files are not.)
    • Ensure that the names of your chunk files paths contain fewer than 66 characters.
    • The maximum chunk files size is 4 TB (Terabyte). If you need more than 4 TB, contact IBM® Rational Software Support.
    Note: Do not back up Informix data files as normal UNIX files. Avoid putting this directory under the installation directory, $CCM_HOME, or under the ccm_root or informix home directory.

    See Informix chunk files for more information about creating chunk files.

    root# mkdir informix_chunkfiles
    root# chown informix informix_chunkfiles
    root# chgrp informix informix_chunkfiles
    root# chmod 770 informix_chunkfiles

Feedback