Register Now for COMPLIMENTARY Workshop : Fast Start! DB2 for z/OS Application Development Topics - Gareth Jones [IBM]
@ IDUG EMEA DB2 Tech Conference in Dublin, Ireland
When: Thursday Nov 19th, 2015 - 14:00-17:00
Where: Meeting Room 18
Price: FREE
Register Today ! Limited Places
Agenda
Triggers, Instead Of Triggers and Multi-row operations
This session examines the use of triggers and instead of triggers, and looks at the benefits and coding techniques for exploiting multi-row operations.
Archive Transparency and TIMESTAMP with TIMEZONE
This session explores the DB2 11 feature which allows applications to transparently access data in an archive table, and optionally to move non-active data into an archive table. It also looks at the use of time zone information with TIMESTAMP columns.
SQL Features including Intersect/Except/Merge and other SQL coding techniques
This session looks at a variety of SQL features introduced over several DB2 releases, and how they can be used to provide improved functionality, performance, and to provide alternative coding techniques for your applications.
Dynamic SQL best practices
This session discusses dynamic SQL best practices in terms of exploiting and managing the Dynamic Statement Cache (DSC). Guidance is given on analysing dynamic query performance using performance data available in the DSC and the session concludes with a brief look at protecting the production environment by using production modelling to ensure consistent access path selection across development, test and production..
Managing Query Performance
This session briefly introduces the EXPLAIN tables , which are used to assist in access path analysis. It then looks at some typical access path problems, how they are affected by filter factors and the statistics in the DB2 catalog, how to identify them and some strategies for handling them. Once access path problems have been addressed, PLAN_TABLE and the DB2 Access Path Repository can be used to provide optimisation hints, to stabilise access paths, and ultimately to ensure that preferred access paths are used for critical queries.
Presenter: Gareth Jones
Bio: Gareth Jones has worked in IT since 1985, when he worked for an IBM customer in the UK retail sector. His first real contact with DB2 was when, working as an IMS Systems Programmer and DBA, he took on the job of migrating DB2 from V1.3 to V2.1, and he hasn't looked back since. In the 1990s, he spent eight years as a contractor, in France, the Netherlands and the UK, before joining IBM as a permanent employee in 2000. Gareth worked for several years in IBM's Strategic Outsourcing division, and then in BetaWorks, before joining the DB2 for z/OS SWAT Team, under the leadership of John Campbell. He has worked with many customers around the world with the SWAT Team. He has written a number of technical papers as well as presenting at several conferences including Insight, and many user group meetings.
Comments