2017-DB2 Track

By Jyrki Kannosto, FIN, Tieto and Leif Pedersen, DK, IBM

Jyrki has 40 years experience working with mainframes. During this time he has worked as a computer operator, PL1 programmer and an IMS systems specialist. More recently his career has been focused in DB2 where he is a system specialist and DBA. He currently has responsibility as the DB2 working group chairman and is a manager of a DBDC group for Tieto in Finland.

Leif Pedersen is passionate about the System z platform and especially how the DB2 database technology on this platform can be used to provide values to clients, to IBM business, and to the world in general. As a Technical Leader, Leif is involved in many projects to help customers in Europe, to improve their business by taking advantage of the latest database technology like Analytics by using the DB2 Accelerator for DB2 for z/OS or the Blu feature of DB2 for Linux, Windows, and Unix on Linux for System z. Leif also helps customers to take advantage of using database performance and testing tools to improve their database performance and testing

By Jeff Josten, IBM, US

This presentation gives a high level overview of DB2 12, and also some other interesting features which have shipped recently on DB2 11 (and sometimes DB2 10) including native DB2 RESTful services, DB2aaS cloud-style provisioning, and IDAA on Cloud. We will also take a peek into the future for what is planned beyond DB2 12.

Jeff Josten is an IBM Distinguished Engineer and the lead architect of DB2 for z/OS.  He has worked in DB2 Development at the IBM Silicon Valley Lab since 1985. He owns several patents in the area of data base technology, and is a frequent speaker at user group and customer meetings.

By Haakon Roberts, IBM, US

You might already be aware that DB2 12 for z/OS is forming the basis of a continuous delivery model where new function will be delivered in the maintenance stream rather than on a release boundary. But how will it actually work? How can you retain control of the roll out of function? How will this affect your maintenance strategy? How will it affect vendor products that you depend upon? This session will have all the answers.

 

Haakon Roberts has nearly 30 years' experience working with DB2 on the mainframe platform spanning various aspects of sys-tems programming, database administration, software support and development. He is a Distinguished Engineer at the IBM Silicon Valley Laboratory in San Jose, California and the chief technical architect for DB2 for z/OS Utilities and Tools. He is a regu-lar speaker on these and other topics. 

By Michael Dewert, IBM US

This session will share very early experiences from DB2 12 Early Support Program customers and customers involved in early deployment. The overall goal of the session is to help customer migrates as fast as possible, but most importantly to arrive safely. The session has the following objectives: share lessons learned, surprises, pitfalls; provide hints and tips; address some myths; provide additional planning information; provide usage guidelines and positioning on new enhancements.

Michael Dewert is a IBM senior certified DB2 Consulting Specialist and Senior Software Engineer based in Germany, working for IBM DB2 z/OS development (Silicon Valley Laboratory).  He has over 25 years of experience working with DB2 z/OS. Before joining IBM in 2001, he worked for large banking IT providers in Germany. He has mainly worked on DB2 z/OS and parallel sysplex data sharing, but also experienced in z/OS system programming, other subsystem environments like, CICS, IMS DC/DB. WebSphere, client/server, etc. DB2 data sharing implementations aiming for high availability and performance always was one of his key interest and focus areas. He is also a co-author of IBM DB2 Redbooks and White Papers. Currently he works as a member of the DB2 z/OS Development SWAT team supporting customers across various industries and geographies.

By Kendirck Ren, IBM US

Modern application development requires automated deployments. Many organizations have implemented automated application deployments for distributed platforms, but retain manual deployment processes for System z Applications. Learn how to adopt modern, automated application deployments on System z using Urban Code Deploy. This presentation will demonstrate automated deployment of a complex system z application that uses DB2 to multiple targets.

Kendrick Ren is a senior software engineer and lead developer for cloud offering and devops solution in DB2 for z/OS development, working out of the IBM Toronto Lab. Before this, he was the overall technical lead for Optim Query Workload Tuner as well as the previous incarnations as DB2 Optimization Expert and Optimization Service Center products since the products were borned. Kendrick has more than 15 years of experience in database application design/development/deployment, query optimization and performance areas, and also has been working closely with customers and business partners in these areas.

By Gareth Z Jones, IBM UK

