Infrastructure at your Service

 
Daniel Westermann

Bringing up an OpenShift playground in AWS

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

Before we begin: This is in no way production ready, as the title states. In a production setup you would put the internal registry on a persistent storage, you would probably have more than one master node and you would probably have more than on compute node. Security is not covered at all here. This post is intended to quickly bring up something you can play with, that’s it. In future posts will explore more…

Read More
Morgan Patou

WebLogic – Update on the WLST monitoring

By | Application integration & Middleware | No Comments

A few years ago, I wrote this blog about a WLST script to monitor a WebLogic Server. At that time, we were managing a Documentum Platform with 115 servers and now, it’s more than 700 servers so I wanted to come back in this blog with an update on the WLST script. 1. Update of the WLST script needed Over the past two years, we installed a lot of new servers with a lot of…

Read More
Morgan Patou

Documentum – RCS/CFS installation failure

By | Entreprise content management | No Comments

A few weeks ago, I had a task to add a new CS into already HA environments (DEV/TEST/PROD) to better support the load on these environments as well as adding a new repository on all Content Servers. These environments were installed a nearly two years ago already so it was really just adding something new into the picture. When doing so, the installation of a new repository on existing Content Servers (CS1 / CS2) was…

Read More
Cesare Cervini

How to stop Documentum processes in a docker container, and more (part I)

By | Application integration & Middleware, Entreprise content management, Operation systems | No Comments

How to stop Documentum processes in a docker container, and more Ideally, but not mandatorily, the management of Documentum processes is performed at the service level, e.g. by systemd. In my blog here, I showed how to configure init files for Documentum under systemd. But containers don’t have systemd, yet. They just run processes, often only one, sometimes more if they are closely related together (e.g. the docbroker, the method server and the content servers),…

Read More
Cesare Cervini

How to stop Documentum processes in a docker container, and more (part II)

By | Database Administration & Monitoring, Entreprise content management | No Comments

ok, Ok, OK, and the docker part ? In a minute. In part I of this 2-part article, we showed how traps could be used to control a running executable from the outside. We also presented a bash test script to try out and play with traps. Now that we are confident about that simulation script, let’s dockerize it and try it out in this new environment. We use the dockerfile Dockerfile-dctm to create the…

Read More
Daniel Westermann

PostgreSQL 12: Explain will display custom settings, if instructed

By | Database Administration & Monitoring | No Comments

How many times did you try to solve a performance issue but have not been able to reproduce the explain plan? Whatever you tried you always got a different result. Lets say you managed to get a dump of the database in question, got all the PostreSQL parameters the same, gathered statistics but still you do not manage to get the same plan as the one who reported the issue. What could be a potential…

Read More
Daniel Westermann

PostgreSQL 12: Copying replication slots

By | Database Administration & Monitoring | No Comments

The concept of replication slots was introduced in PostgreSQL 9.4 and was created to prevent a primary instance to delete WAL that a replica still needs to apply. That could happen when you have a network interruption or the replica was down for another reason. With replication slots you can prevent that at the downside that your master could fill up your disk if the interruption is too long. This concept of a “physical replication…

Read More
David Barbarin

RCSI with foreign keys, NULL values and paramater sniffing behavior

By | Development & Performance, SQL Server | No Comments

In this blog post let’s go back to the roots (DBA concern) with a discussion with one of my friends about a weird transaction locking issue. In fact, this discussion was specifically around two questions. The first one was why SQL Server continues to use shared locks in RCSI mode leading to blocking scenarios and the second one was about compiled objects with weird NULL value parameter sniffing behavior. This discussion was very funny for…

Read More
Michael Hein

Second Meetup SOUG / DOAG /AOUG Region Lake of Constance

By | Database Administration & Monitoring | No Comments

Tuesday last week I attended the second meeting of SOUG region lake of constance which took place at Robotron Switzerland in Wil SG. Eleven people attended this event, Georg Russ hold a quite interesting presentation about “Hacked Biometric Data”. He told about how to fake finger prints, iris images, face ids and patterns of hand venes. After this presentation a general discussion about security and other Oracle related themes took place. It was a good…

Read More