Meeting Announcements and Registration

**** Deadline for signup is 12/07/2018 for December 10th 2018 meeting                       ****
**** All attendees must use the Link below to register for the meeting            ****
**** and bring your admission ticket in order to particpate in the free lunch.  ****

December 10th, 2018 Meeting

posted Nov 6, 2018, 7:17 AM by Stefan Kolev   [ updated Nov 7, 2018, 9:08 AM ]


December 10th, 2018 Meeting

This December we host Paul Bartak, Rocket Software, and Terry Purcell, IBM.

Here is our agenda for the December 10th meeting:
======================================================================
8:00 to 8:30 am Check in
------------------------------------------------------------------------------------------------------------------------------
8:30 to 8:45 am IBM
IBM Announcements – TBA, IBM
------------------------------------------------------------------------------------------------------------------------------
8:45 to 10:00 am – Paul Bartak

Zowe: A new Face for z/OS

------------------------------------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
------------------------------------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Paul Bartak

The IBM Db2 DevOps Experience for z/OS Technical Review

------------------------------------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch

Catered lunch in room across from presentation room

------------------------------------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Terry Purcell

Machine Learning and Db2 for z/OS

------------------------------------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
------------------------------------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Terry Purcell

Db2 12 and Continuous Delivery - What's New from the Optimizer?

------------------------------------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

------------------------------------------------------------------------------------------------------------------------------

 

More Information:

Speaker Bios:

Paul Bartak has been working with IBM databases since 1985, including the first version of DB2 on MVS. As an IBM customer for 14 years Paul worked in Application Development, Database Administration, and DBA Management - working with IBM & ISV Labs on various projects. He joined IBM in 1999 as an Information Management Technical Specialist, teaming with the Sales force to present, design, install, demonstrate, and evaluate IBM Information Management solutions in a pre-sales environment; gaining multiple certifications in Database Administration, Data Replication, Blockchain, and Cloud Computing. Paul developed the four generations of Migration Planning Workshops from DB2 V8 for z/OS, to DB2 11 for z/OS; and enablement for Db2 for z/OS pureXML and Temporal features. As a Principal Solutions Advisor with Rocket Software, Paul is focused on the tools used to maximize DB2 for z/OS value, with emphasis in database cloning and DevOps processes. He supports multiple Db2 User Groups, has been a speaker at several IDUG and Insight/Think conferences, and is a Redbook/Redpaper author.

Terry Purcell
is the lead designer for the Db2 for z/OS Optimizer and Machine Learning within Db2 at IBM's Silicon Valley Lab, and is recognized worldwide for his expertise in query optimization and performance with Db2 for z/OS. 


Abstracts:

Zowe: A new Face for z/OS
Information Technology is undergoing a revolution of changing architectures, new processing capabilities and a deluge of programming language options. With the ever-increasing speed of technology advancements, a dynamic workforce that spans millennials to baby boomers and rising expectations in user experience, there needs to be a new standard framework for interacting with the mainframe that enables an intuitive, productive and better integrated solutions.

Come learn about Zowe. A new open source software framework that provides solutions that allow development and operations teams to securely, manage, control, script and develop on the Mainframe like any other cloud platform. Zowe is the first open source project based on z/OS.

The IBM Db2 DevOps Experience for z/OS Technical Review

There are multiple studies that show the relationship between an agile organization and its success in the marketplace. At the same time, the competitive marketplace is tougher than ever, with technology savvy innovators entering industries and challenging mainstay enterprises. DevOps encapsulates the efficiencies necessary for the rapid, quality delivery of the software that drives these innovators. The database portion of the application is just as important as the application code, and has been identified as a major contributor to DevOps friction. This presentation will position where the IBM Db2 DevOps Experience fits in the DevOps world. With that understanding, we will dive into the details of the architecture and workflows, along with information about what this means for our customers. Develop your understanding of this product which elevates Db2 for z/OS into the fast paced, innovative world of DevOps

Machine Learning and Db2 for z/OS
Beginning with enhancing the access path decisions made by the optimizer tailored to your workloads, Db2 for z/OS is embarking on a journey to improve performance and manageability by exploiting machine learning. This session will outline where Db2 is in this journey, and hint at the roadmap for a self-tuning Db2.

Db2 12 and Continuous Delivery - What's New from the Optimizer?
DB2 12 for z/OS has been announced and DB2 has embarked on Continuous Delivery for ongoing features. So what's coming from the optimizer team regarding further performance enhancements? DB2 12 for z/OS had already delivered outstanding performance and scalability improvements from UNION ALL and outer join performance improvements, sort optimizations, improved predicate indexability and tighter integration of the Optimizer and RUNSTATS. This presentation will outline what was delivered and how future optimizer enhancements apply to continuous delivery.

Member Fees

 

The membership fees for 2018 have been eliminated.

Please Note:  Register promptly on Eventbrite to ensure correct headcount for our catered lunch
 
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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 December 10th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

September 10th, 2018 Meeting

