IBM: I've been moved

I migrated my blog over to https://data-henrik.de

Some big news: I migrated my blog over to https://data-henrik.de. Read the details in my first new article on the new site. You can subscribe to the blog feed using https://data-henrik.de/index.xml. See you soon...

Have issues? Communicate! A brief look at Db2 SQLCA

Db2 command line output with printed SQLCA

With many conflicts and problems, big and small, going on, communication is important. So, why not take a brief look at the Db2 SQL Communications Area (SQLCA)? According to the Db2 documentation, an SQLCA is a collection of variables that is updated at the end of the execution of every SQL statement. It provides the structure to pass important information from the database product to the user or application.

Db2 for your data lakehouse

Db2 as engine and data source
for the data lakehouse

A while ago, I was working with IBM watsonx.data to prepare a presentation on data lakehouse solutions. When talking about the (query) engines for a data lakehouse, typically, it is mostly about Presto and Spark. Did you know that Db2 can be used both as data source AND as query engine in watsonx.data (see screenshot)? Let's take a look...

Db2 catalog: Updated documentation links to database metadata

New Db2 metadata created

In 2017 I wrote the post "Db2 Catalog - A guided tour", a title which I also use for some of my talks at user group meetings and conferences. It contains some now outdated links to the Db2 documentation. Time for an update, so that I can find that important information quicker again. And maybe you too...