Service name and port number, Dbspace name, location, and size – IBM GC23-7753-05 User Manual
Page 38
Service name and port number
The service name specifies the service name entry and the port number specifies
the port entry for the database server in the sqlhosts registry.
Specify the service name and port number for the TCP/IP network protocol.
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 database server instances, you must provide unique values.
Dbspace name, location, and size
A dbspace is a logical collection of chunks to which databases and tables are
assigned.
During installation, the root dbspace is created automatically. You can configure an
additional data dbspace, mirror location, or smart blob drive.
Specify the location and disk-space size for the dbspace:
Primary data location
By default, the primary data location is the current drive. The installation
program displays the amount of available disk space; the default dbspace
size is 200 megabytes.
Smart blob drive
A default smart blobspace can be configured optionally. The default size is
200 megabytes.
Mirror location
The mirrored location serves as the backup area if the primary storage
device fails. The mirrored location should be the same size as the primary
location and should be in a different drive. The data dbspace and the
smart blob can be mirrored on the same drive.
This mirrored location is also the value of the MIRRORPATH configuration
parameter.
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 the location in which 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 mirror data-storage location for the default sbspace:
Primary Data Location
By default, the Primary Data Location of the sbspace is the current drive
and must have a minimum of 200 megabytes. The installation program
displays the amount of available disk space. This location also specifies the
value of the SBSPACENAME configuration parameter.
Mirror location
The mirrored location serves as the backup area if the primary storage
3-6
IBM Informix Installation Guide for Windows