How can a RUNSTATS *cause* an SQL error code? Well, my gentle readers read the explanation illustrated with two examples in SPUFI
„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…
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…
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:
Agile,
CD,
Continuous Delivery,
Database activity monitoring,
Db2 11,
Db2 12,
Db2 audit,
Db2 catalog statistics,
Db2 migration,
RUNSTATS,
SQL access path,
SQL workload
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:
Agile,
CD,
Continuous Delivery,
Database activity monitoring,
Db2 11,
Db2 12,
Db2 audit,
Db2 catalog statistics,
Db2 migration,
RUNSTATS,
SQL access path,
SQL workload
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…
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…
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…
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…
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…