Mid-Atlantic Db2 LUW Users Group - Winter 2019
IBM Bethesda Tech Training Rooms
6710 Rockledge Dr.
Bethesda, MD 20817
9:30am -10:30 SESSION 1
My Favorite Db2 Problem Determination Tricks presented by Pavel Sustr
10:30 -1045 BREAK
10:45 -11:45 SESSION 2
IBM Cloud Pak for Data presented by Brad Rowen
11:45 - 12:45 - Networking Lunch
12:45 - 1:45 SESSION 3
Table Space Odyssey presented by Pavel Sustr
1:45 - 2:00 BREAK
2:00-2:45 SESSION 4
Db2 Augmented Data Explorer Demo by Kay Groski
Senior Software Engineer with IBM Db2 LUW kernel development. Always thrilled to work on hard-to-crack puzzles. Expertise in Db2 LUW kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and the assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the Db2 team, Pavel spent years in Db2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to Db2 LUW kernel development where he became Senior Software Engineer and later Development Manager for multiple core Db2 kernel components. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX.
My Favourite Db2 Problem Determination Tricks (1 hour)
As a member of the Db2 LUW development and support team, Pavel uses Db2 problem determination techniques on a daily basis. Whether it is problems reported by test teams, related to his newly written code (rarely happens ;-), or tough customer reports from the field, there are techniques that can lead to a problem resolution more quickly. This session presents some less known or in some cases undocumented tricks and hidden gems that might help the user troubleshoot Db2 issues and even build their reputation as a serious Db2 hacker/insider.
Present less known problem determination techniques
Understand the diagnostic data returned by the techniques
Discuss the best use cases for the individual techniques
Master shortcuts leading to problem resolution
Get an insider view of problem determination techniques used by the IBM Db2 team
Brad Rowen is a Hybrid Data Management specialist for IBM, with deep experience in system and database administration and managed services on distributed platforms.
Feeding Data to your enterprise is a lot like feeding a family. How do you feed a growing enterprise, NOW, with governed data that you know will keep them healthy and give them what they need to operate and innovate? How do you get them collaborating and working together? By getting data engineers, data stewards, data scientists and users of all kinds working from the same modern platform, Cloud Pak for Data.
Table Space Odyssey (1 hour)
Db2 storage de-mystified. DMS, SMS, Automatic Storage table space internals. Default table space types across different Db2 editions and versions. Best practices. Container structure, naming conventions, internal architecture. Buffer pool considerations. Storage paths, auto-extend mechanisms, automatic striping. Parallelism vs. performance discussions. Common high watermark issues, reclaimable (object-relative) vs. non-reclaimable (pool-relative). Explanation on current deprecation statements, upgrade paths and considerations. Common tooling and tricks to deep dive into the storage components (db2dart, db2pd, and others).
Understand the current table space types
Learn about the best usage practices
Clarify the current deprecation statements
Reveal the internal design of Db2 storage