Session Details

The current generation of Db2 DBAs need to pass their knowledge of their companies Db2 environments and how to successfully make changes that meet company standards while avoiding performance pitfalls. In this session attendees will hear how leading companies are taking this knowledge and using it in DevOps automation to ensure fast and accurate Db2 schema changes. The presenters will also cover Db2 Database DevOps for application developers where SQL in applications can be passed through an automated QA process ensuring that the next generation of developers don’t have performance issues with their applications. This session is applicable to DBAs using BMC, Broadcom, and IBMs tools for managing changes to Db2.
Attendees will leave this session understanding:
A. How DBAs can reduce toil and errors by embracing Database DevOps
B. How Db2 Database DevOps can help keep Bad SQL from reaching production
C. Opportunities available to develop a custom solution by leveraging products from BMC, Broadcom, and IBM
D. If your application developers are pushing to be able to manage DDL in development what you will need as a DBA to manage that process

Speaker Bio

Tad Whitten started with BMC Software in 1997. In his current role he works to promote a common code and feature set between Catalog Manager and Command Center and is working to promote other BMC Db2 products integration in Command Center. He is a developer on Catalog Manager, AMI DevOps for Db2 and provides server side support for Command Center.
Tad started his career at BMC on the JCLGEN/Execution team. Later he became a developer on PDB Change Manager and SmartDBA where he took on the lead role of integrating SmartDBA with backend components found in Change Manager. He started working on Catalog Manager in 2001 where he became the lead developer and eventually the Product Architect for Catalog Manager. He has been the Architect and lead on Command Center since its inception in 2010.
Prior to BMC, Tad worked as a Technical Lead Developer at CSC where is supported the applications developers in the life insurance division.
Tad holds a Bachelor’s Degree in Computer Science and Finance from Texas Tech University.

Deploying an existing Db2 LUW Linux Database to OpenShift, Kubernetes, or Cloud Pak for Data usually involves some form of export and import and a lot of work! The new Click to Containerize (Db2 Shift) tool moves your on-premises database directly to the Cloud – with no exporting of data! The tool can also migrate your 10.5, 11.1 and 11.5 database directly into a Db2 container with no additional effort. This session will take you through the IBM Db2 C2C program and how it can help modernize your Db2 databases quickly and efficiently!

Speaker Bio

George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent many years in IBM working on various aspects of database technology. In 1991, George was part of the team that introduced the Db2 distributed product to the market. Since this time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support for the Db2 product.

Db2 has grown tremendously over the years and there have been bits and pieces added on that are either odd, strange or exotic which not many people use or have even heard about. This presentation will describe a few of my personal favourites in the area of esoteric functions. I wish to cover FTB/FIT (not so much esoteric as very interesting!), Spatial Index’s, XML (with regular expressions) , Clone Tables and Scrollable Cursors.

Speaker Bio

Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc. He specializes in Db2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24×7 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 realworld recovery pressure. His activities cover EMEA, as well as North America. As a member of SOFTWARE ENGINEERINGs Request Board he’s working closely with customers and the development labs.

Understanding and administering IMS is complex to say the least. Many IMS customers are already faced with, or will soon be faced with, the loss of experienced and trusted IMS skills that have kept applications running on IMS smoothly for years. Come see the new web browser interface that is shared with Db2 which will make the experience of understanding and administering your IMS environment much easier and allow you to become proficient more quickly. We will also cover automation for monitoring of IMS databases to understand reorg and recovery issues, allowing you to easily visualize the issue and proactively manage your IMS databases.

Speaker Bio

Tracy Dean is an IBM Product Manager, responsible for IMS Tools and z/VM Tools. With over 37 years of Z experience, she works with customers worldwide to understand their pain points and drive development teams to address their needs.
Ron Bisceglia is a Distinguished Engineer and Principal Architect responsible for the design, development, and support for primarily the suite of IMS Tools. He has worked with IMS for over 30 years and has been involved in the development of database reorganization utilities, database propagation tools, database monitoring and analysis solutions, data replication, backup and recovery, and administration products.

In the first part of this presentation, we will cover various topics and user experiences with Db2 sort. These include finding and diagnosing Db2 sort problems, as well as long term thoughts and solutions on dealing with sorts which consume all of the sort space. We will discuss automated solutions to this sort problem and the problems that presents between 4k and 32k. In the second part of this presentation we will be discussing various topics centered around DDF. We will cover dealing with applications which create connections that aren’t complete DRDA connections and the DOS like outcome that can produce. We will also cover user experiences (both good and bad) from an upgrade to the latest version of the Db2 drivers, v11.55, where many issues were encountered and had to be dealt with.

We will review the highlights of the DB2 native encryption capability for data-at-rest, including encrypted backup and restore, performance, and best practices.

Speaker Bio

Nataliya Prokoshyna is a software developer for Db2 LUW at the IBM Canada Lab. As a senior member of the Db2 security development team, Nataliya has worked on authentication, authorization, auditing and encryption, PSIRT, and other aspects of security within Db2.

