Skip to content

DataGeek.blog

Db2 Experts on a Data Science Quest

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • Español
  • February 9, 2021 Ember Crooks

    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 Ember Crooks

    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

    Continue reading »
  • November 10, 2020 Ember Crooks

    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

    Continue reading »
  • July 22, 2020 Ember Crooks

    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

    Continue reading »
  • June 17, 2020 Jonathan Gnagy

    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

    Continue reading »
  • February 26, 2020 Suresh Sane

    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

    Continue reading »
  • January 2, 2020 Ember Crooks

    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

    Continue reading »
  • June 20, 2019 Ember Crooks

    The DBA is Dead? No, the DBA as Gatekeeper is Dead!

    I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest

    Continue reading »
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

Continue reading »
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

Continue reading »
November 5, 2020 Uncategorized

The DevOps DBA – an Overview

The IT industry is a change machine. It is full of change. It always has been. As I get older, I wonder if it really is changing more, or if I’m just becoming set in my ways.

DevOps

The first time I heard the term “DevOps” many years ago, I thought of it as a ploy for developers to get access directly to production.… Read the rest

Continue reading »
October 27, 2020 Uncategorized

The DB2 IPS blues.

I have recently encountered an interesting issue – after an IPS (Intrusion Prevention System) upgrade, client applications suddenly stopped being able to connect to some database instances – not all of them, but just a to a subset.… Read the rest

Continue reading »
September 3, 2020 Uncategorized

What does SNAP_GET_DBM return in the COMM_PRIVATE_MEM element

I have been recently tasked with creation of an early warning solution for a memory condition from which some of our DB2 databases have been occasionally suffering. Once the condition is encountered, the only resolution is to restart the instance which can cause an impact.… Read the rest

Continue reading »
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

Continue reading »
July 20, 2020 Uncategorized

IDUG NA Virtual Conference: Day One Complete!

The IDUG Virtual conference kicked off today, and I thought I’d share my excitement and a few observations.

Content

Today

Today was mostly the opening keynote and the spotlight sessions. Recordings of Monday’s sessions will be available on-demand for conference attendees later in the week, so if you haven’t even registered yet, do so and replay them.… Read the rest

Continue reading »
July 16, 2020 Uncategorized

IDUG NA Tech Conference is 1/10th of Normal Cost, and Online!

If you’ve read the blog for a while, you realize I’m a big fan of the IDUG conferences. I’ve gone to the North American one every year for the better part of a decade now, and the European one for several years.… Read the rest

Continue reading »
July 14, 2020 Uncategorized

Using LDAP for Db2 Authentication in a Docker Container

Db2 is a bit unusual among RDBMSes in that it does not perform authentication. No matter what, you need some external authority to perform authentication. Usually that is either the OS or LDAP, though there are other options. If using LDAP, either transparent LDAP or security plugins can be used.… Read the rest

Continue reading »
Photo by Justin Luebke on Unsplash
June 24, 2020 Uncategorized

Update on Ember’s Data Science Journey – June 2020

It has been a while since I wrote one of these, and it’s about time!

Recap

In June of 2018, I set a new goal for myself.

Long-term goal (by 2035): Work on data science in a way that makes the world a better place.

… Read the rest Continue reading »
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

Continue reading »

Posts navigation

1 2 3 … 46 Next Posts»

Search

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy