By Jeff Josten, IBM US

Cloud computing is big business as more people look for ways to reduce costs and speed deployment. With dynamic, flexible platforms, cloud solutions can scale and maximize your return on investment. Many people don’t realize that System z was born as a cloud platform. For more than 30 years, DB2 for z/OS has offered many of the benefits of cloud computing such as multi-tenancy,
elastic scalability, high availability and unmatched security and reliability. A majority of Fortune 500 companies store their mission-critical operational data on DB2 for z/OS. You can do more for less in an environment that you control to ensure that security, service and access requirements are maintained at predictable costs.


This session will give an overview of some recent technical advancements that position DB2 for z/OS even more strongly for the age of cloud and mobile computing. This includes z/OS Management Facility (zOSMF) which allows for streamlined installs and migrations, which can not only help system programmer productivity but can also be used as a base for self-service cloud-style provisioning. Also Rational Urban Code Deploy (UCD) plugins for DB2 which can enable more agile application DevOps patterns.  And z/OS Connect which can enable new mobile and hybrid cloud application patterns for DB2.  Other topics will also be discussed.

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 Steve Thomas, CA UK

Optimizer Hints have been available since DB2 Version 6 in 1999. This old method was hard to use and prone to error as it relied on the QUERYNO for each statement to link the SQL to the hint. If your program changed causing the QUERYNO to be different then the hint would not operate correctly. To resolve these problems DB2 10 for z/OS introduced a completely new method of providing hints based on the SQL Text and a Repository built into the DB2 Catalog. They can be applied to an SQL statement wherever it appears in the DB2 subsystem. Other advantages the new method provides include the ability to override certain Bind Options at the Statement rather than at the Package level, such as controls over Star joins and Parallelism options. DB2 11 has built on the initial implementation by allowing you to provide Filter Factors for predicates where the Optimizer is not able to calculate them, such as where Host Variables, Parameter Markers or Expressions are being used. This allows the Optimizer to make a more informed decision on the correct access path to use based on your knowledge of the application. This session will describe how to use System Level Access path hints as introduced in DB2 10 for z/OS, along with th additional features that have been added with DB2 11 for z/OS.

Steve is a Senior Engineering Services Architect at CA Technologies. In this role he reports into the R&D organization and ensures customers get the most out of their tools as well as helping influence future product strategy and direction. Steve has been a DB2 Specialist for 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 10 years  and is honored to be serving as the Chairman for the 2015 Conference in Dublin.

By John Campbell, IBM UK

This is part one of a two part session aims to share information and experiences from early customer migrations to DB2 11 for z/OS. The objectives are to: share lessons learned, surprises, pitfalls; provide hints and tips; address some myths, provide additional planning information, provide usage guidelines and positioning on new enhancements. Ultimately this session is to help customer installations migrate as fast as possible, but also safely.

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

This is the second part of a two part session aims to share information and experiences from early customer migrations to DB2 11 for z/OS. The objectives are to: share lessons learned, surprises, pitfalls; provide hints and tips; address some myths, provide additional planning information, provide usage guidelines and positioning on new enhancements. Ultimately this session is to help customer installations migrate as fast as possible, but also safely.

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 Martin Hubel, DB2 Consultant, Fundi Software,  CANADA

Is it a DB2 problem? DBAs always hear this question. In fact, today’s complex z/OS environments involve many subsystems such as CICS, DB2, IMS, and WebSphere MQ. Some problems do not clearly indicate their origin. For example, IMS or CICS users might report slow response time, but to solve the problem, you may need to correlate DB2 with other measurement data across subsystems to discover the root cause.
This presentation looks at the available sources of performance and log data both inside and outside of DB2, and describes the value of this data for forensic transaction analysis, problem determination and tuning

Martin Hubel is a consultant to Fundi Software and has worked extensively with DB2 since 1985. Martin develops and teaches DB2 advanced courses and is recognized as a leading authority in the field. He has been using DB2 Universal Database on Linux, Unix, and Windows since 1993 and has participated in several beta test programs for these platforms. He is an IBM Gold Consultant and Information Champion, and a member of the IDUG Volunteer Hall of Fame. Since 1991, he has come to the Nordic GSE every 8 years.

By Jeff Josten, IBM US

This session will review the key DB2 11 features and will also take a peek into the future at the next DB2 release code named Cypress. DB2 for z/OS continues to evolve to meet the needs of modern applications. At the same time, DB2 continues improving its industry leading performance, scaling, availability, management and security capabilities to continue meeting the needs of the most demanding operational environments into the future.  The following areas will be covered:

  • Performance:  DB2 11 delivers out-of-the-box performance improvements that will benefit a wide range of customer workloads. 
  • Simplification:  DB2 11 provides several improvements which reduce the time and effort required to manage DB2 systems. DB2 migration tasks are also made significantly easier.
  • Availability and Security:  DB2 11 extends the industry leading availability and security capabilities for the System z platform.
  • Extended SQL and Analytics Capabilities:  DB2 11 delivers several important SQL and XML enhancements, along with new capabilities for JSON and Big Data.
  • DB2 Cypress plans to deliver important new features to help DB2 customers stay ahead of continually escalating business and technical requirements. 

 

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 Phil Grainger, BMC UK

