Tag: SQL access path

2018-02 Db2 Catalog Statistics revisited

Db2 Optimizer & access path selection for Db2 11 & Db2 12 : Db2 Catalog data | Problematic default values | Correlations in the Db2 Catalog  It has been six years since the last update so I thought, after Terry Purcell’s excellent

Tagged with: , , ,

Southwest Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , , , ,

Heart of Texas Db2 Users Group – February 2018

SEGUS & SOFTWARE ENGINEERING proudly sponsor this event and present:
1 Compliance with compliments! Viable Db2 z/OS workload tracking: A presentation about capturing DDL, DML, DCL and more of the entire workload, by exploiting resource friendly IFCID technology.
2 Db2 12 Continuous Delivery – New challenges for deployment: A presentation about Db2 12 Continuous Delivery and how it affects Db2 migration/maintenance strategies.
3 Db2 z/OS Lies, Damn Lies, and Statistics: A presentation about Db2 RUNSTATS, BIND/REBIND enhancements and how to protect/recover access paths.

Tagged with: , , , , , , , , ,

2017-11 Db2 APAR list: An APAR a day keeps the bugs at bay

Db2 12 APAR – time saving list With all the talk about “agile” going on, and referring to one of my older 2017-09 newsletters* on APARS, I think it is time to tell you all about another little service that

Tagged with: , , , , , , ,

2017-09 Db2 12 SQL Access path: Death by APAR

We recently held one of our Design Councils, this one was all about Db2 12 and going Agile. I was asked the following question after one of my presentations about verifying Db2 Code/Catalog/Function Levels: “How many APARs really can affect

Tagged with: , , , , , ,