A hub for sharing relational database knowledge and experimentation
IBM released fix pack 3, mod pack 3 for Db2 11.1 earlier this year, and there was a high-severity problem in the initial version of that fix pack. IBM fixed the problem and re-released the fix pack within about a day, but the bug was reported far and wide, while I’m not sure the resolution of the bug was, so I thought I’d cover it quickly.… Read the rest
Continue reading »
Once IBM made the Request For Enhancement (RFE) program workable last year, I blogged about it and tweeted about it, but now that we’ve seen more action on it, I thought I’d share some additional details.
First off, an RFE is a request for some feature or functionality in Db2 that does not exist today.… Read the rest
Continue reading »
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 aren’t bad, but uploading can take 8 hours or more, depending on the client.… Read the rest
Continue reading »
Updated 6/26/2017 to include links on details for DSM 2.1.4 and a link to the DB2Night Show replay.
June 22 and the week surrounding it brought a number of announcements from IBM about DB2.
IBM has recognized that they need to invest more in marketing DB2.… Read the rest
Continue reading »
Edited 2018-02-01. This page is now obsolete. The newest version of this is: Using FTPS to get a Fix Pack Directly to a Db2 Server
This seems to change every few years, so I thought I’d document what’s working for me today.… Read the rest
Continue reading »I have recently had the chance to do several installs on DB2 10.1 and migrate a couple of 9.7 environments to 10.1. I may be late to the party – oddly, IBM takes longer to certify WebSphere Commerce on new versions of DB2 than many external vendors do with other products.… Read the rest
Continue reading »I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer topics included here.… Read the rest
Continue reading »Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes.… Read the rest
Continue reading »I haven’t actually personally installed DB2 in about a year. We scripted it out, and I’ve been spoiled to just use the script. But now we have a custom server that varies enough from our standards that I’m installing it manually.… Read the rest
Continue reading »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 than the standard two-server HADR-only TSA implementation, these procedures probably aren’t the best idea, as they could break other things.… Read the rest
Continue reading »So there are a few topics I wanted to cover relating to DB2 clients and how Commerce uses them.
So strictly speaking, this is referring to the JDBC driver being used. Type 2 JDBC drivers are the traditional kind that require having a DB2 client installed, and the databases properly cataloged within that DB2 client.… Read the rest
Continue reading »Ok, so this is an issue I ran into recently. The Commerce guys were trying to install a Feature Pack, and got this:
SQL0569N Authorization ID "<authorization-name>" does not uniquely identify a user, a group or a role in the system.… Read the rest Continue reading »