Db2 Basics: Getting Data Out of Db2
One of the things that learning a new platform (MySQL) has taught me is just how critical the most basic topics are, so I thought I’d do an overview of how to get data out of a Db2 (on Linux,…
Tag DB2 Basics
Basic but comprehensive introductory coverage on core DB2 topics
Db2 Basics: IBM IDs – How to Sign Up for One
IBM IDs are completely, 100% free. You pay with a bit of your personal information. You have to provide an email address and a first and last name. Purpose Those of us who have been working with (or for) IBM…
Announcing DISCOVER.DB2
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…
DB2 Basics: What Port Number is Db2 Listening for Connections on?
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…
Index of Introductory Db2 Topics
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.
Db2 Basics: Error Messages
When I do work in other domains – even something as connected as scripting – I find the error messages confusing and unhelpful. Most of the time, this is mostly because I don’t know much about the language or the…
Db2 Basics: Introduction to IBM Db2
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,…
Db2 Basics: Using FTPS to get a Fixpack Directly to a Db2 Server
This is the third time I have written this post. It keeps changing, so I keep sharing. I work from home, so downloading software to my laptop and then uploading it to a server is not very efficient. Download speeds…
Db2 Basics: Investigating Permissions in an Existing Database
Edit: 01/23/2018 – corrected one word not in an SQL statement. I have written several other articles on security and permissions, but I thought I would write one from a purely practical perspective. If you don’t understand the basics of…
Db2 Basics: Levels of Configuration
Updated 11/22/2017: instructions on how to run the SQL statement There are a number of places where we can store and change configuration for a Db2 server. I wanted to walk through the main areas and a few details about…
DB2 Basics: Statement Terminators
The default statement terminator for DB2 on Linux, UNIX, and Windows platforms is the semi-colon (;). If you are executing a script of SQL using the -tf options, and do not specify an alternate terminator, DB2 will assume you are…
Troubleshooting with Mickey Mouse, Snow White, and Cinderella
It’s that magical time of year again. DBAs excitedly pack their bags for a week-long trip. On-call rotation is hurriedly passed to the next poor soul on the rotation list. Ember dons her trademark pigtails. Melanie Stopfer crams another 20…