Technical Content

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...

From the IBM Data Management Console Development Group Jun Liu , Guo Bin Zhao, Yinmei Chen | Db2 maintains a set of catalog tables that describes...

Whether they want to view all objects, check the status of an object, locate statistics, browse the data, generate DDL, or any other action that...

If you are experienced with database management systems outside of mainframe, you've probably heard about an information schema. This is a set of...

zHyperWrite and zHyperLink certainly sound very similar. However, when it comes to Db2 Log Manager, they are really two different sets of...

Most likely, you understand how logging in Db2 for z/OS works in general. There are log buffers, active logs, which get offloaded to archive logs,...

The access paths formulated by the Db2 optimizer during the BIND process or access paths formulated at runtime for dynamic queries are critical to...