A hub for sharing relational database knowledge and experimentation
Db2u is here as a technical preview! I’ll cover the basics of how to set it up for a local sandbox, and leave the details and whys to future articles. IBM has stated that db2u will be available in GA later this year on Amazon EKS and Azure EKS, but meanwhile, I’ve got the technical preview up and running on my MacBook Pro!… Read the rest
Continue reading »
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 4. It’s posting on February 1.… Read the rest
Continue reading »
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
Continue reading »
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
Continue reading »
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 2.
AOC Day 2
My day 2 solutions are available in my GitHub repo.… Read the rest
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 1.
AOC Day 1
My day 1 solutions are available in my GitHub repo.… Read the rest
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
Continue reading »
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
Continue reading »
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
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
Continue reading »
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
Continue reading »
AWS S3 is a cloud object storage service that is easy to use. It is highly available and offers ELEVEN nine’s of durability.
I have quite a few blog entries over the years on backup and recovery.… Read the rest
Continue reading »