June 20, 2024

Sponsored By: 
NEDB2UG
Agenda: 
9:00
Agenda: IDUG opening remarks
9:15
Db2 Connect – What’s New and Best Practices (Chistoph Theisen, Rocket Software)
10:15
Break
10:30
Securing Db2 for z/OS Data: Encryption – and Much More (Robert Catterall, IBM)
11:30
Virtual Lunch
12:30
Ask The Developer: The Db2 for z/OS Distributed Data Facility, and DRDA (Hugh Smith, IBM)
1:30
Meeting Wrapup
Abstracts and Biographies: 

Meeting link:
https://meet.goto.com/621826589

9:15 - 10:15 AM -> Db2 Connect – What’s New and Best Practices (Chistoph Theisen, Rocket Software)

Session abstract: Db2 Connect is supposed to be a well-known topic but it is often not very well understood. This session shows the latest updates to Db2 Connect V11.5 and presents some of the best practices from conversations and interactions with customers. We cover topics such as installation, deployment, license activation, and configuration, including setting up TLS. In addition, we show why direct connectivity to Db2 mainframe servers is the preferred solution over Db2 Connect Servers, a.k.a. as Gateways.

Speaker bio: Christoph is working as Principal Solutions Advisor for Rocket Software and located in Germany. Before joining Rocket in April 2021, he worked for three decades for IBM. Starting in IBM's Global Services unit in 1991 he worked in several client engagements - the majority related to Db2 on the Mainframe - as application developer, database administrator, architect and consultant. In the last couple of years his role in IBM shifted to a Client Technical Specialist. This means that his primary focus was on making Db2 z/OS users more familiar with new features and functions but also with new analytics capabilities of Db2 for z/OS and related products.

10:30 - 11:30 AM -> Securing Db2 for z/OS Data: Encryption – and Much More (Robert Catterall, IBM)

Session abstract: How can you effectively secure Db2 for z/OS-managed data? Encryption is an important part of that story, but there's more - plenty more. In this session you'll learn about various aspects of Db2 data encryption, and you'll also learn the importance of privilege management, client authentication, column masks, row permissions. auditing, application architecture, test data management, and RACF (or equivalent) management of Db2-internal security.

Speaker bio: Robert Catterall is a Principal Db2 for z/OS Technical Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.

12:30 - 1:30 PM -> Ask The Developer: The Db2 for z/OS Distributed Data Facility, and DRDA (Hugh Smith, IBM)

Session abstract: The distributed data facility (DDF) – the component of Db2 for z/OS that handles client-server interaction with network-connected applications – continues to grow in importance for Db2-using organizations (in some production Db2 for z/OS systems, over 90% of all SQL statements processed by Db2 are associated with DDF-using applications). So, too, does DRDA (distributed relational database architecture) – Db2’s protocol for distributed database operations (DRDA requester applications typically interact with Db2 using the JDBC or ODBC APIs). Ever since Db2 Version 8 for z/OS, Hugh Smith has been a leader in the ongoing development of DDF. If you have questions about DDF and/or DRDA, here’s your chance to put those questions to the authority on the topic.

Speaker bio: Over an IBM career of almost 50 years, Hugh Smith has (among other things):

Worked on the development of SMP/E
Provided technical support for CICS
Was on the ground floor in the development of DRDA
Worked in the performance team in IBM Db2 for z/OS development, focusing on distributed database performance
Was awarded a patent for a technique to balance workloads across a set of servers
Helped to bring 64-bit addressing to DDF
Developed enhancements for data security in a DDF environment (including support for RACF PassTickets)
Helped with the introduction of the REST interface to Db2 for z/OS (an extension of DDF functionality)
Led development of MFA authentication support for DDF
Worked on extending Db2 profile table functionality to protect primary DDF workloads from applications that might otherwise over-consume connection and thread resources