2021 Db2/DevOps Track

By Kirsten Ann Larsen, JN Data, Danmark
DB2 Sessions: Room C first floor

Kirsten Ann Larsen works as a DBA at JN Data A/S in Denmark. She has 20+ years of experience with Db2 and z/OS in a number of different roles and companies, including DBA, SQL and system tuning, architecture and XML. She holds a master’s degree in Computer Science from Aarhus University. She has co-authored a number of articles and redbooks on Db2 and is an experienced presenter.

DB2 Sessions: Room C first floor

Session Evaluation

Encourage your developers to test early and often to ensure faster delivery of quality code. In this session you will hear about some of the best practices and tools for creating automated unit tests for z/OS applications., Konnine Alpers

 

DB2 Sessions: Room C first floor

Session Evaluation

Why is it so hard to Adopt Devops ?, Anders Hecquet DXC 

By Haakon Roberts, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

In the era of V12 continuous delivery, Db2 development continues to provide new enhancements both within and outside new function levels. This session will provide a review of overall Db2 strategy, the highlights of V12 and go into more detail on recent improvements delivered via APARs and PTFs. 

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 Kirsten Ann Larsen, JN Data, Danmark
DB2 Sessions: Room C first floor

Session Evaluation

Tuning SQL using EXPLAIN STMTCACHE.

Speaker TBD

Kirsten Ann Larsen works as a DBA at JN Data A/S in Denmark. She has 20+ years of experience with Db2 and z/OS in a number of different roles and companies, including DBA, SQL and system tuning, architecture and XML. She holds a master’s degree in Computer Science from Aarhus University. She has co-authored a number of articles and redbooks on Db2 and is an experienced presenter.

By Jane Man, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Are you interested in getting insight from your enterprise data? Is existing solution too costly and/or too general that cannot satisfy your needs? In this session, we will show you how to do database analytics and write your own ML scoring function customize for your own environment. Using an easy to adapt example, we will illustrate how you can achieve this step by step. We will also illustrate use cases such scoring function can be used (like embed in a SQL statement). Hints and tips are provided to help you to avoid pain points, and improve development efficiency.

Jane Man is a key member of the development team in Db2 for z/OS. She has worked on various features of Db2 for z/OS. In addition to her development work, she has assisted a lot of customers on implementing successful applications/workloads. In addition, she is the enablement focal point in the team and is involved in many enablement activities, like creating sample applications, demos, hands-on labs, and presenting in conferences and bootcamps, etc. Before joining the DB2 development team, Jane was a developer in IBM Content Manager. Jane is a IBM Certified System Administrator for WebSphere Application Server, IBM Certified Database Administrator for DB2 Universal Database for z/OS, Linux, UNIX and Windows, IBM Certified Solution Designer for DB2 Content Manager, IBM Certified Deployment Profession for Tivoli Storage Manager, and IBM Certified Application developer for DB2 Universal Database Family. 

By Haakon Roberts, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Db2 Utilities development continues to deliver significant new features and performance improvements on a regular basis. This session will cover all the recent enhancements; explaining their value and how to take full advantage of them. 

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 Jørn Thyssen, Rocket Software, DK
DB2 Sessions: Room C first floor

Session Evaluation

System provisioning, DevOps, Continuous Delivery / Integration are all modern-day initiatives that accelerate the delivery of business applications. Several open source tools can be used to orchestrate and automate these tasks. In this session we will show how you can build Db2 for z/OS pipelines. Examples include maintaining and deploying ZPARMS, installing a product and running SQL and DDL leveraging z/OSMF, Zowe and vendor tools. We will use Jenkins which is one of the most popular open source orchestration tools but the techniques shown can be used with other orchestration tools.

Jørn Thyssen has worked almost 20 years on the mainframe platform as a developer, application DBA, application architect, technical field specialist, and more recently as a Db2 tools product specialist for Rocket Software. He is also an 2019 IBM Champion. 

By Frank van der Wal, IBM, NL
DB2 Sessions: Room C first floor

Session Evaluation

Just like Newton explained the attraction between objects by the Law of Gravity, we see a metaphor in data and applications. As datasets grow, they become harder to move and are likely to attract applications rather than moving data to the applications. As we all know, data on IBM Z both is significant in size as well as in freshness. We might ask ourselves why do we need to ETL, morph, and manipulate data off the platform to another place? And although this paradigm already exists for many years, we see that IBM has recently put together a significant amount of technologies that makes it worth while to re-evaluate Enterprise Data strategy. In this session you'll learn how data on Z might fit in such Enterprise Data Strategy while complying to a hybrid multi-cloud approach.

