Welcome to the Planet DB2 Blog

Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.

Rate-limit Kafka event generation with kcat and bash

by Henrik Loeser (data_henrik) | Nov 24, 2021

Traffic for event streamsRecently, I worked with IBM Cloud Event Streams which is a message bus built with Apache Kafka. I was looking for a simple command-line tool to test my Event Streams instance and to stream access logs into it. That’s when I ran…

Get educated: The IDUG Virtual 2021 EMEA Db2 Tech Conference is coming up

by Henrik Loeser (data_henrik) | Nov 23, 2021

The virtual Db2 conference is coming upDo you remember meeting in person, at a conference? Well, hang on to that memory because the International Db2 User Group (IDUG) conference for EMEA is going to be virtual again this year. The “IDUG Virtual 2021 E…

“Unstructured ” Data and LOBs

by Craig S. Mullins | Nov 22, 2021

Let’s take a look at the burgeoning role of “unstructured” data and the impact of using LOBs to store that data in our Db2 databases. The Growth of “Unstructured” Data Although structured data remains the bedrock of the information infrastructure in mo…

DB2Night Show #Z121: Esoteric Functions in Db2

by The DB2Night Show | Nov 21, 2021

Presented by: Roy BoxwellSr. DB2 Product Specialist
Segus / Software Engineering

Esoteric Functions in Db2 for z/OS
100% in our audience learned something! Roy described some of the newer functions in Db2 and how they impact customers’ u…

On serverless data scraping, cloud object storage, MinIO and rclone

by Henrik Loeser (data_henrik) | Nov 18, 2021

Building a data lake the serverless wayThis fall, I started another side project. It involves mobility data and its analysis and visualization. As first step and still ongoing, I am building up a data lake (and maybe integrating it into a data fabric)….

Db2, SQL, and Modern Coding Techniques

by Craig S. Mullins | Nov 15, 2021

Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time thereafter, most Db2 programs were written in COBOL and coded to use static SQL. This meant that the SQL wa…

The DB2Night Show #239: Db2 Blu Improvements

by The DB2Night Show | Nov 14, 2021

Presented by Satya Krishnaswamy, Program Director, IBM

“The DB2Night Show #239: Satya Krishnaswamy” Replays available in WMV and MP4 formats!

100% of our studio audience learned something!Satya gave a detailed overview of upcoming Db…

Db2 SQL PL book as PDF and many useful doc links

by Henrik Loeser (data_henrik) | Nov 3, 2021

Tell the world about Db2 documentationYesterday was one of those days when I, again, worked as information broker. I received a question, asked around myself, passed on information that I learned, and finally handed back an answer to the originator. Wi…

Update on No-Charge IBM Tools for Db2 for z/OS

by Robert | Oct 29, 2021

Recently there has been important news regarding no-charge IBM tools for application developers and for database administrators who work with Db2 for z/OS. This news has to do with strategic replacements for the development and administration features …