Baltimore-DC-NoVa Db2 User Groups (2!) for December

Kim May

Baltimore-DC-NoVa Db2 User Groups (2!) for December
Coming up in December are two (yes 2, TWO!!) Db2 Users Group events in the
Baltimore-Washington-NoVA area:

First, the Mid-Atlantic Db2 LUW group is scheduled to meet December 6th in
Bethesda. This meeting is sponsored by IBM, there is no fee to attend, and
features two sessions on Data Server Manager with DSM Offering Manager Peter
Kohlmann, and a session on the future of Db2 by Dr. Jon Lind, the Db2
Product Offering Manager. This meeting is being held in conjunction with
Washington Area Informix Users Group, and we are looking forward to sharing
lunch and networking with their session attendees. Registration is
required; register
a-tickets-51662818882> HERE.

Details on the Mid-Atlantic Db2 sessions and the registration link
(registration is required) are below; information on the Washington Informix
sessions is HERE.

The following week, the Baltimore/Washington Db2 Users Group will host our
quarterly meeting Wednesday, December 12th at the BWI Hilton. The day's
sessions include presentations by IBM's Master Inventor Terry Purcell, along
with 3 (yes, 3!) user presentations, from Steve Cricchi, and NFCU's Joe
Huang and Joe Watson. Details on the sessions and agenda are below, and
attached. Registration is required; register HERE.

If you are in the area, please join us. And if you are going to join us,
bring a friend!

Mid-Atlantic Db2 User Group Meeting
Sponsored by IBM

Date: December 6, 2018
Time: 10:00am - 3:00pm (registration opens at 9:30am)
Location: IBM, 6710 Rockledge Drive, Bethesda, Maryland 20817
Cost: There is no cost but attendees must pre-register
a-tickets-51662818882> HERE


9:30am - 10:00am Registration and Continental Breakfast
10:00am - 11:15am Data Server Manager, Part 1. Peter Kohlmann,
11:15am - 11:30am Break
11:30am - 12:45pm Data Server Manager, Part 2. Peter Kohlmann,
12:45pm - 1:45pm Lunch, sponsored by IBM
1:45pm - 3:00pm What's New in Db2? Jon Lind, presenter

Session Abstracts
Data Server Manager, Part 1
Learn about the latest trends, directions and updates to the full line of
Data Management Consoles for the Db2 family of offerings from ground to
cloud. Where are we today, what is our vision and how are we getting there.

Data Server Manager, Part 2
Go on a deep dive of how to monitor the overall performance of your Db2
family database. Learn how to dive deeply into the three levels of statement
monitoring and choose which to use for your specific challenge. And learn
how to use Db2 Workloads to surgically decompose your database performance
by application and by user to see exactly who is doing what.

What's New in Db2?
In this session attendees will gain an understanding of IBM's Db2 product
roadmap. IBM's current strategy and plans for Db2 include increased
functionality and support for a variety of deployment options - on premise,
cloud, and several "mix and match" offerings.

Presented by IBM Db2 Product Offering Manager Dr. Jon Lind, you will gain an
understanding of IBM's plans for the future of Db2. Whether your
organization has been running Db2 for LUW for years or weeks, or if you are
just beginning to consider Db2, this session will provide an excellent
summary of what's available today and what IBM's investment in Db2 will
deliver in the future.


Peter Kohlmann
Peter Kohlmann has been a member of the IBM database and Analytics
development and product management teams since Version 2 of Db2 for Linux,
UNIX and Windows. He is currently an IBM Offering Manager with a focus on
tools for database and data services and IBM Data Server Manager used for
the Db2 family. He was one of the original developers and designers of the
Db2 Control Center and also created the Technology Explorer for IBM Db2 open
source project. As the Db2 Release Manager he oversaw the delivery of Db2
for LUW 10.1 and 10.5 and he also directed the new technology adoption
program for Db2 pureScale Version 9.8.

Jon Lind
Jon Lind is the Db2 for Linux, UNIX and Windows Product Manager, supporting
one of the largest software products at IBM. Dr. Lind's responsibilities
include managing, positioning, marketing, and deploying Db2. He works with
customers, internal product teams and key partners to drive product
enhancements as well as the IBM marketing, sales and channel teams to
determine the various routes to market for successful product launch and
go-to-market campaigns.

Prior to this role he held various technical positions in the IBM Toronto
Lab and IBM Beaverton Lab, from technical development, project management,
technical support, to management. With his solid technical background and
broad experience in many areas of enterprise software business, Dr. Lind has
assisted customers across all geographic areas at all levels - from
development to C-level executives.

Washington Area Informix Users Group (WAIUG) Meeting
Sponsored by IBM

Date: Thursday, December 6, 2018
Time: 9:30am - 2:30pm (registration opens at 9:30am)
Location: IBM, 6710 Rockledge Drive, Bethesda, Maryland 20817
Cost: There is no cost but attendees must pre-register HERE

Session Abstracts

Docker & Informix - What can Docker do for you?
Presenter: Darin Tracy
Understand what Docker is, how it works. How to create an Informix Docker
image and best practices. Docker containerization is the first step into
using Kubernetes as a fault tolerant clustering service.

Darin began working for Informix in 1994 and continues to work for IBM now.
He has worked in the openlink support group, and the Down Systems Group and
has been with the APD (RT) group. Darin has presented at many IIUG events as
well as many internal classes to IBM support.

Informix roadmap - Where do we go from here?
Presenter: Karen Qualley
What might we expect from Informix in 5 years? Join IBM to learn about the
Informix roadmap and what the team is working on.

