View Printable Version

EDS4 - DB2 Advanced Programming, Automation, and Performance

Session Number: 3311
Track: Educational Seminar - II
Session Type: Educational Seminar
Primary Presenter: Daniel Luksetich [DanL Database Consulting]

Frio - Ed. Sems. => Tue, May 24, 2016 (08:00 AM - 11:30 AM)

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: Application Design, Data Management, Emerging Technology, Implementing New DB2 Releases and Features, Managing Database Resources, Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), New Release (DB2 for LUW), New Release (DB2 for z/OS), SQL and XML Features, SQL and XML Performance, Triggers, Stored Procedures, UDFs, User Experiences
Objective 1: Understand Database Enforced Referential Integrity, Table Check Constraints, Sequence Objects and Identity Columns, Statement Include Columns
Objective 2: discuss proper use of Stored Procedures, User-Defined Functions, User-Defined Data Types, Triggers
Objective 3: understand Large Objects and Clone Tables
Objective 4: understand Materialized Query Tables and Temporal and Archive Tables
Objective 5: learn about XML Support, JSON Support, RDF Support

Abstract:  Both DB2 for LUW and DB2 for z/OS contain a set of advanced functionality that can provide significant programming and automation to applications. Application developers that understand these advanced features can take advantage of them to improve the flexibility and performance of their database applications. Centralizing application logic in the database engine can also make applications easier to develop and more portable. This one day seminar, which is beneficial to database administrators and application developers will introduce the attendee to the various advanced programming features of DB2 for z/OS and LUW that can be utilized to save development time and improve application and database performance. Within each subject area the advantages and disadvantages of the feature will be discussed as well as the performance implications.

For questions or concerns about your event registration, please contact