Baltimore/Washington DB2 Users Group Weds, 12/9

Kim May

Baltimore/Washington DB2 Users Group Weds, 12/9

Join us for presentations by: Curt Cotner, Paul Westfall, Rick Weaver,
Roger Miller and Steve Rosenberger!

Two tracks! DB2 for z/OS and DB2 for LUW

The Baltimore/Washington DB2 Users' Group

Meeting Schedule for December 9, 2009 (Wednesday)

Sheraton Hotel, Columbia, Maryland

To register please visit our new website:

DB2 for LUW Track Agenda:

8:30 - 9:00 Registration

9:00 - 10:15 "Scaling OLTP Applications on DB2 for LUW with
Clustering Technology"

Paul Westfall, IBM

Organizations running online transaction processing (OLTP) applications on
distributed systems that require high availability can now utilize cluster
technology similar to DB2 for z/OS shared-disk storage that enables multiple
nodes to operate against a single physical database. This delivers
scalability, high-availability and the ability to load balance. This
presentation will explain in detail how it works and how it compares with
other high availability solutions available for DB2 for LUW.

10:15 - 10:30 Coffee Break

10:30 - 11:45 "Revolutionizing the Data Abstraction Layer"

Curt Cotner, IBM
Looking for a more flexible and efficient way for Java programs to access
the database? Join us as we explore how you can bridge the gap between Java
and relational databases. Enhance your Java environment with access layer
generation, data access best practices, traceability between Java packages
and SQL statements, improved impact analysis, and more. And most
importantly, see how new technology can improve not only new development,
but existing applications as well.

11:45 - 12:45 Lunch

12:45 - 2:00 "Case Study: Implementing an Archiving Solution"

Steve Rosenberger, FEPOC

In this presentation Baltimore/Washington DB2 Users Group Board Member Steve
Rosenberger will present a case study on his organization's implementation
of an archiving solution. The Service Benefit Plan Administrative Services
Corporation (SBPASC), aka Federal Employee Program Operations Center
(FEPOC), a subsidiary of CareFirst BCBS, implemented an archiving solution
for their claims DB2 database. Steve will review the factors considered
prior to implementation, the implementation plan and process followed, and
suggestions for other organizations considering an archiving solution.

2:00 - 2:15 Break

2:15 - 3:30 "Accelerating Solution Delivery for Data-Driven

Curt Cotner, IBM
Accelerate your existing Java applications, leverage static SQL, reduce
cost, and gain insight, reliable performance, problem determination, and
control over which SQL is issued from where in your Java applications.
Whether your application uses Java Database Connectivity (JDBC), the Java
Persistence API (JPA), Hibernate, Spring or IBatis, existing programs can be
improved without changing the code.

The presenters:

Paul Westfall, IBM

Paul Westfall has been an Information Management Specialist with IBM for
over 13 years, helping customers along the east coast implement IBM's data
management solutions. He has worked with every distributed release of DB2
for Linux, Unix and Windows, and has recently been focused on data
warehousing, XML, and information integration.

Curt Cotner, IBM

Curt Cotner Vice President & Chief
Technology Officer for Database Servers

Curt Cotner is an IBM Fellow, and a member of the IBM Academy of Technology.
Curt is the chief technology

officer for the DB2 family and Informix IDS database servers, and has both
management and technology oversight

responsibility for all the client software offerings used with DB2 and IDS.
This includes the client runtime APIs

(JDBC, .NET, CLI, pureQuery, etc.) and the application development and
administration tools offerings (IBM Data

Studio). Prior to taking his current assignment, Curt was the chief
architect for the DB2 for z/OS development team.

Steve Rosenberger, FEPOC

Steve has nearly 30 years of Information Technology experience in the
healthcare industry. His career began in applications, coding COBOL and
Assembler Language programs. He held positions in CICS Systems Programming,
Database Administration and finally in management. He has been responsible
for Change Management, Disaster Recovery and Business Continuity Services
and most recently Data Management. In his current role he is responsible for
database administration, data architecture and everything data. Core systems
execute in a multi-platform environment consisting of z/OS, UNIX and Windows
while data warehousing systems operate on the UNIX platform. He enjoys just
about any outdoor activity and 'relaxes' maintaining his small farm and
creating gardens for his wife in Northwestern Virginia.

DB2 for z/OS Track:

8:30 - 9:00 Registration

9:00 - 10:15 A Row's Life

Rick Weaver, BMC Software

Abstract - 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.

Session Objectives:

. 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

Abstract - 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.

Session 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 session 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!

The presenters:

Rick Weaver

Rick Weaver has over 30 years of experience
in Systems and Database Administration for IMS and DB2

database systems, and has been involved in
developing large, complex, mission critical applications in a

variety of business areas. At BMC since
1994, Rick has worked in Software Consulting, Professional Services,

Product Marketing, and Product Management.
Rick is currently Product Manager for DB2 Solutions,

responsible for setting product direction
and managing release requirements for the BMC Software

DB2 for z/OS product line.

Roger Miller

DB2 for z/OS technical evangelist,
strategist, architect, designer, developer, writer, service,

DB2 factotum (from the Latin for does
everything or jack of all DB2 trades, master of several). Roger's current

projects include working to roll out DB2 9 for z/OS, and to design the next
improvements in DB2.

Roger's technical accomplishments include
being a DB2 for z/OS technical evangelist, architect

and designer working on many facets of DB2,
ranging from overall design issues to SQL, languages,

install, security, audit, standards,
performance, concurrency, and availability. He has worked for 30 years

on DB2 development, product design and
strategy. He often helps customers to use the product, answers

many questions and presents frequently to
user groups. B.S. Mathematics, Stanford University,

M.S. Quantitative Methods of Business, U.C.L.A. Fun facts - Roger likes
hiking, bicycling, music, reading, Shakespeare,

Yosemite and bears. He has learned to like working out with a personal


* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________ is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!

If you need to change settings, is the home of IDUG's DB2-L