posted Jul 25, 2018, 8:24 AM by Stefan Kolev   [ updated Jul 25, 2018, 8:27 AM ]

September 10th, 2018 Meeting

This September we host Craig Mullins, Mullins Consulting; Bob Bersano, Rocket Software; and Kai Stroh, UBS Hainer.

Here is our agenda for the September 10th meeting:
======================================================================
8:00 to 8:30 am Check in
------------------------------------------------------------------------------------------------------------------------------
8:30 to 8:45 am IBM
IBM Announcements – Terri Kemmer, IBM
------------------------------------------------------------------------------------------------------------------------------
8:45 to 10:00 am – Craig Mullins

It’s Not Your Daddy’s Db2

------------------------------------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
------------------------------------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Craig Mullins

The Top Ten Db2 Things You Need to Know: For DBAs and Developers

------------------------------------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch

Catered lunch in room across from presentation room

------------------------------------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Bob Bersano, Rocket Software

Db2 Recovery Simplified with considerations for GDRP

------------------------------------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
------------------------------------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Kai Stroh, UBS Hainer

Exploit DB2’s Log

------------------------------------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

------------------------------------------------------------------------------------------------------------------------------

 

More Information:

Speaker Bios:

Craig S. Mullins is president and principal consultant of Mullins Consulting, Inc. where he focuses on data management strategy and consulting. He has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He writes the monthly DBA Corner column for Database Trends & Applications magazine. He has worked as a programmer/analyst, a DBA, an industry analyst, a software executive and a consultant.

 

Craig has over three decades of experience in all facets of database systems development and has worked with DB2 for z/OS since V1. You may know Craig from his popular books: DB2 Developer's Guide, 6th edition and Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd edition.

 

Follow Craig on Twitter at @craigmullins


Bob Bersano began his career as a mainframe software developer back in 1986 and has worked with IBM Db2 since version 2.1.  Bob has designed and developed many different enterprise Db2 tools handling data migration, log analysis, security and backup and recovery.  Bob joined Rocket Software in 1995 as a Senior Software developer to design and code a new database backup and recovery product that would exploit fast replication technology.  Bob has recently moved into a role as a Senior Solutions Advisor supporting customers with backup and recovery and log analysis products.  He is currently based in Chicago, and is an alumnus of the University of St. Francis with a bachelor’s degree in Computer Science.

Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 internals and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations. 

Abstracts:

It’s Not Your Daddy’s Db2
Db2 for z/OS is always changing, adding more features and functionality… and discarding old stuff, too. If you are still using Db2 the same way you did 20 years ago, or even 10 years ago, you are probably doing things wrong! This presentation takes a look at how things are changing, not just with Db2, but also with IT and the industry. It is delivered in two parts: first looking at industry and DBA trends, and then looking at some of the specific changes made in the past few versions of Db2 that should impact how you use Db2.

Topics include:
*  Industry & DBA Trends
*  Db2 Modernization including coverage of database design, security and development trends.
*  Some Guidance on how to move forward

The Top Ten Db2 Things You Need to Know: For DBAs and Developers
 There is a veritable boatload of information and details about DB2 for z/OS available to you. But can you digest all of it? Wouldn't it be nice if you could focus on the things that were the most important for you to know instead of wading through thousands of pages of manuals, web pages, and presentations? This session will distill the essence of what you need to know into the top ten most important issues for the two biggest categories of DB2 users: application programmers and database administrators. This presentation offers a count down the top ten most important things you need to know. Along the way we will uncover what is most important for DBA, developers, and managers to understand about Db2 for z/OS. If you are interesting in understanding the hierarchy of Db2 performance tuning objectives, and moving further along in your mastery of Db2 performance, this this presentation will help.

Db2 Recovery Simplified with considerations for GDPR

Db2 recovery can be complex and only a small fraction of users will practice any type of recovery scenarios on a regular basis.  Recovery scenarios can range from recovering a single object to recovering a complete Db2 system.  It seems that whenever a request for recovery ends up on a DBA‘s desk, it‘s always at the most inconvenient time because more and more  DBA teams seemed to be understaffed.  The majority of time in a recovery exercise is spent analyzing what has happened and which objects need to be recovered.

There are a lot of utilities available in Db2 for z/OS that can help you with recovery.  In order to use these utilities at the right time and in the most efficient way, it requires a lot of expertise and experience to execute the steps in the correct order in a situation that normally comes with some pressure. 

On May 25th of 2018 GDPR will take effect.  GDPR is designed to unify data privacy requirements across the European Union (EU) so if your company processes the information of EU Data Subjects (which include end users, customers and employees) you will need to make sure you address these key requirements.  While this guideline certainly provides room for interpretation, it may result in an auditing requirement to prove that certain data or particular applications can be recovered within a given period of time.  