With the rise of popularity of REST APIs in the z/OS world, IMS shouldn’t be left behind. In this presentation, we will go through different approaches on how to develop REST applications accessing IMS resources with a deep dive into transforming IVTNO transactions into REST API. We will also cover the possibility of onboarding such API into the Zowe ecosystem.

Speaker Bio

Vaclav is IMS tools developer and occasional sustaining engineer at Broadcom. He likes to inject simplicity and straightforwardness into mainframe applications.

IMS DB – 101: This session is an overview of the Database features of IMS that many companies use for their highest volume and business critical processing. A description of IMS Databases Structures, Access methods and activating Resources is presented. How are databases built? How are application programs defined? How are Programs and Databases separated from IMS so rewriting of application resources is unneeded. All answered here. We will also examine IMS features and capabilities for modernization, such as the IMS Catalog and management of IMS metadata, database versioning support including both the HALDB Alter and DEDB Alter Functions with IMS 15, IMS Managed ACB support, and the implementation of Data Definition Language (DDL) Statements to update IMS resources and schemas. Help yourself and learn how business keeps up with today’s availability requirements.

Speaker Bio

Dennis has over 45 years of experience with ‘mainframe’ operating systems and database systems experience. He has worked as a developer, a consultant, business partner, competitor and vendor to IBM. Dennis is currently a member of the IMS Support team of the Washington Systems Center. His spare time is spent practicing the Gentle Way.

Every new release of Db2 has provided numerous new features and many of these features have to be reflected in the catalog. This presentation will do a detailed comparison between Db2 12 FL500 and Db2 12 FL510 and Db2 13 FL100 in order to understand all the differences.

Objective 1: New and modified objects between the three Function levels.

Objective 2: Existing columns with new content.

Objective 3: Misc. items like usage of Temporal Tables and other valuable topics

Speaker Bio

Steen Rasmussen is a Customer Services Consultant currently instrumental in the ongoing development and support of the Broadcom Db2 solutions. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 – like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.
Steen has been working with DB2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the Broadcom DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at Broadcom working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Since 2014 Steen has been an IBM Champion. Steen has also been the Broadcom liaison for IDUG NA since 2013.

Optimal query access plans are essential for good data server performance and it is the query optimizer’s job to choose the best one. However; occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down; due to a poorly-performing query; and there isn’t time to implement best practices. When these situations arise; Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again; quickly. Optimization profiles can specify various aspects of an access plan; can control automatic query rewriting or can control the optimizer’s plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.

Speaker Bio

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2; Db2 Warehouse; Db2 on Cloud and Db2 Big SQL. John also works closely with customers to help them maximize their benefits from IBM’s relational DB technology products.

In this session the speaker will cover basic Db2 topics that developers are being asked to perform that have traditionally been the role of DBAs. We will cover the Db2 Catalog and how to find information related to the Db2 objects that are part of the development environment and what it takes to perform those tasks. Topics will include:

• Where to find Db2 CREATE, ALTER, and DROP syntax and how to understand the railroad diagrams necessary for to build that syntax.
• How to quickly get data into your Db2 tables for testing
• How to setup performance statistics so you can EXPLAIN your SQL statements. Then a quick overview and how understand the data in the PLAN_TABLE in order to build in performance to your SQL statements.
• How does DevOps and Shift-Left impact todays Db2 developers?

Attendees will leave the session understanding:

• Options available to perform simple Db2 related tasks like CREATE, ALTER, and DROP
• Where to find manuals and help for Db2 related topics
• How to diagnose and resolve some of the more common Db2 errors
• How to be a better Db2 application by understanding some basic Db2

Speaker Bio

Tad Whitten started with BMC Software in 1997. In his current role he works to promote a common code and feature set between Catalog Manager and Command Center and is working to promote other BMC Db2 products integration in Command Center. He is a developer on Catalog Manager, AMI DevOps for Db2 and provides server side support for Command Center.
Tad started his career at BMC on the JCLGEN/Execution team. Later he became a developer on PDB Change Manager and SmartDBA where he took on the lead role of integrating SmartDBA with backend components found in Change Manager. He started working on Catalog Manager in 2001 where he became the lead developer and eventually the Product Architect for Catalog Manager. He has been the Architect and lead on Command Center since its inception in 2010.
Prior to BMC, Tad worked as a Technical Lead Developer at CSC where is supported the applications developers in the life insurance division.
Tad holds a Bachelor’s Degree in Computer Science and Finance from Texas Tech University.

IMS TM 101 – This session is the first of two primer sessions for new IMS professionals and managers. The session is an overview of the structure of the transaction management, application environment, and communication capabilities that allow the development and processing of wide range of high-volume and rapid-response interactions along with the ability to geographically disperse your data processing applications while keeping centralized control of your database.

Speaker Bio

Suzie Wendler is a member of the IMS team – Washington Systems Center. Over the past several years, her major responsibilities have included areas such as customer support, design implementations for IMS connectivity and, most recently, integration projects in support of the API economy. She has been with IBM supporting IMS for 35 years and prior to that was a customer for 10 years in the systems and application areas.