Wisconsin Db2 Users Group
Log in

March 2020 WDUG meeting

  • 03/11/2020
  • 8:30 AM - 4:30 PM
  • Aurora Medical Center, 36500 Aurora Dr, Summit, WI 53066


  • Registration for z/OS Sessions for non-WDUG members.

Registration is closed

Meeting Agenda – March 11, 2020

8:45-  9:15
Registration – Coffee, juice and rolls 

DB2 for z/OS

9:15 - 10:30 Db2 for z/OS and data set encryption (Mark Rader, IBM)

Db2 for z/OS supports data set encryption as part of pervasive encryption on the Z platform. This session discusses the Db2 changes and the roles that participate in encrypting sensitive data. Included in this discussion are the new Db2 features that allow Db2 staff to specify key labels for encryption, as well as positioning data set encryption relative to other options for encrypting Db2 data.

Mark Rader is a Db2 for z/OS specialist in the IBM Washington Systems Center. He has over 36 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, SHARE, IBM Technical University 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.

10:30 - 10:45 Break

10:45 - 12:00 Db2 12:  How do I keep up with this stuff ?? (Michael Cotignola, BMC)

We’ll take a quick look at the usual suspects:
Reliability, Availability, Scalability, Security
But… we can’t forget about:
Analytics, Autonomics, Cloud, Mobile, Machine Learning…

12:00 - 1:15 Lunch - On your own

1:15 – 2:30 How Can Db2 DBAs Get Agile ?  (Frank Rhodes, BMC)

In this session, Frank will cover:

Understand the need for Db2 for z/OS DBAs to participate in agile deployment of applications.
Discuss how to automate and speed up the process of validating SQL changes before they are promoted to production.
Discuss the issues around schema changes associated with application deployments.
Understand why the communication of outage and impact information is so important.
Discuss the importance of test provisioning for Db2 for z/OS in a DevOps environment.

Frank Rhodes started with BMC Software in 1995.  In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products, like BMC AMI DevOps for Db2.
Prior to BMC, Frank worked as a Systems Programmer for IBM in support of NASA JSC’s administrative processors.  He supported installation and maintenance of MVS products and oversaw implementing Automated Operation for IBM’s internal systems as well as NASA’s systems.

2:30-2:45 Break

2:45 - 4:00  Know your limits!  (Ulf Heinrich, SEGUS)

In this presentation I will show and explain the current number of limits within Db2 on z/OS starting with relatively basic simple things like DSSIZE or PIECESIZE. Moving on to Linear Dataset limits (32 for Segmented spaces, 254 for LOB ) we then will have a quick look at how the COPYPOOL is looking before diving off to the world of PBGs where you must be aware of MAXPARTIONS among other things. Then we will review SEQUENCES and Numeric Primary Key usage before finally delving into the abstract limit of Db2 within the Db2 engine including DBATs etc.
Presentation items:
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
5. SEQUENCES and Numeric Primary Key usage
6. Abstract limit of Db2 (DBATs etc.)

Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24x7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real world recovery pressure. His activities cover EMEA, as well as North America through SE’s U.S.
subsidiary, SEGUS Inc. As a member of SE’s Request Board he’s working closely with customers and the development labs.

Powered by Wild Apricot Membership Software