Exploit DB2’s Log
Relational DBMS have a transaction log for recovery purposes in case of failure. However, the information stored in the log is also well suited for other purposes. Think of undoing bad transactions, data propagation, and auditing. The DB2 log is a potential gold mine if you know how to seamlessly filter and make complex log data usable. We will show you how the DB2 log is structured, what data DB2 stores in the log besides table contents, and how to find the information you are looking for. As the DB2 log can become extremely large, we will also show you a solution for automating your log analysis needs with an easy to use, panel-driven application.


Member Fees

 

The membership fees for 2018 have been eliminated.

Please Note:  Register promptly on Eventbrite to ensure correct headcount for our catered lunch
 
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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 10th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

 

June 11th, 2018 Meeting

posted Apr 26, 2018, 11:04 AM by HOA DB2   [ updated Apr 26, 2018, 11:17 AM ]

June 11th, 2018 Meeting

This June we host Mark Rader, IBM, and Ulf Heinrich, SEGUS, Inc.

Here is our agenda for the June 11th meeting:
======================================================================
8:00 to 8:30 am Check in
------------------------------------------------------------------------------------------------------------------------------
8:30 to 8:45 am IBM
IBM Announcements – Manas Dasgupta, IBM
------------------------------------------------------------------------------------------------------------------------------
8:45 to 10:00 am – Mark Rader, IBM

Connecting Applications Including Mobile and Cloud with Db2 for z/OS using REST

------------------------------------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
------------------------------------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Mark Rader, IBM

DB2 for z/OS is in The Cloud!  Using z/OSMF to Install, Migrate and Provision Db2

------------------------------------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch

Catered lunch in room across from presentation room

------------------------------------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Mark Rader, IBM

Db2 for z/OS System Profile Monitoring with Real Life Use Cases

------------------------------------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
------------------------------------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Ulf Heinrich, SEGUS, Inc.

Db2 12 – 12 months agile production experience with more focus on the Data and less on the base

------------------------------------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

------------------------------------------------------------------------------------------------------------------------------

 

More Information:

Speaker Bios:

Mark Rader is a Db2 for z/OS specialist in the IBM Washington Systems Center. He has over 34 years of technical experience with IBM, primarily with Db2 for z/OS. He has led many Db2 data sharing implementations and has presented a variety of topics at World of Watson (and Insight, IOD, and Db2 Technical Conference), Enterprise or Edge, System Technical University, IDUG, and SHARE conferences and at regional Db2 user group meetings. He has worked closely with Db2 development in delivering the Early Support Programs for Db2 10, Db2 11, and Db2 12. He is an author of redbooks on Parallel Sysplex application considerations, Db2 data sharing, and Db2 for z/OS distributed function.

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 realworld 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.

Abstracts:

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 native 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. We will also discover how to use z/OS Connect for a DB2 environment. 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.

Db2 for z/OS is in The Cloud! Using z/OSMF to Install, Migrate, and Provision Db2
These are exciting times and you may not realize it, but DB2 for z/OS is in the cloud! You may be thinking, what exactly does that mean? Many of your z/OS colleagues are already using z/OSMF for all sorts of functions. Come learn how to use z/OSMF to manage DB2 software, install, migrate, and provision data for DB2 and what the cloud means to us.

Db2 for z/OS System Profile Monitoring with Real Life Use Cases
Based on actual customer experience, this session describes how to implement DB2 System Profile Monitoring to optimize and manage access by applications or clients using DRDA to interact with DB2 data. What is DB2 System Profile Monitoring? Introduced in DB2 9 for z/OS and extended in DB2 10, DB2 11 and DB2 12 for z/OS, System Profile Monitoring provides a variety of exciting capabilities: ZPARMs at a more granular level than the subsystem, modeling production in test, and managing application specific behavior - all available via online changes!

 

Db2 12 – 12 months agile production experience with more focus on the Data and less on the base

Short Presentation Abstract:

On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience.  In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on "Data"—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

 

Full Presentation Abstract:

Migrating to Db2 12 is pretty much the same procedure like every 3 years. Then we get introduced to a variety of levels that control new features and functions being delivered and realize that the every-3-years-same-procedure is history. The levels, their dependencies and behavior are a fundamental change, which was implemented to control agile and more specifically it’s associated Continuous Delivery of future upgrades and fixes. As usual, it comes with benefits, but also challenges.

This presentation not only covers customers experiences migrating to Db2 12, but also how the changed maintenance approach has forced them to change existing procedures.

The second part is the daily operation and exploitation using Db2 12 enhancements from customers of different industries. The over-all results aren’t bad, but a major conclusion is also that this Db2 version is significantly different than other versions before. It’s the first agile version with all its pros and cons.

According to IBMs July 2017 announcement, the new database design “represents the elemental nature of Db2 (think periodic table) and connotes the fundamental importance of hybrid data management.". Where does this materialize in our daily work with Db2?

Join this presentation and benefit from the experience of other Db2 customers around the world running Db2 12.

 

Presentation Outline:

1a – Db2 migration and maintenance – meet the agile and continuous delivery face of Db2.

1b – DB2 Code, Catalog, Function and Application Levels – differences, dependencies and how to successfully manage them.

