Central PA Regional DB2 User Group - June 7

Terry Gawlas

Central PA Regional DB2 User Group - June 7

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 http://www.db2parug.org

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