DB2 z/OS EXPLAIN is a vital tool available for application developers and database administrators who need to understand what access paths have been chosen by the DB2 Optimizer, and why. This presentation starts with the very basics of DB2 for z/OS EXPLAIN, and builds on that to provide you with the understanding of its infrastructure. You will learn about the EXPLAIN tables, how to populate them and how to analyse the information in them.

Gareth Z. Jones has worked in IT since 1985, Until 2000, he was an IBM customer, with experience as a systems programmer and DBA. He is now works in DB2 for z/OS development, as a member of the SWAT Team, which is led by John Campbell. He has worked with many customers around the world to help them be successful in their use of DB2. He has written several technical papers and presented at many conferences and many group meetings.

By Jeff Josten, IBM, US

This presentation gives a deeper level of technical information about the major features of most interest in DB2 12.  We will also look at early DB2 12 customer experiences and technical discussions of some of the features planned for after DB2 12.

Jeff Josten is an IBM Distinguished Engineer and the lead architect of DB2 for z/OS.  He has worked in DB2 Development at the IBM Silicon Valley Lab since 1985. He owns several patents in the area of data base technology, and is a frequent speaker at user group and customer meetings.

By Haakon Roberts, IBM, US

DB2 12 for z/OS delivers massive improvements in terms of data scalability and availability. In addition there are a number of significant improvements that have been delivered in the maintenance stream in V11 that you can take advantage of today. This session will explain what you need to know and give practical advice on how to plan for the future in DB2.

 

Haakon Roberts has nearly 30 years' experience working with DB2 on the mainframe platform spanning various aspects of sys-tems programming, database administration, software support and development. He is a Distinguished Engineer at the IBM Silicon Valley Laboratory in San Jose, California and the chief technical architect for DB2 for z/OS Utilities and Tools. He is a regu-lar speaker on these and other topics. 

By Kendirck Ren, IBM US

One of the most difficult challenges for businesses is dealing with business outages due to unexpected query performance regressions. These issues can be difficult to identify, diagnose, and resolve. This investigation may occur while business response times suffer. This presentation will show how DB2 12 for z/OS Dynamic Plan Stability feature can be used to attain unprecedented query performance reliability for dynamic SQL. Specifically the presentation will show how to: - Examine the statement cache to identify candidates - Stabilize dynamic statements - Identify stabilized and non stabilized statements - Examine properties of stabilized statements (dependencies, explain data) - Identify statements to FREE using LASTUSED.

Kendrick Ren is a senior software engineer and lead developer for cloud offering and devops solution in DB2 for z/OS development, working out of the IBM Toronto Lab. Before this, he was the overall technical lead for Optim Query Workload Tuner as well as the previous incarnations as DB2 Optimization Expert and Optimization Service Center products since the products were borned. Kendrick has more than 15 years of experience in database application design/development/deployment, query optimization and performance areas, and also has been working closely with customers and business partners in these areas.

By Gareth Z Jones, IBM UK

DB2 for z/OS is an "automatic navigation" database. It frees application developers and other users from the task of telling DB2 how to retrieve data from the database; instead, you just tell the database what data you want. The DB2 Optimizer then determines, as far as possible, the most efficient way to retrieve the data from the database and builds an access path (or access plan). Application developers and database administrators often need to understand what access plan has been chosen when analysing performance problems. This presentation outlines some of the most common access plans used by DB2 and explains how they actually work.

Gareth Z. Jones has worked in IT since 1985, Until 2000, he was an IBM customer, with experience as a systems programmer and DBA. He is now works in DB2 for z/OS development, as a member of the SWAT Team, which is led by John Campbell. He has worked with many customers around the world to help them be successful in their use of DB2. He has written several technical papers and presented at many conferences and many group meetings.

By Susan Lawson, IBM, US

With every new release of DB2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in DB2 12, that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features that can be utilized by DBAs and application programmers.

Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM GOLD Consultant for DB2 and z/Series, and an IBM Information Champion and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’ and the IBM ‘DB2 for z/OS V7 Application Programming Certification Guide’. She is also the co-author of several DB2 books including the IBM ‘DB2 10 for z/OS DBA Certification Guide’, IBM ‘DB2 9 for z/OS DBA Certification Guide’, ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’. She is also a SME(Subject Matter Expert) for the IBM Certification exams for DB2 z/OS Database and System Administration assisting with writing and verifying questions for the exams.