2 – Running Db2 12 and exploiting new features – what’s hot and how to exploit it best?

3 – Emphasizing the Data – what has changed since July and what are the hybrid aspects managing Data?

4 – Top 10 list of tips and gotchas from a year of Db2 12 production Data bases around the world


Member Fees

 

The membership fees for 2018 have been eliminated.

Please Note:  Register promptly on Eventbrite to ensure correct headcount for our catered lunch
 
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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 June 11th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

March 12th, 2018 meeting

posted Jan 31, 2018, 9:17 AM by Louis Connell

March 12th, 2018 Meeting 

Free admission to this meeting is limited to the first 20 attendees that sign up in eventbright.

 

Our guest speaker is Tony Andrews of Themis. This full-day session consists of topics selected specifically to assist developers with Db2 SQL programming performance and best practices.

 

Attendees will gain knowledge of SQL programming, performance and tuning, and the SQL-PL native Stored Procedure language.

 

The material provided to each attendee will include:

 

SQL Standards and Guidelines

SQL coding best practices

SQL-PL coding best practices

Many great SQL examples on rewrites

SQL and program tuning tips

SQL and program tuning step by step processes


We will start at 8:30 am, break for a catered lunch at 11:30, and expect to wrap up by 3:30 pm.

 

Speaker Bio:

 

Tony Andrews, Themis Inc., Consultant and Trainer

Tony Andrews has more than 25 years’ experience in the development of relational database applications. For most of this time he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs and has also served as a database analyst. For the last 10 years Tony has been splitting his time between performance and tuning consulting engagements and training.  His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance.  He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA.  He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.

 

Abstract:

 

Session Topics:

Learn the top reasons for poor performance

Learn our top SQL rewrites every developer should know

Learn our top SQL Tuning Tips for developers

Learn our top reasons why you have to watch out for null columns

Learn the top reasons why developers need to know their data

Learn what filter factors are and why they are so important

Learn our top 10 steps to tuning a query or program

Learn our top SQL-PL stored procedures best practices

 

Member Fees

The membership fees for 2018 have been eliminated.

 

For our March meeting we need to limit the number of free attendees to the first 20 that sign up in eventbrite.

 
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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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.

December 11th, 2017 Meeting

posted Oct 31, 2017, 7:37 AM by HOA DB2   [ updated Nov 15, 2017, 8:58 AM ]

December 11th, 2017 Meeting
Our guest speakers this December are David Simpson (Themis), Howard Hirsch (IBM), and David Churn (DST).
Here is the tentative agenda for our December 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 – David Simpson
Using REXX with Db2
---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – David Simpson

Access Path Stability on Db2 for z/OS  - Best Practices
---------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch
---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Howard Hirsch
Protecting your Crown Jewels – Data Protection on the mainframe
---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – David Churn
Making JSON with SQL
---------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements
---------------------------------------------------------------------------------------------------

 
More Information:
Speaker Bios:
David Simpson is currently Vice President at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA onboth z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame
.

Howie has been working in IT since 1979. He has extensive experience in DB2 for z/OS and now works as a CyberSecurity specialist. He has worked almost exclusively on z/OS systems for firms in the telecommunications, finance and health care insurance industries. He is a co-author of the IBM Redbook, DB2 9: Packages Revisited. He has been with IBM for the last 10 years, and is currently the North American technical lead for Guardium Data Activity Monitor for z/OS and Guardium Data Encryption for DB2 and IMS Databases.

David Churn is an Architecture Database Consultant for DST Systems, Inc. who has been working full-time on DB2 for z/OS since 2003.  David advises project teams on DB2 features, experiments with features on new releases of DB2 and writes many triggers.
 
Abstracts:
Using REXX with Db2
REXX is a great tool on z/OS for administrators and developers to create custom tools that will help them in their day to day work.  REXX also works great with Db2.  This presentation will discuss the REXX/Db2 interface and give you some practical code samples to help you implement scripts in your own environment right away.


Access Path Stability on Db2 for z/OS  - Best Practices

Db2 has provided some great features for stabilizing performance through changes in the environment, particularly through a Db2 version upgrade.  In this session we will look at the evolution of access path stability over the last few releases and provide some thoughts on best practices for implementation.

Protecting your Crown Jewels – Data Protection on the mainframe
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.

Making JSON with SQL
In our connected world, we send and receive messages with other businesses using different formats.  One message format, JSON, is relatively new to the mainframe.  This presentation will discuss ways to work with JSON documents using SQL functions.  The emphasis is on building, storing, and parsing documents to handle the information content.  We will also touch on a couple programming language alternatives to SQL to achieve the same result.
Objectives:

  1. What is JSON?
  2. Comparing data types
  3. Converting between JSON and DB2 data types
  4. IBM supplied JSON functions
  5. Alternatives

 
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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 December 11th!
 
Stefan Kolev
 
President, Heart of America DB2 Users Group

September 11th, 2017 Meeting

posted Aug 7, 2017, 7:51 AM by Louis Connell   [ updated Sep 6, 2017, 5:52 AM by Stefan Kolev ]

