Reminder! Central PA DB2 User Group 6/7!

Terry Gawlas

Reminder! Central PA DB2 User Group 6/7!
If you are interested in attending the user group, please let me know!

Central PA Regional DB2 User Group

Date: Wednesday, June 7, 2006
Place: Camp Hill Corporate Center, Building 300, Large Auditorium
Cost: FREE
Reservations: Email or call: [login to unmask email] (717) 302-3991

For details and directions: See

Agenda for June 7, 2006

8:00-8:30 Breakfast & Announcements
Breakfast Sponsored By: Tom Doering & Mona Hogue, Mainstar

8:30-9:40 Help! My Storage Administrator Doesn?t speak DB2! What Can I
Presenter: John Iczkovitz, IBM Advanced Technical Support (ATS)
Learn how to talk to your Storage Administrator about DB2. Learn how to
get our DB2 technology and architecture across to your Storage
Administrator so they can better handle DB2. Get some key points from a
storage perspective to be able to ask the proper questions and have your
Storage Administrator help you out in your future DB2 endeavors.

9:40-9:55 Break

9:55-11:05 Faster Fetch and Insert ? DB2 V8 Multiple Row processing
Presenter: John Iczkovitz, IBM Advanced Technical Support (ATS)
Multiple Row Insert (MRI) and Multiple Row Fetch (MRF) are new SQL
constructs for DB2 for z/OS V8. This presentation will delve into the
details you will need to know to take advantage of the performance and
functional enhancements introduced with MRI and MRF. Information on
usage, for local and distributed applications, and interaction with other
SQL constructs such as Scrollable Cursors, UPDATE and DELETE WHERE CURRENT
OF, and a quick discussion of GET DIAGNOSTICS statement will be presented.
MRI and MRF will be compared and contrasted to existing techniques used by
the DB2 family for processing multiple rows ? Limited Block Fetch (LBF)
and Chained Inserts (LBF and Chained Inserts are DRDA constructs used by
DB2 to reduce network traffic).

11:05-11:35 Lunch
Sponsored By: Tom Doering & Mona Hogue, Mainstar

11:35-12:45 Lunch & Learn ? Data Cloning Made Easy!
Presenter: Reggie Culpepper, Mainstar
Many z/OS applications have critical requirements for quick, accurate
cloning of entire DB2 subsystems. Data cloning requirements can stem from
the need for production or development copies which can be used to refresh
DB2 test beds, recovery initiatives, query-only access, or reporting.
Utilizing current methodologies, data cloning can require the better part
of a day and can take several days to complete. With the demand for usable
clones increasing, it's imperative to make data cloning an easy, automated
process with minimal downtime. There are many replication tools that can
be used to create replicas of data. The challenge is how to access the
data once it?s been created, since these products rarely, if ever, manage
the renaming and cataloging of the data to produce a usable clone. Learn
data cloning issues and challenges, items to consider and how with the
right tools, you can completely automate the cloning process. With
automation, the time to create a data clone can be reduced from hours or
days to minutes. A data cloning methodology will be discussed that
utilizes Mainstar's MS/VCR to automate the entire cloning process,
including the renaming of all data sets.

12:45-1:00 Break

1:00? 2:15 The perfect combination: zSeries, z/OS, and DB2
Presenter: Willie Favero, IBM
The synergy between IBM?s zSeries processors, their z/OS operating system,
and their premier database DB2 for z/OS has never been greater. Total
cost of ownership is being reduced. Shared functionality is improving.
All while performance, availability, and scalability continue to improve.
This presentation will discuss the latest improvements in zSeries and z/OS
that DB2 has been able to take advantage of and how this unbeatable
combination is still your best choice in the industry. If you have
anything to do with DB2, from a programmer to manager, system programmer
to DBA, you need to hear this presentation.

2:15 ? 2:30 Break

2:30-3:45 The Best Defense is a Good Defense
Presenter: Willie Favero, IBM
The best way to protect your DB2 for z/OS investment is to aggressively
prepare for the next release. Just because migrating to DB2 for z/OS
Version 8 may only be a dream today, that is no reason to put off the
planning and preparation for your almost guaranteed move to you will have
to make to Version 8 tomorrow. There are lots of things you can do today
to get ready for the eventual migration tomorrow. This presentation will
review and discuss the task available while on Version 7 (or before) so
you are in the right shape to do a Version 8 migration.

3:45-4:00 Closing

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