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

When? Tuesday, June 21st, 2011, 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 DB2 10 for z/OS Migration Planning and Very Early Experiences
  John Campbell, IBM

This presentation will introduce and discuss very early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hints on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc.

The presentation also provides the following:

  • additional planning information
  • share surprises, pitfalls and lessons learned
  • provide hints and tips
  • enable fast start
  • introduce and discuss some further enhancements
  • latest news
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Optimizing Insert Performance
  John Campbell, IBM

This presentation will discuss the performance bottlenecks and pain points for insert intensive workloads, the areas for tuning insert intensive workloads, how to design for high performance, and how to use the new features of DB2 9 for z/OS to benefit insert intensive workloads, and specific considerations for data sharing.

  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 10 Time Travel Data (aka Temporal Tables)
  Charles Lewis, IBM

One of the major functions added in DB2 10 for z/OS is the support for temporal tables and versioning. Starting with DB2 10 new-function mode, you can define temporal attributes for a table and enable versioning of the table's data. These new attributes give you a lot of flexibility in how you can query data based on periods of time. DB2 10 supports two types of periods, which are the system time (SYSTEM_TIME) period and the business time (BUSINESS_TIME) period. The SYSTEM_TIME period is a system-maintained period in which DB2 maintains the beginning and ending timestamp values for a row. For the BUSINESS_TIME period, you maintain the beginning and ending values for a row. Support of business time and system time allows for significant simplification of applications, pushing the complicated handling of these concepts down to the database engine itself. In addition, DB2 10 introduces versioning, which is the process of keeping historical versions of rows for a temporal table that is defined with a SYSTEM_TIME period, or both time periods, allowing for simple retrieval of key historical data. This presentation will provide an introduction to the new DB2 capabilities to maintain more data for longer periods of time and to provide better ways for business users to analyze past, current, and future events.

  2:00 - 2:15 Break
  2:15 - 3:30 Gain insight into DB2 9 and DB2 10 for z/OS performance updates and save costs
  John Iczkovitz, IBM

In this presentation, we will discuss the latest updates for system and application performance on IBM DB2 9 and DB2 10 for z/OS. Beginning with performance impact and tuning at the system and application level, we’ll have a special focus on topics requested by product representatives and field inquiries. This presentation will also cover DB2 10 for z/OS and its improved performance and scalability — including general CPU usage reduction and scalability, buffer management, and insert and select functionality — in addition to the reduction of virtual storage constraints. Other topics include improvements to DDF, JDBC, SQLPL and line-of-business performance. You’ll also learn how DB2 9 and DB2 10 interact with IBM z10 and z11 processors.


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, June 17th, 2011.

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
Tom Howell has more than a decade of experience in the technology industry. He has spoken at numerous conferences, user groups and associations on topics ranging from data privacy and compliance to the implementation of data management strategies and the implementation of solutions to secure data in test and development environments. His background includes work with leading organizations such as Gryphon Networks, Princeton Softech, and currently IBM.
Patrick Bossman works on the DB2 for z/OS DB2 Query Optimization team. He has worked for IBM for 8 years and has 14 years of experience with DB2 as an applications developer, DBA, SQL writer/performance tuner, and now a member of the optimization development team. His current focus is on automating the identification and resolution of query performance problems.
David Beulke is an internationally recognized DB2 consultant, author, and teacher, known for his extensive expertise with database performance, data warehouses, and internet applications. He is an inaugural member of IBM's DB2 Data Champions program, one of the 45 IBM DB2 Gold Consultants worldwide, past president of the International DB2 Users Group (IDUG), columnist for DB2 Magazine for the last 8 years, co-author of the IBM V7 and V8 z/OS DB2 Certification exams, co-author of the Business Intelligence Certification exam, former instructor for The Data Warehouse Institute (TDWI), and former editor of the IDUG Solutions Journal. David has experience working with DB2 on the mainframe, AIX/UNIX, and Windows over the last twenty two years in a variety of environments and industries. His clients save millions of dollars by reducing CPU demand, avoid unnecessary hardware upgrades, and improved application implementations through his customer focused solutions, performance tuning expertise, and expert business designs.
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.