Skip to content

DevOps

How we automate infrastructure and databases so that deployments become boring: Ansible, Docker, Kubernetes, CI/CD pipelines, infrastructure as code, GitOps, Control-M scheduling and our own YaK deployment framework.

Control-M/EM Shout destination tables graphic and cmd mode

Introduction Today we will check how to use notification by using shout destination table, indeed sometime it could be useful to be notified about our jobs status ( long execution, late submission failure etc..). For that kind of need we can use job notifications through shout method. We will explain it below: We will use shout destination table to manage… 

DevOpsDays 2020 Geneva – Day 2

As promised in my previous blog, I will give you a short feedback on the second day here at DevOpsDays 2020 Geneva. In fact, I prepared a very interesting program of sessions to attend and people to meet. I must say that the open-spaces concept applied on the second day allowed participants to discuss on different topics without limit. I… 

DevOpsDays 2020 Geneva – Day 1

It is a pleasure to come back to Geneva after 5 years to attend my first DevOps event. I’m very excited to share with you my first day feedback, but before I would like to thank dbi services for allowing me to attend this event and continuously improving my knowledge in this growing field. The first day started by the… 

Oracle 20c SQL Macros: a scalar example to join agility and performance

By Franck Pachot . Let’s say you have a PEOPLE table with FIRST_NAME and LAST_NAME and you want, in many places of your application, to display the full name. Usually my name will be displayed as ‘Franck Pachot’ and I can simply add a virtual column to my table, or view, as: initcap(FIRST_NAME)||’ ‘||initcap(LAST_NAME). Those are simple SQL functions. No… 

Control-M/EM Unlock and Take ownership of a folder

Introduction Definition of a workspace It is a board letting you create and update folders and jobs, once you work ended and saved into the base the workspace can be deleted. Sometimes when you want to work on a folder and edit it (Check in) you can be stuck by someone else “working” on it: But how can you proceed… 

Control-M – Agent Upgrade – Communication Issue

At a customer, we are upgrading Control-M Agents running on Windows/Unix from 9.0.00.400 to 9.0.19.200 using Agent Deployment, an upgrade of one agent fails with error talking about communication issue between Control-M/server and Control-M agent: Testing Communication with Control-M/Server using new Control-M/Agent binaries failed, Control-M/Agent Upgrade aborted, please check Log and agent installation requirements On the other hand, the agent… 

Control-M/EM – emdef utility – Jobs

The emdef is a command line utility used to make various modifications to job definitions in the Control-M/EM database. we saw how emdef can help to manage Calendars and Folders, today it the Jobs turn so let’s deep in 😉 The emdef need some parameters which vary according to the method to be executed, methods related to Jobs management are:… 

Control-M/EM Update ctmuser & emuser DBO password

Introduction For security purposes we sometimes must update the password of our Control M architecture. This task seems to be easy, but you must be careful to update the passwords wherever they are used. Today we will check how to update the password of our Control M infrastructure including application user and database owner for each of our databases. Prerequisites… 

Control-M/EM – emdef utility – Folders

In a previous blog I talked about the emdef utility and how it can help to manage and standardize calendars across multiple environments. In this blog we will deal with folders definitions in the Control-M/EM database. This can be used to extract data as a backup, or for migration from one to another environment. The emdef need some parameters which… 

Control-M/EM – emdef utility – Calendars

The emdef is a command line utility used to make various modifications to calendar definitions in the Control-M/EM database. It can be used to extract data as a backup, or for migration from one to another environment. The emdef need some parameters which vary according to the method to be executed, methods related calendars are: copydefcal: Creates a new calendar… 

Control-M/EM Import/Export Calendar

Control-M: Export/Import Calendars Introduction: What is a Control M Calendar? A Control M calendar is used to schedule Control M jobs that are assigned to him: For example the job named JOB_TEST will be executed depending of the days and rules defined in the calendar named CALENDAR_EXAMPLE_1 : You can see that the job is scheduled following the calendars rules…