Tag: RUNSTATS

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

2017-01 Db2 12 technical overview: Roy’s first features review

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

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

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

2015-05 Top 10 Things to Ignore for DB2 z/OS

  This newsletter was inspired by a recent article I read in the “Enterprise Systems Magazine” called “Top 10 Ways to Waste Money on CPU”. Why not the Top 10 things to ignore?   DB2 z/OS things you could ignore

Tagged with: , , , , , , , , ,