DB2 11 z/OS Migration process
Jim Brogan - IBM
Abstract:
DB2 11 was one year old in October, 2014. It is time to start thinking about migration to the latest version of DB2 for z/OS.
The migration steps look similar, but there are some key considerations and differences this time around. The Migration Planning Workshop
is a full day event, and these presentation will cover the key aspects of DB2 11 z/OS.
Planning, Prerequisites, Incompatibilities, deprecated items, Application Compatibility , Statistics Feedback,Archive Transparency, and
Extended RBA/LSRN features.
Bio:
Jim Brogan is an IBM Certified Consulting IT Specialist. Throughout his 40+ year career, Jim has had many roles in the IT industry
including those of DBA, DBA Manager, and Database Consultant at many large corporations including United Technologies Corp,
General Electric, and Westinghouse. Jim's Database experience includes IMS, DB2 z/OS, DB2 for LUW, and Oracle. His current responsibilities
are as an IBM DB2 Advisor and Infosphere (IDAA and Replication) CTP providing technical support to the IBM sales team and customers on
the Z Series platform in the Northeastern United States.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Going Native: Leveraging DB2 for z/OS Native SQL Procedures and User-Defined Functions
Robert Catterall - IBM
Abstract:
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to user-defined
functions (UDFs) with DB2 10. DB2 11 has delivered additional SQL PL-related enhancements. This session will provide information
that attendees can use in the development, management, and monitoring of native SQL procedures and UDFs. It will also cover exploitation
of native SQL procedures and UDFs to enhance DB2 for z/OS performance, scalability, and security -- particularly for client-server
applications.
Bio:
Robert Catterall is an IBM Consulting DB2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s
as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology
strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010.
Robert is a past President of IDUG, and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences, and blogs about
DB2 for z/OS at http://robertsdb2blog.blogspot.com/.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB2 for z/OS Distributed Data Facility Questions -- and Answers
Robert Catterall - IBM
Abstract:
The DB2 distributed data facility (DDF) is, increasingly, the primary channel through which DB2 for z/OS data is accessed. As DB2
people deal with the growing volume and variety of DDF workloads, associated questions come to the fore. How do you effectively monitor
DDF activity? How should DDF-using applications be architected? How can a DDF workload be managed and controlled? How do I secure data
accessed via DDF? This session will provide answers to these and related DDF questions -- questions asked by real users in the real world.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB2 11 for z/OS Optimizer Enhancements
Mark Rader - IBM
Abstract:
DB2 11 for z/OS provides additional opportunities for CPU savings, and many of these savings come from enhancements to the DB2 Optimizer.
Most of the benefits accrue based only on package rebinds; others will require some action to exploit. This session explores the
optimizer changes and how you can realize the potential benefits.
Bio:
Mark Rader is a Senior Consulting IT Specialist with IBM working with DB2 for z/OS clients. He has over 30 years of technical experience
with IBM, primarily with DB2 for z/OS. focusing on data sharing, performance, and DB2 and WLM interaction. He has led many DB2
data sharing implementations and has presented a variety of topics at Insight (IOD), Enterprise, IDUG and SHARE conferences and at
regional user group meetings. He is an author of redbooks on Parallel Sysplex application considerations, DB2 data sharing, and
DB2 for z/OS distributed function.