Baltimore / Washington DB2 Users Group

BWDB2UG's DB2 Educational Session

Craig S. Mullins

When? March 9th, 2016, 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 Developerís Guide Comes Alive!
  Craig S. Mullins, Mullins Consulting, Inc.

This one day session, delivered by Craig S. Mullins, will cover tips, techniques, and procedures you need to know in order to excel at administering and using DB2 on the mainframe.

The material is based upon DB2 Developer’s Guide, the best-selling DB2 for z/OS book on the market. The course material will contain references to sections and pages within the book so that students can find additional material on each topic after the training.

Topics to be covered include:

  • A performance tuning roadmap for managing DB2 application, database and system performance. Learn SQL coding and tuning techniques, guidance for database optimization and reorganization, coverage of buffer pool settings and parameters for performance.
  • Logical and physical database design recommendations for DB2, so you can build and maintain effective DB2 databases immediately. Includes discussion of standards, logical to physical translation, data types, nulls and more.
  • Coverage of the newer features added to DB2 in recent versions that can boost application performance, such as REOPT enhancements, plan management, multi-row FETCH and index on expressions.
  • Tips and guidelines for writing efficient and effective DB2 SQL.
  • Coverage of newer features added to DB2 including hash access, index include columns, efficient caching of dynamic SQL statements with literals, temporal data and time travel queries, and more.

Save time, improve your systems and applications. Learn techniques for creating, managing and accessing efficient DB2 databases.

The class focuses on practical applications on how to best use DB2 at your shop. From SQL usage, to performance, to new features, to best practices and much more - make sure you reserve a seat in the class ASAP.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 DB2 Developerís Guide Comes Alive! (cont.)
  Craig S. Mullins, Mullins Consulting, Inc.
  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 Developer's Guide Comes Alive! (cont.)
  Craig S. Mullins, Mullins Consulting, Inc.
  2:00 - 2:15 Break
  2:15 - 3:30 DB2 Developer's Guide Comes Alive! (cont.)
  Craig S. Mullins, Mullins Consulting, 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 4th, 2016.

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
Craig S. Mullins is president & principal consultant of Mullins Consulting, Inc., a consultant for datAvail, and the publisher/editor of The Database Site, His working experience spans multiple industries (banking, utilities, software dev, research and consulting).

Craig writes for many computer/IT publications, having authored articles for many popular IT and database journals and web sites.

Craig is a frequent speaker at IT conferences, having spoken about database issues to thousands at conferences including SHARE, IBM Insight, IDUG, DAMA Symposium and Oracle World. He has spoken at events on 4 continents (North America, Europe, Asia, and Australia).
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.