Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>
Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM
9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.
10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
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 delivered SQL PL support for array parameters, and introduced autonomous native SQL procedures DB2 12 provided additional SQL PL enhancements, including the ability to use SQL PL in the definition of database triggers. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also cover exploitation of SQL PL routines to enhance DB2 for z/OS performance, scalability, and security -- particularly for client- server applications.
11:45 -1:00 Lunch - Sponsored By: IBM
1:00 - 2:15 Presenter: Randy Ebersole, IBM
* "DB2 System Profiles- How Can They Help?"
More and more complexity of distributed access to DB2 for z/OS requires a more granular ability to manage resources. This technical session will show how DB2 system profiles can be used to monitor threads for remote TCP/IP access to DB2(r) servers. Additionally, details will be provided on how to use system profiles to manage resources by particular clients, applications, and users, and prioritize resources accordingly.
* "DB2 12 Continuous Delivery - Start Planning"
DB2 12 introduces continuous delivery of new capabilities and enhancements in a single service stream as soon as they are ready. The result is that you can benefit from new capabilities and enhancements without waiting for an entire new release. This presentation will discuss how to begin planning for continuous delivery by considering how you will be able to control the timing of the activation and adoption of new features, with the option to continue to apply corrective and preventative service without adopting new feature function.
2:15 - 2:30 Break
2:30 - 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.
3:45 - 4:00 Closing
This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.