Baltimore / Washington DB2 Users Group
BWDB2UG z/OS Quarterly Meeting

When? Wednesday, December 13th, 2017, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50

Meeting Schedule:

  8:30 - 9:00 Registration
  9:00 - 10:15 The Functional and Operational Considerations for Database Activity Monitoring vs Database Performance Monitoring on DB2 for z/OS
  Michael Figaro, Imperva

Most DB2 admins are familiar with Database Performance Monitoring. Some are tasked with using Performance Monitors to gather activity data for CISOs and auditors. However, there is a distinct difference between the functional and operational requirements for Activity vs Performance monitoring. We will explore these differences and how they affect DB2 sysprogs and DBAs.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Data Masking Overview
  Mike Spearns, Imperva

Data masking is a must-have addition to your defense in depth security strategy. Most organizations replicate production data to support development, testing, training and other activities, which significantly increases data breach risk. Data masking is a technology that removes sensitive data from those production copies enabling use of copy data without the associated risk. This introduction will touch on common topics, techniques and capabilities for enterprise data masking.

  11:45 - 12:30 Lunch
  12:30 - 1:45 Mine your DB2 Performance Warehouse for gold
  Robert Andresen, CA
  Use data analytics tools to examine metrics in your DB2 Performance Warehouse looking for hidden trends and festering problems. We will cover features in Excel, R and Python to help you understand what your data is telling you. Don't be overwhelmed by the sheer volume of all the data. Tame it with these tools and gain the performance insights you need.
  1:45 - 1:55 Break
  1:55 - 2:15 Db2 for z/OS Provisioning – Heavy Lifting Ahead
  Paul Bartak, Rocket Software
  System provisioning, DevOps, Continuous Delivery / Integration are all modern-day initiatives that accelerate the delivery of business applications. Each may have requirement for a copy of an entire DB2 subsystem or portions thereof to obtain full value. How do you scale your database administration staff to meet the increasing demands of application & BizOps teams, who are, in turn, pressured to meet agile delivery targets?

Today’s tools have the capabilities to clone objects and data to efficiently scale your administration teams. In some cases, these tools can use today’s fast copy technology in conjunction with DB2 page set preparation techniques to provide consistent & coherent test or production subsets. The key to fitting in to modern processing is support for REST. The next time you are asked if you can fulfill the data requirements for one of today’s delivery methods, be armed with ideas to get it done.

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

Member Registrations
Non-Member Registrations

2) To pay by check, mail the check with attendee and company name to:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117




All pre-registrations must be received by Friday, December 8th, 2017.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Sign up for Email Updates
Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
Michael Figaro is a Security Engineer for Imperva who specializes in database activity monitoring for z/OS. Michael has worked in z/OS and its predecessor OSs since 1978. This has included experience as an application programmer, DBA (IMS and DB2) and sysprog (z/OS, CICS and DB2). In 1985, Michael installed one of the first 61 GA installations of DB2 for z/OS and has concentrated mostly in DB2 for z/OS ever since.
Mike Spearns has 25 years of professional information technology experience, including several years of team leadership and mentoring in the data masking sector. He has significant field expertise with Imperva Camouflage, and is listed as co-inventor on one of the company's patents related to data masking. As a Senior Technical Specialist, Mike is responsible for working with customers to implement Imperva Camouflage solutions utilizing established best practice methodology as a blueprint for success. In addition, Mike has over 15 years of data management experience working at the senior level in the telecommunications industry. He also holds a degree in Computer Science, with a minor in Business Administration.
Robert Andresen is a Principal Consultant with CA Technologies. He has been working in performance management and monitoring for several software companies since 1997 and has been supporting mainframe systems since 1976 in various capacities including being a zOS/CICS/Db2 Systems Programmer. He is a co-author of the IBM Redbook: Linux on IBM @server zSeries and S/390: System Management. He has presented at IDUG, CMG, SHARE, the IBM zOS Conference and LinuxWorld as well as many local and regional user groups. He holds a degree in Mathematics from the Illinois Institute of Technology. He is certified as an IBM Certified Database Administrator, DB2 10 and 11 for z/OS, an IBM Certified SOA Associate and also is ITIL Foundation Certified. At CA he has been supporting their suite of Db2 for z/OS. His areas of expertise include z/OS, Db2, CICS, UNIX/Linux, Windows, and R.
Paul Bartak has been working with IBM Information Management solutions since 1985, including the first version of DB2 on MVS. As an IBM customer for 14 years Paul worked in Application Development, Database Administration, and DBA Management - working with IBM & ISV Labs on various projects. With IBM for 18 years his roles included that of a DB2 Advisor, developing the V8 V11 Migration Planning Workshops, pureXML and Temporal Proof of Technologies; and a Client Technical Leader, working across a large payments processing company and the IBM account team. Paul holds multiple certifications across Information Management and Cloud domains and recently joined Rocket Software as a Principle Solutions Advisor.