Tag: RUNSTATS

2018-03 RTS RUNSTATS

 „Breaking the rules is often fun, although we cannot condone it. But breaking the rules of Real Time Statistics (RTS) in Db2 12 can really land you in hot water. We provide two queries that may give you a Get

Tagged with: , , , ,

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

Northeast Ohio Database Users Group – December 2017

NEODBUG – Northeast Ohio Database Users Group – December 7th, 2017
SEGUS & SOFTWARE ENGINEERING present
Db2 z/OS Lies, Damn Lies, and Statistics: accurate statistics is more important than ever in the Db2 world of today…

Tagged with: , ,

Michigan Db2 Users Group – December 2017

MDUG – Michigan Db2 Users Group -December 6th, 2017
SEGUS & SOFTWARE ENGINEERING present

1- 25 Years of Missed Opportunities? SQL Tuning Revisited: Find out how a modern DB2 z/OS SQL warehouse can collect and store all executed static and dynamic SQL (plex-wide) with basically no overhead.

2- Db2 z/OS Lies, Damn Lies, and Statistics : accurate statistics is more important than ever in the Db2 world of today.

Tagged with: , ,

Central Ohio Db2 Users Group – December 2017

CODUG – Central Ohio Db2 Users Group – December 5th, 2017.
SEGUS & SOFTWARE ENGINEERING present:

Db2 z/OS Lies, Damn Lies, and Statistics: the need for statistics and, above all else, accurate statistics is more important than ever in the Db2 world of today…

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-01 Db2 12 technical overview: Roy’s first features review

This Db2 12 technical overview presents in an “easy to read” table list a review of new Db2 12 features Have you encountered any other Db2 12 changes you’d like to discuss?   Now that Db2 12 has gone GA

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

Rotten Results from RUNSTATS Require Rescue

Do you know the basic rules to ensure access path stability when using RUNSTATS? Time for another of my “I noticed something strange at a customer site recently” newsletters. Enjoy!   RUNSTATS are good aren’t they? At this particular site, the RUNSTATS

Tagged with: , , , , , , ,