All articles

PostgreSQL message levels

When you start to write business logic in the database by using triggers or functions/procedures you usually want to report messages to the user that runs your code or you want to include some debugging output for your own. In(…)

Documentum – Rename of Lockbox on RCS/CFS

As you probably know, Documentum introduced the optional use of a Lockbox since version 7. It was done initially to contribute to the security of the AEK key which is one of the central components of a Content Server. Time(…)

SQL Server Tool: MSSQL-CLI

MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the(…)

Documentum – dm_DMFilescan fails with invalid method_verb?

Recently in a project, one of the Documentum environments we were working on started showing failure on the execution of the dm_DMFilescan job and only this one. After a couple minutes of investigation, I quickly found the root cause of(…)

Migrating an Oracle instance to AWS Aurora – 4 – AWS DMS Change Data Capture (CDC)

This is the last post in this little series about migrating on Oracle instance to AWS Aurora with PostgreSQL compatibility. For the previous one you can check here, here and(…)

Documentum – LSS registerOracleVersionView script with wrong content

As discussed in a previous blog, working with LSS might prove a little bit challenging from time to time. In this blog, I wanted to share an error I saw while installing LSS 16.6.1 on an(…)

Documentum – D2-Smartview class cast exception

D2-Smartview is a new UI that OpenText now provides starting with the version 16 of D2. It’s a lightweight UI that can perform some of the actions that D2 does. The list of features will probably increase with time but(…)

Migrating an Oracle instance to AWS Aurora – 3 – Data replication with AWS DMS

If you followed the last two posts in this little series (here and here) this is the current status of this demo migration project: We have converted the Oracle SH schema and(…)

Migrating an Oracle instance to AWS Aurora – 2– The AWS Schema Conversion Tool (SCT)

Having the required infrastructure ready now it is time to have a look at the AWS Schema Conversion Tool (SCT). The goal of this tool is to convert a source schema (Oracle(…)

Can I put my temporary tablespaces on a RAM disk with PostgreSQL?

The short answer to the title of this blog post is: yes, of course you can. The more important question is: should you? The PostgreSQL documentation about tablespaces contains an explicit warning: "Placing a tablespace on(…)