March 28, 2019

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Sponsored By: 
UBS Hainer
Theme: 
Data Masking and Test Data Management
Agenda: 
9:00
Opening Remarks
9:05
Benefits of Attending the IDUG North America Conference – Charlotte, NC Mark Rader IBM
09:15
DB2 Data Security in a GDPR regulated world (Title is fancy, but this is all about masking)
10:30
Break
10:45
Data Masking for Db2 on z/OS
12:00
Lunch
1:00
Db2 for z/OS Transparent Data Set Encryption: Db2 11 and Db2 12 Capabilities
2:15
Break
2:30
Db2 for z/OS Data Sharing: Configurations and common issues
3:45
Wrap Up - Discuss June presentations
3:50
Raffle for UBS and IDUG 2019 pass prizes
Abstracts and Biographies: 

 

DB2 Data Security in a GDPR regulated world (Title is fancy, but this is all about masking) - Alexandros Mathopoulos DELPHIX
 

Abstract:
Enforced by the European Union since April 2018, GDPR (General Data Protection Regulation) is making many CIOs and CISOs nervous about how to deal with the data we have in our databases. As DBAs, we are responsible to ensure data we store and provision for an increasing number of non-prod environments and end-users is compliant with GDPR (and also other) regulations. The objective of this presentation is to learn what options do we have today when it comes to securely and efficiently manage data masking for DB2 in compliance with GDPR.

Bio:

Alexandros Mathopoulos is currently a Product Manager leading strategy related to Risk Data Management, New Data Sources & Platform Extensibility. Over the last several years, Alexandros has helped develop Delphix's risk data management functionality to be one of the leading solutions on the market and the fastest growing set of features of Delphix Platform.

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

Data Masking for Db2 on z/OS - Kai Stroh  UBS Hainer

Abstract:

This presentation discusses requirements for algorithms that can be used to mask personally identifiable information (PII) in QA and test environments that were populated with production data. We will have a look at how to mask names, postal addresses, e-mail addresses, social security numbers, credit card numbers, bank account details, birthdays, and other pieces of information. We will discuss how to implement the algorithms with respect to constraints in the database and in the applications. Masking algorithms must be designed so that they can run repeatedly with the same results, and must generate plausible data such as street names and ZIP codes that match the city. In addition, we will have a look at possible points in a typical test data management process where data masking can be applied.

Bio:

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. 

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

Db2 for z/OS Transparent Data Set Encryption: Db2 11 and Db2 12 Capabilities -  Mark Rader  IBM

Abstract:

Encryption of data sets on disk or tape has been available for years. Now Db2 data can be encrypted as it travels from Db2 to disk or tape and back. Encryption can be specified by the security administrator, the storage administrator, and now, with Db2 12, by the Db2 system or database administrator. This session describes the hierarchy in which Db2 interacts with RACF and DFHSM and explains the choices the Db2 administrators have

Bio:

Mark Rader

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

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

Db2 for z/OS Data Sharing: Configurations and common issues - Mark Rader  IBM

Abstract:


Db2 for z/OS Data Sharing has been available for over 20 years. Many IBM clients rely on Db2 Data Sharing for their production systems to provide continuous availability, flexible scalability, and workload balancing to their critical applications. This session describes various configurations, discusses common issues, and explores the Coupling Facility structures which Db2 uses: the Lock Structure, the SCA, and Group Buffer Pools

Bio:

Mark Rader

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