Meeting Announcements and Registration

**** Deadline for signup is 9/8/2017 for September 11th 2017 meeting      ******
**** Annual members please use the Link and Register for the free          ******
**** meeting ticket, these registrations are used to include you in            ******
**** the lunch that is provided                                                                        ******

Meeting information is below the registration and payment links.

September 11th 2017 Meeting Registration and payment Links, agenda follows below:

Please use the following Eventbrite Link to register for the September 11th 2017
Meeting:


If you do not have an annual membership,
and you wish to attend the September 11th 2017 meeting as a single meeting,
please register with the above link, and then
you may use the button below to pay $55 in advance for the
registration, or you can pay $65 at the door.
 
Click on the "Add To Cart" button to pay for the meeting with PayPal.


If you wish to get an annual membership, which includes all 4
2017 quarterly meetings
please use the below "Add to Cart" button


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

June 13th, 2016 Meeting

posted May 5, 2016, 9:38 AM by HOA DB2

June 13th, 2016 Meeting

This June we have the opportunity to hear from Sheryl M. Larsen, BMC and Dr. Avijit Chatterjee, IBM.

 

Here is our agenda for the June 13th 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 – Dr. Avijit Chatterjee

Run Spark on z Systems to deliver end-to-end Analytics

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Sheryl M. Larsen

SQL Performance Tuning in 2016

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

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Sheryl M. Larsen

Think You Can Avoid the Digital Tsunami?  Think Again

---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Dr Avijit Chatterjee

IBM Cloud Data Services is Open for Data

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

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


 

More Information:

Speaker Bios:

Sheryl M. Larsen is a Sr. DB2 Product Specialist at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.

 

Dr. Avijit Chatterjee is a Senior Technical Staff Member in the IBM Competitive Project Office and also a member of the IBM Academy of Technology. Dr. Chatterjee is a thought leader specializing in Big Data, Analytics, Mobile Computing and Enterprise Architecture.  His active hands-on research and deep expertise uniquely position him to share his broad knowledge and deep insights with customers worldwide. During his 25 years with IBM, Dr. Chatterjee has provided consulting services to customers, played an instrumental role in launch of products resulting in 6 patent filings, led development of industry solutions and participated in numerous research projects.   He has a Ph.D. in Computer Science from the University of Southern California.

Abstracts:

SQL Performance Tuning in 2016

 

New access paths, size limits, and new features can change the way you look at tuning your DB2 workloads. Today’s digital forces add to the complexity. Come hear about some old and new tuning techniques like adding math, empty data, or creative table expressions, applying hints, and profiles that can get you ahead of the learning curve. Best practice strategies for getting a handle on all DB2 resource consumption will also be included.

Objective 1: Understand what the new DB2 features will change the way we tune queries.
Objective 2: Understand what external forces will change the way we tune queries
Objective 3: Learn the five ways to make DB2 SQL go faster

Objective 4: Learn what the long term implications are in using hints
Objective 5: Learn what BMC solutions can tame DB2 resource consumption

Think You Can Avoid the Digital Tsunami? Think Again

The explosive growth of data in the digital enterprise can hit your organization like a tsunami so you’d better be prepared to avert a disaster. Tsunamis, as you may know, are massive tidal waves, usually caused by earthquakes, volcano eruptions, and landslides. The destruction can be far reaching and long term.

Just like a tsunami in nature, the digital tsunami will be devastating. If you’re not prepared, the wave of overwhelming data growth will slow down your applications and lead to outages, costing you customers.  This digital tsunami is caused by the demands of people accessing more applications and conducting transactions more frequently than ever before. For example, several years ago you may have gone to a gas station and paid for the gas with a credit card. You just conducted just one transaction with your bank. Today, while you’re waiting for the tank to fill, you check your account balance, deposit a check using the camera in your phone, transfer funds from your savings account, and purchase that movie ticket for later tonight. In the same amount of time, you created five transactions with your bank. This type of activity is driving an exponential growth in data to your business.

Failure to use the right tools to optimize and manage this growth can result in downtime that leads to lost customers and lost revenue. There’s a new way of looking at downtime. One large credit card company that processes over 1,000 transactions a second told us they don’t measure downtime in dollars, but rather in lost customers. Every minute of downtime costs the business 60,000 customers who may never return.

