Optional: Installing MonetDB

MonetDB computation engine is bundled as part of a IBM Process Mining deployment. Backing up and restoring is not needed for MonetDB, since the data is stored outside IBM Process Mining. In case of an issue with MonetDB, its content can be restored by re-doing the mining (visualise button).

Important: Under normal circumstances you do not have to install your own instance of MonetDB.

If Support recommends that it is necessary to install your own MonetDB deployment, use one of the following commands depending on your operating system:

  • To install the recommended MonetDB version on Ubuntu, you must state the explicit version during the installation. Run the following command:
  echo "deb https://dev.monetdb.org/downloads/deb/ $(lsb_release -sc) monetdb" | sudo tee /etc/apt/sources.list.d/monetdb.list
  sudo wget --output-document=/etc/apt/trusted.gpg.d/monetdb.gpg https://dev.monetdb.org/downloads/MonetDB-GPG-KEY.gpg
  sudo apt update
  sudo apt install monetdb5-server=11.55.1 libmonetdb-client28=11.55.1 libmonetdb-stream28=11.55.1 libmonetdb31=11.55.1 monetdb-server=11.55.1 monetdb-sql=11.55.1 libmonetdbe27=11.55.1 libmonetdb-mutils=11.55.1 monetdb5-server-dev=11.55.1 libmonetdb-dev=11.55.1 libmonetdb-stream-dev=11.55.1 monetdb-server-dev=11.55.1 monetdb-sql-dev=11.55.1 libmonetdbe-dev=11.55.1 libmonetdb-client-dev=11.55.1 monetdb-client=11.55.1

For more information, see Ubuntu&Debian Easy Setup.

  • To install the recommended MonetDB version on RedHat, you must state the explicit version during the installation. Run the following command:
  sudo yum install https://dev.monetdb.org/downloads/epel/MonetDB-release-epel.noarch.rpm
  sudo rpm --import https://dev.monetdb.org/downloads/MonetDB-GPG-KEY
  sudo yum install MonetDB-SQL-11.55.1 MonetDB-client-11.55.1 MonetDB-11.55.1 MonetDB-stream-11.55.1

For more information, see RedHat&CentOS Easy Setup.

Important: RedHat 9, if you encounter a KEY import error. You need to temporarily set crypto-policies to LEGACY
  sudo rpm --import https://dev.monetdb.org/downloads/MonetDB-GPG-KEY
  warning: Signature not supported. Hash algorithm SHA1 not available.
  error: https://dev.monetdb.org/downloads/MonetDB-GPG-KEY: key 1 import failed.
  
  update-crypto-policies --set LEGACY
  rpm --import https://dev.monetdb.org/downloads/MonetDB-GPG-KEY
  update-crypto-policies --set DEFAULT

After the installation, do the following steps:

  1. Ensure that MonetDB is not enabled with the following command on Ubuntu and RedHat:
    sudo systemctl status monetdbd
sudo systemctl stop monetdbd
sudo systemctl disable monetdbd
  2. To add the IBM Process Mining MonetDb module library to this MonetDB deployment, run the following commands:

For Ubuntu:

pushd /usr/lib/x86_64-linux-gnu/monetdb5
# Folder present per Ubuntu version
#  native/ubuntu
#  ├── jammy
#  └── noble
cp ${PM_HOME}/native/ubuntu/$(lsb_release -sc)/*.so .
ln -s lib_PM-sql-2.2.0.so lib_PM-sql.so
popd

For RedHat:

pushd /usr/lib64/monetdb5-11.55.1
# Folder present per RHEL version
#  native/rhel
#  ├── 8
#  ├── 9
cp {PM_HOME}/native/rhel/$(lsb_release -rs  | awk '{printf"%d",$NF}')/*.so .
ln -s lib_PM-sql-2.2.0.so lib_PM-sql.so
popd

Configuring MonetDB

Standard configuration of MonetDB is automatic and does not require manual configuration.

Overriding bundled MonetDB

In order to use alternative MonetDB binaries, you must set an override in <PM_HOME>/bin/environment.conf:

PM_MONET_OVERRIDE=1

If alternative MonetDB binaries were not deployed as directed as in the installation section, additional overrides are available.

An example of an additional override:

PM_MONET_BINARIES_FOLDER=/home/user/bin
PM_MONET_LIB_FOLDER=/home/user/usr/lib64

Additional MonetDB override options

You can manually configure additional settings in <PM_HOME>/bin/environment.conf, <PM_HOME>/etc/processmining.conf. These changes include database folder location, port, hosting server and database name.

The following code is an example of additional settings:

PM_MONETDB=${PM_REPOSITORY}/monetData
PM_MONET_PORT=50000
PM_MONET_LISTEN=0.0.0.0
PM_MONET_DB_NAME=processmining
PM_MONET_LIBRARY_SUFFIX=PM-sql

Changing those settings must be duplicated in the processmining.conf file in the MonetDB section. An example of changes, which correspond to the manually configured additional settings:

monetdb: {
  database: "processmining",
  host: "127.0.0.1",
  port: 50000
  ...
}

External MonetDB

You can also install an external instance of MonetDB. For more information, see Optional: Installing native external MonetDB.