Agenda
Day One
10.00-10.15
Welcome: presentation of topics and speakers
10.15-11.30
Top cost Saving Enhancements in DB2 11 for z/OS
James Guo
11.30-11.45 Coffee Break
11.45-12.45
Trigger, Instead of Triggers and Multi-row operations
Gareth Z Jones
12.45-14.00 Lunch
14.00-15.30
Archive Transparency and TIMESTAMP with TIMEZONE
Gareth Z Jones
15.30-15.45 Coffee Break
15.45-17.15
SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques
Gareth Z Jones
Day 2
9.30-11.00
Lightning Fast Analytic Queries on Operational Data with DB2 11 and IBM z13 System
James Guo
11.00-11.15 Coffee Break
11.15-12.15
Super Fast Complex Analytic Queries with DB2 Analytics Accelerator V41 and Pure Data System for Analytics N3001
James Guo
12.15-13.00
Interpreting the Explain tables, using optimizer hints and establishing query stability
Gareth Z Jones
13.00-14.00 Lunch
14.00-15.30
RUNSTATS, Catalog Statistics and the DB2 Optimizer
Gareth Z Jones
15.30-15.45 Coffee Break
15.45-16.45
Dynamic SQL best practices and analyzing query performance
Gareth Z Jones
16.45-17.15
Closing and Open Forum
Comments