Tri-State Db2 Technology Exchange
Db2 Users Group
Session title: Data Virtualization and Project Queryplex
Session abstract: Regardless of the industry, data has become a fundamental driver in today’s business decisions. Businesses pivot and remain competitive based on the analytics performed on that data. Increasingly that data comes from more and more sources, its volume is increasing at an exponential rate, and need for insight is increasingly real-time. Continue reading “Data Virtualization and Project Queryplex”
Session title: Adaptive Workload Management in Db2 Warehouse
Session abstract: IBM’s Db2 Warehouse (and Db2 Warehouse on Cloud) has recently rolled out a new Adaptive Workload Management technology that allows you to easily manage your database resources across workloads and ensure they meet their desired performance objectives. Continue reading “Adaptive Workload Management in Db2 Warehouse”
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!
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”