Db2 for z/OS Track
Agenda for March 14, 2023
|
Time is CDT
|
Db2 for z/OS Topics
|
Speakers
|
|
8:45 AM – 8:50 AM
|
Introduction
|
Scott Follmer, Cigna
|
|
8:50 AM – 9:00 AM
|
IDUG News
|
Chris Muncan/Dustin Ratliff, IDUG
|
|
9:00 AM - 10:00 AM
|
Db2 Connect Packaging, Configuration, and What’s New
|
Jørn Thyssen, Rocket Software
|
|
10:00 AM - 11:00 AM
|
Monitoring Db2 Connect with Db2 System Profile
|
Paul Bartak, Rocket Software
|
|
11:00 AM – 12:00 PM
|
Db2 Java Performance Best Practices Version 10
|
Dave Beulke, Dave Beulke & Associates
|
|
12:00 PM - 01:00 PM
|
Db2 z/OS 12+13 Database and Application Performance: Features and Usage
|
Susan Lawson, YL&A
|
|
01:00 PM – 02:00 PM
|
Examples of Db2 Mistakes for Others to Avoid
|
Sheryl Larsen, Kyndryl
|
To CONNECT for the March 14th Meeting:
Please join the meeting from your computer, tablet or smartphone.
https://meet.goto.com/778316453
You can also dial in using your phone.
(For supported devices, tap a one-touch number below to join instantly.)
You can also dial in using your phone.
United States (Toll Free): 1 877 309 2073
United States: +1 (646) 749-3129
Access Code: 778-316-453
Get the app now and be ready when your first meeting starts: https://meet.goto.com/install
WEB Access: If you are not able to download “goto meeting” software onto your laptop, you can use their web site:
https://www.gotomeeting.com/meeting/join-meetingTopics:
Db2 Connect Packaging, Configuration, and What’s New
IBM encourages Db2 customers to move away from Db2 Connect Servers and "fat" Db2 Clients towards more lightweight Db2 Data Server Driver packages. This presentation will help you select which Data server Driver package to install and how to easily configure it for Db2 for z/OS connectivity. We will also cover recent significant enhancements related to Db2 for z/OS connectivity.
Speaker Bio
Jørn Thyssen, Principal Solutions Advisor, IBM z Data and AI
Jørn Thyssen joined Rocket in 2017 as a Solutions Advisor specializing in Db2 tools bringing in 16 years of experience working with IBM z technology and Db2 for z/OS. He specializes in mainframe modernization, Db2 administration, and Db2 performance supporting customers across the world. As a Solutions Advisor he works with customers from their initial interest in a solution all the way to a successful deployment and beyond. He also helps R&D with designing and validating innovative solutions for modernization, hybrid cloud, and AI.
Jørn started his career at IBM and held several positions starting as application developer, later application DBA and architect, before working many years as a technical sales specialist supporting mainframe customers in the Nordics.
Jørn is also a 2022 IBM Champion and has presented at many Db2 and mainframe user groups, IBM conferences, and IBM webcasts.
Monitoring Db2 Connect with Db2 System Profile
Isn’t it nice when you already have something needed to accomplish monitoring tasks? When it comes to Db2 Connect, you do. The Db2 System Profile Facility, which has been in Db2 for z/OS for at least 5 releases now can help. This presentation will cover the primary use cases with some specific examples. It will also highlight how this facility can help with other configuration and customization use cases.
Speaker Bio
Paul Bartak, Principal Solutions Advisor, IBM z Data and AI
Paul Bartak is a Distinguished Engineer with Rocket Software, focused on the tools used to maximize z/OS platform value, with an emphasis in database administration & cloning, DevOps processes and modernization. He supports multiple Db2 User Groups, has been a speaker at several IDUG, IBM Z Day, and Insight/Think conferences, is a Redbook/Redpaper author, and IBM Champion.
Db2 Java Performance Best Practices Version 10
This presentation details Db2 and Java performance best practices and discusses how to get your processing done 32x faster. Db2 coding best practices, java class frameworks and debugging/tracing practices will be presented that can immediately identify your performance bottlenecks. After this discussion you will be able to dramatically improve your Db2 access, Java runtimes, minimize CPU and quickly access billions of rows with the best performance possible.
- Understand the Db2 coding best practices to enhance performance, avoid problems and enhance debugging.
- Realize all the application coding options and java class frameworks that can help and hinder performance.
- Realize the debugging methods available, the java tracing tools and the easy and fast best practices to find performance issues.
- Understand the standard performance characteristics and special java statistics to monitor to determine quickly whether a performance problem or improvement opportunity exists.
- How to bring some of these java performance tuning best practices to your shop and enhance your standard development procedures.
Speaker Bio
Dave Beulke, Lifetime IBM DB2 Information Champion, President – DAMA-NCR, IBM Gold Consultant
Dave Beulke is a system strategist, creative database designer and performance expert who excels at solving complex problems and finding performance solutions for difficult processing issues. His decades of consulting has exposed him to a variety of systems, databases, and application issues and gives him deep technical expertise, database design experience and problem solving insights. His client performance tuning successes, security audits and database designs supporting billions of rows and 10s of millions of daily transactions are highlighted in his frequent presentations at international and national conferences, seminars and blogs.
Db2 z/OS 12+/13 Database Design and Application Performance: Features and Usage
With every new release of Db2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in Db2 12 (+FLs) and 13 that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features (including those in the most current function level) that can be utilized by DBAs and application programmers.
Speaker Bio
Susan Lawson, Principal Owner and Technical Consultant, YL&A
Susan Lawson is an internationally recognized consultant and lecturer with a background in Db2 z/OS system and database administration for 34 years. She works with several large clients to help design, develop, implement, and tune some of the worlds’ largest and most complex Db2 z/OS databases and applications. She also performs performance/availability audits and health checks for many clients to help reduce costs through proper performance tuning and to help ensure availably, stability and scalability. Her other activities include authoring books, articles, and white papers, and developing/teaching a variety of advanced database and application courses. She is an IBM GOLD Consultant and an IBM Champion.
Examples of Db2 Mistakes for Others to Avoid
It may be one summer, collection, package or one query brings your CPU to its knees. These are the war stories that I will cover so you can learn from others’ mistakes. Examples of seriously delayed filtering, not following performance rules, checking to see if Db2 is up, and many other tricky but painful techniques will be divulged.
Speaker Bio
Sheryl Larsen, zCloud Sales Representative
Sheryl is the zCloud Sales representative for Kyndryl. Previously she worked for BMC, IBM, Sheryl M. Larsen, Inc., and Platinum Technology (now Broadcom). She is known for her extensive expertise in SQL Tuning and has performed detailed Db2 Performance Health Checks for 42 Fortune 500 clients. Sheryl has over 30 years’ experience in Db2, has published many articles, white papers and co-authored a book, Db2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest Db2 User Group, an IBM Z Champion, and a member of the Northern Illinois University Computer Science Alumni Council.