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

When? Tuesday, December 11th, 2012, 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 Recent changes in DB2 for z/OS Logging
  Jim Dee, BMC Software

How well DB2 handles Log data can be a critical factor in maximizing performance, particularly in a high transaction rate environment. There have been a number of changes in the area of Logging over recent DB2 releases. Some of these have been obvious improvements such as the ability to use DFSMS Striping for Active Log datasets, but there have been Logging implications in some other changes such as the introduction of Reordered Row Format. However, many sites I visit have not really investigated these changes in any detail and the impact they might have on their operations. This presentation provides an update on changes to how DB2 manages logging updates and some useful hints and tips you will be able to take away and use to review your logging environment.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 The Natives are getting Restless, an overview of DB2 Stored Procedures
  Frank Rhodes, BMC Software

Stored Procedures were first added to DB2 for z/OS back in V5. Most every release of DB2 since has added additional functionality or type of stored procedures. The different types of stored procedures have strengths and weaknesses. This presentation will provide a brief history of Stored Procedures in DB2 for z/OS, along with an overview of the schema used to create stored procedures. It will discuss the different types of stored procedures, External, External SQL and Native touching on some of the advantages and disadvantages of the different types. How can you test a new version of a Native stored procedure without affecting other executions of the active version? When it comes to deploying Native Stored Procedures across your environment, what options do you have available?

  11:45 - 12:45 Lunch
  12:45 - 2:00 Virtualize Production in DB2 z/OS with Profiles
  Jim Dee, BMC Software

Most sites understand the importance of having a performance measurement/assurance environment to validate the performance of new or changed SQL. The snag is, as DB2 gets smarter about its environment, it gets increasingly difficult to guarantee that the performance DB2 subsystem really does behave the same as the real production subsystem(s). This is why IBM have introduced Production Virtualization to "fool" a DB2 subsystem into thinking that certain aspects of its environment are actually different from reality - making it possible to model a production subsystem in a completely separate LPAR. This session looks at how this has been implemented - with a couple of dsnzparm changes and addition to the capabilities of DB2 Profiles. As always, things are never quite as simple as they might have been.

  2:00 - 2:15 Break
  2:15 - 3:30 An XML Document's Life - Dr. Node!!!
  Frank Rhodes, BMC Software

XML continues to be an emerging technology and more features are being added to DB2 to support it. So what is this new XML data type? Follow the adventures of 'Dr. Node', an XML document as he gets inserted into a DB2 table. Not only will you see how he is related to his parent row but you will learn about his hierarchical tree structure and the catalog tables involved in supporting him. You will also see how to use the new DB2 10 XMLMODIFY commands to manipulate individual nodes within Dr. Node. In order to verify Dr. Node's integrity, we will discuss the impact of the new DB2 10 Check Data syntax for XML spaces. Finally we will look at how a Reorg impacts the doc'tor'. We will end with a discussion of how things could have been different in Dr. Node's life with non-versioning versus multi-versioning, indexing with the new Date and Timestamp data types, and the new zparm value that allows for DOCID's to be randomized.


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 7th, 2012.

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
Jim Dee is a Corporate Architect in the Mainframe Business Unit of BMC Software. He is responsible for the technical content and integration of the DB2 for z/OS product lines. He has worked at BMC Software since 1990, mostly in DB2 Backup and Recovery, as a developer, product author, and architect. Prior to joining BMC Software, Jim worked at various employers in the IT industry for 16 years. He worked as an application developer, systems programmer, DBA, and vendor developer.
Frank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products that he has primary responsibility for are ALTER for DB2, Change Manager for DB2, Catalog Manager for DB2 and DASD Manager Plus for DB2. Frank has been a Developer on the Change Manager for DB2 product for over 10 years. His main areas of responsibilities being the development and maintenance for the Analysis Engine as well as the product's user interface. Prior to joining the Change Manager Product team, he worked on the TIS Install for the Administrative products. He was the lead developer in charge of the initial implementation of a common install for all of the DB2 products. Prior to BMC, Frank worked as a Systems Programmer for IBM in support of NASA JSC's administrative processors. He supported installation and maintenance of MVS products and was in charge of implementing Automated Operation for IBM's internal systems as well as NASA's systems. Frank holds a Bachelors Degree in Computer Science from the Texas A & M University.
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.