I’m going to walk through the basic creation of auto-incrementing integer columns in MySQL and Db2 and point out some differences and similarities. Functionality Every relational database I have worked with has had a functionality for generating column values. The…
When I started working as a DBA in 2001, the relational database management system choices were more limited and the choice itself was often left up to a system architect. Rarely did developers have a say, and even DBAs only…
This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2…
Working in technology, I’ve heard a number of things about ChatGPT from various news sources. I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I…
The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for…
As I’ve been learning the details of MySQL, there have been a lot of similarities with Db2, and a number of differences. Some of those differences have been things I was expecting, while others have been a bit more shocking.…
Moving from being a DBA on a proprietary RDBMS for 20 years to working on an open source RDBMS is teaching me a lot of lessons. Many of them are lessons I expected – remembering how and when to ask…
I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a…
This blog entry is designed to serve as a roadmap for current blog entries directed at those newer to Db2. In my mind, this likely includes anyone who has been working with Db2 for less than 2 years. However, often there are areas we spend more time in than others, so I think of these topics also as "spackle" - to fill in gaps for the self-taught. Note that some of the topics below are not links. This is because they're areas I plan to blog about in the future.