September 11th, 2017 Meeting

September 11th, 2017 Meeting
Our guest speakers this September are Suresh Sane (Southwestern Grocers), Ulf Heinrich (SEGUS), and  John Iczkovits (IBM).
Here is our agenda for our September 11th meeting:
8:00 to 8:30 am Check in and continental breakfast
8:30 to 8:45 am IBM
IBM Announcements – Manas Dasgupta, IBM
8:45 to 10:00 am – Suresh Sane
SQL Programming: 30 Tips in 60 Minutes!
10:00 to 10:15 am Break
10:15 to 11:30 am – Suresh Sane
Query Optimization in Relational Databases – Why it Matters!
11:30 to 12:30 pm Lunch sponsored by SEGUS
Product Demo (optional)
12:30 to 2:00 pm –  Ulf Heinrich
DB2 12 Continuous Delivery – New challenges for deployment
2:00 to 2:15 pm Break
2:15 to 3:30 pm – John Iczkovits
Connecting Applications Including Mobile and Cloud with DB2 for z/OS using REST
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

More Information:
Speaker Bios:
Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24x7 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’s U.S. subsidiary, SEGUS Inc. As a member of SE’s Request Board he’s working closely with customers and the development labs.
Suresh Sane is an IDUG Hall of Fame speaker with four Best User Speaker awards. He has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and DB2 Packages). 
He was recognized as an IBM Information Champion in 2009-2017. 
He was the Conference Chair for IDUG NA 2008 and also served on the IDUG Board of Directors.
John Iczkovits is a Senior IT Specialist with IBM Advanced Technical Support. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has 34 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, trade magazine articles, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, Insight Conference, zEXPO Conference, IBM System z Technical Symposium, Edge, CMG, IDUG, InterConnect, and at local DB2 users groups.
SQL Programming: 30 Tips in 60 Minutes!
This session will cover in rapid fire succession a large number of pitfalls I have seen in code reviews over the last 2 decades. Numerous topics will be covered including Identity columns/Sequence objects, case statements, outer joins, subselects, use of Distinct, trouble with nulls, outer joins, indexing, programming logic to name just a few. We will also cover why it is important to ask the right question in SQL.
The session will provide food for thought and serve as a template for your own code reviews.
Objective 1: Understand the appropriate use of various features
Objective 2: Understand basics of query optimization
Objective 3: Understand the choices and tradeoffs when coding SQL
Objective 4: Strike a balance between ease, efficiency and elegance
Objective 5: Understand that not all SQL tuning is about SQL!
Query Optimization in Relational Databases – Why it Matters!
From the early days of SQL, we have advertised that the user specifies the “what” without worrying about the “how” - query optimization takes care of that.
A lot has changed since the early days of RDBMS. SQL queries are more complex. The amount of data has grown exponentially and the service level expectations have become tighter. What was good then is simply not acceptable today.
In this session, we will provide a glimpse into some of the challenges and how some of the leading RDBMS (DB2, Oracle) are addressing them. We will discuss what the future of query optimization may look like and why “perfect” may not be attainable.
Objective 1: Fundamentals of query optimization 
Objective 2: Major challenges 
Objective 3: Recent improvements – DB2, Oracle 
Objective 4: What might the future hold?
Objective 5: Is a perfect access path even possible?
DB2 12 Continuous Delivery – New challenges for deployment
Short Presentation Abstract:
Starting with version 12, DB2 goes agile and code fixes, as well as new features and functions will be delivered in a continuous stream, so called Continuous Delivery. While this change intends to make new technology available faster than in a three-year cycle it’ll also affects the way we did DB2 migration and testing before. This presentation provides an overview about DB2 Levels and how they affect the DB2 subsystem, the Catalog/Directory, SQL and DDL. More importantly, I’ll show how changes can be applied safely and what levels of quality assurance and testing can be passed to assure Continuous Delivery goes well with Continuous Availability.
Full Presentation Abstract:
Fundamental changes in the DB2 z world often lead to concerns. Let’s face it – some changes force us to change! While a DB2 version migration usually took months, or even years, there will be no new DB2 version after 12, but continuous code drops. This will have a tremendous impact on migration strategies, because we have to find a reliable way to test these code deliveries in a fraction of time. If we make it, Business Divisions will become enthused at how quickly new technology becomes available for new applications. This presentation will describe the difference between Code, Catalog, Function and Application Levels, how you can control them and how you can fallback in case of anomalies. It also illustrates how we still can be pro-active in testing without burning weeks and months.
Learn how to choose from four different levels of testing and a new way of automation. CD-Screening allows you to pick and choose from KPI based test automation. The levels include simple anomaly alerting, access path verification, clone Pre-apply and even workload capture/replay to easily discover different behavior resulting from a new code level. Joining this presentation, you’ll learn how to align Continuous Delivery to your Continuous Availability.
Presentation Outline:
1 – Agile, Continuous Delivery, DevOps – just buzz words, or new methodologies? 
2 – DB2 Code, Catalog, Function and Application Levels – differences and dependencies. 
3 – Activation/Deactivation of new code and how to fallback and when you can’t. 
4 – Different flavors of (pro-active) CD-Screening and how it can be automated.
           -Anomaly alerting based on Incompatibility Change Indicators (ICIs)
