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


Tony Andrews

When? Wednesday, March 11th, 2015, 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 V11 – What’s New?
  Tony Andrews, Themis Inc.
 
 

This presentation introduces the attendee to the new SQL, optimization and application features of DB2 11 for z/OS. As with prior releases, DB2 delivers a large number of new features, functions, improvements, and enhancements with many specific to developers. New DB2 V11 functionality covers the areas of general subsystem performance improvements, optimization, and many application features affecting both the developers and DBAs.

Topics Include:

  • Access Path Stability
  • Application / SQL Compatibility
  • Global Variables
  • Transparent Archiving
  • Sequence Objects Alias Support
  • Declared Global Temporary Table (DGTT) Improvements
  • SQL Grouping Sets (Grouping, Rollup, Cube)
  • SQL PL Variable Arrays
  • Temporal Table Improvements / Special Registers
  • Indexing and Null Values
  • Optimization / Performance Enhancements
  • XML Enhancements (XQuery, XMLMODIFY, Etc.)
  • Tips on being proactive
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 DB2 V11 – What's New? (cont.)
  Tony Andrews, Themis Inc.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 DB2 V11 – What's New? (cont.)
  Tony Andrews, Themis Inc.
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 DB2 V11 – What's New? (cont.)
  Tony Andrews, 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:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, March 6th, 2015.

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
Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
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.