Most sites understand the importance of having a performance measurement/assurance environment to validate the performance of new or changed SQL

The snag is, as DB2 gets smarter about its environment, it gets increasingly difficult to guarantee that the performance DB2 subsystem really does behave the same as the real production subsystem(s)

This is why IBM have introduced Production Virtualization to "fool" a DB2 subsystem into thinking that certain aspects of its environment are actually different from reality - making it possible to model a production subsystem in a completely seperate LPAR

This session looks at how this has been implemented - with a couple of dsnzparm changes and addition to the capabilities of DB2 Profiles. As always, things are never quite as simple as they might have been

Phil has over 20 years experience of DB2, starting work all those years ago in 1987 with DB2 Version 1.2. Since then he has worked with all versions, including DB2 10

From his beginnings as a DB2 DBA for one of the largest users of DB2 at that time in the UK, through his time at PLATINUM technology and including almost 10 years as Senior Principal Product Manager for CAs line of DB2 solutions, Phil has always been a keen supporter of user groups and is a regular speaker at both vendor sponsored and independent events. His work with IDUG includes being a past member of the European IDUG Planning Committee, an inductee into the IDUG Volunteer Hall of Fame and now Board Liaison for BMC Software

Phils focus as Senior Principal Product Manager for DB2 tools at CA was with an international view as to the usage of DB2

In 2009, 2010, 2011, 2012 and 2013, Phil was honoured by IBM as an Information Champion

Phils is now at BMC Software working as their Lead Product Manager in support of their DB2 tools portfolio

In addition, Phil is a regular contributor to the IDUG sponsored
DB2-L discussion list

By Phil Grainger, BMC UK

There are many ways of looking at the temporal data support in DB2 for z/OS - most of them spend time looking at the syntax of the new DDL required to create temporal managed objects

This session is different

We will look at the life of a generic insurance policy as an example of how Temporal Data support can simplify application development and provide simple access to historical data purely by coding relevant DML clauses

 

Phil has over 20 years experience of DB2, starting work all those years ago in 1987 with DB2 Version 1.2. Since then he has worked with all versions, including DB2 10

From his beginnings as a DB2 DBA for one of the largest users of DB2 at that time in the UK, through his time at PLATINUM technology and including almost 10 years as Senior Principal Product Manager for CAs line of DB2 solutions, Phil has always been a keen supporter of user groups and is a regular speaker at both vendor sponsored and independent events. His work with IDUG includes being a past member of the European IDUG Planning Committee, an inductee into the IDUG Volunteer Hall of Fame and now Board Liaison for BMC Software

Phils focus as Senior Principal Product Manager for DB2 tools at CA was with an international view as to the usage of DB2

In 2009, 2010, 2011, 2012 and 2013, Phil was honoured by IBM as an Information Champion

Phils is now at BMC Software working as their Lead Product Manager in support of their DB2 tools portfolio

In addition, Phil is a regular contributor to the IDUG sponsored
DB2-L discussion list

By John Campbell, IBM UK

This session will introduce and discuss all the major availability and data sharing enhancements in DB2 11 for z.OS. For data sharing, enhancements in the in the following areas will be covered: group buffer pool and castout, CF DELETE_NAME, Restart light enhancements, locking, indexing. For availability, enhancements in the in the following areas will be covered: BIND/REBIND/DDL break-in with persistent threads, IFCID 306 support for old compression dictionaries, Online Alter Partition Limit Keys, Deferred alter PIT recovery, DROP Column, Workfile, Defer Define Object, Extended RBA/LRSN, Auto Clean-up of Pseudo-deleted Index Entries.

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

With every new release of DB2 we look to see what features will allow us to improve the performance of our existing applications and the availability of our data. We also begin to plan to utilize new feature in our development efforts. This presentation takes a look at the features in DB2 11 that will both improve our performance and provide us with maximum data availability.

·        Discuss overall improvements and migration goals in DB2 11

·        Discuss features for improved application and database performance

·        Discuss features for improved data availability

·        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 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.

By Susan Lawson, YL&A US

With every new release of DB2 we look to see what features will allow us to improve the performance of our existing applications and the availability of our data. We also begin to plan to utilize new feature in our development efforts. This presentation takes a look at the features in DB2 11 that will both improve our performance and provide us with maximum data availability.

·        Discuss overall improvements and migration goals in DB2 11

·        Discuss features for improved application and database performance

·        Discuss features for improved data availability

·        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 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.