Frank van der Wal is European Technical Leader for Data & AI on IBM Z. In this role he supports and lead engagements with customers and key influencers communities, to raise the visibility and true capabilities of the contemporary capabilities on IBM Z in the Data and AI domain.

By Kirsten Ann Larsen, JN Data, Danmark
DB2 Sessions: Room C first floor

Session Evaluation

The session introduces Db2 AI for z/OS and explains two main features - SQL optimization and System assessment. With SQL optimization feature, Db2 AI for z/OS applies machine learning insights from your workload characteristics to find better access paths for SQL queries aiming for CPU and elapsed time savings. System Assessment feature combines machine learning with IBM domain expertise to provide customized recommendations for performance tuning based on your operations statistics. Learn how Db2zAI utilizes machine learning technology to optimize data base performance.

Kirsten Ann Larsen works as a DBA at JN Data A/S in Denmark. She has 20+ years of experience with Db2 and z/OS in a number of different roles and companies, including DBA, SQL and system tuning, architecture and XML. She holds a master’s degree in Computer Science from Aarhus University. She has co-authored a number of articles and redbooks on Db2 and is an experienced presenter.

By Marcus Davage, BMC
DB2 Sessions: Room C first floor

Session Evaluation

Over the years, the role of the DBA has included SQL Guru, High Priest of z/OS, Scribe of the Sacred Site Standards, Gatekeeper to Production, and Management Piñata. Now, in these Strange Days of DevOps, the role of the DBA is to change yet again.

Marcus has been a Db2 systems programmer and/or database administrator since V2.3 in 1992. He has worked with Db2 on z/OS, OS/2 (awww *sniff* remember that?), LUW and iSeries and has written many Rexx/Db2 routines. He has spoken at IDUG and UK Db2 events, and is currently co-chairman of the GSE UK Db2 User Group. He is a Lead Product Developer for AMI-DevOps for Db2 at BMC Software.

By Jane Man, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

A new era of applications focused around cloud and machine learning is becoming increasingly important in large enterprises. Kubeflow is an open source Machine Learning toolkits for Kubernetes. It also provides a platform for building, deploying, and managing multi-step workflows on Kubernetes (based on Docker containers). In this session, we will first walk through a sample application to train, serve, and test a ML model using Kubeflow. Then, we will illustrate how to leverage Kubeflow to create, invoke, and drop a database service.

Jane Man is a key member of the development team in Db2 for z/OS. She has worked on various features of Db2 for z/OS. In addition to her development work, she has assisted a lot of customers on implementing successful applications/workloads. In addition, she is the enablement focal point in the team and is involved in many enablement activities, like creating sample applications, demos, hands-on labs, and presenting in conferences and bootcamps, etc. Before joining the DB2 development team, Jane was a developer in IBM Content Manager. Jane is a IBM Certified System Administrator for WebSphere Application Server, IBM Certified Database Administrator for DB2 Universal Database for z/OS, Linux, UNIX and Windows, IBM Certified Solution Designer for DB2 Content Manager, IBM Certified Deployment Profession for Tivoli Storage Manager, and IBM Certified Application developer for DB2 Universal Database Family. 

By Kirsten Ann Larsen, JN Data, Danmark
DB2 Sessions: Room C first floor

Session Evaluation

Db2 for z/OS continues to provide the enhancements to improve the performance under the continuous delivery model. 

This session covers the latest performance updates from Silicon Valley Lab. and covers both existing and new exciting features. The new features include Db2 exploitation of z14 zHyperLink which provides the lightning fast I/O response time, deeper compression with Huffman compression, elapsed time improvement with Async CF cross invalidation. The session provides the information of the key metrics to monitor when you enable Db2 12 performance features and covers hint & tips from experiences gained from IBM evaluations as well as from early adaptors.

Kirsten Ann Larsen works as a DBA at JN Data A/S in Denmark. She has 20+ years of experience with Db2 and z/OS in a number of different roles and companies, including DBA, SQL and system tuning, architecture and XML. She holds a master’s degree in Computer Science from Aarhus University. She has co-authored a number of articles and redbooks on Db2 and is an experienced presenter.