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

Lori Ann Galluzzo

Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013 - sign up by Decemer
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


Lawrence Gero

Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013 - sign up by Decemer
(in response to Lori Ann Galluzzo)
 
 Count me in... sounds like a good meeting for developers.

Regards,

Lawrence H. Gero
C: 717-405-8607



On Tuesday, December 3, 2013 4:07 PM, "Galluzzo, Lori (HC Product Support)" <[login to unmask email]> wrote:


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]   - 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 ChorusTMis 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] 
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
 
 

-----End Original Message-----

Odessa Fennen

Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013 - sign up by Decemer
(in response to Lawrence Gero)
Thanks!

From: Lawrence H. Gero [mailto:[login to unmask email]
Sent: Tuesday, December 03, 2013 5:55 PM
To: [login to unmask email]; [login to unmask email]
Subject: [DB2UGCENPA] - RE: Central PA IDUG Regional User Group Meeting Agenda - Weds. December 11th, 2013 - sign up by Decemer 4th!


Count me in... sounds like a good meeting for developers.

Regards,

Lawrence H. Gero
C: 717-405-8607

On Tuesday, December 3, 2013 4:07 PM, "Galluzzo, Lori (HC Product Support)" <[login to unmask email]<mailto:[login to unmask email]>> wrote:
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



Site Links: View post online<http://www.idug.org/p/fo/st/post=161056&anc=p161056#p161056> View mailing list online<http://www.idug.org/p/fo/si/topic=65> Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscriptionhttp://www.idug.org/p/us/to
** ** ** Attend the 2014 EMEA IDUG DB2 Tech Conference ** ** **
---> Prague, Czech Republic, 9 - 14 November, 2014 <---
www.bit.ly/IDUGEMEA2014

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2


-----End Original Message-----