-Dyn./Stat.Access Path Change Detection e.g.via Plan Management
-Clone based code change pre-apply exploiting Backup System
-Workload-KPI verification using SQL replay and KPI comparison
5 – Conclusion – looking back at BIF Compatibility, APPLCOMPAT and how it may develop.
Connecting Applications Including Mobile and Cloud with DB2 for z/OS using REST
Although z Systems provides unmatched scalability, security and availability for valuable data, applications have to be able to get to that data. Applications also must be able to access the data from a variety of front-end layers, including cloud and mobile. In this session, you learn about the new DB2 z/OS REST service feature available in DB2 for z/OS 11 and 12. The new DB2 z/OS REST feature leverages the existing distributed data facility (DDF) capability. It provides the same class of services you expect when using DDF to access DB2 data. This includes authentication, authorization, client information, enclave classification, system profiling, sysplex awareness, accounting; statistics, displays, and monitoring which are fully integrated into existing DB2 facilities. The new REST feature will also be demonstrated to show how easily REST is to use with DB2 z/OS. Included in this presentation is how to use z/OS Connect EE for your DB2 data and how to configure DB2 related APIs.
Member Fees
The membership fees for 2017 remain unchanged from 2016 and the breakdown is as follows:
2017 Fee Structure:
Annual Membership $180.00
Pay in Advance Single Event $ 55.00
Late Registration/Walk in Single Event $ 65.00

Please Note:  There are options to purchase annual memberships as well as individual meetings through the website.
Meeting Location
A reminder that our meetings are held at Kansas University -
Edwards Campus, Regnier Building at 127th and Quivira in Overland Park.
*** Please note this is the Regnier Building at KU-E, NOT the ***
*** Regnier Building at Johnson County Community College. ***
Kansas University - Edwards Campus
12600 Quivira Rd
Overland Park, KS 66213-2402
Maps and directions are available here:
The Regnier building is in the southeast corner of the complex, and you will find parking in front of that building off of 127th St. Our exact room will be posted on the information screen as you enter the building.
I hope to see you on September 11th!
Stefan Kolev
President, Heart of America DB2 Users Group

0 Response to "September 11: Heart of America DB2 User's Group Meeting"

Post a Comment

Group Tools

Random Prize Winner
Use this tool to generate random numbers for prize drawings.

Computer Humor Slideshow
Just for fun!

Follow this twitter list of the twitter accounts for the user groups. Ask for your group to be added to this list: twitter list
Subscribe to the Kansas City User Group Newspaper at

Blog Archive