Schlagwort: Access path

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

Rotten Results from RUNSTATS Require Rescue

Do you know the basic rules to ensure access path stability when using RUNSTATS? DB2 z/OS Access path stability: Time for another of my “I noticed something strange at a customer site recently” Newsletters. Enjoy!   RUNSTATS are good aren’t they? At

Getagged mit: , , , , , , ,

Can you guess how interesting the DSN_PREDICAT_TABLE really is?

DB2 z/OS literal replacement: Do you know the queries to list the Dynamic SQL which have literals or Parameter markers? Here is a very handy method to (fairly) quickly see if you have a literal problem that is killing the DSC

Getagged mit: , , , , , , ,