_ Archives - Page 17 of 19 - Tri-State Db2 Technology Exchange

GWLM: A helpful free tool to unlock the complexities of Db2 WLM – Paul Bird, Senior Technical Staff Member, Db2 Development

Session title: GWLM: A helpful free tool to unlock the complexities of Db2 WLM – Paul Bird, Senior Technical Staff Member, Db2 Development

Session abstract: Tired of trying to figure out your workload management configuration from dense db2look output? Having trouble making even simple changes to your system without mistakes? Unable to remember all the DDL options available? Come learn about the free IBM Graphical Workload Manager (GWLM) tool that helps to unfold and make clear the mysteries of Db2 workload management in a simple, visual manner!

Continue reading “GWLM: A helpful free tool to unlock the complexities of Db2 WLM – Paul Bird, Senior Technical Staff Member, Db2 Development”

Db2 = SQL + JSON

Download PDF

Session title: Db2 = SQL + JSON

Session abstract: This is your opportunity to come learn about what we have been doing in Db2 to support JSON in the relational world. We will cover what has been done so far in DB2 10.5 and Db2 11.1 and we will look ahead to what else the future might hold. Continue reading “Db2 = SQL + JSON”

Data Server Manager Update and Directions

Download PDF
Additional information

Session title: IBM’s Hybrid Data Management Strategy

Session abstract: Peter will provide an overview of the latest enhancements and the trends and directions for the Db2 Family consoles including Data Server Manager. He will also deliver a deep dive on Monitoring best practices, tips and tricks using Data Server Manager that will include configuration, statement history and under the covers insights.

Continue reading “Data Server Manager Update and Directions”

Runstats challenges for Optimal Query Performance

Download PDF

Session title: Runstats challenges for Optimal Query Performance

Session abstract: In DB2 development, we see many customers that are NOT following RUNSTATS collection “Best Practices”. But what are those best practices? The largest contributor to poor query performance is insufficient or misleading RUNSTATS. Continue reading “Runstats challenges for Optimal Query Performance”

Db2 for z/OS Provisioning – Heavy Lifting Ahead

Download PDF

Session title: Db2 for z/OS Provisioning – Heavy Lifting Ahead

Session abstract: System provisioning, DevOps, Continuous Delivery / Integration are all modern-day initiatives that accelerate the delivery of business applications. Each may have requirement for a copy of an entire DB2 subsystem or portions thereof to obtain full value. Continue reading “Db2 for z/OS Provisioning – Heavy Lifting Ahead”

IBM Data Virtualization

Download PDF

Session title: IBM Data Virtualization

Session abstract: IBM Data Virtualization Manager (IBM DVM) unlocks the full potential of data on IBM Z to provide universal access to any application regardless of location or format required. In the past, previous data architectures struggle with real-time requirements, which are increasingly driven by today’s 24/7 mobile world. Continue reading “IBM Data Virtualization”

Db2 12 and Continuous Delivery – What’s New from the Optimizer

Download PDF

Session title: Db2 12 and Continuous Delivery – What’s New from the Optimizer

Session abstract: Session abstract: DB2 12 for z/OS has been announced and DB2 has embarked on Continuous Delivery for ongoing features. So what’s coming from the optimizer team regarding further performance enhancements? Continue reading “Db2 12 and Continuous Delivery – What’s New from the Optimizer”

IBM’s Hybrid Data Management Strategy

Download PDF

Session title: IBM’s Hybrid Data Management Strategy

Session abstract: There is a significant amount of new news in 2018 across our hybrid data management porfolio. This includes a look at our 2018 roadmap as well. Continue reading “IBM’s Hybrid Data Management Strategy”

Some of My Favorite Tuning Tips and Tricks for Db2

Download PDF

Session title: Some of My Favorite Tuning Tips and Tricks for Db2

Session abstract: Performance problems come in many flavors, with many different causes and many different solutions. I’ve run into a number of these that I have not seen written about or presented elsewhere Continue reading “Some of My Favorite Tuning Tips and Tricks for Db2”

DB2 Recovery Best Practices V2

Download PDF

Session title: DB2 Recovery Best Practices V2

Session abstract: We will walk through several scenarios evaluating the different options with the pros and cons of each will being discussed. I will present what is new in the field of recovery within DB2. Continue reading “DB2 Recovery Best Practices V2”