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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…