Gareth has worked in IT since 1985, when he worked in the UK for an IBM customer. His first real contact with DB2 when, as an IMS Systems Programmer and DBA, he was handed the job of migrating DB2 from V1.3 to V2.1, and he hasn't looked back since. He spent eight years as a contractor, gaining experience 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 in BetaWorks, before joining the DB2 for z/OS SWAT Team, under the leadership of John Campbell, taking advantage of the opportunity to work with many customers around the world.
Dynamic SQL best practices, and analysing query performance This presentation looks at some dynamic SQL best practices, and also looks at how you can code for and analyse query performance.
Java error handling for JDBC and SQLJ applications: This presentation provides some guidance on handling SQL errors and SQL warnings in your Java applications, in the case of JDBC and SQLJ
INSERT optimisation and Batch processing: This presentation looks at how you can optimise your applications and your database design for INSERT-intensive workloads, and for other batch operations/
Interpreting the Explain tables, using optimiser hints and establishing query stability: There presentation delves into the information available in the EXPLAIN tables which can be used to understand what access path is chosen by DB2 and why. It also looks at how this same infrastructure can be used to provide hints to the optimiser to influence access path selection, and ultimately to ensure that preferred access paths are used for critical queries.
SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques: This presentation 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.
Archive Transparency and TIMESTAMP with TIMEZONE:This presentations 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.
Triggers, Instead of Triggers and Multi-row operations: This presentation examines the use of triggers and instead of triggers, and looks at the benefits and coding techniques for exploiting multi-row operations.
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024
HR
EN
SL