The next Central Ohio Db2 User Group meeting will be December 5, 2017 at the IBM Sterling campus in Dublin, OH (Tuttle Crossing).
Registration is now open => REGISTER http://codug.org/node/99/register
We are pleased to welcome Craig Mullins of Mullins Consulting, Frank Fillmore of the Fillmore Group and Ulf Heinrich of SEGUS as our speakers.
This will be a full day meeting with a nominal $10 fee to help defray the cost of hosting these great speakers. Payment can be made on day of event.
8:30 - 9:00 Registration
9:00 - 9:15 Welcome and Opening Remarks
9:15 - 10:30 Frank Fillmore - “QMF Analytics v11: Not Your ‘Green Screen’ QMF”
10:30 - 10:45 Break
10:45 - 12:00 Craig Mullins - It's not your Daddy's Db2
12:00 - 1:00 Lunch and networking
1:00 - 2:15 Craig Mullins - The Top Ten Db2 Things You Need to Know: For DBAs and Developers
2:15 - 2:30 Break
2:30 - 3:45 Ulf Heinrich - Db2 z/OS Lies, Damn Lies, and Statistics
3:45 - 4:00 Closing Remarks
Craig Mullins (Mullins Consulting)
* It's Not your Daddy's Db2
* The Top Ten Db2 Things You Need to Know: For DBAs and Developers
Ulf Heinrich (SEGUS)
Title: Db2 z/OS Lies, Damn Lies, and Statistics
..Lies, damn lies, and statistics… ‐ Benjamin Disraeli, Prime Minister of England (1868, 1874-1880)
The above line may, or may not, have been spoken well over 100 years ago, but the need for statistics and, above all else, accurate statistics is more important than ever in the Db2 world of today. Bad statistics is the number one reason for bad access paths! How could that happen; well usually bad timing is the number one reason, followed by manually updated stats and then forgotten about. There are various features and enhancements for both static and dynamic SQL delivered with Db2, but unfortunately still no common way to fallback.
This presentation explains Db2s Optimizers behavior and discusses the pros and cons of Plan Stability and Stabilized Dynamic Queries. It additionally introduces your lifesaver when your critical access path goes ballistic, a simple and solid “RUNSTATS recovery”. The basis is a complete copy of all productive required statistical data in the Db2 catalog. This should be regularly executed and the data saved away. The best way to do this is to use a Generation Gengroup which automatically stores multiple “copies” of the data.
* Db2 RUNSTATS basics
* Catalog tables and Columns used for access paths
* IBM recommendations through the ages : from Db2 V3 to Db2 12
* Db2 RUNSTATS advanced
* SYSCOLDIST explained
* RUNSTATS real world Q&A: use of SAMPLE, COLGROUP, PROFILE, REOPT (ONCE), TABLESAMPLE SYSTEM, HISTOGRAM, …
* RUNSTATS reversal
Audience experience Level: Beginner, Intermediate, Advanced
Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc & SOFTWARE ENGINEERING GmbH. He specializes in Db2 recovery issues and database maintenance, focusing on the growing requirement for cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real‐world recovery pressure. His activities cover EMEA, as well as North America through SE’ U.S. subsidiary, SEGUS Inc.
Frank Fillmore (The Fillmore Group)
“QMF Analytics v11: Not Your ‘Green Screen’ QMF”
Your users have developed lots of QMF queries, forms, and procs over the past three decades. But they think that 3270 terminal emulation screens went out with big hair and leg warmers. In July, QMF Analytics v11 became generally available. This solution delivers QMF:
* Data virtualization (federation to non-Db2 data sources including IMS and VSAM)
* Dash boarding
* Graphical ad-hoc query capabilities
* All the while enabling users to leverage their existing legacy QMF assets
In this session Frank Fillmore will provide 1. a case study on migrating twenty-year-old QMF assets to QMF Analytics v11 2. an overview of the features of QMF Analytics v11 3. a live demonstration that includes new updates to QMF's data visualization interface
Frank is an IBM Gold Consultant and IBM Champion for Analytics with over thirty years experience working with data repositories on all platforms and a track record of successful consulting and training engagements with clients located around the world.
An award-winning teacher and presenter, Frank developed the IBM Top Gun Information Management sales program for IBM employees and Business Partners, has delivered over one hundred IBM Analytics courses, appeared on the Experts Panel at the International Db2 Users Group (IDUG) and presents frequently to customers and international and regional technical users groups.
Frank leads a team of two dozen Analytics consultants who deliver a diverse set of implementation, tuning and mentoring services to IBM Data Servers, Optim and InfoSphere customers.