By Jyrki Kannosto, FIN, Tieto and Leif Pedersen, DK, IBM
DB2 Sessions: ZETA

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.

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
DB2 Sessions: ZETA

DB2 Latest News and Continuous Delivery. DB2 12 is the latest release of DB2 for z/OS, it is built on the core capabilities of DB2 11 and gives businesses the capabilities needed to meet the business demands of the future by providing scale and speed for next era of Mobile and Interconnected devices along with application support for Cloud and Analytics.  It delivers faster analytical insights and leverages advanced speedy In-Memory database performance. This session will give a quick recap of the DB2 12 features of most interest, and the latest news for DB2 11 and 12. We will also cover the latest on DB2 continuous delivery, which delivers features faster than ever before and in a more consumable way for customers.

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 Gareth Z Jones, IBM UK
DB2 Sessions: ZETA

DB2 12 for z/OS Migration Planning and Early Experiences to help customers migrate as quickly as possible but safely to the new release covering: Share lessons learned, surprises, pitfalls; Provide hints and tips; Address some myths; provide additional planning information; Provide usage guidelines and positioning on new enhancements; Help customers migrate as fast as possible, but safely.

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 Paul Oostvogel , BMC, UK
DB2 Sessions: ZETA

As DB2 buffer pools are still a key resource for good performance, your primary concern remains how many pools you need, what size they will be, and which objects go in which pools. DB2 has multiple buffer pool thresholds, variable and fixed. Now you can even simulate behavior. Time to revisit thresholds how they can affect, and help. Review the buffer pool commands and output detailed information on characteristics as well as the incremental performance metrics. Additional to large continuous buffer pools and simulated buffer pools, we touch on functionality added in v12 to move to in-memory database, like fast index traversal.

Providing a short history and review of settings, sizes, placement, thresholds, fixed and variable

Short recap on setting and managing thresholds

Simulated buffer pools, and examining the effect of simulated buffer pool sizes

Review the –DISPLAY BUFFERPOOL DB2 command output detailed information on buffer pool characteristics as well as the incremental performance metrics 

Is DB2 v12 the in-memory database?  

 

In 1984 Paul Oostvogels started in IT as a IMS programmer. Moved into systems engineering for IMS, and later DB2 for z/OS, before joining BMC in 1995. Currently, Paul is Advisory Consultant supporting all aspects of BMC’s mainframe data management and cost optimization solutions.

By Patrick Bossman, IBM, US
DB2 Sessions: ZETA

This presentation relies heavily on demos to show how to adopt DevOps principles to automate development operations.  Demonstrations include automated application deployment including schema changes, practices allowing continuous integration and continuous delivery on mainframes.  There are sure to be some new goodies continuously delivered in 2018 the developer self-services space that I cannot publish at the moment.

Patrick Bossman is a Senior Technical Staff Member for DB2 for z/OS Development. His current role is the lead architect of DB2 for z/OS DevOps and Cloud Provisioning. This includes REST enablement of services to provision, configure, manage, and use DB2 for z/OS. Patrick also assists with the solution design of install, migration, 24x7 application availability, query optimization and performance tuning and tooling.

By Jeff Josten, IBM, US
DB2 Sessions: ZETA

DB2 12 introduced a new way of keeping index information in a memory-optimized structure outside of the buffer pools to reduce the index traversal  index traversal costs. This structure is called a Fast Traverse Block (FTB) and it can significantly improve application performance and reduce CPU with no application changes needed. This presentation tells you what you need to know to get the most benefit from this feature for your installation.

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 Frances Villafuerte, IBM, US
DB2 Sessions: ZETA

Design database for better availability, scalability and reliability with DB2 V12.  High demand of data availability is an essential requirement in a 24/7 environment. DB2 V12 provides additional features that enables the user to manage large database object while maximizing availability and scalability.    

This presentation will provide a comprehensive overview of V12 features that gives greater availability, scalability and reliably for large database design.
 
The contents includes :
1.        Lift Partition limit with UTS PBR RPN - The next generation of partitioned table space
2.        Insert Partition  
3.        Online schema enhancements  
4.        Improvement of partition-level REORG for PBG table spaces

NB. This session is also relevant for students.

