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

When? Wednesday, December 11th, 2013, 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 Application Developers & DB2 for z/OS
  Ted Alexander, President, Atlanta DB2 Users Group
  Things are changing with every release of DB2 for z/OS. More features for application developers to exploit and a few that are going away. In this session we will cover DB2 for z/OS version 9 and DB2 for z/OS version 10 and we'll see if we can find some stuff on DB2 for z/OS version 11.

This presentation is gear towards the application developer and the tricks that can make their application run smoothly and upgrade easier to the next release of DB2. Did you ever wonder how DB2 for z/OS new features are chosen; we'll have a look at that too. We look forward to seeing you at the session.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Development in a Virtualized Production Environment
  Ulf Heinrich, SEGUS Inc.
  Trustworthy access path visualization not only shows when performance changes, but also how, why, and what it changes to. Environment simulation allows exact access path simulation on another machine showing what will happen if you switch hardware or use different configurations for CPU, I/O, or memory. Create virtual indexes and see the results without affecting your real applications. Detect and understand Optimizer choices that originate from the environment and avoid any more unforeseen application behavior when moving a new release to production. These capabilities introduce a whole new world of "what if" opportunities and especially protect you from testing that doesn’t focus on what counts: the resulting performance in your production environment.
  11:45 - 12:45 Lunch
  12:45 - 2:00 Episode 9 – The Return of the Hierarchical Empire
  Ulf Heinrich, SEGUS Inc.
  The integration of XML in DB2 for z/OS V9 has been called the revenge of IMS. There is some truth in this because XML is a hierarchical structure, which is now integrated into the relational model. A few questions are brought up with this, like:
  • How do we access the data in XML structures?
  • What about indexing to improve performance?
  • Are there recommendations for database design?

In this presentation, we will highlight experiences with XML integration in DB2 for z/OS. Additionally, we will provide hints and tips on how to improve performance. Last, but not least, you will see why you should recall hierarchical "thinking modes" to survive in the new fashionable XML world.

  2:00 - 2:15 Break
  2:15 - 3:30 Eenie, Meenie, Miney, Mo! Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS?
  John Iczkovits, IBM
  Choosing the correct DB2 table (Space) type is requires careful analysis. Should I use a segmented table space, a universal table space (UTS partitioned by range or UTS partitioned by growth), HASH access, or a classic range partitioned table space? What about the page size? Does 4K, 8K, 16K, or 32K page size work best for my application requirements? Are there benefits to storing more than one table per table space? Are there benefits to using DB2 to compress the data? Choosing the correct attributes for by table and indexes the first time is essential to avoid costly re-work and outages. This presentation is designed to enlighten you on best practices for choosing the correct tables space types, page size and attributes for your data.

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.

Member Registrations
Non-Member Registrations

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 6th, 2013.

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
Ted Alexander has been working with DB2 for z/OS since version 2.1 in various roles, as Install Sysadm, Sysadm, Security Architect and Applications Developer. With experience on DB2 for z/OS and DB2 Linux UNIX and Windows, Ted understands many of the issues facing application developers when implementing a new or updated application, implementing a package application or implementing a new version of the databases.
Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. Ulf's specialties are DB2 availability and performance, focusing on the growing requirement for 24x7 operations and cost reduction. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real world recovery pressure. Ulf's activities cover EMEA, as well as North America through SE's U.S. subsidiary, SEGUS Inc.
John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability and he has held numerous positions at IBM including DB2 Systems Engineer, Database Administrator, DB2 consultant, and DB2 implementation project lead. He has 31 years of IT experience working with database products such as DB2 and IMS and with z/OS systems support and storage management. He has co-authored IBM redbooks, red papers, technical white papers, and I/T industry magazine articles. He often presents at customer events such as SHARE, IDUG, Information On Demand, zEXPO, IBM System z Technical Symposiums, CMG, and regional DB2 users groups.
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.