Technical Content

DSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program.

Solve Sudoku using SQL!!! This festive season, impress your friends and colleague with your quick Sudoku skills and some clever SQL! How? Using...

New, Final and Old tables are features that have been around in Db2 for several versions, at least back to v9.7, but they don’t seem to get a lot...

Several case studies on what to do when indexes are only be effective to a limited extent

One of the oldest problems in Db2 performance was the efficient processing of pagination – when an online application needs to process an...

Many new features of Db2 are being used quite frequently, while others not so much. This article is a reminder, and may not be a complete list....

Indexes perform a critical role in any relational database and Db2 is no exception. Let’s take a look at the way indexes work in a Db2 environment.

From Emil Kotrc and Julia Carter | Package rebinds can sometimes be a real challenge for DBAs when it comes to Db2 upgrades. But when it comes to...

Db2 Version 13 is upon us! After V12, IBM was a bit vague about when a new version number for Db2 would be created. Why? IBM was using Db2...

From George Baklarz and Phil Downey | Many customers are looking at modernizing their databases by moving them into a containerized environment such...

Containerization takes Db2 to the world of Cloud Paks, Red Hat OpenShift, Public Cloud Kubernetes platforms (AWS, Azure, Google Cloud and IBM...

Recently, I have been visiting a technical university with a short speech at a seminar and my topic was IBM mainframes. Fortunately, this was after...