Db2 Experts on a Data Science Quest
 |
 |
 |
 |
 |
 |
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 »
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
Continue reading »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
Continue reading »
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
Continue reading »
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
Continue reading »
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
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.
First a quick overview of the types of monitoring that every DBA should be doing.… Read the rest
Continue reading »
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 »