By Jeff Josten - IBM Silicon Valley Lab
This presentation covers the latest on DB2 10 customer experiences and new features functions, with a special focus on data sharing.
We will also take a peek into the future and discuss plans for the next release, DB2 11.
Jeff Josten is an IBM distinguished engineer and lead architect for DB2 for z/OS.
By John J. Campbell, IBM (UK)
The DB2 for z/OS optimizer is continually evolving with each release, and for static SQL, REBIND is generally recommended to take advantage of these new optimizations. But how do customers minimize their exposure to access path regression for static SQL? What about dynamic SQL that is exposed to the new optimizer on day 1? And then there is the RUNSTATS enhancements that came in DB2 9 and then in DB2 10. Can I model the potential impact before I get to
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 Maryela Weihrauch, IBM (US)
DB2 for z/OS uses DRDA as distributed communication protocol. Starting with V8, DB2 clients changed the communication protocol to also use DRDA. Now, distributed DB2 configuration could be simplified by DB2 clients directly connecting to DB2 for z/OS server resulting in better performance and availability. Nevertheless, a culture has developed around DB2 Connect gateway management that seems to make the migration away from DB2 Connect gateways to direct DB2 client connections difficult. Maryela will go through migration approach and discuss migration considerations around configuration, process implication and trouble shooting, monitoring to help with the migration process.
Maryela Weihrauch is a Distinguish Engineer with DB2 z/OS development.
She has been working with customers around the world to design their DB2 systems and applications for optimum performance and availability.
Currently, she drives DB2's technology in support of Service Oriented Architecture (SOA) and real time Business Analytics. Maryela is frequently sharing her experience at conferences.
By John J. Campbell, IBM (UK)
Objectives
- Understand real storage monitoring and control
- Introduce and discuss performance opportunities and surprises
- How to plan for and execute online release migration
- Introduce and discuss release incompatibilities
Topics
Real storage control
Release migration in 24*7 environment
Steps to investigate CPU performance
OPTIMIZE FOR 1 ROW
OPTIOWGT
zIIP Capacity
CHAR, VARCHAR, CAST
ECSA
Preventative Service
SPT01/DBD01 space growth - base and LOB tablespaces
64-bit common and shared
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 Patrick Bossmann, IBM US
This session will preview DB2 for z/OS V11 Query Optimization enhancements. Learn of improvements in query transformations, query costing, and query execution improvements to improve the performance of your queries.
Patrick Bossman started working with DB2 in 1993. Patrick has worked as a customer with DB2 as an applications programmer, database designer and administrator, and complex query performance tuner. Patrick joined IBM in 1999 as a DB2 Advocate where he assisted customer with query performance tuning. Patrick joined the DB2 for z/OS Query Optimization team in 2000 working on query performance service. Patrick is a STSM within the DB2 for z/OS Query Optimization organization and is responsible for service as well as identifying areas of improvement in query optimization and query tuning tools. Patrick holds numerous patents in the area of query optimization and query tuning tools.
By Phil Grainger, BMC UK
During the design of a DB2 application, there is now a lot more to consider than just “what should the tables look like”. We need to take into consideration where we should create indexes, and why. We might think about partitioning for performance or for manageability. What about partitioned and non partitioned indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option to create Materialized Query Tables, but when would these be good to use?
This presentation steps through some of the new (and not so new) elements of DB2 database design and highlights pros and cons of each
Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in your case will always “depend” on circumstances, but hopefully this presentation will give you the information you need to make informed choices
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 and 2012, 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 Jeff Josten - IBM US
Bi-temporal data was a new feature delivered in DB2 10 for z/OS and later also
for DB2 LUW which gives novel new constructs to allow applications to easily
manage data entities in DB2 along time period dimensions, and also to query
along time dimenions in the past, present or future. This is done with standardized
SQL syntax. Use of this feature can provide powerful new application capabilities, and
can greatly simplify application development and maintenance.
Jeff Josten is an IBM distinguished engineer and lead architect for DB2 for z/OS.
By Patrick Bossman, IBM US
Learn how to mitigate the risk of production query performance regression using a variety of recently introduced DB2 for z/OS features. This session takes a scenario specific approach on using new features to reduce the risk of performance regression in cases such as DB2 maintenance, release migration, and rolling out application changes.
Patrick Bossman started working with DB2 in 1993. Patrick has worked as a customer with DB2 as an applications programmer, database designer and administrator, and complex query performance tuner. Patrick joined IBM in 1999 as a DB2 Advocate where he assisted customer with query performance tuning. Patrick joined the DB2 for z/OS Query Optimization team in 2000 working on query performance service. Patrick is a STSM within the DB2 for z/OS Query Optimization organization and is responsible for service as well as identifying areas of improvement in query optimization and query tuning tools. Patrick holds numerous patents in the area of query optimization and query tuning tools.
By Susan Lawson, YLA US
This presentation will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also discuss converting legacy programs to DB2 and how to best code for DB2 performance.
Objectives:
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, YLA US
This presentation will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also discuss converting legacy programs to DB2 and how to best code for DB2 performance.
Objectives:
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 Andy Ward, CA UK
DB2 10 provides us with a time machine for answering questions about the state of data at a certain point, relating to the concepts of real time and business time, and even a combination of the two. This presentation will outline the theory behind temporal tables and how this data is managed and queried to provide a view into the past to correctly answer questions that are reliant on understanding data as it was and not as it is now
Andy has been working in the mainframe arena for the past 24 years. During the last 19 of which he has specialised on DB2, working as both a DBA for a large insurance company in the UK and with a number of DB2 tools vendors including; Platinum Technology, BMC and most recently CA. He speaks regularly at user groups and works with DB2 on a daily basis ensuring CA’s customers are gaining the maximum benefit from the CA DB2 solutions in their environments, concentrating specifically on; performance, administration and backup and recovery