Tag: Access path

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

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

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

Tagged with: , , , , , , ,