DB2 Advanced SQL and Performance

Session Number: 4009
Track: Application Development
Session Type: Podium Presentation
Primary Presenter: Daniel Luksetich [DB2 Consultant - DanL Database Consulting]
Time: Sep 15, 2015 (09:00 AM - 05:00 PM)

Speaker Bio: Dan Luksetich is a data scientist and senior DB2 DBA consultant. He works as a DBA, application architect, presenter, author, and teacher. Dan has been in the information technology business for over 30 years, and has worked with DB2 for over 25 years. He has been a COBOL and BAL programmer, DB2 system programmer, DB2 DBA, and DB2 application architect. His experience includes major implementations on z/OS, AIX, i Series, Windows, and Linux environments. Dan's experience includes: Application design and architecture, Business analytics, SQL consulting and education, database administration, complex SQL, SQL tuning, DB2 performance audits, replication, disaster recovery, stored procedures, UDFs, and triggers. Dan works everyday on some of the largest and most complex DB2 implementations in the world. He is a certified DB2 DBA for DB2 for z/OS and LUW, system administrator for z/OS, and application developer, and has worked on the teams that have developed the DB2 for z/OS and LUW certification exams. He is the author of several DB2 related articles as well as the author of the Computer Associates DB2 Performance Handbook, co-author of the DB2 9 for z/OS Certification Guide and the DB2 10 for z/OS Certification Guide. Dan is an IBM Gold Consultant, an IBM Champion for Data Management, and the chairman of the International DB2 Users Group Content Committee.
Audience experience level: Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), SQL and XML Features, SQL and XML Performance
Objective 1: To understand newer and more advanced SQL features
Objective 2: To understand the implications of using various SQL features from a performance perspective
Objective 3: To get an introduction of predictive performance analysis and EXPLAIN
Objective 4: To get an introduction to performance monitoring on all DB2 platforms
Objective 5: Using advanced SQL coding techniques to solve complex application problems and reduce the quentity of SQL statements issued by a transaction

Abstract:  This seminar address advanced SQL syntax and coding techniques with query performance in focus. Examples of complex SQL in different formulations are shown to demonstrate those that they perform efficiently versus those that perform in the worst possible manner. DB2 brought a whole new world to relational with advancements in SQL processing and object relational support. Presented here are the more advanced examples of subqueries, joins, anti-joins, table expressions, CASE expressions, UDFs, table functions, SQL recursive processing, relational division, OLAP expressions, PureXML, and many other features of the DB2 family. There are many examples taken from real systems. An emphasis is made on the proper use of each technique for performance.