September 11th, 2017 Meeting - Updated with new IBM speaker

Our guest speakers this September are Suresh Sane (Southeastern Grocers), Ulf Heinrich (SEGUS), and  Craig Friske (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

Query Optimization in Relational Databases – Why it Matters!

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Suresh Sane

My Favorite SQL Features in DB2 for z/OS V11 and V12

---------------------------------------------------------------------------------------------------
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 – Craig Friske

DB2 12 for z/OS PBR Tablespaces- "The Next Generation"

---------------------------------------------------------------------------------------------------
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.

Craig has over 25 years of development experience with Db2 for z/OS at the Silicon Valley Lab. He has led or worked on numerous utility projects including statistics gathering enhancements, partition independence, data compression, and online utilities (REORG, CHECK and REBUILD). Craig has also worked on many availability enhancements for Online Schema Evolution. His most recent endeavor was leading the implementation of Partition by Range Relative Page Numbering table spaces in Db2 12 for z/OS.


Abstracts:

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?

My Favorite SQL Features in DB2 for z/OS V11 and V12
This presentation provides an in-depth look at the top DB2 for z/OS V11 and V12 SQL features.  We present a clear and detailed explanation of each feature showing how you can use this feature in your shop and explain how you will benefit from these enhancements.  We will not just scratch the surface but take a deep dive into features most important to you as a developer and a DBA.


5 Bullet Points

  • Usability Enhancements
  • Temporal enhancements
  • Analytics functions
  • Anvanced triggers
  • Pagination

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.

DB2 12 for z/OS PBR Tablespaces- "The Next Generation"

DB2 12 for z/OS allows the ingestion of data at extremely high rates, so the proper infrastructure must be in place to receive and properly manage these large amounts of data. Partition By Range table spaces have been improved with relative page numbering. This allows partitions to grow much larger, allows much more agile handling of hot spots or partitions, and lays the groundwork for scheme independence by partition. This presentation will give you all the details on how to incorporate and exploit this new technology.

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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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

June 12th, 2017 Meeting

posted May 12, 2017, 8:32 AM by Louis Connell   [ updated Jun 12, 2017, 12:41 PM ]

June 12th, 2017 Meeting

This June we host Steen Rasmussen, CA, Patrick Bossman, IBM, and our own Kevin Harrison, Argus Health.

Here is our agenda for the June 12th 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 – Steen Rasmussen, CA

What’s hidden in the ARCHIVES – DB2’s answer to American Pickers?

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Patrick Bossman

Example videos -  

        Auto Notify

        Sandbox Deploy

        Provision Schema

---------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Patrick Bossman

---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Kevin Harrison, Argus Health

A DB2 technician's perspective on Spark, Machine Learning, and Data Lakes

---------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

---------------------------------------------------------------------------------------------------


 

More Information:

Speaker Bios:

Steen Rasmussen is a Sr. Engineering Services Architect currently instrumental in the ongoing development and support of the CA Technologies DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at CA technologies working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Since 2014 Steen has been an IBM Information Management Champion. Since 2013 Steen has been the CA liaison for IDUG NA.   

 

Patrick Bossman is a Senior Technical Staff Member for DB2 for z/OS Development. His current role is the lead architect for DevOps and cloud provisioning for DB2 for z/OS. This includes REST enablement of services to provision, configure, manage, and use DB2 for z/OS. Patrick also assists with the design of install, migration, 24x7 application availability, query optimization and performance tuning and tooling.

Kevin Harrison joined Argus in June of 2016 after 27 years as Certified Senior I/T Architect and DB2 Sr. Software Engineer at IBM, serving on the DB2 SWAT team a worldwide group of experts based at the IBM Silicon Valley Lab in San Jose. He has broad experience in application development, database management systems, architecture development, technical infrastructures, and system integration.  37 years of overall DB2 experience with a wide range of implementations and engagements with DB2 on large systems. He has served as a DB2 educator, DB2 Redbook author, DB2 user group liaison and speaker, led many DB2 design/implementation reviews, and DB2 performance and tuning engagements. He is certified in several disciplines in DB2 z/OS and currently is a member of the American Association of Enterprise Architects and Open Group Master IT Architects.  He is a customer designated member of the IBM Professional Certification Exam developers team where he contributes and authors certification exams for DB2 z/OS.

He is currently serving as an Executive IT Architect for Argus Health Systems, with responsibility for DB2 technical lifecycle management, DB2 product technical direction, integration of Argus POS with new technologies such as Spark and Machine Learning. At Argus he is working on new processes to improve DB2 resiliency, allow for faster and greater uptake of DB2 new function for faster adaptability,  and overall DB2 consultancy on a variety of issues.

 

Abstracts:

What’s hidden in the ARCHIVES – DB2’s answer to American Pickers ? 

DB2 10 offered Temporal Tables to optimize, automate and streamline the ability to keep the history of a row’s life. DB2 11 adds a different dimension to this area – now it’s possible to have DB2 automate archiving data without the need for applications to activate triggers, execute reorg DISCARD processing or even maintain your own programs to achieve archiving.

 

Detailed abstract :   

The attendee will get a detailed overview of what’s needed in terms of DDL to enable data archiving automatically as well as the changes needed from the SQL/application view. There’s no perfect world (Utopia doesn’t exist) so we will also look into the limitations and restrictions when Archive tables are exploited in DB2 11 NFM. Next topic is to go over what needs to be considered in terms of backup and recovery as well as other DB2 utilities which are impacted.

The entire presentation will be done based on a real DB2 11 subsystem to see how all the moving parts work together.     

 

Bullet points :

1)      DDL changes to enable archive tables

