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

When? Wednesday, December 9th, 2009, 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 A Row's Life
  Rick Weaver, BMC Software

Rows in a DB2 z/OS database get mauled and moved and wholly and partially duplicated. There are different ways to find them and different surroundings. And most DBAs find they need to understand these transformations thoroughly to manage performance and recovery and even security. In this presentation, we take a lighthearted view of one row's life to emphasize some of the internals of DB2 on the z/OS platform including impact of basic DML, Utility implications, and how various DB2 features (e.g. compression) impact the appearance of the row. Sessions opbjectives:

  • Have a high level understanding of the physical incarnation of data within a DB2 tablespace, log, and other resources.
  • See the impact of some data definition choices on the physical structure of a row.
  • See some differences DB2 Version 9 will introduce to row format and versioning.
  • Understand how the artifacts discussed can be used for recovery and other purposes.
  • Piqued interest in learning more details about physical page layout and logging within DB2.
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Audit your SOX off.
  Rick Weaver, BMC Software

We will discuss methods of using a DB2 log processing tool to accomplish the auditing requirements mandated in your environment. Discussion and examples will be included to show how to monitor power users (e.g. SYSADMs), track changes in authorizations and underlying structures, look for updates to sensitive columns and more. The additional uses of a DB2 log tool will also be covered to show how they can be used for transaction level recovery, data migration, adhoc and regular reporting, and for problem diagnosis. This presentation is vendor neutral, but Log Master for DB2 will be used in the examples. Sessions objectives:

  • Learn about log processing concepts with a brief overview.
  • Discussion and Examples of Audit compliance reporting .
  • Examples of how log based reporting can be used for problems diagnosis.
  • Transaction Level Recovery using a log tool.
  • Migration to a data warehouse, test system, or wherever you need.
  11:45 - 12:45 Lunch sponsored by BMC
  12:45 - 2:00 DB2 for z/OS Selected Performance Topics
  Roger Miller, IBM
  This talk will present some of the latest challenges and achievements for DB2 performance, noting some recent measurements and what can be achieved with the latest software and the latest hardware. The discussion will be centered on what you can do to help improve performance in your shop, particularly on the items that can help in DB2 9.
  2:00 - 2:15 Break
  2:15 - 3:30 Ask the developer (questions and answers)
  Roger Miller, IBM
  Open discussion (questions and answer). Attendees will be able to ask this key DB2 developer all their burning questions!

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 4, 2009.

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.