Infrastructure at your Service

Category

Database Administration & Monitoring

Nabil Saoual

Control-M/EM Order jobs with a specific user daily

By | Control-M, Database Administration & Monitoring | No Comments

Introduction Hi everybody,today let’s see an easy way to order a folder at a specific hour/date instead of being ordered directly by the new day procedure. To do so, we will use the ctmudly utility. Ctmudly command To order a folder depending of a specific user daily we will use this syntax (connected as controlm) ctmduly -DAILY_NAME ENTER_YOUR_USER_DAILY_NAME Be careful of maximum numbers of characters allowed to define your specific user daily(10 char). Example: ctmduly…

Read More
Daniel Westermann

The EDB tool-set integration into PEM – EDB EFM

By | Database Administration & Monitoring | No Comments

In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is EDB EFM (EDB Failover Manager). We again will not cover how that tool works or how you need to set it up, but rather focus on how EFM integrates into PEM. What I expect from the integration of…

Read More
Daniel Westermann

The EDB tool-set integration into PEM – EDB BART

By | Database Administration & Monitoring | No Comments

When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a choice of other open source components for supporting backup and recovery, high availability and monitoring/alerting. The other type of customer usually already has a subscription for the underlying Linux operating system and wants to have the same supported model…

Read More
Lazhar Felahi

Oracle Data Pump Integration for Table instantiation with Oracle Golden Gate

By | Database Administration & Monitoring, Oracle | No Comments

From Oracle GoldenGate (OGG) version 12.2 and above, there is a transparent integration of OGG with Oracle Data Pump as explained in the Document ID 1276058.1. The CSN for each table is captured on an Oracle Data Pump export. The CSN is then applied to system tables and views on the target database on the import. These views and system tables are referenced by Replicat when applying data to target database. This 12.2 feature, no…

Read More
Nabil Saoual

Control-M/EM Mass create reset counter to 0

By | Control-M, Database Administration & Monitoring | No Comments

Introduction Hi everybody, making jobs has never been such easier in using mass create utility, easy also to increment with counter feature (ex: JOB1,JOB2,JOB3) but  sometimes we may not have the expected result,especially when you do mass update for 2 different folders.Let’s see that: You already know how to do mass update, if not check on of my previous posts But what happens when I try to mass create jobs for another folder? As we…

Read More
Steven Naudet

SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption

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

In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes. So the Job ran outside of its maintenance window, still running in the morning when users come back to the office. They immediately complained about poor application performance. While running the CHECKDB we could…

Read More
Jérôme Dubar

Oracle Database Appliance and CPU speed

By | Database Administration & Monitoring, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction A complaint I heard from customers about ODA is the low core speed of the Intel Xeon processor embedded in the X8-2 servers: Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz. 2.30GHz only? Because of its comfortable number of cores (16 per processor), the cruise speed of each core is limited. Is it a problem compared to a home made server with less cores? Why clock speed is important? As you may now, the faster…

Read More
Franck Pachot

A lesson from NoSQL (vs. RDBMS): listen to your users

By | Database Administration & Monitoring, NoSQL | One Comment

By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to bound resources”). And I’ll continue on other points that are claimed by some NoSQL vendors and are, in my opinion, misleading by lack of knowledge and facts about RDBMS databases. But here I’m sharing an opposite opinion: SQL being user-friendly is now a myth. Yes, that was the…

Read More