August 18, 2015 CODUG meeting

Central Ohio DB2 User's Group meeting

Tuesday, August 18, 2015 

We welcome Dan Luksetich as our speaker!

Dan Luksetich

Lunch will NOT be provided - but you can expect something tasty during the break.


8:30 - 9:00 Registration

9:00 - 9:10 Welcome and Opening Remarks 

9:10 - 10:25 First presentation block 

Temporal tables and time travel queries are a very popular feature of DB2 10 for z/OS and DB2 10 for LUW. They are one of the most powerful automated database features to come out in some time. This session will go into depth about the things you need to understand and prepare for before using temporal tables. This will include proper table, index, and table space design and configuration, as well as the ongoing management of these objects. In addition, we will be going into depth about how exactly time travel queries work, the complexity with period specifications, and the performance implications. This is a must see session if you want your time travel queries to perform!

10:25 - 10:45 Break

10:45 - 12:00 Second presentation block

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.



IBM/Sterling Campus Building One
6060 Britton Parkway
Dublin OH 43016
Meeting rooms - Auditorium C is straight back and then left down the hall

Map to the address.

Driving Directions to IBM/Sterling Campus:

  • Hit the Columbus I-270 outerbelt and head to the northwest quadrant of greater Columbus, the suburb of Dublin.
  • Exit onto Tuttle Parkway.
  • Turn to the west ... away from the Tuttle Mall ... head outside the loop ... head towards the countryside
  • Once clear of the highway interchange, at the 1st big light turn right onto Emerald Parkway (turning left would be Britton Parkway)
  • After about 100 feet turn right again into the IBM Sterling Campus.
  • After about 100 feet (again) turn right into the parking lot that is adjacent to Building ONE (6060 Britton Parkway).
  • Enter the foyer of Building ONE and call the number delimited on a sign that will be posted (or call 614-937-7076) for entry assistance.

Register here.

Looking forward to seeing you there.