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 »Category: Uncategorized
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
Continue reading »
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
Continue reading »
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
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »