International Db2 Users Group Logo

Technical Content

IDUG News Technical Content
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