IDUG News & Blogs

Check back here frequently for our curated content – technical articles, IDUG news, and thoughts from our leadership, all posted here, and featured monthly in the IDUG eBulletin.

Interested in contributing an article for consideration? Contact our Content Committee! 

IDUG News Technical Content
Db2 catalog tables - Statistics
Posted In: Technical Content,
Date posted May 24

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

Read Post
Exploring the Db2 for z/OS Catalog
Posted In: Technical Content,
Date posted May 16

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

Read Post
Catalog Queries for Db2 for z/OS
Posted In: Technical Content,
Date posted May 5

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

Read Post
Db2 for z/OS Dual Logging: zHyperWrite and zHyperLink—are they related?
Posted In: Technical Content,
Date posted Apr 13

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

Read Post
Back to Basics: Algorithms for Recovery and Isolation Exploiting Semantics
Posted In: Technical Content,
Date posted Apr 5

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

Read Post
Back to Basics: Db2 z/OS Access Paths and Db2 Explain
Posted In: Technical Content,
Date posted Mar 29

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

Read Post
Travel through time with Db2 SQL to investigate complex application data change questions
Posted In: Technical Content,
Date posted Mar 15

Why does policy 123 in the POLICY table have status code X. I could have sworn the status code should be Y. How could this be? Who did it? When? ...

Read Post
Access Paths Db2 for z/OS EXPLAIN: What an Access Path Is, and What it Would Be
Posted In: Technical Content,
Date posted Feb 24

The EXPLAIN functionality of Db2 for z/OS, by which the query optimizer's access path determinations are externalized, has been around as long as I...

Read Post
Access Paths Part 1: The introduction of Db2 optimizer and cost model
Posted In: Technical Content,
Date posted Feb 21

Whether they are beginners or experienced DBA, they have more or less doubts about the behavior of Db2, especially in terms of the execution...

Read Post
Access Paths Part 1: The introduction of Db2 optimizer and cost model
Posted In: Technical Content,
Date posted Feb 21

Whether they are beginners or experienced DBA, they have more or less doubts about the behavior of Db2, especially in terms of the execution...

Read Post
Implicit / Explicit objects – why SET CURRENT RULES makes a difference
Posted In: Technical Content,
Date posted Feb 9

All of us have an opinion about IMPLICITLY created objects in a Db2 subsystem – it’s like a love/hate relationship. The ability for Db2 to...

Read Post