Exploit DB2’s Log - Kai Stroh - UBS-Hainer
Abstract:
Relational DBMS have a transaction log for recovery purposes in case of failure. However, the information stored in the log is also well suited for other purposes. Think of undoing bad transactions, data propagation, and auditing. The DB2 log is a potential gold mine if you know how to seamlessly filter and make complex log data usable. We will show you how the DB2 log is structured, what data DB2 stores in the log besides table contents, and how to find the information you are looking for. As the DB2 log can become extremely large, we will also show you a solution for automating your log analysis needs with an easy to use, panel-driven application.
Bio:
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 dumps and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations.
SQL Enhancements Delivered with Db2 12 for z/OS - Robert Catterall - IBM
Abstract:
Every version of Db2 for z/OS introduces new SQL-related capabilities, and Db2 12 is no exception. In this session I will describe new SQL features delivered with Db2 12, including temporal enhancements, the native REST interface, the new-and-improved MERGE statement, piece-wise DELETE, result set pagination, advanced triggers, "real" Unicode columns in EBCDIC tables, global variable enhancements, new built-in functions, and more.
Bio:
Robert Catterall is a Senior Consulting Db2 for z/OS Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, a member of IDUG's Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He presents frequently at conferences, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.
A Field Guide for Test Data Management - Kai Stroh - UBS-Hainer
Could you be administering your supply of Db2 z/OS test data better?
Implementing an effective test data management strategy can seem daunting even to the most seasoned IT veteran. We will cover the unique challenge of data provisioning and how to manage multiple test and QA environments – from small unit tests to massive acceptance tests – and hopefully offer a few new tricks for your playbook.
We will go through actual customer stories and demonstrate how we have helped companies streamline and automate their Db2 data refresh strategies. Plodding Db2 copy procedures can stretch your staff thin, which is why automation, speed and low resource usage are our main focus.
Robert's Db2 for z/OS Blog: Best of the Blog, Volume 1 - Robert Catterall - IBM
Abstract:
I started blogging about Db2 for z/OS back in 2007, while working as an independent consultant. I launched my current blog, "Robert's Db2 blog," when I rejoined IBM in 2010. That blog gets a lot of page views and has been enthusiastically received by people in the Db2 for z/OS user community. In this session, I'll present material drawn from selected entries in my Db2 blog - posts for which reader feedback has been especially positive, and entries that cover topics that I find to be particularly interesting.
Bio:
Robert Catterall is a Senior Consulting Db2 for z/OS Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, a member of IDUG's Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He presents frequently at conferences, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.