Baltimore/Washington DB2 Users Group--Meeting Announcement--December 12, 2007

Henry Nalven

Baltimore/Washington DB2 Users Group--Meeting Announcement--December 12, 2007
The Baltimore/Washington DB2 Users' Group
Meeting Schedule for September 12, 2007 (Wednesday)

Wednesday, December 12, 2007, 9:00 AM-3:30 PM
(Registration at 8:30)

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

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

To pre-register, please mail the appropriate fee with attendee's and
employer's name to:

P.O. BOX 18554

All pre-registrations must be received by
Friday, December 7, 2007. Make checks payable to the
Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on website

Visit our website,, for more information.

Baltimore/Washington DB2 Users' Group Meeting

Date: December 12, 2007 (Wednesday)
Location: Sheraton Columbia
10207 Wincopin Circle
Columbia, MD
(410) 730-3900


8:30 - 9:00 Registration

9:00 - 10:15 DB2 z/OS XML for SQL People
Stan Goodwin, IBM Corporation

This presentation is a building block approach to learning
about the XML capabilities and implementation in DB2 9 for z/OS. The
presentation will cover the basics of XML, XML Components, and
XML/database techniques. In addition, the DB2 9 pureXML implementation will
be described in-depth, down to the DSN1PRNT of the data page, and then a
quick scenario will be presented

10:15 - 10:30 Coffee Break

10:30 - 11:45 Ins and Outs of Distributed Processing in DB2 z/OS
Bill Arledge, BMC

More and more DB2 application workloads originate off the
mainframe, utilizing technologies like DB2 Connect, Websphere Application
Server, and others. This shift to increased distributed processing presents
new challenges in understanding and managing DB2 application
implementation. This session discusses basic issues about distributed
applications, including distributed fundamentals, implementation
considerations, problem identification, and performance management for your
DB2 z/OS distributed applications

11:45 - 12:45 Lunch sponsored by BMC
(Product session: PRESENTATION BY BMC)

12:45 – 2:00 Demystifying the Dynamic Statement Cache
Bill Arledge, BMC

The Dynamic Statement Cache in DB2 has the potential to
greatly improve performance for dynamic SQL. As with most things, there are
tradeoffs and costs to be considered with this DB2 feature. In addition, the
implementation of the cache often changes from release to release. This
technical session will discuss the Dynamic Statement Cache to help you
understand how the cache is implemented as well as the contents of the
cache and how you can mine the statistics stored there. Possible benefits,
the costs of the cache, and potential issues related to use of the Dynamic
Statement Cache will also be discussed.

2:00 - 2:15 Break

2:15 - 3:30 DB2 Recovery Resources in Review
Bill Arledge, BMC

DB2 on z/OS, like all database management systems,
provides backup and recovery functionality that allows you to recover your
data from problems, whether they are catastrophic or local to a single
application structure or device. This capability is supported by a combination
of utilities and recovery assets that identify the state of a DB2 object at
different points in time. This presentation takes a look at the recovery assets
and utility processes that are used to implement backup and recovery in the
DB2 environment. The assets that will be discussed include:

• The boot strap data set (BSDS)
• SYSCOPY catalog table
• SYSLGRNX directory table
• Active and archive logs

The flow of DB2 utilities and of the system used in
recovery will be presented.


IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at