SAND CDBMS Administration Guide
Installing and Configuring SAND CDBMS

Installing SAND CDBMS for Windows

Setting Up the nucleus.ini File

In order to start a database instance with the nserv database server program and connect to it with a client program such as the SAND CDBMS Interactive SQL utility (nisqlm), the SAND CDBMS Data Loader (ndlm), or SAND Analytic Explorer, the appropriate entries must be present in the nucleus.ini file. This file must be 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 server_test]
DatabasePath=C:\PROGRA~1\SAND

[CONNECTION cn1]
Port=50501
Host=<local-host>

This file allows a database called server_test to be started in the default SAND CDBMS SUPPORT directory. The database server will run on the local computer 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 (DatabasePath) 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.