All articles

Documentum – A first experience with the Life Sciences Suite 16.6.1 silent installation

A few months ago, I was working on automating an LSS installation for a customer so I thought about sharing my experience around that topic… LSS is the Life Sciences product from OpenText (formerly EMC->Dell->OpenText). It can be split into(…)

About temp_tablespaces in PostgreSQL

There often is a discussion if tablespaces should be used in PostgreSQL. People used to work with Oracle are often a bit surprised by this discussion as there is no way around using tablespaces in that technology. PostgreSQL does not(…)

Upgrading SUSE Linux Enterprise online

One really good feature from SUSE Linux Enterprise (SLE) is that it allows you to upgrade from your running system to a new service pack online. Let's say from SLE 12 SP3 to SLE 12 SP4. No new installation is(…)

ysql_bench: the YugaByteDB version of pgbench

By Franck Pachot . This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://www.dbi-services.com/blog/yugabytedb-2-1/ A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by(…)

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

By Franck Pachot . 9 months ago I was looking at YugaByteDB which was still in beta version for its 'YSQL' API. I published my first test on Medium: https://medium.com/@FranckPachot/running-pgbench-on-yugabytedb-1-3-3a15450dfa42. I have been very enthusiastic about(…)

Collations in PostgreSQL – basics

When you work with databases sooner or later you will need to get in touch witch collations. It might be that you never needed to think about it as initdb picked a(…)

Restore S3 Object with AWSPOWERSHELL

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the(…)

How to automate a kill of one or several executing jobs in AJF at specific Date/Time at once

Introduction We had a request to automate a kill of some executing jobs in AJF at specific date and time. For example: A Control-M job is running a script all day, in order other programs can connect to it,(…)

SQL Server: Collect Page Split events using Extended Event session

Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up(…)

Control-M/EM Mass update,some examples on how to use it

Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you(…)