2019 Db2 Track

By Leif Pedersen, DK, IBM and Kirsten Ann Larsen, JN Data, Danmark
DB2 Sessions: Room C first floor

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

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 Jeff Josten, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Abstract

Db2 is investing for leadership in the cloud, mobile, and analytics era, while extending our mainframe heritage of 24x7 availability, security, scalability, and performance.  This presentation reviews the latest Db2 enhancements including: zHyperLink support for ultra-fast read and write I/O, Huffman compression for improved Db2 data compression, Db2 native RESTful services improvements, Db2 AI for z/OS for embedding Machine Learning into Db2 for performance optimization, Db2 DevOps Experience for z/OS for cloud provisioning and CI/CD automation, IDAA impovements, as well as numerous improvements delivered in the V12 continuous delivery stream. 

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 Sessions: Room C first floor

Session Evaluation

Abstract

Db2 for z/OS utilities are used by everyone and in recent years there have been a lot of enhancements to transform usability, availability and performance. This makes it even more critical to understand the basic rules of how to run utilities. What are the essential things you need to know about how these utilities work to ensure REORGs are successful with minimal application impact? How can I ensure that LOADs run with a minimum of time and resource? Even how can I avoid table versioning problems with DSN1COPY? If these types of questions are important to you, then this session will demystify Db2 utilities and show you how to take full advantage of their untapped potential. 

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 John Campbell , IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

This double session (S203 and S211) introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Seconely, learn from the positive and negative experiences from other customer installations. The following topics will be discussed: Running out of basic 6-byte log RBA addressing range; Diagnosing resolving slow-downs and hangs; Hung Db2 threads; New ZSA keyword on HIPER and PE APARs; Insert free space search algorithm; Insert with APPEND; Fast un-clustered insert (Db2 12); Hidden ROWID support to partition; Cost management using CPU capping; Fast REORG with SORTDATA NO RECLUSTER NO; Requirement for increased RID Pool size (Db2 12); Setting initial STATISTICS PROFILE (Db2 12); System parameter REALSTORAGE_MANAGEMENT; Transaction level workload balancing for DRDA traffic; Use of High-Performance DBATs; Overuse of UTS PBG tablespaces and MAXPARTS; Cleaning up after STATCLUS = STANDARD; “MBA lock”; IRLM query requests for package break-in; Db2 maintenance issues with  batch utilities; Running CHECK utilities with SHRLEVEL CHANGE; Local buffer pool allocation – virtual and real memory. 

John J. Campbell is an IBM Distinguished Engineer reporting to the Vice President of IBM Analytics Private Cloud Product Development. He has extensive experience of Db2 for z/OS in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

By Henrik Henriksen, Danske Bank, DK
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

The keyword for this presentation is:

How we in Danske Bank work with partitioning of data.

How we use application parallelism to process high volumes of DB2 data in partitioned tables.

How we have migrated partitioned tablespace to UTS-R

Some experiences with UTS PBR RPN from our DB2 12 beta test.

The presentation will discuss partitioning from a performance, availability and scalability perspective.  We will start with some basic considerations about table design, clustering and partitioning of data. It will present different methods to partition a table. All based on practical experience. 

In Danske Bank we have a long tradition of running parallel batch on large partitioned tables. The presentation will give some tips about design of parallel batch application and discuss the performance benefit and pitfalls. 

In Danske bank we have converted our partitioned tablespaces to UTS. This presentation will share our experience. To materialize pending alters on large tablespaces can be challenge for all of us. This presentation will give some guidelines that can be used for UTS migrations as well as other large REORG with pending alters.

DB2 12 introduced a new type of tablespace UTS-R Relative page numbering. We will share our findings from test cases in the Beta program for DB2 12. What is the benefit from an availability and scalability perspective?

Henrik Henriksen has more than 33 years of experience with DB2. The experience include application development, Data Base design, Performance, tuning, replication and more. He has many years of experience as instructor in DB2 classes in Danske Bank and has presented at international DB2 events.   

He has participated in beta test of DB2 version 10, 11 and 12. He has completed the master class training set up by the DB2 swat team. 

By Jeff Josten, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

Db2 12 for z/OS contains many improvements to help customers maintain 24x7 availability across planned maintenance & upgrade activities, as well as unplanned outages.  This presentation covers the most relevant Db2 improvements in this area.

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: Room C first floor

Session Evaluation

Abstract 

High demand of large and complex data format has become an essential requirement in today’s business model. DB2 LOB data type enabled the user to process data with various format and maximizing the capability of storing large data. Managing the large volume of data has been a challenging task for DBA. DB2 for z/OS V12 has many enhancements to assists users in managing the LOB table space. This presentation will provide a comprehensive overview of managing Large Data (LOB) and it best practice

Objective 1: Overview of LOB data type and its operation 

Objective 2: What affects the performance of LOB table space

Objective 3: Db2 12 enhancement for performance and data compression 

Objective 4: Additional tips and hits when operating Db2 utilities with LOB

Objective 5: Performance recommendation Various techniques in managing the LOB data to reach optimal performance and its best practice

Frances Villafuerte 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 Claus E Mikkelsen, IBM, Denmark
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

Is Flash Copy Image Copy (FCIC) really lightning fast? Does it save a lot of CPU? How you can adopt FCIC as primary backup tool and practice Db2 recovery on a more regular basis than just when disaster has struck

