Tri-State Db2 Technology Exchange
Db2 Users Group
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Historical Monitoring
Session abstract: Introducing db2histmon, the newest addition to the family of problem determination tools. This lightweight technology allows you to collect historical data on your database, helping especially with performance or workload problem root cause analysis even for past occurrences, greatly reducing the need to recreate the problem with additional trace techniques enabled.
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 – Ready for modernized deployments and workloads
Session abstract: There are two major modernization dimensions. Modern deployments and modern workloads. Iin this session we will discuss what Db2 is doing to help our clients modernize their deployments and to ensure Db2 is ready to handle modern workloads. This will include Db2’s investment in multi-model, NoSQL, mixed workloads, containerization and cloud.
Continue reading “Db2 – Ready for modernized deployments and workloads”
Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 AIX to RHEL X86 Migration
Session abstract: As many users are modernizing workloads, they often want to standardize and run these workloads on an X86 platform. This session will show you how to move your Db2 database from AIX to Linux X86 platform while navigating some of the nuances of the different operating systems.
Watch recording (logged in Tridex members only)
Session title: New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance
Session abstract: z/OS LPAR real storage resources are getting larger and larger, and Db2 keeps providing new ways to leverage that resource for enhanced application performance. In this session, I’ll talk about assessing a z/OS LPAR’s real storage resource, and then I’ll explain how to optimize a Db2 buffer pool configuration, utilize thread memory for CPU savings, effectively manage EDM pool space, and more.
Continue reading “New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance”
Watch recording (logged in Tridex members only)
Session title: Is your test data as agile as your development?
Session abstract: We will discuss the issues that must be dealt with to supply test beds of vastly different sizes with fresh data quickly, efficiently and automatically. As developers switch to agile processes, their test data requirements change and fresh data is needed multiple times per day. Your test data provisioning strategy needs to keep pace with these demands.
Continue reading “Is your test data as agile as your development?”Download PDF
Watch recording (logged in Tridex members only)
Session title: Db2 Query Optimization 101 session
Session abstract: Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer’s job to choose the best access plan. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access plans for the variety of features and table organizations supported by Db2.
Download PDF
Watch recording (logged in Tridex members only)
Session title: Best practices: Step by step instructions to configure a secure database system
Session abstract: From installation to rolling into production ; security impacts every step of setting up a database system. From the OS ; to authentication ; authorization ; encryption and auditing ; a locked down database is a necessity in today’s world.
Continue reading “Best practices: Step by step instructions to configure a secure database system”
Download PDF
Watch recording (logged in Tridex members only)
Session title: Light at the end of the encrypted tunnel
Session abstract: Transport Layer Security (TLS, aka SSL) is the foundation of encrypting data in motion. This presentation will cover the fundamental principals of TLS encryption and working with certificates.
Watch recording (logged in Tridex members only)
Session title: Let Me Make This Clear: Explaining Often-Misunderstood Db2 for z/OS Concepts and Facilities
Session abstract: Some aspects of Db2 for z/OS technology are plain as day; others, less so. Questions I get from Db2 users worldwide have highlighted for me things that a lot of folks – even very experienced Db2 people – tend to misunderstand. From APPLCOMPAT to contiguous buffer pools, from MAXDBAT to the IBM Data Server Driver package collection, in this session I’ll try to take folks from “Uh” to “Oh!”
Continue reading “Let Me Make This Clear: Explaining Often-Misunderstood Db2 for z/OS Concepts and Facilities”
Watch recording (logged in Tridex members only)
Session title: What Organizations are Doing (and Looking to Do) with Db2 for z/OS: Trends and Directions
Session abstract: You may have seen Db2 for z/OS “trends and directions” presentations at various conferences and user group meetings. They are typically given by the IBM Director of Db2 for z/OS Development, together with one of the senior architects on the development team, and they provide a look into the future: where is IBM taking the product?
Continue reading “What Organizations are Doing (and Looking to Do) with Db2 for z/OS: Trends and Directions”