Meeting Agenda – Sept 16, 2020
Introduction for the STLDUG, WDUG, MWDUG, Twin Cities
9:00 - 10:00
Db2 Resiliency Models—What Real Customers Are Doing
Dale McInnis, IBM
In this presentation we will detail several DB2 resiliency patterns that customers have deployed. We will review the customer’s requirements, discuss alternatives and detail the final architectural chosen outlining both the pros and cons. Monitoring is key to success in building a resilient environment this we will detail what needs to be monitored.
Speaker Bio: Dale McInnis is a Certified Executive Technical Sales Specialist from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering (M.Eng) from the University of Toronto. Dale joined IBM in 1988, and worked in the DB2 development team from 1992 - 2014. Dale's area of expertise includes DB2 for Linux, UNIX and Windows Kernel development, where he led teams that designed the current backup and recovery architecture and other key high availability and disaster recovery technologies. He has obtained eleven (11) patents in the area of database resiliency. Dale is a popular speaker at the International DB2 Users Groups (IDUG) conferences worldwide, as well as DB2 Regional users groups and IBM's Information On Demand (IOD) conference. His expertise in the area DB2 availability area is well known in the information technology industry. Dale spent 10 months as the IBM Cloud Data Services Chief Availability Architect, and now Dale is now on the North American Data and AI Technical Sales team.
10:00 - 11:00
DevOps for Db2
Ken Shaffer, Aerodata
How do we keep up with the demands for rapid deployment in an Agile environment? Our customers need multiple Development and test environments that can be stood up and torn down quickly and efficiently. Clearly the old “Build by hand” methods are not going to cut it any longer. In this presentation, we will discuss some automated and modern methods and tools to install, configure, and position Db2 to support rapid DevOps style environments. Most cloud-native examples show a simple, micro-service. This is the trivial case, we have fully built-out, complex applications to deploy!
Perhaps our environment uses tooling like Chef to build out infrastructure. What pitfalls await us? What other tools will we need to install, buy, configure and learn? How do we handle things like userids and passwords?
What about Containers? Sure, installing a Db2 Docker image is easy. But, what then? How do we make this fit into our current Db2 Universe.
What about all the other Db2 features like HADR, DPF, etc. How do we make all this work?
Speaker Bio: Ken Shaffer has been a DB2 Consultant for over fifteen years, specializing in LUW systems. He has worked on a variety of large databases for large corporate and government clients. Most of these projects have involved deploying and supporting mission critical applications where constant availability and high performance are required. Ken is a Db2 Gold Consultant, and an IBM Champion. He has presented multiple times at IBM's IOD/INSIGHT/WoW and at several IDUG conferences. He started working with DB2 on the mainframe, somewhere around the v2.2 timeframe. However, those details have become a bit fuzzy… He returned to the Db2 world around the time that V8 for LUW was introduced. In between, Ken was a COBOL / SQL developer and a C/C++ programmer. His frustration with non-existent specifications and poor Software Development practices drove him to the relative comforts of UNIX system administration, where he spent ten years supporting every flavor of UNIX except AIX. (His LUW experience has remedied that deficiency!).
11:00 - 12:00
Storage Basics for Db2: Faster I/O, Fewer Headaches
Ian Bjorhovde, Xtivia
I/O is at the heart of every database system. Understanding how Db2 reads from and writes to disk is critical to ensuring high performance. Therefore, DBAs must have a strong working knowledge of the storage that supports their database. This session covers the basics of storage from both a Db2 perspective and an operating system perspective. Learn what to consider when requesting storage; how to lay out the file systems on your server; what metrics to use to monitor database I/O performance and how to diagnose I/O problems.
Speaker Bio: Ian Bjorhovde is the Lead Db2 DBA and Delivery Manager for XTIVIA, and is based in Phoenix, Arizona. He has spent over 20 years as a consultant developing and supporting large and small Db2 databases for clients in many different industries. Ian is an IBM Gold Consultant and IBM Champion. He volunteers for the International DB2 Users Group and holds numerous DB2 certifications. He co-hosts The Whole Package Cache Podcast, and has presented at many RUG, IDUG and IBM conferences around the world.
12:00 - 1:00
Db2 BLU: Maximizing the Potential of Data
Sanoop Nambiar, IBM
Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. This session will provide you with tips, tricks, and best practices to manage and access your data effectively using Db2 BLU. This includes maximizing compression, minimizing storage space, and increasing performance while populating tables and executing analytical queries. Attend this session to learn how to maximize the effectiveness of Db2 BLU.
Speaker Bio: Sanoop Nambiar is an advisory software engineer at the IBM Silicon Valley Laboratory and one of the technical leaders for Db2 with BLU Acceleration with deep knowledge in the areas of storage, compression, and memory management. Db2 with BLU Acceleration is the common database engine technology used in Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 Warehouse on Cloud, and IBM Integrated Analytics System (IIAS). Sanoop has developed features for page-based string compression, reorg table reclaim extents, and dictionary eviction to reduce memory consumption.