Daniel Luksetich

Speaker Details

Company:

IBM

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 28 years, and has worked with DB2 for over 23 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 certification exams. He is the author of several DB2 related articles as well as co-author of the DB2 9 for z/OS Certification Guide and the DB2 10 for z/OS Certification Guide.

Dan is and IBM Gold Consultant, an IBM Champion for Data Management, and the chairman of the International DB2 Users Group Content Committee.

Past presentation

28 May 2014
10:15 - 11:00

European SQLAdria Seminar – Dubrovnik 2014

Can RDF Based Storage Make a Better DB2 Data Warehouse?

One of the most difficult and time consuming processes in developing a data warehouse is the table and ETL design. Can we use new software technology to bypass this design and get right to processing data using DB2? NoSQL, MapReduce and GraphStore are becoming popular technologies for the storage and processing of what might be called "big data". This presentation will explore the possibility of using this available technology in DB2. Using the provided RDF (Resource Description Framework) NoSQL GraphStore feature of DB2, we will see if the typical complexities associated with data warehouses can be avoided

27 May 2014
15:00 - 16:00

European SQLAdria Seminar – Dubrovnik 2014

Understanding Query Transformation in DB2 for z/OS

There is always a lot of talk about the DB2 optimizer and what is the best access path for a particular query. While this is of course important it is also important to know that the optimizer is only part of the story. When a query is submitted one of the first thing that happens is that it goes through query transformation. In this part of the process DB2 interprets the submitted SQL, and rewrites it. Views and UDFs are merged with the query, subqueries possibly transformed to joins, table expressions merged, and much more. If you are a serious query tuner you need to understand what is happening during query transformation and what you can do to influence it. We'll learn about query transformation, how to view query transformation, and how to influence query transformation

13 June 2013
09:00 - 16:00