Skip to content

DB2

GoldenGate DB2 z/OS upgrade checklist

Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate upgrade and migrating from Classic to Microservices Architecture is still valid. However, there is an extra layer to deal with. It has to do with… 

DB2 SQL1598N licensing error when upgrading GoldenGate

While upgrading GoldenGate to 26ai for a DB2 z/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (CLI Driver, in short) alongside it. Since I realized that DB2 driver know-how was rare in companies, I figured it would be worth writing a blog about the topic. In this GoldenGate upgrade, the previous driver was… 

Deployment creation INS-85037 error with GoldenGate 26ai for DB2 z/OS

Among all the automation I was doing around a GoldenGate installation for DB2, I recently ended up with an INS-85037 error when running the configuration assistant oggca.sh. And because this error is quite common and has many different possible root causes, I wanted to write about it. Differences in GoldenGate setup between Oracle and DB2 If you’re wondering how to… 

Patching an IBM Db2 instance

The next task in my journey with DB2 is to apply a patch. In the world of DB2 there are Modification Packs and Fix packs. As far as I understand it, Modifications Packs come with new features, while Fix Packs come with bug fixes only. Keeping your database installations up to date is important, that applies to all products. As… 

Setting up IBM Db2 on Linux – root installation

In the first post about Db2 I went for the non-root installation method. While this is great if you want to get started fast and to do some tests this also comes with limitations. Most installations, I guess, are root installations, especially if you want to run more than one instance on a host, and you want to have them… 

Getting explain plans out of Db2

The last post about Db2 was about getting it up and running. As the issue we had to solve was about performance, getting an explain plan for the problematic statement(s) was the obvious step to do. In PostgreSQL you can just use EXPLAIN for that, and you’re done. In Db2 the procedure is a bit different, but once you know… 

Setting up IBM Db2 on Linux

My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with. And now we have a request… 

IBM Bluemix Database Cloud Service – My first trial

By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest…