DataGeek.blog

December 21, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL – Day 03!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s posting on December 21.… Read the rest

December 17, 2021 Featured

db2u Without RedHat OpenShift – A Container-Native Database!

Earlier in 2021, I wrote an article on the big mistake I thought IBM was making by only offering their container-native version of Db2 (db2u) on RedHat OpenShift.

Well, that article and tirelessly asking questions of EVERY IBMer I could get to listen to me (seriously, I could hear eyes rolling when I asked for the umpteenth time) has finally worked!… Read the rest

December 3, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 02!

AOC Day 2
My day 2 solutions are available in my GitHub repo.… Read the rest

December 2, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL – Day 01!

AOC Day 1
My day 1 solutions are available in my GitHub repo.… Read the rest

December 2, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL

This year, I’m going to be working through the Advent of Code challenges in SQL and sharing my progress here on the blog. I don’t expect to complete each challenge and the blog entries on them on the same day they are released – I’m not competing on time, I’m just using this to share SQL techniques.… Read the rest

September 7, 2021 Featured

Db2 Basics: Buffer Pools

What is a Buffer Pool?

A buffer pool is one of the most critical memory areas for a Db2 database. Buffer pools are used to cache data in a way that the data can be reused by other connections. They do not store the results of Query A and Query B, but they store the data pages used to produce those results.… Read the rest

August 27, 2021 Featured / IDUG

In Memory of Scott Hayes

I was very sad to learn that Scott Hayes passed away from COVID-19 on August 18.

The comments on his obituary are a list of friends and mentees from the Db2 community. I wanted to pay tribute to him by sharing my good memories of him and sharing the impact he had directly on my career.… Read the rest

July 22, 2021 Uncategorized

How to use Docker on your Local Machine – For DBAs

Recent posts related to using Docker with Db2:
An Overview of Running Db2 in Containers
Where do Db2 Containers Come From and How are they Used

The focus of this article is to go through a few of the basics of using Docker with Db2.… Read the rest

July 15, 2021 Uncategorized

The Basics Of Containers for DBAs

I’ve spent much of the last year or two on a containerization and DevOps crash-course. I’m just recently starting to come up for air and fill in some of the gaps that being neck-deep in the how leave in in the what and why.… Read the rest

June 8, 2021 Uncategorized

Backing up a Db2 Database to AWS S3

AWS S3 is a cloud object storage service that is easy to use. It is highly available and offers ELEVEN nine’s of durability.

A Few Backup and Recovery Best Practices

I have quite a few blog entries over the years on backup and recovery.… Read the rest

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 Uncategorized

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