Home

Calendar
of Events

Current
Meeting
Information

Membership
Information


Meeting
Sponsorship


Officer
Information


DB2 Links

Submit
Announcements


View
Announcements


View/Download
Past Presentations

Register for
Announcements
Only

DB2 Forum 2019 First Quarter Meeting

When:
Tuesday, February 12, 2019
08:30 - 12:00 p.m.

Meeting Location:
The Original Pancake House
5220 Beltline Road
Dallas, TX 75254
(972) 385-6468



Meeting Cost: $10 for non-members, free to members. Membership is $25 per year per person --or-- $100 for 5 people in a company --or-- $350 for unlimited people in a company. You can register at the meeting.



This meeting is sponsored by UBS Hainer GmbH.


First Speaker
Kai Stroh - UBS Hainer


Presentation Overview
Test Data Masking
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.


Speaker Biography


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.

Second Speaker
Kai Stroh - UBS Hainer


Presentation Overview
Copy Smarter

When you get tasked with setting up a refresh process for thousands of Db2 z/OS tables you probably have a few thoughts running through your head: How long does it take to create all the required jobs? How long for all the control cards? Do all the target tables exist, or are there any new tables in production? Have tables been changed? Better double check if the tables have grown or if Db2 has added more VSAMs so that you don’t run out of space halfway through like last time. Don’t forget catalog statistics and RTS. And those identity columns and sequences - they’re always trouble. What seems like little bits and pieces at first can really stretch your staff thin, which is why automation is key if you want to save time and energy. This presentation discusses advantages and disadvantages of different utilities that copy Db2 data, but the main focus is automating all the side tasks that DBAs usually need to do in addition to copying the data itself.

Speaker Biography

See above


Third Speaker
-


Presentation Overview




Speaker Biography