Run Spark on z Systems to deliver end-to-end Analytics

Most businesses today are targeting customers as individuals and no longer as segments. Hence, CxOs have a new boss in town - the customer! Analytics helps companies cater their products and services to the right customer at the right place and right time. To understand what the customer wants in real-time, one has to analyze enterprise operational data often residing on on-premises z Systems as well as external data from blogs, social network sites and IoT sources. Spark helps keep the data in place and run in-memory analytical queries using a federated approach. It powers a universal compute model acting as a new operating system for analytics. It supports a wide variety of data formats and supports SQL, streaming, graph and machine learning based computations. Spark in conjunction with Rocket's Data Virtualization Server running in z/OS can access any z Systems data source seamlessly and integrate with analytics results from Spark running on the public cloud accessing external data. IBM is a strong contributor to the open Spark ecosystem and provides best of breed technology for end-to-end analytics.

IBM Cloud Data Services is Open for Data

IBM Cloud Data Services (CDS) provides a complete portfolio of managed services for data and analytics. Using a hybrid, open source-based approach that application developers, data scientists and IT architects seek, IBM CDS addresses their data-intensive needs and delivers both immediate and longer-term benefits. It gives every member of the data team self-service access to the right tools for their jobs.

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 June 13th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

March 14th, 2016 Meeting

posted Feb 2, 2016, 9:40 AM by Louis Connell   [ updated Mar 14, 2016, 11:04 AM by HOA DB2 ]

March 14th, 2016 Meeting

Our first meeting for 2016 is coming up on Monday March 14th and we have three outstanding speakers.  Susan Lawson, YLA, will present in the morning.  In the afternoon we will open up with Frank Fillmore, Founder and President of the Fillmore Group, Inc.  We will finish up with Kevin Harrison, Senior Software Engineer, IBM Silicon Valley Lab.

 

Here is our agenda for the March 14th 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 – Susan Lawson - Part 1

DB2 11 Performance and Availability Features: What Can I Take Advantage Of?

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Susan Lawson - Part 2

DB2 11 Performance and Availability Features: What Can I Take Advantage Of?

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

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  Frank Fillmore

Hybrid Transactional/Analytical Processing(HTAP)

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

DB2 Version 11 Migration Experiences from the Field
---------------------------------------------------------------------------------------------------
3:30 to 3:45 pm Gregg LaRock, Vice President
User Group Announcements

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


 

More Information:

Speaker Bios:

Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM GOLD Consultant for DB2, and an IBM Champion and has authored the IBM 'DB2 11 for z/OS Database Certification Review Guide', the IBM ‘DB2 for z/OS V8 DBA Certification Guide’ and the IBM ‘DB2 for z/OS V7 Application Programming Certification Guide’. She is also the co-author of several DB2 books including the IBM ‘DB2 10 for z/OS DBA Certification Guide’, IBM ‘DB2 9 for z/OS DBA Certification Guide’, ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’. She is also a SME(Subject Matter Expert) for the IBM Certification exams for DB2 z/OS Database and System Administration assisting with writing and verifying questions for the exams.

 

DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner that specializes in IBM Analytics software sales, consulting, and training. Frank has been providing IBM Information Management solutions to government, industry, and not-for-profit enterprises as varied as The World Bank, J.P. Morgan Chase, Northrop Grumman, and the FBI for over 28 years. Frank’s current practice centers on Hybrid Transaction and Analytic Processing (HTAP) and Oracle to DB2 migrations as well as information governance and integration. Frank kayaks and cheers for the Baltimore Orioles.

 

 Kevin Harrison holds an IBM professional certification as a Certified Senior I/T Architect with broad experience in application development, database management systems, architecture development, technical infrastructures, and system integration. He is a Senior Software Engineer with DB2 for z/OS Development at the IBM Silicon Valley Lab and a member of a worldwide DB2 SWAT team for DB2 on z/OS. Kevin draws on a wide range of experience from 30+ years of involvement with DB2 on large systems, with 26 of those years at IBM as a DB2 technical specialist in various organizations within IBM. Kevin 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. Kevin is certified in several disciplines for DB2 on z/OS and currently is a member of the IBM North American I/T Architect Certification board, and Open Group Master IT Architects. Kevin supports and consults with a variety of customers in multiple industries as an advocate from the DB2 Silicon Valley Lab.

 