Claus E. Mikkelsen has 32 years of experience in various DB2 disciplines, mainly focused on writing and tuning SQL. The last four years Claus has been working as a DBA. The assignment was to tune Db2 for z/OS systems, but was changed to focus on Db2 backup/recovery.

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

Session Evaluation

Abstract

Db2 Utilities Suite continues to be an intense focus area for improvement, delivering new capabilities in terms of availability, performance and usability. This session will provide a brief overview of what is new in Db2 12, but the primary focus will be on what has been delivered via APARs on V11 and V12 in the past few years. Enhancements that you can take advantage of today. 

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 Christopher Duellmann, BMC, Germany
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

Implementing the right strategy how to make images of your data for the unlikely event of data corruption or data loss is essential for your business. Once strategic decisions have been set up, the even more important question has to be answered which techniques to choose and to assemble in order to meet your goals. Recovery time objectives (RTO) and recovery point objectives (RPO) have to be considered as well as which business-critical applications have be recovered first in a situation where recovery is crucial. 

This presentation will start with a quick recap of which resources are necessary in a modern Backup & Recovery process and then will explain the Db2 z/OS possibilities. Because high-sophisticated techniques are provided by independent software vendors also, this presentation will take a closer look at exclusive features and architectural  product designs, that support the ambition of maximal speed, correctness, and integrity.

The end of the presentation will be focused on some special B&R processes that include data surgery to exclude bad data, and the always actual topic of data replication and data auditing to highlight technical alternatives besides unload and load processes.

Chris Duellmann is a Db2 principal consultant with a strong background in backup & recovery and database administration working at BMC Software for the last 21 years. He has over 30 years of Db2 experience and has presented at various conferences including GSE Guide Share, IDUG EMEA, and other international Db2 user events. 

In the past, he has been a systems programmer and DBA as well as a lecturer and technical advisor where he supported several large companies. He provided technical consulting for backup & recovery strategies in ERP environments, as well as implementing Db2 maintenance procedures in 24x7 high-availability systems. 

He is co-author for the BMC Best Practices Book Recovery Management.     

By Emil Kotrc , Broadcom, CZ
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

Db2 is constantly evolving over the years, bringing new features with every new release. It might be hard for the developers and administrators to catch up with all the new useful technologies and possibilities. Often, even the features that are not brand new and that have the potential to help reducing the costs by improving the performance or making the application simpler, are not yet fully exploited.

This presentation will list and remind some features that might help application developers to use more power of the Db2 engine. The discussed topics will cover advanced SQL like the MERGE statement, SELECT from data change references, multi-row operations, lock avoidance techniques, built-in functions like GENERATEUNIQUE(), timestamp functions, and some other small tips. We will also cover highlighted features of Db2 12.

Objectives:

1. Review some of the new features brought through the Db2 releases.

2. Advanced SQL statements like MERGE, SELECT FROM table change reference.

3. Multi-row operations, cursors.

4. Lock avoidance techniques.

5. Several smaller tips using built in functions. 

Emil Kotrc is a principal software engineer at CA Technologies working in Prague Technology Center since 2005. He started on Resource management products for Mainframe and later moved into Database management for DB2 for z/OS development. Before joining CA Technologies, Emil worked in an academic environment.

By John Campbell , IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Abstract

This double session (S203 and S211) introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Seconely, learn from the positive and negative experiences from other customer installations. The following topics will be discussed: Running out of basic 6-byte log RBA addressing range; Diagnosing resolving slow-downs and hangs; Hung Db2 threads; New ZSA keyword on HIPER and PE APARs; Insert free space search algorithm; Insert with APPEND; Fast un-clustered insert (Db2 12); Hidden ROWID support to partition; Cost management using CPU capping; Fast REORG with SORTDATA NO RECLUSTER NO; Requirement for increased RID Pool size (Db2 12); Setting initial STATISTICS PROFILE (Db2 12); System parameter REALSTORAGE_MANAGEMENT; Transaction level workload balancing for DRDA traffic; Use of High-Performance DBATs; Overuse of UTS PBG tablespaces and MAXPARTS; Cleaning up after STATCLUS = STANDARD; “MBA lock”; IRLM query requests for package break-in; Db2 maintenance issues with  batch utilities; Running CHECK utilities with SHRLEVEL CHANGE; Local buffer pool allocation – virtual and real memory.

John J. Campbell is an IBM Distinguished Engineer reporting to the Vice President of IBM Analytics Private Cloud Product Development. He has extensive experience of Db2 for z/OS in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.

By Frances Villafuerte, IBM, US
DB2 Sessions: Room C first floor

Session Evaluation

Abstract 

Db2 for z/OS strategist Universal Table Space (UTS) has been a widespread adoption by many customers as they have been taking actions to convert legacy table space to UTS. Identifying which type of UTS table space to be used has become a challenge task for DBA. This presentation will provide a lesson learned from customer’s experience and things to think about and its best practice. 

Objective 1: Overview of design rational of Partition by Growth, Partition by Range or Partition by Range RPN table space.

Objective 2: This presentation will provide use case of each type of UTS.

Objective 3: Many table space attributes such as SEGSIZE, DSSIZE, MEMBER CLUSTER or MAXPARTITION can affect the operation of UTS. This presentation will provide information on how table space attributes affect performance on UTS.

Objective 4: How indirect reference records affects space usage and performance. 

Objective 5: Recent experience learned from customer - use case  

Frances Villafuerte 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.