Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
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...
Travel through time with Db2 SQL to investigate complex application data change questions The poor beleaguered support staff sometimes come up with the strangest questions. Why does read more...
Access Paths Part 1: The introduction of Db2 optimizer and cost model: Posted By: Tony Andrews Written By: IBM Data Management Console Development Group Jun Liu, Yan Zeng, Jun Qing Huang, Bian Li read more...
Written by Steen Rasmussen Client Services Consultant Broadcom Inc Implicit / Explicit objects – why SET CURRENT RULES makes a difference All of us have an opinion about IMPLICITLY read more...
This is not a pipe, it’s a pipeline: becoming a DevOps DBA – part 2 Written by: Marcus Davage CEng CITP MBCS Lead Product Developer Intelligent Z Optimization and Transformation read more...
This is not a pipe, it’s a pipeline: becoming a DevOps DBA – part 1 Written by: Marcus Davage CEng CITP MBCS Lead Product Developer Intelligent Z Optimization and Transformation read more...
Javier Estrada Benavides javier.strad@gmail.com Setting your Db2 zParms to the right values can be a never ending task, but luckily the previous article from Emil Kotrc ( found in here ), gave read more...