Abstracts:

DB2 11 Performance and Availability Features: What Can I Take Advantage Of?

There are several features in DB2 11 focusing on opportunities for improved performance. Many of those features will be in the form of internal processing improvements and will be automatically available as we migrate into DB2 11. But for those of us who want to take advantage of other new features we need to look at what is available, determine if it applies to our environment, how to implement it, what the expectations are, and what are the pros and cons. This presentation will look at some of the new features in DB2 11 focused on performance and availability and provide a discussion on usage and expectations.

  • Discuss overall performance improvements and goals in DB2 11
  • Discuss features for improved application and database performance
  • Discuss usage potential for new features and any required changes
  • Discuss implementation and expectations of these new features

 

Hybrid Transactional/Analytical Processing (HTAP)

 

The concept of Hybrid Transactional/Analytical Processing (HTAP) was coined by Gartner.  IBM implements HTAP in two ways:

•         IBM DB2 Analytics Accelerator (IDAA) - DB2 for z/OS (using Netezza hardware)

•         DB2 BLU Acceleration – DB2 for Linux, Unix, Windows (a software-only implementation)

See how customers are using HTAP to eliminate analytic latency and data synchronization issues and transform and simplify information management infrastructure.

 

DB2 Version 11 Migration Experiences from the Field

Because the initial response to DB2 11 has been very positive, with significant CPU savings, more and more IBM clients are making the move to DB2 11. Upgrading to the latest release of this critical software can bring valuable rewards – if you know how to take advantage of it.
This discussion will touch on moving forward to migration planning from DB2 10 to DB2 11. You will learn about some surprises, pitfalls to be aware of and lessons learned from those who have already migrated. The discussion includes hints and tips, enabling fast start, as well as the latest news about migrations and issues we have observed during customer migrations.

 

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 March 14th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

December 14th, 2015 Meeting

posted Nov 13, 2015, 9:59 AM by Louis Connell   [ updated Dec 14, 2015, 7:31 AM ]

December 14th, 2015 Meeting

The last HOADB2UG meeting for 2015 is coming up on Monday December 14th.  I am excited to have Linda Claussen, a Senior Systems Advisor for Themis, Inc. present for us.  Our morning guest speaker is Marichu Scanlon, who is with the IBM Silicon Valley Laboratory.

Here is the tentative agenda for the December 14th meeting:
======================================================================
8:00 to 8:30 am Check in and continental breakfast
----------------------------------------------------------------------------------------------------
8:30 to 8:35 am IBM
IBM Announcements – Shri Shrimali, IBM
---------------------------------------------------------------------------------------------------
8:35 to 10:00 am – 
Marichu Scanlon - Part 1

Data Server Manager

---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – 
Marichu Scanlon - Part 2

Data Server Manager

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

12:15 to 12:30 pm Optional presentation about Themis, Inc.

---------------------------------------------------------------------------------------------------
12:30 to 2:00 pm –  
Linda Claussen - Part 1

Using DB2 for zOS Extended Features

---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – 
Linda Claussen - Part 2

Using DB2 for zOS Extended Features

---------------------------------------------------------------------------------------------------
3:30 to 3:45 pm Stefan Kolev, President
User Group Announcements, Officer Elections and/or Vote of Confidence

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


 

More Information:

Speaker Bios:

Marichu Scanlon has over 30 years experience in application development, software development, QA and customer advocacy.  She has co-authored 2 redbooks and a redpaper, and written several articles for developerWorks, and presented in several DB2 Technical Conferences,  DB2 User Groups and Insight (formerly known as Information on Demand) conferences.  She is currently an Enablement Specialist for the IBM Analytics Platform and works with clients to evangelize and deploy IBM Data Server Manager, Optim Performance Manager, Optim Configuration Manager for z/OS and LUW.  Before working in this group, she was a developer for Data Studio and was in QA for DB2 for z/OS.  She works out of the Silicon Valley Laboratory in San Jose, California.

Linda Claussen - A frequent speaker at conferences and user groups, Linda's 40+ years of experience spans the various roles of application developer, project manager, Data Base Administration and Systems Programmer. Linda's first exposure to DB2 started with DB2 1.1 and since the late 80’s she has been actively engaged in consulting and training assignments to large DB2 environments. She has frequently worked with new DB2 sites performing the initial DB2 install, providing training and consulting to the Project Leader, DBAs and Application staff responsible for the initial DB2 pilot project and conducting design reviews to insure successful project implementation. Linda is currently a senior systems advisor for Themis, Inc., a past member of the IBM DB2 GOLD Consultants program and a current member of the IBM consultants advisory counsel.

 

