Baltimore / Washington DB2 Users Group
Archived
BWDB2UG z/OS Quarterly Meeting

When? Wednesday, December 10, 2008, 9:00AM-3:30PM (registration at 8:30)

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

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 How In-memory Database Technology and IBM solidDB Complement IBM DB2 for Extreme Speed
  Joan Monera-Llorca, IBM
 
 

In 2008, IBM introduced in-memory database technology known as solidDB. This presentation includes a technical deep-dive of in-memory database technology; how it works, including storage algorithms and architectures, compared to conventional, on-disk databases; and why an in-memory database is faster than an on-disk database, even when the latter caches all data into main memory. There will be an architectural overview of IBM solidDB to show how it integrates with DB2 and can be used as a cache to complement DB for accelerated response times and increased transaction throughput. If time permits, several use cases will be explored.

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 XML - A Technical Overview
  Bill Arledge, BMC Software
 
 

DB2 on z/OS becomes a hybrid data server with the DB2 9 release, providing comprehensive support for XML. XML (eXtensible Markup Language) is a key enabler for Electronic Data Interchange, allowing unstructured data to move within and across organizations. This presentation will clear the air about XML, describing fundamental concepts as well as details about XML support in DB2 9, including XML tablespace structures, specialized indexes, and SQL access to XML data.

 
  11:45 - 12:45 Lunch provided by BMC Software
 
  12:45 - 2:00 Exploring the DB2 Directory
  Bill Arledge, BMC Software
 
  Metadata information stored in the DB2 Catalog is very well known and easy to interrogate using SQL. However, at run time, DB2 makes extensive use of the other primary DB2 system database, the Directory or DSNDB01. This presentation describes the contents of the Directory, explains how to look at its contents, and discusses how you can improve your overall system performance and recovery times by paying a little more attention to this often forgotten resource.
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 SQL Optimization & Access Paths: What's Old & New
  David Simpson, Themis, Inc.
 
 

Some things with SQL optimization have been the same for a long time. Other things are changing rapidly with the introduction of Version 8 and 9. This presentation reviews the basics of access path analysis with an extended discussion of what's new in the latest releases of DB2. The appropriate places for Visual Explain and Optimization Service Center will also be covered. Let's talk about what's old, what's new, and how to make the optimizer work for you.

   

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, December 5th, 2008.

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
Joan Monera-Llorca is a senior data management technical specialist with a primary focus on in-memory database technology. He joined IBM in 2008 through the acquisition of Solid Information Technology, where he was Director of Technical Sales and Customer Support. Prior to Solid, Joan was at Nortel, where he held several R&D positions. He is the author of several journal publications and has been in the database, software, and telecom industry for over 10 years.
Bill Arledge is an IT veteran with 33 years experience across a variety of roles, including application development and database administration. Bill's database experience began in the late 1970s as an IMS DBA and developer. He began working with DB2 in 1984 as a database specialist at IBM. He worked with DB2 throughout the late eighties, consulting with numerous IBM customers on existing and planned DB2 implementations. Bill joined BMC in 1990 and is currently a technical product manager responsible for BMC's DB2 data management products. In that capacity, he consults extensively with BMC DB2 customers and works closely with BMC's Research and Development organization to drive product direction.
David Simpson is currently a Senior Technical Advisor at Themis, Inc. He teaches courses on SQL, application programming, DB2 administration as well as optimization and 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 15 years as an application programmer, DBA, and technical instructor. David is a certified DB2 DBA on both z/OS and LUW. David 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.