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

Getagged mit: , , ,

Southwest Db2 Users Group – Februar 2018

SEGUS and SOFTWARE ENGINEERING sponsern diese Veranstaltung und präsentieren:
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.

Getagged mit: , , , , , , , , , , ,

Heart of Texas Db2 Users Group – Februar 2018

SEGUS and SOFTWARE ENGINEERING sponsern diese Veranstaltung und präsentieren:
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.

Getagged mit: , , , , , , , , , , ,

Northeast Ohio Database Users Group – Dezember 2017

Treffen sie uns auf dem NEODBUG am 7. Dezember 2017 – SEGUs & SOFTWARE ENGINEERING präsentieren:
Db2 z/OS Lies, Damn Lies, and Statistics : accurate statistics is more important than ever in the Db2 world of today…

Getagged mit: , ,

Michigan Db2 Users Group – Dezember 2017

MDUG – Michigan Db2 Users Group – 06. Dezember 2017
SEGUS & SOFTWARE ENGINEERING präsentieren

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…

Getagged mit: , ,

Central Ohio Db2 Users Group – Dezember 2017

CODUG – Central Ohio Db2 Users Group – 5. Dezember 2017. SEGUS & SOFTWARE ENGINEERING Präsentieren:
Db2 z/OS Lies, Damn Lies, and Statistics: accurate statistics is more important than ever in the Db2 world of today…

Getagged mit: , ,

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

Getagged mit: , , , , , ,