2)      DML changes / add-on’s to facilitate Archive tables

3)      Restrictions, limitations and gotcha’s

4)      Utility considerations

5)      A case study using a real DB2 11 system – some ideas about implementation

 

DB2 z DevOps and Cloud Provisioning
Modern development organizations demand agility. Learn how incorporating DevOps practices and self-service provisioning, you can radically improve the productivity of developers and DBAs.

This presentation will show how a non-z skilled developer can self-service provision an application database environment, make a stateful schema change and have it instantly deployed, changing their sandbox development environment. If desired, DBA defined business rules and naming conventions can be enforced as part of the automated process. See how to efficiently perform DBA review and approval via automated generation of changed artifacts and deployment process delivered to the DBA when it's time for review. Learn how when the database schema change is integrated, developers with newly down-version environments can have changes automatically pushed, or be auto-notified with a link to upgrade their sandbox environment when they are ready.


Dynamic Plan Stability
Increase application availability by avoiding unexpected dynamic SQL performance regressions.
Query performance instability has been a key drawback of dynamic SQL. Learn how to use dynamic plan stability to stabilize query performance, and reduce CPU costs during workload transitions. This presentation walks through stabilizing an application, explaining stabilized queries, observing invalidation and re-stabilization, identifying and removing stale queries, and more.

A DB2 technician's perspective on Spark, Machine Learning, and Data Lakes 
New technologies in Big Data and Machine Learning that utilize DB2 databases present new challenges for traditional DBA and System programming staff. A whole new set of design thinking comes into play. Migration of DB2 data to "lakes" or using our own DB2 structures as part of a "lake" can challenge our known parameters around data consistency, availability, performance, and replication. How does all this stuff fit together?  How do we prepare our enterprise to accommodate this technology and how do we adapt?
And what are all these new terms and principles and how do we interact with Data Scientists?
This session will start with some basics and relate the experience of a long term DB2 technician and the challenges involved in an implementation of this technology. The viewpoint is from SPARK on z/OS with the ML component on x/86 Linux. But the thought process is all the same regardless of platform.

 

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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 June 12th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

March 13th 2017 meeting

posted Feb 4, 2017, 6:10 PM by Louis Connell   [ updated Mar 13, 2017, 7:40 AM ]

March 13th, 2017 Meeting

The first HOADB2UG meeting for 2017 is coming up on Monday March 13th. Joining us will be Haakon Roberts (IBM), Jase Alpers (IBM), and Kai Stroh (UBS Hainer).

Here is the tentative agenda for the March 13th 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 – Haakon Roberts, IBM
DB2 Utilities Update

----------------------------------------------------------------------
10:00 to 10:15 am Break
----------------------------------------------------------------------
10:15 to 11:30 am – Jase Alpers, IBM
What's New from the Optimizer in DB2 11 and 12 for z/OS?

----------------------------------------------------------------------
11:30 to 12:30 pm Lunch
----------------------------------------------------------------------
12:30 to 2:00 pm –  Haakon Roberts, IBM

DB2 V12 and Beyond
----------------------------------------------------------------------
2:00 to 2:15 pm Break
----------------------------------------------------------------------
2:15 to 3:30 pm – Kai Stroh, UBS Hainer

Log Enhanced Copies for 24x7 DB2 Refresh/Migration

----------------------------------------------------------------------
 

More Information:

Speaker Bios:

Haakon Roberts has over 30 years' experience working with DB2 on the mainframe platform covering various aspects of systems programming, database administration, software development and support. He is a Distinguished Engineer working for DB2 for z/OS development at the IBM Silicon Valley Laboratory in San Jose, California and the chief technical architect and strategist for DB2 for z/OS Utilities and Tools. He holds several patents and is a leading expert in data integrity, availability, serialization techniques and problem resolution. He is a regular speaker on these and other topics.

Jase Alpers is part of the DB2 for z/OS optimizer development team out of the IBM Silicon Valley Lab.  He is a frequent speaker on DB2 query optimization with more than 15 years experience with DB2 in application development, consulting, DB2 support, and DB2 optimizer development.  Prior to joining the DB2 optimizer team, Jase led the SQL performance and Relational Data Systems DB2 support teams.  Jase's work is focused on driving improvements to DB2 query optimization as well as deep dive analysis and resolution of SQL performance problems.  In the last several releases of DB2, Jase has designed and delivered enhancements to automate identification and management of which statistics to collect for optimal query performance.


Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 dumps and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations. 

 

