Meeting Agenda – June 6, 2018
8:30-9:00 Registration
9:00-9:30 IBM Announcements and WDUG Board Elections
DB2 for z/OS Track
9:30-10:30
A Single Point of Entry for Data Virtualization - Data Virtualization Manager
Tim Willging—Rocket Software
What if all your enterprise data could be accessed through a modern single API, use a single metadata model or catalogue, and utilize a single security model? This session will explore IBM’s Data Virtualization Manager for z/OS. Learn how any application that connects to Db2 can have virtualized access across a wide range of mainframe and non-mainframe data sources.
10:45-12:00
Db2 Recovery Simplified with considerations for GDPR
Bob Bersano, Rocket Software
There are a lot of utilities available in Db2 for z/OS that can help you with recovery. In order to use these utilities at the right time and in the most efficient way, it requires a lot of expertise and experience to execute the steps in the correct order in a situation that normally comes with some pressure.
12:00-1:15 Lunch - Buffet (Must pre-register—See ‘Other News’ for details)
1:15–2:30
SQL Procedural Language – Creative Uses
David Simpson, Themis
The SQL PL language is useful for writing stored procedures, user defined functions (UDFs) and triggers. The language is becoming more powerful with each release. This session will cover the basics of the language and give you some samples to take home and try!
2:45–4:00
Environment simulation workload Replay in an agile
World
Ulf Heinrich, Segus
Learn how to integrate individual task for flexible automation and how to choose from four different levels of testing. The levels include simple anomaly alerting, access path verification, cloning and workload capture/ replay to easily discover different behavior resulting from changes, like new application releases, or environment upgrades. Find out how easily you can pick and choose from KPI based test automation.
DB2 for LUW
9:30-10:30
App Dev Simplified: A Workshop for Developers and DBAs
Jon Lind—IBM
New applications must often leverage multiple types of data from many sources; and you have to deliver fast. While relational or transactional data is at the core of applications, and now you must also integrate unstructured sources like geo-location information, emails, and more. Instead of coding with different databases for different data types, why not use a single
database to reduce complexity and deliver applications faster?
IBM Db2 database software stores both relational data and unstructured data like JSON in a single database to make coding simple. Furthermore, Db2 meets requirements for enterprise scalability, availability and reliability.
10:45-12:00
App Dev Simplified:
A Workshop for Developers and DBAs… continued
Jon Lind—IBM
12:00-1:15 Lunch - Buffet (Must pre-register—See ‘Other News’ for details)
1:15–2:30
App Dev Simplified:
A Workshop for Developers and DBAs… continued
Jon Lind—IBM
2:45–4:00
How to Write Bad SQL: Seven SQL Performance Killers to
Avoid in Db2
Ember Crooks—XTIVIA
Writing top-performing SQL is a complex task. It takes practice and patience, as well as trial and error. Having a framework and a few rules to work from is a good place to start, whether writing SQL is your primary job or you are a database administrator who just needs to be able to help tweak SQL from time to time. Come learn seven mistakes that lead to slow SQL in Db2 and how to avoid them. This session is targeted at LUW, but may have applications across platforms.
Comments