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

When? Wednesday, March 14th, 2012, 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 z/OS Advanced SQL - Working with Complex Queries
  Tony Andrews
 
 

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this session is for you! We’ll look at some of the features in the latest releases of DB2 that allow us to solve even more complex business problems.

Agenda

  • Review of Joins, Subqueries, Nested Table Expressions, Common Table Expressions
  • Quota Queries for Ranking and Top 10 List
  • OLAP Ranking Functions
  • Solving Complex Problems with SQL. Evaluating Options
    • Looking at multiple ways to get the same answer
    • Looking at Intersect and Except for solutions
  • Merge Statement - what did it do?
  • New SQL
    • Currently Committed, Skip Locked Data, Uncommitted Reads
    • Extended Null Indicators
    • Stored Procedures ‘With Return to client’
    • Select From Update, Insert, Delete
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 DB2 z/OS Advanced SQL - Working with Complex Queries (cont.)
  Tony Andrews
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 IBM Data Studio for Mainframe Developers
  David Simpson
 
 

IBM Data Studio is a free tool for interacting with your DB2 environment from a client machine. The functionality of this tool is particularly strong in the development and testing of stored procedures as well the query tuning functionality that was formerly in Visual Explain. The product was built on the Eclipse framework, something not always familiar to mainframe people. This session will enable you to quickly benefit from the functionality that IBM Data Studio offers and be able to evaluate its features for your environment.

Agenda

  • The Purpose of IBM Data Studio
    • Distributed Development
    • What’s it good at?
  • The Eclipse Infrastructure used by IBM Data Studio
    • Tips and tricks for navigation
    • Getting help
  • Perspectives and Projects
  • Stored Procedure Development & Debugging
  • Query Tuning
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 IBM Data Studio for Mainframe Developers (cont.)
  David Simpson
 

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 9th, 2012.

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 17 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.
Tony Andrews has more than 23 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 RDMS 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 user groups, IDUG NA, and IDUG EMEA.
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.