All articles

Setting up IBM Db2 on Linux – root installation

In the first post about Db2 I went for the non-root installation method. While this is great if you want to get started fast and to do some tests this also comes with(…)

ODA KVM Machines : Adding a Network Interface on a Virtual Machine

By Mouhamadou Diaw In a previous blog , I was talking about virtual machines on ODA servers. Sometimes it comes that we want to add another network interface for other purpose. In this blog I(…)

Getting explain plans out of Db2

The last post about Db2 was about getting it up and running. As the issue we had to solve was about performance, getting an explain plan for the problematic statement(s) was the obvious step to do. In(…)

Migrating a CentOS 7 EC2 instance to Rocky Linux 8

Some time ago I've written about migrating a CentOS 8 machine to Red Hat 8, because CentOS 8 reached end of life last December. We did that for all CentOS 8 installations at that(…)

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)

Managing Ansible with AWX – Part II – Organizations, Users and Teams

In the 1st post of this serie, I demonstrate how easy it is to install AWX on a local Minikube Kubernetes cluster. Now that the installation is done and the access to the web console is(…)

PostgreSQL on ARM using Odroid N2/N2+

For this installation i’m using a Hardkernel Odroid N2/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on(…)

Setting up IBM Db2 on Linux

My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL/application level. I've never done an installation of Db2 as most of our customers either don't use it, or we(…)

Automating Linux patching with Ansible – How to keep all your environments consistent ?

Your may want to patch your Linux servers on a regular basis (e.g using “yum/dnf update”). As always, it’s obviously recommended to : 1) Patch the TEST systems 2) Check if there is no side effects 3) Wait(…)

What I really like about Percona PMM

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)