Installing the Derby Database

If you do not use an RDBMS as the Infor System Console database, use this procedure to install a Derby database and start the Derby network server. The Derby database is needed to enable the Notifications and Alerts feature of the Infor System Console if you are not using an RDBMS instead.

After you install the application server for the Infor System Console, you will then need to configure that application server for your Derby database.

Download the Derby file (db-derby-10.10.2.0-bin.zip) from the following URL:

http://db.apache.org/derby/releases/release-10.10.2.0.cgi
Extract the contents of the zip file to a directory for Derby. For example:

/derby
Move the contents of the db-derby-10.10.2.0-bin directory to the derby directory. When you are done, the path to the bin directory should then be, for example:

/derby/bin
Create DERBY_INSTALL and DERBY_HOME environment variables and set their values to the derby directory where you moved the Derby files.
Using your preferred method of setting environment variables, ensure that you have a command line session with the new Derby variables set.
Change directory to DERBY_INSTALL/bin and at the command line type:

setEmbeddedCP
In a command line session, navigate to $DERBY_HOME/bin.
At the command line, type

startNetworkServer -h derbyHostName -p derbyPortNumber

where derbyHostName is the name of the host where the Derby database is installed and derbyPortNumber is the port for the Derby database. If you do not specify the port number, the command will assume the default Derby port number of 1527.
Ensure that the Derby network server is running during the installation of the Infor System Console and whenever you want to use the Infor System Console. The default is for the network server to continue running unless explicitly shut down or if it fails for some reason such as a system shutdown.