Central Ohio Db2 User Group
The official CODUG web site.
Like us on Facebook
Search CODUG.org:


CODUG Leaders 

Subscribe / Membership 

All Presentations / PDFs


Meeting May 21, 2020 via WebEx
10:00 - 10:15 am (Eastern time) Welcome and Introductions. Bill Moran (BMC)
10:15-11:15 Partitioned Tablespace Overview
Presented by Frank Rhodes (BMC)
11:15-12:15 Access mainframe Db2 using z/OS Connect EE RESTful APIs and Db2 REST services
Presented by Randy Black and Andy Johnson (Nationwide)
12:15 - 1:15 Db2V12 Update Updates (includes Db2V11 update as well)
Presented by Mark Rader (IBM)
1:15 - 2:00 Q&A (This is with CODUG, MDUG, and NEODbug!)

Partitioned Tablespace Overview

Discuss the different types of Db2 Table Spaces; Simple, Segmented, LOB, XML, Index Controlled Partitioning, Table Controlled Partitioning, Partition by Growth, Partition by Range

High level overview of how they organize data for the Tables stored within them. DDL needed to create them. When were some of them deprecated. What does using a deprecated Tablespace mean to you? What is DB2 pushing as the standard for Tablespaces and what are the advantages of adopting what Db2 is pushing?

About the Speaker - Frank Rhodes (BMC)
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. The products that he has primary responsibility for are ALTER for DB2, Change Manager for DB2, Catalog Manager for DB2, DASD Manager Plus for DB2, NGT STATS, NGT Utility Manager, Workbench for DB2 as well as BMC AMI DevOps for Db2.

Frank was a Developer on the Change Manager for DB2 product for over 10 years. His main areas of responsibilities being the development and maintenance for the Analysis Engine as well as the productís user interface. Prior to joining the Change Manager Product team, he worked on the TIS Install for the Administrative products. He was the lead developer in charge of the initial implementation of a common install for all the DB2 products.

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.

Frank holds a Bachelorís Degree in Computer Science from the Texas A & M University.

Access mainframe Db2 using z/OS Connect EE RESTful APIs and Db2 REST services

A deep dive into the world of Db2 APIs and REST Services. We will see some exciting demos using Db2 APIs and walk through the simple process of creating a Db2 RESTful API using z/OS Connect EE.

About the Speakers - Randy Black and Andy Johnson
Andy Johnson - Johnsoau@Nationwide.com

  • Application DBA for the past 8 years
  • Specializing in IDAA and Db2 REST services/zOS Connect
  • Mainframe Developer for 12 years prior
  • Worked with DB2 and IMS

Randy Black - blackr3@Nationwide.com

  • Application DBA for the past 25 years
  • Specializing in IDAA/Db2 REST services/zOS Connect & SQL Performance
  • Mainframe Developer for 10 years prior
  • Worked with COBOL and DB2

Db2 v12 Update Updates (includes Db2 v11 update as well)

Db2 12 for z/OS has been generally available for 3.5 years and many customers are running Db2 12 in production. New features and functions continue to be delivered, plus new information about migration experiences and recommendations are available. This session will summarize all of this information, as well as identifying function that has also been included in Db2 11.

About the Speaker - Mark Rader
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, and over 31 years 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.

Directions -- Register for WebEx meeting here: reservations@mdug.org

CODUG Home | Meetings | CODUG Leaders | Subscribe / Membership | All Presentations / PDFs | CODUG Home  2018 by Central Ohio Db2 User Group. All rights reserved.

Created: 6/18/2018 / Changed: 5/11/2020 10:27:08 PM

We are the Central Ohio Db2 User Group in Columbus, Ohio. paul@nationwide.com.