Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
September 2022 has a content committee primary focus on indexes . Indexes are those critical Db2 objects that define uniqueness and/or importantly help us quickly find our data. There have read more...
Indexes perform a critical role in any relational database and Db2 is no exception. Applications expect to receive near instant response when querying multi-billion row tables Indexing tables in a manner read more...
Are you Packaged and Bound for Db2 13? Written by: Julia Carter and Emil Kotrc, Broadcom Package rebinds can sometimes be a real challenge for DBAs when it comes to Db2 upgrades. There are read more...
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 “ continuous delivery ” and function levels to introduce new read more...
Introducing Db2 Click to Containerize Written by George Baklarz and Phil Downey Many customers are looking at modernizing their databases by moving them into a containerized environment such as OpenShift, read more...
Modernizing Db2 Containerization Footprint with Db2U Written by Aruna De Silva Containerization takes Db2 to the world of Cloud Paks, Red Hat OpenShift, Public Cloud Kubernetes platforms (AWS, Azure, read more...
Cool Factor of IBM z16 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 IBM's announcement of the new read more...
Db2 catalog tables – Statistics Written By: IBM Data Management Console Development Group Jun Liu , Guo Bin Zhao, Yinmei Chen Db2 maintains a set of catalog tables that describes the metadata of read more...
Exploring the Db2 for z/OS Catalog Written by Sowmya Kameswaran Navigating and exploring the Db2 catalog is a very common activity for anyone who interacts with the database engine. Database read more...
Catalog Queries for Db2 for z/OS Introduction If you are experienced with database management systems outside of mainframe, you've probably heard about an information schema . This is read more...
Db2 for z/OS Dual Logging: zHyperWrite and zHyperLink—are they related? Sharon Roeder, IBM zHyperWrite and zHyperLink certainly sound very similar. Both have definite performance benefits for read more...
Back to Basics: Algorithms for Recovery and Isolation Exploiting Semantics Most likely, you understand how logging in Db2 for z/OS works in general. There are log buffers, active logs, which get offloaded read more...