Session title: Advanced Performance Diagnostics for SQL
Session abstract: Db2 provides a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will introduce you to the latest Db2 capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. Continue reading “Advanced Performance Diagnostics for SQL”
Session title: Machine Learning for z/OS
Session abstract: Gain an overall understanding of Machine Learning for z/OS and its role in enabling advanced analytics on IBM Z. You will learn how this machine learning technology integrates with Db2 Analytics Accelerator and Db2 for z/OS to drive real-time insight on an enterprise scale. Continue reading “Machine Learning for z/OS”
Session title: Security for a Modern Mainframe Database Environment
Session abstract: IBM’s mainframe security is well known for being hacker resistant. However, the deployment of technology depends on a combination of people, process and technology. Some of those processes, like authentication, begin on desktops and mobile devices that are outside the mainframe security controls and most susceptible to theft, key logging and other means to enable unauthorized personnel to access mainframe systems. Continue reading “Security for a Modern Mainframe Database Environment”
Session title: Revival of the SQL Tuner
Session abstract: The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? Continue reading “Revival of the SQL Tuner”
Session title: Ensuring Availability with Modern Db2 Backup and Recovery Strategies
Session abstract: This presentation will discuss what we as DBA and System folks can do now to help when there is a recovery situation. We all have done recoveries… but we usually don’t wake up one morning and say let’s do some recoveries today. Or are we ready for a hardware or software failure today? Continue reading “Ensuring Availability with Modern Db2 Backup and Recovery Strategies”
Session title: Db2 – Continuously Available and Transparently Scalable
Session abstract: Db2 pureScale has taken the gold standard for availability of the mainframe DB2 z/OS SYSPLEX and made it available on distributed AIX and Linux systems on premises and on cloud. We’ll take you through the architecture, latest features and capabilities that is running the worlds more critical and scalable systems.
Continue reading “Db2 – Continuously Available and Transparently Scalable”
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”
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”
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”
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”