Baltimore / Washington DB2 Users Group
Archived
BWDB2UG's DB2 Educational Session

When? Wednesday, March 13th, 2013, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered: $250 (lunch and break refreshments included)
At-the-door: $350 (lunch and break refreshments included)

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 DB2 10 for z/OS New Features for Application Development - SQL Enhancements
  David Simpson, Themis Inc.
 
 

This course introduces the attendee to the new SQL and application features of DB2 10 for z/OS. By the end of the day, attendees should understand the new SQL and Development Features of DB2 V10, understand the new SQL Optimization Features of DB2 V10, and be ready to implement and support these features in applications.

Agenda

  • Recap of OLAP Features
  • OLAP Moving Sum, Avg
  • Extended Null Indicators
  • Implicit Casting
  • New Timestamp Precisions
  • Currently Committed Processing
  • Hash Access Processing
  • SQL PL UDF Enhancements
  • Temporal Tables
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 DB2 10 for z/OS New Features for Application Development - SQL Enhancements (cont.)
  David Simpson, Themis Inc.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 DB2 10 for z/OS New Features for Application Development - Optimization Features
  David Simpson, Themis Inc.
 
 

This course introduces the attendee to the new SQL and application features of DB2 10 for z/OS. By the end of the day, attendees should understand the new SQL and Development Features of DB2 V10, understand the new SQL Optimization Features of DB2 V10, and be ready to implement and support these features in applications.

Agenda

  • Transitive Closure
  • Single Matching ‘OR’ Predicates
  • Cursor / Scrolling Feature
  • New ‘IN’ Lists
  • Safe Query Optimization
  • Index Include
  • Explain Package Feature
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 DB2 10 for z/OS New Features for Application Development - Optimization Features (cont.)
  David Simpson, Themis Inc.
 

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, March 8th, 2013.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, DB2 Administration as well as performance and tuning. He has supported transactional systems that use DB2 for z/OS databases in excess of 10 terabytes. David has worked with DB2 for 20 years as an application programmer, DBA and technical instructor. David is a certified DB2 DBA on both z/OS and LUW. David is a frequent speaker at user groups and IDUG and was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.