Technical Content

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