Tag: Db2 catalog statistics

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

2015-07 Bad Data Day

A Good time to check your DB2 Catalog Statistics ! One of my favorite topics is STATISTICS and RUNSTATS. This month I have a short newsletter involving both of them!   Something jumped right out… Some time ago we were helping

Tagged with: , , , , , ,