Frances is a key senior engineer and lead architect of data structure design in DB2 z/OS Development team. She has been responsible for several critical functional areas within the product which including Online Schema evolution, Space Management, Performance improvement, LOBs and Real Time Statistics. She has great experience working with customers to design their DB2 system for optimal performance and availability. In addition, she is also a frequent speaker in various conferences.

By Steen Rasmussen, CA, US
DB2 Sessions: ZETA

Understanding “the normal behavior” of the DB2 applications (static as well as dynamic SQL) can be a challenge, but using existing performance metrics and baseline these could put you in a situation where you can take action before the SLA’s are violated and even save you a lot of headaches in the “war room” finger pointing.    

1) Is the Green Highway really Green and what is it ?

2) Why baselining ?

3) Static versus dynamic baselines pros and cons.

4) Moving average and Electric Rules – what’s happening with DB2

5) Avoiding War Room meetings and finger pointing

NB. This session is also relevant for students.

Steen Rasmussen is a Principal Engineering Services Architect currently instrumental in the ongoing development and support of the CA Technologies DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.
Steen has been working with DB2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at CA technologies working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Steen is honored to be an IBM Champion for four years.

By Gareth Z Jones, IBM UK
DB2 Sessions: ZETA

DB2 12 for z/OS Migration Planning and Early Experiences to help customers migrate as quickly as possible but safely to the new release covering: Share lessons learned, surprises, pitfalls; Provide hints and tips; Address some myths; provide additional planning information; Provide usage guidelines and positioning on new enhancements; Help customers migrate as fast as possible, but safely.

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 Patrick Bossman, IBM, US
DB2 Sessions: ZETA

Patrick Bossman will walk through the process the lab follows to determine root cause of query performance problems.  This will be peppered with best practice recommendations and explanations.  Everyone from beginner to advanced is likely to learn something

Patrick Bossman is a Senior Technical Staff Member for DB2 for z/OS Development. His current role is the lead architect of DB2 for z/OS DevOps and Cloud Provisioning. This includes REST enablement of services to provision, configure, manage, and use DB2 for z/OS. Patrick also assists with the solution design of install, migration, 24x7 application availability, query optimization and performance tuning and tooling.

By Frances Villafuerte, IBM, US
DB2 Sessions: ZETA

DBAs often needs to alter schema definitions of objects to support evolving needs of applications. A common scenarios occurs when a DBA copying data from one subsystem to the other and must synchronize the definitions of these objects.  When the DBA might not succeed in synchronizing object definitions in the catalog can cause application outage and significantly affect the requirement of 24/ 7 environment.  This presentation will start with an overview of DB2 data versioning and presenting the common scenario of " do's and don't's" when using DSN1COPY to copy data cross different DB2 subsystem. A new option introduced in REPAIR utility that provides better reliability capability to enhance application availability after DSN1COPY.

Frances is a key senior engineer and lead architect of data structure design in DB2 z/OS Development team. She has been responsible for several critical functional areas within the product which including Online Schema evolution, Space Management, Performance improvement, LOBs and Real Time Statistics. She has great experience working with customers to design their DB2 system for optimal performance and availability. In addition, she is also a frequent speaker in various conferences.

By Susan Lawson, YL&A, US
DB2 Sessions: ZETA

With every new release of Db2 we look to see what features can help us better design tables and indexes to maximize availability and improve overall performance. We will discuss many issues surrounding alternative table and index designs for performance and availability current with Db2 12 for z/OS. We will look at many options to help design tables and indexes for the best performance possible for the type of application process and how to achieve high availability. There are many issues to consider for supporting very large tables, high volume inserts and updates, responsiveness to readers and providing continuous availability of the data. Db2 12 breaks limits that we faced in the past allowing us to explore new alternatives as well as providing for improved performance in several areas.

Discuss challenges with designing tables and indexes to support various workloads

Discuss alternative designs for tables/indexes in order to achieve high performance/availability

Discuss features introduced in various releases for improved database performance and availability

Discuss features introduced in Db2 12 breaking old limitations

Discuss implementation and expectations of new features

 

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 books, articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM Gold Consultant and an IBM Analytics Champion and is the author of the IBM DB2 11 for z/OS Database Certification Review Guide. 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.