SAND CDBMS Administration Guide
Installing and Configuring SAND CDBMS

Installing SAND CDBMS for UNIX

Setting Up the nucleus.ini File

In order to start a database instance with the nserv program and connect to it with a client program such as the SAND CDBMS interactive SQL utility (nisqlm) or the SAND CDBMS Data Loader (ndlm), the appropriate entries must be present in the nucleus.ini file, which is located in the directory specified by the SUPPORT parameter in the NUCLEUS environment variable.

The server-side nucleus.ini file must contain a [DATABASE instance-name] section for each database instance (real database or virtual instance) that will be used on the system, and a [CONNECTION connection-name] section for each database instance that will be running concurrently. Instance-name and connection-name will be specified both in the database server startup command and in connection requests from client programs.

The DATABASE section must contain at least a DatabasePath parameter specifying the path to the directory containing the primary database file (.n00 file) for the instance. This is required to start or create a database with the nserv program. The CONNECTION section must contain at least a Host parameter specifying the host name or IP address of the computer on which the database instance is running, and a Port parameter specifying the port number that will be used to connect to the running database instance. For information about the other parameters that may be included in the nucleus.ini file, consult the Nucleus.ini reference page.

A sample server-side nucleus.ini file is included in the SAND CDBMS installation, containing the following entries:

[DATABASE db1]
DatabasePath=/usr/sand/db1_dir
Cache=128

[CONNECTION cn1]
Port=50501
Host=server1

This file allows a database called db1 to be started in the /usr/sand/db1_dir directory, using 128 megabytes of SAND CDBMS cache. The database server will run on a computer called server1 and listen for connection requests on port 50501. To start using a SAND database on your system, replace the values to reflect the desired database name and connection name, and specify the desired location for the database and port number for connection (Port). The Cache value should be no more than 80% of the real memory available to the system. Make sure to include the correct Host name or IP address in the CONNECTION section.

Once these entries have been made, the database can be started using the nserv program. If the specified database does not physically exist, nserv will create it and then start it. Database file configuration can then be set using the nconfig program.

When connecting to a database instance from a remote client on a network, a client-side nucleus.ini file is required. This file must contain a [CONNECTION connection-name] section that matches the appropriate CONNECTION section in the server-side nucleus.ini file.

Note:
SAND Enterprise Manager and SAND Analytic Explorer automatically write entries to the nucleus.ini file as required.