Database

The IBM Process Mining application requires the databases, Monet 11.51.5 and PostgreSQL 15.

Installing PostgreSQL

IBM Process Mining requires PostGreSQL version 15 installed or accessed remotely. To install your own deployment of PostGreSQL, use one of the following commands depending on your operating system:

  • To install the recommended PostGreSQL version on Ubuntu, you must state the explicit version during the installation. Run the following command:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmour -o /usr/share/keyrings/postgresql.gpg
echo "deb [signed-by=/usr/share/keyrings/postgresql.gpg] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt install postgresql-15

For more information, see PostgreSQL Ubuntu installation.

  • To install the recommended PostdreSQL version on RedHat, you must state the explicit version during the installation. Run the following command:
sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(lsb_release -rs  | awk '{printf"%d",$NF}')-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum -qy module disable postgresql
sudo yum install postgresql15-server
sudo postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15

For more information, see PostgreSQL RedHat installation.

For more information on the initial steps required by IBM Process Mining for PostgreSQL, see Basic setup.

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).

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-sql=11.51.5 monetdb-sql=11.51.5 monetdb-server=11.51.5 monetdb-client=11.51.5 libmonetdb-client27=11.51.5 libmonetdb-stream27=11.51.5 monetdb5-server=11.51.5 libmonetdb29=11.51.5

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.51.5 MonetDB-client-11.51.5 MonetDB-11.51.5 MonetDB-stream-11.51.5

For more information, see RedHat&CentOS Easy Setup.

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
  1. 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
#  ├── focal
#  ├── jammy
#  └── noble
cp ${PM_HOME}/native/ubuntu/$(lsb_release -sc)/*.so .
ln -s lib_PM-sql-2.0.1.so lib_PM-sql.so
popd

For RedHat:

pushd /usr/lib64/monetdb5-11.51.5
# 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.0.1.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 Installing MonetDB 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 and <PM_HOME>/etc/brm-service.conf files. 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
  ...
}

Changing those settings must be duplicated in the brm-service.conf file. An example of changes, which correspond to the manually configured additional settings:

BRM_MONET_HOST=127.0.0.1
BRM_MONET_PORT=50000
BRM_MONET_DB_NAME=processmining