Abstracts:

Data Server Manager Overview and Demo

Customers have always had separate tools for database administration, performance monitoring, configuration management, and query tuning. Now you can do all of these tasks using one tool. IBM® Data Server Manager Base Edition (DSM) is available as a no-charge download from Developer Works. DSM Base Edition is a simple, scalable, and smart solution to administer, monitor, manage, and optimize the performance of IBM DB2 for Linux, UNIX, and Windows databases across the enterprise. Available with DB2 for Advanced Enterprise Server Edition and as a Business-value offering is the IBM Data Server Manager Enterprise Edition. The Enterprise Edition includes historical monitoring and analysis, smart alerting, client configuration and monitoring, query tuning, and more. Both editions offer a lightweight setup option for real-time monitoring and administration. DSM Enterprise Edition requires a repository database that can be created and setup before or after DSM is up and running. Today, you will see a high-level overview of DSM and then we will go through a demo of the product.


Using DB2 for z/OS Extended Features to Solve Complex Requirements

Throughout the last several releases of DB2 for z/OS IBM has introduced extended features to address complex data access requirements. Making informed choices in the utilization of MQTs, Table Expressions, Clone tables, Global Temporary Tables, Archive and Temporal Tables, surrogate keys, and more are critical to performance. This 2 part session helps the application developer and database administrator in the selection, use and implementation of the extended features of DB2 to solve complex performance problems.

Objectives:

          Create and manage array data types, surrogate keys,  MQTs, clones, triggers, temporal tables, temporary tables, hash tables, LOBs, and more

          Make informed advanced feature selection choices.

          Identify key strengths and weaknesses of selected features.


Member Fees

The membership fees for 2015 remain unchanged from 2014 and the breakdown is as follows:
 
2015 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 December 14th!

 
Stefan Kolev

 
President, Heart of America DB2 Users Group

September 14th, 2015 Meeting

posted Sep 2, 2015, 7:27 AM by HOA DB2

September 14th, 2015 Meeting

The third HOADB2UG meeting for 2015 is coming up on Monday September 14th. Our morning speakers will be Avard Hart, System z IT Specialist at IBM, and Shri Shrimali, System z Software Technical Sales and DB2 Advisor, IBM.  There will be an optional product demo during lunch, courtesy of SEGUS.  In the afternoon we will hear from Ulf Heinrich, Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH and Roy Boxwell, Senior Architect Development Labs, SEG.
 
Here is the tentative agenda for the September 14th meeting:

======================================================================
8:00 to 8:30 am Check in and continental breakfast
----------------------------------------------------------------------------------------------------
8:30 to 8:35 am IBM
IBM Announcements – Shri Shrimali, IBM
---------------------------------------------------------------------------------------------------
8:35 to 10:00 am – Avard Hart, IBM
IBM Capacity Analytics with demo
---------------------------------------------------------------------------------------------------
10:00 to 10:15 am Break
---------------------------------------------------------------------------------------------------
10:15 to 11:30 am – Shri Shrimali, IBM
The big picture - z Systems, the data server for big data, analytics, mobile and cloud;
Connecting applications, including mobile and cloud, with data on z Systems
---------------------------------------------------------------------------------------------------
11:30 to 12:30 pm Lunch provided by SEGUS Inc
Optional Product demo by SEGUS Inc during the lunch hour
---------------------------------------------------------------------------------------------------
12:30 to 12:35 pm Stefan Kolev, President
User Group Announcements
---------------------------------------------------------------------------------------------------
12:35 to 2:00 pm –  Ulf Heinrich, SOFTWARE ENGINEERING GmbH
DB2 z/OS Cloning – What’s new and faster?
---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm Break
---------------------------------------------------------------------------------------------------
2:15 to 3:30 pm – Roy Boxwell, SEGUS
25 Years of Missed Opportunities?  SQL Tuning Revisited
---------------------------------------------------------------------------------------------------
 
More Information:

Speaker Bios:

