Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013

Lori Ann Galluzzo

Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013
Central PA Regional DB2 User Group
Date: Weds. December 11th, 2013
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]> - BY December 4th, 2013!
Agenda for Weds. December11th, 2013

8:30-9:00 Breakfast & Announcements
Sponsored By: CA Technologies

9:00-10:15 "DB2 11 Technical Overview - Part 1"
Presenter: Jay Yothers, IBM Corporation

This presentation will provide a technical preview of DB2 11. As in the past many DB2 z/OS releases, DB2 11 has a wealth of performance improvements as well as a long list of new functionality. This presentation gives the attendee an early view of the benefits and functionality that is being delivered with DB2 11 to allow for technical planning in migrating to this next version of DB2 for z/OS.

10:15-10:30 Break

10:30-11:45 "DB2 11 Technical Overview - Part 2"
Presenter: Jay Yothers, IBM Corporation

This presentation is a continuation of DB2 11 Technical overview.

11:45 -1:00 Lunch - Sponsored by CA Technologies
12:15-12-45 - Lunch & Learn - "Dynamic Data Center & Chorus Product Support Features"
Presenter: Bob Anderson - CA Technologies

The role of the data center is rapidly evolving from simply supporting established business processes to continuously driving innovation through the optimal alignment of IT resources. Moving forward, the most effective organizations will progress to a fully integrated and dynamic data center.
CA ChorusTM is the first and only mainframe solution architected to manage multiple disciplines by providing a platform for unified change for DB2 DBAs, Security and Compliance Administrators, and Managers of Networks, Systems and Storage. It re-invigorates the customer experience by delivering a visionary, discipline-based workspace designed to transform the way customers manage critical systems, applications and resources. It provides an intuitive design and embedded intelligence to appeal to novice staff while also offering significant productivity improvements for today's experts.

12:45 - 1:00 - Drawings

1:00-2:15 "Don't Copy Prod to Test!"
Presenter: Bob Anderson, CA Technologies

Many companies build their test databases by copying production data over to the test system. If your production data includes private financial or HIPAA information you or your company could be at risk of lawsuits or loss of employment if you are thought responsible for this kind security breech. We'll look at some of the applicable law and discuss what this means to you and your company.

2:15-2:30 Break

2:30-3:45 "Using DB2 9 Native Stored Procedures"
Presenter: Bob Anderson, CA Technologies

Native SQL stored procedures are new for DB2 9. They offer less overhead, are zIIP eligible and are easier to write, in short a win/win/win situation. We will cover the writing and definition of native SQL stored procedures and discuss the new capabilities for versioning these procedures. We will also cover the new SQLFORMAT option and new coding support for Extended GOTO and Nested compound statements. Next we will look at testing and debugging capabilities, including a sample Rexx exec to quickly verify the functionality of the new procedures quickly. Measuring and monitoring resource consumption will be covered. We will then cover deployment commands and migration from existing external SQL procedures to the new native SQL procedures. Finally we will discuss documentation resources that to learn more about native SQL stored procedures.

3:45-4:00 Closing

Lori Galluzzo
Database Administrator - Data Engineer III
US Data Engineering Capability
HP Enterprise Services
Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011

IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS