Seminar Program

Date: November 9, 2016 - Seminar Agenda

Location: The Crowne Plaza Hotel , Novi Michigan

        
8:15am - 9:00am Check In / Continental Breakfast
  
9:00 am - 9:05 am Meeting kickoff and Opening comments
 
9:05 am - 10:20 am "Trusted Context and Roles – How are you serving up your security?"
Speaker: Tony Poole (BMC)
Download "Trusted Context and Roles – How are you serving up your security?"
  
10:20 am - 10:40 am Break
  
10:40 am - 12:00 pm "The Natives are getting Restless, an overview of DB2 Stored Procedures”
Speaker: Tony Poole (BMC)
Download "The Natives are getting Restless, an overview of DB2 Stored Procedures”
 
12:00 pm - 1:00 pm Lunch - included as part of the seminar
 
  
1:00 pm - 2:15 pm "DB2 for z/OS V12 Early View”
Speaker: Randy Ebersole (IBM)
Download "DB2 12 Overview Nov UG 2016 Final"
  
2:15 pm - 2:30 pm Break
  
2:30 pm - 3:45 pm "Everything a DB2 for z/OS Application Developer Needs to Know About the DB2 Engine in 3.6 Milliseconds"
Speaker: Randy Ebersole (IBM)
Download "Everything a DB2 for zos Application Developer needs to know"
     

 

Presentation Abstracts

Presentation #1:

Tony Poole (BMC) - "Trusted Context and Roles – How are you serving up your security?"

Abstract:

Practical approaches to how to utilize these DB2 constructs to manage access and ownership of your objects and data. Using ROLE's to own and manage your objects and data can remove auth IDs and groups from the security picture. Useful information allowing you to verify whether you’re environment is as secure as you think it is!

Objective 1: Introduce and define the concepts of Trusted Context and Role

Objective 2: Illustrate how to utilize Role - WITH ROLE AS OBJECT OWNER--AND QUALIFIER

Objective 3: Illustrate implications when using ROLE vs AUTHID and GROUPS

Presentation #2:

Tony Poole (BMC) – "The Natives are getting Restless, an overview of DB2 Stored Procedures”

Abstract:

Stored Procedures were first added to DB2 for z/OS back in V5. Almost every release of DB2 since has added additional functionality or type of stored procedures. The different types of stored procedures have strengths and weaknesses. This presentation will provide a brief history of Stored Procedures in DB2 for z/OS, along with an overview of the schema used to create stored procedures. It will discuss the different types of stored procedures, External, External SQL and Native touching on some of the advantages and disadvantages of the different types. How can you test a new version of a Native stored procedure without affecting other executions of the active version? When it comes to deploying Native Stored Procedures across your environment, what options do you have available?

Presentation #3:

Randy Ebersole (IBM) – "DB2 for z/OS V12 Early View”

Abstract:

Every new release of DB2 for z/OS has a wealth of new features and functions and DB2 12 has delivered! This presentation is an early view of the long list of new features in DB2 12. Our focus is to provide details on the top features you should consider first as you begin planning on the exploitation of this newest version of DB2 for z/OS. Our focus will be on those features that deliver big returns for the broadest functional areas such as Query, OLTP and Insert performance, scalability in-memory usability and tablespace size, continuous availability features with a streamed line migration path, Easier application development and continued zAnalytics advancements.

Presentation #4:

Randy Ebersole (IBM) – "Everything a DB2 for z/OS Application Developer Needs to Know About the DB2 Engine in 3.6 Milliseconds"

Abstract:

In today’s world, DB2 for z/OS application requirements have become more complex than ever. This presentation is intended to provide the DB2 for z/OS processing fundamentals to the application developer. By increasing the developer’s awareness of how DB2 handles workloads, efficiencies will be realized. Areas such as index

 

Speaker Biographies

Tony Poole (BMC)

Tony Poole has worked in the mainframe industry for 31 years. He started his career as an analyst/programmer for IBM in 1985 after graduating from the Central Institute of Technology with a Bachelors in Computer Science. His DB2 experiences began with IBM and continued for the next 10 years in the UK/US as Tony gained experience working as a contract A/P across a variety of industry verticals. Tony joined a Southern Californian start-up in the late 90’s and joined BMC in 1999 as a Professional Services Consultant. Tony joined BMC’s R&D organization in 2001.For the past nine years he has been managing Engineering teams in the DB2 ADMINISTRATION product line area.

Randy Ebersole (IBM)
Randy Ebersole is an Executive Certified IT Specialist in IBM's Analytics Platform DB2 for z/OS Lab Services organization. Randy provides DB2 technical consulting to customers around the world. Randy is also involved with supporting customers participating in the DB2 Early Support Program. With over 30 years of practical, hands on DB2 experience, Randy has expert level skills in database, analytics and application design, DB2 system and application performance and high availability design.