My name is Avard Hart and I am from Arkansas.  I joined IBM in the Los Angeles Systems Center in 1978, supporting VM.  After leaving the support center, I became an SE and supported VM and MQSeries. I left IBM in 1995 to explore other opportunities and returned in 2005.  Upon my return to IBM, I joined the ‘Premium Support’ team, supporting VM, MQ, WebSphere and MB.  In 2008 I rejoined the world of z, providing technical sales support for BPM, ODM and now BA.

Shri  has spent 35 years in Information Technology, all in IBM relational technology. Shri did graduate and research work in "semantic integrity in relational databases". At IBM Shri has worked in strategy, business development, growth markets, technical sales and marketing. He is Expert in Mainframes and Data Management. He has designed and implemented complex projects.

Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. 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.
 
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.

 
Abstracts:

IBM Capacity Analytics

The IBM z Analytics platform is transforming IT from technology implementers to business innovators by introducing solutions that can more directly impact revenue growth, cost savings and risk reduction for a more competitive, high performance business.
To stay ahead of the competition, means being able to generate more rapid, data driven decisions out of the growing volumes of data coming in to the business. When transactional data originates on z Systems, revolutionary software technologies like DB2 Analytics Accelerator,  Cognos BI and SPSS are creating new opportunities for IT to deliver right time analytics across the enterprise. 
  
IBM Capacity Management Analytics for z Systems (zCMA) is an example of an advanced analytics solution designed to help you more easily manage and predict your consumption of IBM® zEnterprise®  infrastructure resources.  zCMA is built on IBM’s Cognos BI and SPSS Modeler, providing the ability to manage the complete life cycle of all your computing infrastructure resources.  

The big picture - z Systems, the data server for big data, analytics, mobile and cloud

Today, organizations demand more than just “speeds and feeds” from data-serving technology. In this session, you hear about recent advances in IBM z Systems information management software that can help you build and extend applications that use big data, analytics, mobile and cloud computing to respond to customer needs more quickly and personally

Connecting applications, including mobile and cloud, with data on z Systems

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 new options for connecting to z Systems -based data, including z/OS Connect. You also learn about new ways to manage connections to a DB2 for z/OS system for enhanced performance and control.

CLONING

“DB2 z/OS Cloning – What’s new and faster?”

There are many reasons to clone DB2 environments, like for development, DR testing, QA, audit or just to set up a new SAP environment.
Cloning procedures aren’t rocket science, but using the right procedure can make it a one knob process that even handles terabytes of data in a fraction of time. This presentation focuses on creating an exact copy of a full subsystem/data sharing group or a subset of objects and shows how to consistently duplicate objects/ without compromising availability. Implementing fast dataset rename steps and your own high speed DSNTIAD can make even a fresh copy of large ERP/CRM systems like SAP available in minutes.
Working on the object level should consider any kind of naming conversion for DB2 objects, working on the subsystem/data sharing group level usually requires to clone into another subsystem or group ID. Non data sharing to data sharing and vice versa can be covered with some extra steps as well as cross DB2 version cloning.
The goal is fully automating cloning scenarios including individual steps. See how easy and flexible cloning can be when exploiting the strengths of XML even for complex scenarios and get introduced to the powerful features your storage technology offers to make it highly efficient and incredibly fast!

Presentation Outline:

1. Cloning basics
What type of cloning is the right choice for a given requirement?
What are the gotchas and where are the shortcuts?
What to take care of – beyond DB2?

2. Cloning details
XML scenario definition – the sky is the limit!
Naming conversion – how do you want to be called today?
The path to DB2 Data Sharing – how many members do you need?
How can I exploit instant copy technology, like Flashcopy?

3. Tips and Tricks
DB2 cross version cloning and system cloning
Cloning costs considerations
Do’s and Don’ts


SQL Workload Analysis and Tuning

"25 Years of Missed Opportunities?  SQL Tuning Revisited."

Nothing is more expensive than a missed opportunity” (H. Jackson Brown, Jr).
This is especially true when it comes to SQL Tuning!
There are many low-hanging fruits within easy grasp of anyone tasked with tuning their systems. But how do you know what is dangling within reach if you can’t see it?
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.
By comparing SQL statements side-by-side, the “easy pickings” will immediately become apparent. But why stop there? Experts can effortlessly dig deeper and find the totally hidden gems: Disc Problem Detection, Delay Detection, Never executed SQL, SQL Timeline. Precisely pinpoint specific areas to target and get the most out of your DB2 system – while reducing costs.
 

