When I was in my early thirties, I was diagnosed with a learning disability. This really put my learning style into perspective. Teaching myself via a book was incredibly hard, and still is in some ways. Where I thrived was with hands on labs and engaging speakers.
DB2 has one or two ports that it is listening on for each and every Db2 instance. Two Db2 instances cannot share a port to listen on. Remember that Db2 allows multiple instances per server and also multiple databases per instance, and has for years.
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.
What is Db2? This article is one of my few that is not directed at a Db2 DBA or someone trying to fill some of the roles of a Db2 DBA. This is directed, as much as I can manage, at any technologist trying to understand what Db2 is and the role it plays in an IT organization.
This is the third time I have written this post. It keeps changing, so I keep sharing.
Edit: 01/23/2018 – corrected one word not in an SQL statement.
Updated 11/22/2017: instructions on how to run the SQL statement
It’s that magical time of year again.
This blog post was inspired by a DM on Twitter. A follower asked me for ideas on how to best interact with developers and how much expertise to give away. This is a big question with a vast array of correct answers. It is also a subject on which I have a lot of opinions that are wholly mine and do not belong to any employer, past or present.
This blog article should appeal to a wide audience. This article is not specific to DB2, but speaks to the larger role of the database in the IT organization.