Using files to specify parameters for Windows

A parameter file is a file that you create, based on the following template. It contains all the information that Informix® uses to create the database server.

About this task

Here is an example of a parameter file.

   ***********************************************************
   # Maximum Number of Users
   USERS                           40
   # Root Dbspace Parameters
   ROOT_CHUNK_PATH                           D:\ifmxdata\rootdbs.000
   ROOT_CHUNK_SIZE                           60
   # Temp Dbspace Parameters
   TEMP_CHUNK_PATH                           D:\ifmxdata\tempdbs.000
   TEMP_CHUNK_SIZE                           40
   # Log Dbspace Parameters
   LOG_CHUNK_PATH                           D:\ifmxdata\log.000
   LOG_CHUNK_SIZE                           40
   # Dbspace Parameters
   CCM_CHUNK_PATH                           D:\ifmxdata\ccm.000
   CCM_CHUNK_SIZE                           80
   ***********************************************************   

The following example shows how to create a database server using a parameter file (assume that you called it tonnyx.dat).

> ccmsrv create/file tonnyx.dat

/file tonnyx.dat specifies the name of the parameter file.

The above parameter file creates a database server with a maximum of 20 users (the default) and with chunk files created under D:\.

The results of this command are as follows:

***********************************************************
Database Server Configuration of
Maximum Number of Users:                           40
   Dbspace Name:                           rootdbs
   Root Chunk Path:                           D:\ifmxdata\rootdbs.000
Root Chunk Size:                              60 MBytes
   Dbspace Name:                           log
   Log Chunk Path:                           D:\ifmxdata\log.000
Log Chunk Size:                              40 MBytes
   Dbspace Name:                           ccm
   Ccm Chunk Path:                           D:\ifmxdata\ccm.000
   Ccm Chunk Size:                           80 MBytes
***********************************************************

Procedure

To use a file to specify parameters for Windows®:

  1. Indicate that you want to create the database server by using a parameter file.
  2. Confirm that you are ready to create the database server.
  3. Check your values.
  4. If you have typed any incorrect values, quit by typing N, and then start again, typing the correct values.
  5. When your values are correct, create the database server.
    Would you like to create the database server? (Y/N) [Y]

    A Y response uses the previous configuration to create the database server. If you choose to create the database server, type Y. Here is an example of a message you might see:

    ***********************************************************
    Initializing Disk Space and Shared Memory, please wait...
    ....
    Processing log and ccm dbspaces, please wait...
    ............................
    ***********************************************************

Results

If your database server is created successfully and brought online, you do not receive a message.

If the database server is not created, an error message explains why.


Feedback