Abstracts:

DB2 Utilities Update
IBM DB2 utilities is an area of intense development, delivering major improvements in function, availability and performance. This session will explain not only what was delivered in DB2 12, but also cover recent enhancements that have been delivered recently in the V11 maintenance stream that you can take advantage of today.

What's New from the Optimizer in DB2 11 and 12 for z/OS?

IBM DB2 for z/OS customers expect improved performance in each release, while maintaining the stability and reliability to which they have grown accustomed from the mainframe environment.  DB2 11 and 12 continue this theme with significant attention given to improved plan management, runtime optimizations and new access path choices.  If you are interested in improving performance for your DB2 applications you won’t want to miss this session.

DB2 V12 and Beyond
DB2 12 for z/OS is now available. This session will provide an overview of the significant enhancements delivered in V12 as well as taking a look at what the future holds beyond V12.

Log Enhanced Copies for 24x7 DB2 Refresh/Migration
File system level copies of DB2 tablespaces and indexes are a fast alternative to traditional methods of data movement, such as Unload/Load. One common requirement is to copy production data in a consistent manner without jeopardizing the performance or availability of the production tables. In this presentation, we will explain how DB2 uses its log to ensure the consistency of its tables, atomicity of transactions and durability of data. In a live demonstration, we will see how advanced copy programs can exploit the information on the DB2 log in order to make consistent copies of tablespaces, indexes, LOB and XML objects without stopping the source tables.

 

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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 March 13th!
 
Stefan Kolev

 
President, Heart of America DB2 Users Group

December 12th, 2016 meeting

posted Oct 10, 2016, 4:26 PM by Louis Connell   [ updated Dec 12, 2016, 11:59 AM ]

December 12th, 2016 Meeting

 

Our final meeting for 2016 will feature two distinguished IBM speakers – Robert Catterall and Adrian Burke.

 

Here is our agenda for the December 12th 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 – Robert Catterall, IBM

Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Robert Catterall, IBM

Modernizing the Architecture of Your DB2 for z/OS-Accessing Applications

---------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch

Our lunch break may run a little longer if Adrian’s flight gets delayed

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Adrian Burke, IBM

DB2 for z/OS Distributed Access – In the Mobile Age

---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Adrian Burke, IBM

Avoiding L2 Performance PMRs

---------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
Officer Elections and/or Vote of Approval

---------------------------------------------------------------------------------------------------

 

Speaker Bios:

Robert Catterall is a Senior Consulting DB2 for z/OS Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of the International DB2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/.

Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab. In this role as a technical advocate for DB2 for z/OS Adrian conducts and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Adrian has spoken at numerous DB2 Regional User Groups in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 and z/OS performance.


Abstracts:

 

Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)

Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology

 

Modernizing the Architecture of Your DB2 for z/OS-Accessing Applications

DB2 for z/OS has been around for more than 30 years, and there are applications written for DB2 in the 1980s that are running just fine today. That said, recent years have seen major changes in the architecture of DB2-accessing applications. These newer developments have delivered enhanced agility, resiliency, and flexibility, while conforming to the programming preferences of a new generation of application developers. This session will explore a variety of topics related to modern architecture for DB2-accesisng applications, including native SQL procedures, synergy with message queuing technology, support for Java and other modern languages, RESTful services, and leveraging developer-friendly DB2 features and functions.

 

DB2 for z/OS Distributed Access – In the Mobile Age

Come and learn the best practices and updates to Distributed Access on DB2 for z/OS 10 and DB2 11. As distributed environments become more complicated and important your organization needs a methodology for adjusting timeouts and other thresholds for high availability.  We will go over the recommended driver and server configurations for workload balancing, high availability, and client reroute in a Data Sharing or non-Data Sharing environment.  You will be exposed to recent customer incidents that could have been avoided with the correct proactive driver/server settings  We will also discuss improvements to DDF cancel thread, location stats, and how to positively identifying these distributed threads for problem determination.

 

Avoiding L2 Performance PMRs:

Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today's diverse environments.  Everything from CEC capacity, LPAR utilization, real/virtual storage, WLM settings, PARMLIB members, and DB2 parameters can play a part in performance degradation.  Wouldn't it be nice if there were some tools (no-charge ones at that) which could quickly guide you in the direction of the root cause?  Not just in text format but with graphs and trending lines that can visually depict the bottle neck and help educate management and colleagues.  Many man hours have been wasted studying the effects of a system slowdown. This presentation will walk through a methodology for avoiding these issues.


Member Fees

The membership fees for 2016 remain unchanged from 2015 and the breakdown is as follows:
 
2016 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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 December 12th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

September 12th, 2016 Meeting

posted Jul 25, 2016, 9:54 AM by Louis Connell

September 12th, 2016 Meeting