Outlines

1 – Tuning SQL – how we always done it
2 – Single SQL, package, application
3 – Tuning SQL – year 2004 – ACCESS PATH comparison and simulation
4 – Tuning SQL Revisited – A new methodology
5 – Harvesting the low hanging fruit

 
Member Fees

The membership fees for 2015 remain unchanged from 2014 and the breakdown is as follows:
 
2015 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 September 14th!
 
Stefan Kolev
 
President, Heart of America DB2 Users Group

June 8th 2015 Meeting

posted Apr 23, 2015, 8:46 AM by HOA DB2   [ updated Jun 9, 2015, 10:15 AM by Louis Connell ]

June 8th  2015 Meeting

The second HOADB2UG meeting for 2015 is coming up on Monday June 8th. Joining us will be Haakon Roberts, Chief Technical Architect for DB2 for z/OS Utilities and Tools, and Jane Man, an original member of the XML development team in DB2 for z/OS. 

Here is the tentative agenda for the June 8th 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 – Haakon Roberts, IBM
DB2 Utilities Best Practices

----------------------------------------------------------------------
10:00 to 10:15 am Break
----------------------------------------------------------------------
10:15 to 11:30 am – Jane Man, IBM
Building a Big Data Solution using DB2 for z/OS

----------------------------------------------------------------------
11:30 to 12:30 pm Lunch
----------------------------------------------------------------------
12:30 to 12:45 pm Stefan Kolev, President
User Group Announcements
----------------------------------------------------------------------
12:45 to 2:00 pm –  Haakon Roberts, IBM

REORG Utility Deep Dive
----------------------------------------------------------------------
2:00 to 2:15 pm Break
----------------------------------------------------------------------
2:15 to 3:30 pm – Jane Man, IBM

JSON Support in DB2 for z/OS

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

More Information:

Speaker Bios:

Haakon Roberts has nearly 30 years of experience working with DB2 on the mainframe platform covering various aspects of systems programming, database administration, software support and development. He is a Distinguished Engineer at the IBM Silicon Valley Laboratory in San Jose, California, the Chief Technical Architect for DB2 for z/OS Utilities and Tools, and a leading expert in data integrity, availability and problem resolution. He is a regular speaker on these and other topics.

Jane Man is a Senior Software Engineer and one of the original members of the XML development team in DB2 for z/OS. She has worked on various features of DB2 for z/OS. In addition to her development work, she is the enablement focal point in the team and is involved in many enablement activities, like creating sample applications, demos, Hands on Labs, and presenting in conferences and boot camps. Before she joined the DB2 for z/OS development team, Jane was a developer in IBM Content Manager. 

 

Abstracts:

DB2 Utilities Best Practices
DB2 Utilities Suite has been an area of intense activity for a number of years, delivering tremendous new capability. Exploiting that new capability can make a huge difference to the day to day running of your systems. This session will cover some of the more important features of DB2 utilities and how best to take advantage of them. It will also provide answers to common questions regarding utilities processing.

Building a big data solution using DB2 for z/OS
This presentation focuses on key technologies in DB2 11 for z/OS that enable a seamless  integration between DB2 and BigInsights, using both structured and non-structured data. We show how to enable the DB2 server to integrate with BigInsights.  Using a scenario that is common to all DB2 for z/OS users, we demonstrate how Jaql, JAQL_SUBMIT and HDFS_READ can be used to create an integration solution between BigInsights and DB2 by creating a machine data analysis.

REORG Utility Deep Dive
DB2 REORG is becoming increasingly critical for reasons other than simple reclustering of data. Yet its options and processing are the least understood of any utility. This session will explain how REORG works, what its capabilities are, including what is new in DB2 11, and how to tune it to ensure it is successful with minimal application impact.

JSON support in DB2 for z/OS
A new era of applications focused around mobile devices are becoming increasingly important in large enterprises.  Learn how you can leverage NoSQL technologies like JSON within your DB2 for z/OS environment. We will also compare JSON and XML inside DB2 for z/OS.

 

Member Fees

The membership fees for 2015 remain unchanged from 2014 and the breakdown is as follows:
 
2015 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 June 8th!

1-10 of 11

Comments