Infrastructure at your Service

 
Morgan Patou

Documentum – SSL Certificate based secure communication setup

By | Application integration & Middleware, Enterprise content management | No Comments

Around four years ago, I did a few presentations, here, in Switzerland about “Security & Documentum”. In there, I talked about a lot of different subjects related to both security and Documentum (you guessed it…) like: ciphers, SHA, FIPS & JCE, Documentum & DFC connect mode (characteristics, ciphers, protocols, encryptions, limitations), Documentum & DFC encryptions in transit and at rest (AEK/DBK/LTK/FSK/FEK, TCS, CS Lockbox, D2 Lockbox vs D2 Keystore, Passwords encryption and decryption), and some…

Read More
Morgan Patou

Documentum – Configuration of an IDS Target Memory/RAM usage on Windows

By | Application integration & Middleware, Enterprise content management | No Comments

A few months ago, I had to work on a Windows Server to setup an IDS Target. The installation and configuration of the target wasn’t that different compared to a Linux host, so it wasn’t difficult at all (if you ignore some strange behavior like described here for example). But there was one point for which I was a little bit skeptical: how do you configure the IDS Target Memory/RAM assignment for its JVM? On…

Read More
Franck Pachot

DynamoDB / Aurora: sparse and partial indexes

By | AWS, Cloud | No Comments

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If you work with AWS Databases and frequently switch between DynamoDB and Aurora, or other RDS databases, you may be confused by the same terms used for different meanings. An index is a redundant structure that is maintained by the…

Read More
Nabil Saoual

JENKINS : Update manually your Jenkins master

By | DevOps | No Comments

Hi there, What about keeping up to date your Jenkins 🙂 Such easy to perform that!Today we will check the manual update of our Jenkins master Check if updates are available You can see that a new version is available in the blue info ribbon We got 2 ways to upgrade Jenkins : manually or automatically You can check your current version at the bottom right hand corner of your page Check the changelog Note…

Read More
Stéphane Haby

Ansible Basics Workshop day @dbi services

By | Ansible, Database Administration & Monitoring, DevOps, Technology Survey | No Comments

Today, I follow our Workshop Ansible Basics with Jérôme Witt. Why I follow this workshop? First, it’s to have the basics and Best Practices before begin myself and do “bricolage” by my customers. The second point is to develop templates to use and reuse by all customers if needed. Let’s start the course! My first remark is that the Control node cannot be installed on a Windows machine… Not good news for me! 👿 I…

Read More
Nabil Saoual

Control-M/EM : libnsl.so.1: cannot open shared object file: No such file or directory

By | Control-M | No Comments

Hi team, When installing a brand new control-M server on your machine,you may encounter issues related to Control-M installation prerequisite. That was my case on my Virtual machine,we will see how to fix it quickly. System configuration: Issue encountered during installation: machine: [[email protected] ~]# uname -a Linux localhost.localdomain 4.18.0-80.11.2.el8_0.x86_64 #1 SMP Tue Sep 24 11:32:19 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux [[email protected] ~]# CentOS Linux 8 64bits =============================== === Control-M 9.0.20.000 Installation === === Installation…

Read More
Franck Pachot

K8s on Windows/VirtualBox

By | Kubernetes, Postgres | No Comments

By Franck Pachot . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hello World” but a real database running here, able to scale up and down with full availability. Install Virtualbox I use Oracle VirtuaBox because I’m a big fan of Oracle products, especially when they are good and free. However, you can use Hyper-V (then just skip this paragraph and…

Read More
Steven Naudet

SQL Server: Audit changes on Instance Configuration, Linked Servers and Agent Jobs

By | Database Administration & Monitoring, SQL Server | No Comments

Introduction Very often with our customers, there is only one person with the DBA role. The configuration of the instances is then under control and if anything strange has to be questioned, the culprit is quickly identified. 🙂 When many people, not necessarily having DBA knowledge, have high permissions (sysadmin) on instances it becomes important to know who does what. In this blog post, we will see how to get notified by email when certain…

Read More
Steven Naudet

SQL Server connectivity issue – troubleshoot TLS configuration

By | Database Administration & Monitoring, Security, SQL Server | No Comments

In the blog post, I will share a case of troubleshooting a connectivity issue with SQL Server. The problem occurred in a migration context. The SQL Server databases (in version 2008 to 2014) from multiple applications were consolidated on a new server with SQL Server 2019. Application servers were also migrated to new VMs. The new servers are hosted on a brand new infrastructure managed by a third-party provider which my customer has very little…

Read More
Daniel Westermann

temBoard on SLES15 – 2 – The agent

By | Database Administration & Monitoring | No Comments

In the last post we’ve installed the temBoard repository and the UI. As this alone is not so much fun, we’ll be installing the temBoard agent on another SLES 15 machine in this post. We’ll end up with one PostgreSQL instance registered in the temBoard repository and this instance is constantly monitored. With the repository and the UI we had the requirement to use Python 2.7, but this is not anymore required for the temBoard…

Read More
Dieter Henig

Rename your DB clone completely

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Introduction Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicating) with RMAN provided a new DBID, right? So why should we need to rename a DB? There may be several reasons: due to changed company rules, you need to rename all your DBs After a restore you need to run the DB with another name After a snapshot clone, (see my recent…

Read More
Christophe Cosme

SQL Server – Contained Database

By | Database Administration & Monitoring | No Comments

Introduction You may have encounter already case when an application offers the possibility to create and maintain SQL database users and consequently the associated SQL Server instance logins. That’s of course not especially really what a DBA likes, loosing control on the logins that are created on the instance he is responsible of. But sometimes you have to deal with such situation especially when a customer ask you to enable this. Well, then it’s starts…

Read More