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

Votes: 0
E-mail me when people leave their comments –

You need to be a member of World Of Db2 to add comments!

Join World Of Db2