Sept 10th, 2018 Meeting

This September we host Craig Mullins, Mullins Consulting; Bob Bersano, Rocket Software; and Kai Stroh, UBS Hainer.
Here is our agenda for the September 10th meeting:
8:00 to 8:30 am Check in
8:30 to 8:45 am IBM
IBM Announcements – Terri Kemmer, IBM
8:45 to 10:00 am – Craig Mullins
It’s Not Your Daddy’s Db2
10:00 to 10:15 am Break
10:15 to 11:30 am – Craig Mullins
The Top Ten Db2 Things You Need to Know: For DBAs and Developers
11:30 to 12:30 pm Lunch
Catered lunch in room across from presentation room
12:30 to 2:00 pm –  Bob Bersano, Rocket Software
Db2 Recovery Simplified with considerations for GDRP
2:00 to 2:15 pm Break
2:15 to 3:30 pm – Kai Stroh, UBS Hainer
Exploit DB2’s Log
3:30 to 3:35 pm Stefan Kolev, President
User Group Announcements

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

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

Follow Craig on Twitter at @craigmullins

Bob Bersano began his career as a mainframe software developer back in 1986 and has worked with IBM Db2 since version 2.1.  Bob has designed and developed many different enterprise Db2 tools handling data migration, log analysis, security and backup and recovery.  Bob joined Rocket Software in 1995 as a Senior Software developer to design and code a new database backup and recovery product that would exploit fast replication technology.  Bob has recently moved into a role as a Senior Solutions Advisor supporting customers with backup and recovery and log analysis products.  He is currently based in Chicago, and is an alumnus of the University of St. Francis with a bachelor’s degree in Computer Science.
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 internals and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations. 
It’s Not Your Daddy’s Db2
Db2 for z/OS is always changing, adding more features and functionality… and discarding old stuff, too. If you are still using Db2 the same way you did 20 years ago, or even 10 years ago, you are probably doing things wrong! This presentation takes a look at how things are changing, not just with Db2, but also with IT and the industry. It is delivered in two parts: first looking at industry and DBA trends, and then looking at some of the specific changes made in the past few versions of Db2 that should impact how you use Db2.
Topics include:
*  Industry & DBA Trends
*  Db2 Modernization including coverage of database design, security and development trends.
*  Some Guidance on how to move forward
The Top Ten Db2 Things You Need to Know: For DBAs and Developers
 There is a veritable boatload of information and details about DB2 for z/OS available to you. But can you digest all of it? Wouldn't it be nice if you could focus on the things that were the most important for you to know instead of wading through thousands of pages of manuals, web pages, and presentations? This session will distill the essence of what you need to know into the top ten most important issues for the two biggest categories of DB2 users: application programmers and database administrators. This presentation offers a count down the top ten most important things you need to know. Along the way we will uncover what is most important for DBA, developers, and managers to understand about Db2 for z/OS. If you are interesting in understanding the hierarchy of Db2 performance tuning objectives, and moving further along in your mastery of Db2 performance, this this presentation will help.

Db2 Recovery Simplified with considerations for GDPR
Db2 recovery can be complex and only a small fraction of users will practice any type of recovery scenarios on a regular basis.  Recovery scenarios can range from recovering a single object to recovering a complete Db2 system.  It seems that whenever a request for recovery ends up on a DBA‘s desk, it‘s always at the most inconvenient time because more and more  DBA teams seemed to be understaffed.  The majority of time in a recovery exercise is spent analyzing what has happened and which objects need to be recovered.
There are a lot of utilities available in Db2 for z/OS that can help you with recovery.  In order to use these utilities at the right time and in the most efficient way, it requires a lot of expertise and experience to execute the steps in the correct order in a situation that normally comes with some pressure. 
On May 25th of 2018 GDPR will take effect.  GDPR is designed to unify data privacy requirements across the European Union (EU) so if your company processes the information of EU Data Subjects (which include end users, customers and employees) you will need to make sure you address these key requirements.  While this guideline certainly provides room for interpretation, it may result in an auditing requirement to prove that certain data or particular applications can be recovered within a given period of time.  

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

Member Fees

The membership fees for 2018 have been eliminated.
Please Note:  Register promptly on Eventbrite to ensure correct headcount for our catered lunch

Meeting Location
A reminder that our meetings are held at Kansas University -
Edwards Campus, Regnier Building at 127th and Quivira in Overland Park.
*** Please note this is the Regnier Building at KU-E, NOT the ***
*** Regnier Building at Johnson County Community College. ***
Kansas University - Edwards Campus
12600 Quivira Rd
Overland Park, KS 66213-2402

Maps and directions are available here:

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.

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

Post a Comment

Group Tools

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

Computer Humor Slideshow
Just for fun!

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

Blog Archive