Completing the Configuration Worksheet

You need the following information to respond to prompts during database server configuration, which appears at the end of the installation process.

Database Server Number

The database server number uniquely identifies a database server if more than one instance of the database server is installed. If only one instance of the database server is installed, set this number to 0. The database server number that you specify is the value for the SERVERNUM configuration parameter.

The database server uses configuration parameters, set in the onconfig file, during initialization. For more information about configuration parameters and the onconfig file, see the "Configuration Parameters" chapter of the IBM Informix: Dynamic Server Administrator's Reference.

To determine how many instances of the database server are installed, run the Server Instance Manager program (choose Start > Programs > IBM Informix Dynamic Server 10.0 > Server Instance Manager). For more information, see

Database Server Name

The database server name identifies the database server to client applications. In most cases, you can choose the default value. The database server name that you specify is the value for the DBSERVERNAME configuration parameter.

Database server names must begin with a letter and can contain only letters, numbers, and the underscore character.

Service Name and Port Number

Specify the service name and port number for the TCP/IP network protocol.

The service name specifies the servicename entry and the port number specifies the port entry for the database server in the sqlhosts registry.

If only one database server instance exists on the computer, the installation program provides default values. It is recommended that you use these default values. For subsequent instances, you must provide unique values.

Root Dbspace Name, Location, and Size

A dbspace is a logical collection of chunks to which databases and tables are assigned. The root dbspace is the initial dbspace that the database server creates and is the default dbspace location for any database created with the CREATE DATABASE statement.

The root dbspace contains reserved pages and internal tables that describe and track all other storage components. For more information on dbspaces and the root dbspace, see the IBM Informix: Administrator's Guide.

Specify the storage location and disk-space size for the root dbspace:

• Primary Data Location

  By default, the Primary Data Location is the current drive. The installation program displays the amount of available disk space. This location is the value of the ROOTPATH configuration parameter.

• Mirror Location

  The mirrored location serves as the backup area if the primary storage device fails.

  If a second NTFS drive (with at least 10 megabytes available) is found, the installation program displays the default drive letter and available disk space. If the installation program cannot find a second local drive formatted using NTFS, you cannot set up a mirror location for the root dbspace.

  This location is the value of the MIRRORPATH configuration parameter.

Use the TBLTBLFIRST and TBLTBLNEXT configuration parameters to specify the first and next extent sizes for the tblspace tblspace in the root dbspace that is created when the server is initialized. These parameters can be added if they are not in the standard onconfig file.

Default Sbspace Name, Location, Size, and Page Size

An sbspace is a logical storage area that the database server uses to store smart large objects (CLOB and BLOB data). The default sbspace is where the database server stores a smart large object if you do not specify an sbspace name when you create the smart large object. The database server also uses the default sbspace to store user-defined statistics.

Specify the primary and mirrored data-storage location for the default sbspace:

• Primary Data Location. By default, the Primary Data Location of the sbspace is the current drive. The installation program displays the amount of available disk space. This location specifies the value of the SBSPACENAME configuration parameter.
• Mirror Location. The mirrored location serves as the backup area if the primary storage device fails.

  If a second NTFS drive (with at least 10 megabytes available) is found, the installation program displays the default drive letter and available disk space. If the installation program cannot find a second local drive formatted using NTFS, you cannot set up a mirror location for the default sbspace.

• Size. The size of the sbspace should be at least 50 megabytes.
• Page Size. The size of the sbpage should approximate the size of the most frequently occurring smart large object that the sbspace holds. The default is one page.

For more information about sbspaces, see the IBM Informix: Administrator's Guide.

Shared Server Definition Computer

Specify the computer on which to update the sqlhosts registry information with the shared server definition for the new database server instance and administrative tools as follows:

• The local computer on which you are installing the database server (default)
• Another computer in the network that serves as a central, shared repository of sqlhosts information for multiple database servers in the network

  If you specify another computer on the network, you must set the INFORMIXSQLHOSTS environment variable on your local computer to the name of the computer that stores the sqlhosts information.

Configuration Worksheet

Use the above information to fill out the Configuration Worksheet. This information will help you respond to the prompts during database server configuration.