2016-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 reviews some of the more notable new feature deliveries in DB2 10 and 11, including support for RESTful APIs, automated cloud-style aaS provisioning, and improved performance. We will also take a look at the next release, DB2 12, which was recently announced for the Early Support Program (ESP). DB2 12 introduces many exciting new features to improve performance, increase availability, bolster security, add more autonomics, and enable new applications.

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 Jane Man, IBM, US

Applications around Mobile devices are becoming increasingly important in large enterprises with requirement of storing JSON in database. This presentation will illustrate the JSON storage model and SQL APIs to manipulate JSON data. Tips and pitfalls will be shared to ensure a successful JSON solution in an agile application development model.

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 John Campbell , IBM, US

Introduce and discuss the value of using larger real memory size to improve performance, how to design to run safely, and how to exploit the following features to reduce CPU resource comsumption: thread reuse, thread reuse with BIND option RELEASE(DEALLOCATE), large size page frames, long term bufferpool page fix, large size local and group bufferpool, and larger size global and dynamic statement cache.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 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 Leif Pedersen, DK, IBM and Thomas Sennels

 

Is DB2 for z/OS and Analytics workload a good fit? – In this session, Leif Pedersen, IBM, will update you on the latest enhancement and new features in the DB2 Analytics Accelerator and tell you how you can benefit from running your Analytics workload on DB2 for z/OS. 

Thomas Sennels, Danske Bank, will discuss the considerations Danske Bank has regarding the DB2 Analytics Accelerator, and how we have solved them or worked around them. Furthermore Thomas will focus on the next phase on possibilities with the DB2 Analytics Accelerator.

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

Thomas Sennels is 43 years old and has 15 years of mainframe experience. Thomas is working as a DBA in Danske Bank, with primary focus on development, enhancement and improvement of the DB2 environment, such as implementing the 2 new DB2 Analytics Accelerators.

By Haakon Roberts, IBM, US

Increasing pressure on experienced DBAs is becoming an acute problem. This session explains what IBM is doing about it by moving towards self-managing DB2 systems through delivery of an autonomic infrastructure. Gain an insight into the capability that is available today and the strategy going forward.

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

 In this presentation John will introduce and discuss some customer war stories, greatest hits in terms of positive and negative experience, and share recommended best practice on a number of hot topics. This will include discussion about locking with isolation RS, autobind, schema changes: table controlled vs. index controlled partitioning, GBP tuning, implications of V11 bufferpool management changes, insert space search algorithm and space reuse on delete, is restart light still useful, latest guidance on how to monitor and capacity plan for zIIPs, etc.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 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 Steve Thomas, CA, UK

Real Time Statistics were first made available as an optional feature by a PTF to DB2 V7. Since DB2 9 they have always been collected and the data is now fully integrated into the DB2 Catalog. The original aim of RTS was primarily to provide data to assist with the management of Imagecopies, Reorganizations and other Housekeeping tasks. While that remains a primary reason for their existence and something every site should be using, the last few releases of DB2 have added more valuable data which can be used for a variety of other purposes including performance analysis and even database index design. Are you getting the most value from the RTS data which you are burning CPU cycles to collect? Come to this session and understand how RTS data is collected, how you can manage and control this process and most of all how to make the most of this valuable data source.

Steve is a Senior Engineering Services Architect at CA Technologies, where he works with customers and helps influence future product strategy and direction. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Information Management since 2009 and is a regular speaker at User Groups across Europe and beyond. He has been a member of the Conference Planning Committee for IDUG EMEA for over 10 years  and served as the Chairman for the 2015 Conference in Dublin.

By Florence Dubois, IBM, US

With the explosion of data volumes today, businesses are looking for ways to copy huge volumes of data very quickly – from seconds to minutes – with minimal disruption to the running of applications. In this presentation, you will hear about practical use cases for IBM FlashCopy technology in a DB2 for z/OS environment including non-disruptive data integrity checks, FlashCopy image copies allowing for instant restore, SHRLEVEL(CHANGE) consistent image copy backups, system-level backup and recovery. We will provide many hints and tips on how to set up your environment, share lessons learned from customer experience and address common pitfalls.

Florence Dubois is an IBM Executive IT Specialist and a member of the DB2 for z/OS Development SWAT team. In this role, she consults for worldwide customers on a variety of technical topics, including implementation and migration, design for high performance and availability, performance and tuning, system health checks, disaster recovery. Florence presents regularly at conferences and has co-authored several IBM Redbooks publications. 

By Jeff Josten, IBM, US

Current hardware roadmaps are projecting that processor speeds will not serve as a significant source of performance improvement in coming years. Database systems are looking to use large memory to avoid I/O latency and to improve performance. The latest z machines allow for up to 10 TB of real memory, and the expectation is that memory will become more abundant and more economical in the future. DB2 11 and 12 releases add new features to use large real memories to deliver SQL performance improvements. This presentation will review these capabilities.

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

This session not only describes how to maximise performance, reduce CPU cost and improve application availability when running utilities, it also talks about how to avoid pitfalls that others have encountered that can prove extremely expensive in terms of lost time or even data.

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 Susan Lawson, YL&A, US

DB2 11 and 12 Performance Features...What Can I Take Advantage Of ?

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 11, and the next future release, 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. 

•         Discuss overall improvements and performance goals in DB2 11 and 12
•         Discuss features for improved application and database performance
•         Discuss features for improved data availability
•         Discuss features for advance application development
•         Discuss implementation and expectations of these 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.

By Susan Lawson, YL&A, US

Continuation of Session S211...

DB2 11 and 12 Performance Features...What Can I Take Advantage Of ?

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 11, and the next future release, 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. 

•         Discuss overall improvements and performance goals in DB2 11 and 12
•         Discuss features for improved application and database performance
•         Discuss features for improved data availability
•         Discuss features for advance application development
•         Discuss implementation and expectations of these 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.