Infrastructure at your Service

 
Daniel Westermann

Some thoughts about working with/on AWS

By | Database Administration & Monitoring | No Comments

In the last year working with/on AWS has become an almost daily task in my life as a consultant and trainer. From a trainer perspective there is not much to say about it because we use a very limited amount of services (EC2, mostly) and we have a limited amount of trainers that use the platform to deliver our trainings. When the amount of services you use is small and the amount of people managing…

Read More
Daniel Westermann

Rapid PostgreSQL cloning using AWS EBS snapshots

By | Cloud, Database Administration & Monitoring | No Comments

When you go for AWS EC2 instances to host your PostgreSQL deployments and you want to rapidly clone PostgreSQL instances for development or testing purposes you can make use of AWS EBS snapshots. In this post we’ll look at how you can quickly spin up EC2 instances that use these snapshots as a base for new PostgreSQL clusters. Although we’ll be using the AWS console to show how this can be done you should use…

Read More
Franck Pachot

Oracle recovery concepts

By | Oracle | No Comments

I’ve published a while ago a twitter thead on some Oracle recovery concepts. For those who are not following twitter, I’m putting the whole thread here:   🔴⏬ Here I start a thread about some Oracle Database concepts. We will see how far it goes - all questions/comments welcome. 🔴⏬ A database (or DBMS - database management system) stores (for short and long term) and manipulates (from many concurrent users/devices) your #data. 🔴⏬ #data is logically structured (tablespaces, schemas, tables, columns, datatypes,…

Read More
Daniel Westermann

PostgreSQL 13 – Autovacuum can now be triggered based on inserts

By | Database Administration & Monitoring | No Comments

A common issue with insert only tables in PostgreSQL is, that autovacuum well never kick in as the formula for autovacuum considers obsoleted tuples since the last vacuum but not the number of inserted tuples. Because of this you usually run a manual vacuum when a table is bulk loaded right after the load or you schedule regular vacuums for tables you know are insert only. PostgreSQL 13 will finally solve that issue because autovacuum…

Read More
Morgan Patou

Documentum – D2 Folder structure import failure with wsctf browser plugin

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

Earlier today, I talked about the Export/Download that wasn’t working randomly. In the end, it was both linked to the wsctf browser plugin (that didn’t provide the necessary cookies in the download request) as well as the “loadBalancedContentServer” parameter (that was wrongly set to false). For the previous issue, setting the “loadBalancedContentServer” property to true was sufficient to solve it (see more details on the previous blog). For this blog, unfortunately, the issue has a…

Read More
Daniel Westermann

Using AWS Storage Gateway as a backup target for PostgreSQL – Cached volume gateway

By | Database Administration & Monitoring | No Comments

In the last post we had a look on how you can use AWS Storage Gateway as File gateway to store your PostgreSQL backups safely offsite on AWS S3. Another method of doing that would be to use “Cached Volume gateway” instead of the File gateway we used in the last post. The volume gateways does not provide access via NFS or SMB but does provide a volume over iSCSI and the on-prem machines will…

Read More
Morgan Patou

Documentum – D2 Export/Download random failure with wsctf browser plugin

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

The D2 clients were, until recently (D2 version 16.4 included), working by default with the java plugin mode and therefore, many actions were using a JVM on the client workstation. This setting can be controlled/set in the “WEB-INF/classes/settings.properties” file of D2 applications (D2, D2-REST, D2-Smartview) and the default value was therefore “browser.plugin.mode = java“. Starting with D2 16.5, this was changed and the default value is now “browser.plugin.mode = wsctf,thin“, meaning that it will try…

Read More
Clemens Bleile

A change in full table scan costs in 19c?

By | Database Administration & Monitoring | No Comments

During tests in Oracle 19c I recently experienced this: [email protected]@orcl> select * from demo4 where m=103; [email protected]@orcl> select * from table(dbms_xplan.display_cursor); … ————————————————————————— | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ————————————————————————— | 0 | SELECT STATEMENT | | | | 26439 (100)| | |* 1 | TABLE ACCESS FULL| DEMO4 | 1 | 10 | 26439 (14)| 00:00:02 | ————————————————————————— –> The costs of the full table…

Read More
Daniel Westermann

Using AWS Storage Gateway as a backup target for PostgreSQL

By | Cloud, Database Administration & Monitoring | No Comments

In the last post we had a quick look at AWS Kinesis data streams and how you can push data to AWS S3 using AWS Firehose. Another great AWS service is AWS Storage Gateway and in this post we’ll use that to push our PostgreSQL backups to AWS. The primary usage of AWS Storage Gateway is to extend you local storage to AWS so that you do not have to extend your local storage on…

Read More

SQL Server: Quickly clean backup history with dbatools

By | Database Administration & Monitoring | No Comments

I just had to restore a database in production for my customer. Before doing the restore I have the habit to query the msdb.dbo.backupset table to get an overview of the last backups. When running my query, I felt it was taking longer than usual. So out of curiosity, I looked at the SSMS standard report “Disk Usage by Top Tables”. Here is the output. This instance contains dozens of databases in Always On Availability…

Read More
Nabil Saoual

Control M /EM : Job submission aborted due to error in executing ‘/bin/su’

By | Control-M | No Comments

Introduction: When launching jobs you may have this kind of issue job submission aborted due to error in executing ‘/bin/su’ The purpose of this post is to resolve it and to explain why you can get this issue We created a job with user controlm to execute a basic command:     When it was ordered and submitted the issue occurred: As the ouput explains it , there is an issue: Explanation : It is…

Read More