Informix HCL Licensing
Presenter: Karen Qualley
Information about changes and plans for the Informix licensing model from

Baltimore/Washington Db2 Users Group - sponsored by IBM

Date: Wednesday, December 12, 2018
Time: 9:00am - 3:30pm (registration at 8:30am)
Location: Hilton BWI Airport, 1739 W Nursery Rd, Linthicum
Heights, MD 21090
Fees: $30 Pre-registered and $40 At-the-door
Register: HERE

9:00am - 10:15am Optimize Db2 for z/OS with Machine Learning
using IBM Db2 AI for z/OS
Presenter: Terry Purcell, IBM
10:15am - 10:30am Break
10:30am - 11:45am Db2 12 and Continuous Delivery - What's New from
the Optimizer?
Presenter: Terry Purcell, IBM
11:45am - 12:45pm Lunch Sponsored by IBM
12:45pm - 2:00pm Automating Accelerator Batch Loads in Single
Instance Environments
Presenter: Steve Cricchi
2:00pm - 2:15pm Break
2:15pm - 2:45pm Using and Implementing the Db2 Profiles
Presenter: Joe Huang, NFCU
2:45pm - 3:30pm NFCU Db2 12 Migration Experience
Presenter: Joe Watson, NFCU

Session Abstracts

Optimize Db2 for z/OS with Machine Learning using IBM Db2 AI for z/OS
Terry Purcell, presenter
Machine learning is now prevalent in our day to day activities as it helps
us make better data driven decisions. Therefore, it makes sense to extend
that same technology to help tune performance for Db2 for z/OS. Db2 AI for
z/OS applies machine learning insights from your workload characteristics to
empower the Db2 optimizer and find better access paths for SQL queries. This
offering enables clients to see out-of-the-box CPU and elapsed time savings.
Db2AI for z/OS embeds machine learning and IBM domain expertise to provide
customized recommendations for performance tuning. Learn how Db2AI for z/OS
applies IBM Machine Learning for z/OS to better optimize Db2 for z/OS

Db2 12 and Continuous Delivery - What's New from the Optimizer? Terry
Purcell, presenter
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.

Automating Accelerator Batch Loads in Single Instance Environments Steve
Cricchi, presenter
When concurrency is not needed for warehouse applications it is possible to
use standard z/OS tools to load a Db2 Analytics Accelerator without sample
programs or 3rd party tools. See the mechanics of how to do this for a
cycle-driven process with a high degree of usability and easy job output

Using and Implementing the Db2 Profiles Joe Huang, presenter
How to implement the Db2 Profiles at your shop with real life use cases. The
presentation will show you how to configure and activate a Db2 Profile. The
components of PROFILE tables and the relationship between PROFILE and
ATTRIBUTE table. The presentation will also introduce the Navy Federal
Credit Union use cases such as: to control number of active DBAT threads, to
control IDLE THREAD TIMEOUT, bind DISTRIBUTED packages using multiple COLLID
and Simulate PROD environment in TEST to trick optimizer.

NFCU Db2 12 Migration Experience Joe Watson, presenter
Navy Federal Credit Union recently migrated DB2 to V12 from V11. The
migration occurred 'online' where production workflow continued to process
without interruption. This was a major achievement for increased system
availability / less system downtime, and the first major software
implementation of this type for NFC. This implementation also ranks among a
very few number of organizations that have done online migration. This
presentation will outline the basic concepts pertinent to the NFC DB2 system
configuration that enabled online migration to be pursued, along with
challenges that existed and the approaches to resolve them.

Presenter Bio's

Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley
Lab, where he is lead designer for the Db2 for z/OS Optimizer. Terry has 25
years of experience with Db2 in SQL Performance and optimization as a
customer, consultant and Db2 developer. Terry is an IBM Master Inventor with
more than 25 U.S. patents for database search Technology.

Steve Cricchi has over 25 years of Db2 DBA experience starting with V1.3. He
currently supports Db2 applications on V11 for a major financial

Joe Huang is a Certified Db2 DBA with 30 years of IT experience. During his
career, Joe has held several job roles in Application Programming, Db2 z/OS
system administration, IBM Mainframe System Architecture and Db2 z/OS
Database Administration. Joe is an IBM Certified Db2 V11 Database
Administrator and an IBM Certified Db2 V11 System Administrator. Joe plays
Classic Guitar and he performs at a local 5 star rated restaurant in
Northern Virginia.

Joseph Watson is a Senior DB2 database administrator with Navy Federal
Credit Union, with experience as database and system administration since
version 1.3. Joe earned Master of Computer Science degree from Howard
University; Certificate In Information Systems from George Washington
University. Previous duties include DB2 administration, IMS programming,
CICS programming, application consulting/training for EDS, Verizon, and
consulting/training for IBM including government top secret security
assignments. In a past life Joe was a science and math teacher for the MD
Montgomery County school district.

Kim May, Vice President, Business Development

IBM Champion 2009 - 2018

The Fillmore Group, Inc.

(410) 465-6335 office

(443) 956-0288 mobile

The Fillmore Group has provided technical services to clients worldwide
since 1987. Led by DB2 Gold Consultant Frank Fillmore, TFG sells IBM
software, delivers expert technical services and IBM Authorized Training.


  • image001.jpg (4.6k)
  • image002.jpg (4.4k)
  • image003.png (13.9k)
  • image004.jpg (5.4k)
  • image005.jpg (1.7k)
  • Db2 and Informix Users Groups 12.6.18 Agenda.docx (16.3k)
  • Baltimore Washington Db2 Users Group 12.6.18 Agenda.docx (365.1k)