Featured – DataGeek.blog

May 13, 2021 Featured

The Big Mistake IBM is Making with Db2 in Containers

Note: the statements in this entry are my opinions. I quote IBM once in this article, and that statement should be seen as the only pure fact here. I invite IBM and others to add their perspective in the comments below.… Read the rest

May 11, 2021 Featured

Where do Db2 Containers Come From and How are they Used

In my last post, I wrote an overview of running Db2 in containers. Today, I’d like to talk a bit about where we get Db2 containers and several common ways they are used. Catch my next post about a critical mistake I think IBM is making with containerization.… Read the rest

April 20, 2021 Featured

An Overview of Running Db2 in Containers

One of my steepest learning curves in the last year and a half has been really getting into containers on K8’s and Docker and what running databases within them means. I thought I’d share a general overview, and plan to follow this post with more specific and more technical posts.… Read the rest

March 11, 2021 Featured

The Developer-DB Love-Hate Relationship

There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes you can go down. I’m well aware that there’s probably 40% of Db2 LUW alone that I don’t know, even though I’ve spent 20 years working with it, and am an internationally recognized expert.… Read the rest

February 9, 2021 Featured

It Matters Where Your Join Clauses Go

Explicit Join vs. Implicit Join

When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this:


SELECT * 
FROM table_a as a
    JOIN table_b as b ON a.id=b.id

… Read the rest Continue reading »

November 19, 2020 Featured

Overview of Real-Time Monitoring Options For Db2

I thought I’d share an overview of the real-time monitoring options for Db2 (LUW). This article focuses on comparing the options, with links to deeper information on each tool.

Types of Monitoring

First a quick overview of the types of monitoring that every DBA should be doing.… Read the rest

November 10, 2020 Featured

My Journey through Beginner Data Science Content

When I first started learning about data science, the amount of material out there was daunting. It is hard to find your way in what you should learn and how you should learn. I thought I’d share what has been working for me and what didn’t.… Read the rest

July 22, 2020 Featured

First Look – The New Replacement for db2top and dsmtop – dmctop!

One topic that comes up at most panels, Technical Advisory Board meetings and other longer interactions I participate with for IBM is DBA’s love of db2top. It is such an easy tool, and one that most DBAs I know choose over all others for real-time monitoring and basic investigation of a database.… Read the rest

June 17, 2020 Featured

Disappearing Data in PostgreSQL

I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes. While the issue technically isn’t specific to Kubernetes, per se, it is certainly easy to encounter in Kubernetes for users of the official PostgreSQL Docker image (and many other images) mounting volumes somewhere other than the default location.… Read the rest

February 26, 2020 Featured / MDM

A Single Source of Truth – Even More Elusive in the Cloud Era?

Introduction

I would like to begin by thanking Ember for allowing me to be a guest blogger and explaining the motivation behind writing this blog.

The “need for speed” in today’s world has led to a sweeping reform where old ideas are discarded too rapidly.… Read the rest

January 2, 2020 Featured

Packaging and Licensing of Db2 for LUW – Version 11.5

Edit 2020-01-02: corrected limit for free Db2 on Cloud to the correct 200 MB. Original text is still in the document, in strikeout.

This is one of the few blog entries where I include the Db2 version number right in the title.… Read the rest