Our third meeting for 2016 will feature Roy Boxwell (SEGUS), Kai Stroh (UBS Hainer), and Jase Alpers (IBM).  During the lunch hour we will have an optional product demo by Ulf Heinrich – Director of Solutions Delivery at SEGUS.

 

Here is our agenda for the September 12th meeting:
========================================================
8:00 to 8:30 am Check in and continental breakfast
----------------------------------------------------------------------------------------------------
8:30 to 8:45 am IBM
IBM Announcements – Shri Shrimali, IBM
---------------------------------------------------------------------------------------------------
8:45 to 10:00 am – Roy Boxwell, SEGUS

BIF/ICI Detection

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Ulf Heinrich, SEGUS

SQL Audit

---------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch (sponsored by SEGUS)

Optional product demo by Ulf Heinrich, SEGUS

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Kai Stroh, UBS Hainer

Test Data Management – Concepts and Methods

---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Jase Alpers, IBM

Runstats Challenges for Optimal Query Performance

---------------------------------------------------------------------------------------------------
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

---------------------------------------------------------------------------------------------------

 

Speaker Bios:

Roy Boxwell has more than 28 years of DB2 experience – 25 of those acquired in MVS, OS/390 and z/OS environments. He specializes in installation, migration, and performance monitoring and tuning.  Roy leads the SEG development team responsible for the real time database maintenance solutions and is currently involved in the development of new DB2 HealthCheck products.  He is also an active participant and contributor on the IDUG DB2 Listserve and sends out our monthly DB2 newsletter

               

Ulf Heinrich is the Director of Solutions Delivery at SEG. Ulf’s specialties are DB2 availability and performance, focusing on the growing requirement for 24×7 operations and cost reduction. 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. Ulf’s activities cover EMEA, as well as North America through SE’s U.S. subsidiary, SEGUS Inc.
 
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 dumps and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations. 

 

Jase Alpers is part of the DB2 for z/OS optimizer development team out of the IBM Silicon Valley Lab.  He is a frequent speaker on DB2 query optimization having presented at IOD as well as many DB2 user groups over the years.  Jase has more than 15 years experience with DB2 in application development, consulting, DB2 support, and DB2 optimizer development.  Prior to joining the DB2 optimizer team, Jase led the SQL performance and Relational Data Systems DB2 support teams.  Jase's work is focused on driving improvements to DB2 query optimization as well as deep dive analysis and resolution of SQL performance problems.  In the last several releases of DB2, Jase has designed and delivered enhancements to automate identification and management of which statistics to collect for optimal query performance.

Abstracts:

 

BIF/ICI detection

Don’t let ICIs put your DB2 application in the ICU! - How to discover incompatible changes.

·         The what and why of ICIs

If you’ve been paying close attention, you will have noticed that over the course of the past couple releases of DB2 for z/OS, IBM has been making changes that can modify the behavior of your DB2 application programs. The number of incompatible changes being introduced by IBM started off slowly in DB2 9 but has grown to a significant number today. So much so that there are ways to trace incompatible changes (using IFCIDs and ICIs, or Incompatible Change Indicators), as well as methods to repress the changes, even if only for a period of time.

·         Ways to deal with incompatibilities

This session will discuss the incompatible changes, their potential impact on your applications, as well as provide guidance on how to tackle the whole experience. And you’ll also see how to make it easier to manage and control these incompatible changes. With all of this information at your disposal, you can make sure that your DB2 applications do not wind up in the ICU (intensive care unit)!

·         Customer experiences

Now that we all know everything about ICI’s, let us have a look at how you can find where the “bad guys” are and how to continuously check that everything is ok. This presentation will show how you can find out ICI details for static and dynamic SQL, and then we will show real customer results from a “BiF hunt”.

 

SQL Audit

Compliance with compliments! Viable DB2 z/OS workload tracking

Audit and Compliance is a need that many companies want and have to fulfill. There’s different ways and tools that promise to be able to do it, but what can they really do and what are the associated costs? This presentation introduces DB2 10/11 technology exploitation that delivers any DML, DDL, DCL being executed in a DB2 environment along with identification details. Learn how you can run Audit analytics against a longterm repository, pinpointing who executed a query, when and from where. Analyze your entire workload to understand access patterns and abnormalities.

 

Test Data Management - Concepts and Methods


We will discuss test data management and the issues that DBA's and staff must deal with to supply various DB2 environments with fresh data quickly, efficiently and in a way that saves resources, automates processes and improves data delivery times. Rapid data provisioning, data masking, and test data management topics with emphasis on DB2 z/OS will be addressed, as well as, supporting DB2 LUW, Oracle, SQL Server.

 

Runstats Challenges for Optimal Query Performance

Accurate and relevant statistics are the basis of reliable good query performance.  How do I identify the important statistics?  How do I manage statistics collection?  What new features does DB2 for z/OS provide to help with runstats challenges?  In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.


Member Fees

The membership fees for 2016 remain unchanged from 2015 and the breakdown is as follows:
 
2016 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:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections
 
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 12th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

1-10 of 15

Comments