Part 3 in this series is a bit overdue. Parts 1 and 2 were back in April. This is a complicated topic. Please use any procedures here with extreme care, and keep in mind that if you have anything other…
Managing DB2 licenses isn’t exactly the glory work of DB2. It’s not fun, and the only scenario you might come out of messing with them with Kudos is if you’re dealing with an expired Try&Buy license – and then only…
This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this: >…
Some friends on Twitter were commenting that db2_install is not just deprecated in DB2 10, but is fully discontinued and not available. Melanie Stopfer mentioned this on her webcast on June 22. I do dozens of installs a year, and…
I’m constantly discovering new features. You’d think at this point that I’d know the contents of the directory by heart. Especially since I intentionally went through everything in there when deciding on one of the topics for the db2Night Show’s…
This post is specific to WebSphere Commerce. We spent a fair amount of time on this, both on a SUSE server and a Red Hat Server. The problem manifested in different ways. The main thing that became obvious to me…
Edited 2018-02-01. This post is obsolete. For the best way to use FTPS to get fix packs direct to a server, see: Using FTPS to get a Fix Pack Directly to a Db2 Server Just a simple post here, but…
So there are a few topics I wanted to cover relating to DB2 clients and how Commerce uses them. Type 2 vs. Type 4 drivers So strictly speaking, this is referring to the JDBC driver being used. Type 2 JDBC…
This was a new one to me, and it took some time of some top level experts to find the tech note on it, so I thought I’d post it here so others can hopefully find it more easily. The…
So I’m doing a lot of posts in the DB2 Basics area this week. That’s because they are quick for me to write, and they’re questions I get all the time. So bear with me if you read for the…
On Linux and Unix anyway. This is actually a common request during build when OS-level patches are applied or other OS-level work needs to be done, especially any related to disks. Stop Commerce (and/or any other applications) I’m not going…
What is HADR? HADR is DB2’s implementation of log shipping. Which means it’s a shared-nothing kind of product. But it is log shipping at the Log Buffer level instead of the Log File level, so it can be extremely up…