Tuning ETL Performance

Download PDF
Watch recording (logged in Tridex members only)

Session title: Tuning ETL Performance

Session abstract: This presentation looks at some general aspects for consideration with ETL workloads. Additionally, aspects that might improve the analytical query workloads including performance objects that might need to be established during ETL will be covered. 

Continue reading “Tuning ETL Performance”

The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Download PDF
Watch recording (logged in Tridex members only)

Session title: The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Session abstract: This presentation focuses on the latest advancements in automated HA with Pacemaker as newly-crowned integrated cluster manager for Db2. A recap of features in V11.5.5.0, V11.5.6.0, and a glimpse into V11.5.7.0 and beyond will be provided. 

Continue reading “The Next Stop(s) in Db2 Pacemaker HA Solution Journey”

Db2 Historical Monitoring

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. 

Continue reading “Db2 Historical Monitoring”

Db2 – Ready for modernized deployments and workloads

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”

New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance

Download PDF

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”

Is your test data as agile as your development?

Download PDF

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?”

Db2 Query Optimization 101 session

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.

Continue reading “Db2 Query Optimization 101 session”

Best practices: Step by step instructions to configure a secure database system

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”