Multiple server instances on a single system

You can run multiple server instances on a single system by setting up separate database and recovery log directories for each server instance. You must also set up an instance directory for each server instance to contain the server options file and other files that are required to run the instance.

AIX operating systems HP-UX operating systems Linux operating systems Oracle Solaris operating systems Each server instance requires a unique user ID that is the instance owner.

Windows operating systems Server instances can be owned by the same or different user accounts.

The files for each instance are stored separately from the server program files. As part of server configuration, you create a directory to store the files for the server instance. The following files are stored in the instance directory:

The server options file, dsmserv.opt
The server key database file, cert.kdb, and the .arm files, which are used by clients and other servers to import the Secure Sockets Layer certificates of the server
The device configuration file, if the DEVCONFIG server option does not specify a fully qualified name
The volume history file, if the VOLUMEHISTORY server option does not specify a fully qualified name
The volumes for storage pools of the FILE device type, if the directory for the device class is not fully qualified
The user exits
The trace output file, if the trace file name is not fully qualified
The log file for first-failure data capture, dsmffdc.log

Database and recovery log files are stored in separate directories, not in the instance directory.

To manage the system memory that is used by each server on a system, you can use the DBMEMPERCENT server option. Set the DBMEMPERCENT option to limit the percentage of system memory that can be used by the database manager of each server. If all servers are equally important, use the same value for each server. If one server is a production server and other servers are test servers, set the value for the production server to a higher value than the test servers.

Example: Automatically starting two server instances

To run two server instances, tsminst1 and tsminst2, you can create instance directories such as /tsminst1 and /tsminst2. In each directory, place the dsmserv.opt file for that server. Each dsmserv.opt file must specify a different port for the server to use.

AIX operating systems HP-UX operating systems Oracle Solaris operating systems To run the server instances, use the rc.dsmserv script, as described in Automatically starting servers on AIX, HP-UX, or Solaris.

Linux operating systems To run the server instances, use the dsmserv.rc script, as described in Automatically starting servers on Linux systems.

Windows operating systems To run the server instances, follow the instructions in Starting the server as a Windows service.