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:

/opt/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:

/opt/derby/bin
Create DERBY_INSTALL and DERBY_HOME entries in the etc/lawson.env file and set their values to the derby directory where you moved the Derby files.

For example:
```
Set DERBY_INSTALL    /opt/derby
Set DERBY_HOME       /opt/derby
```
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

Note: This step assumes you are running this command and later ones for the Derby setup as root. If not, you will need to adjust permissions so that the user running them has read/execute rights.
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.