36

Objectives:
Understand the new CLONE SQL instruction. What is (im)possible using this V9 feature?

Outline:
When it can (not) be used
How it works
Restrictions
Utilities
Impact on recovery

Full Abstract:
The SQL CLONE statement is a new powerful statement. But there are restrictions and pitfalls. This sessions explain how it works and what the restrictions are. When used wisely the new instruction is a great addition to the DBA toolkit.

Objectives:
Discuss some new innovative ways to create tables
Discuss new challenges and opportunities for index design
Discuss how to integrate designs with applications for best performance and availability
Discuss how to use new features of DB2 to solve problems
Discuss ways to think differently about designs and see examples from real implementations

Outline:
1.Current challenges faced by our clients
2.Creating new innovative solutions
3.Solving todays performance and availability problems with new designs
4.Use of new features
5.Getting rid of old theories

Full Abstract:
This presentation covers new, bold, creative solutions to achieve high availability and high performance. New challenges mean thinking outside the old rules. We also look at how to synergize creative table designs with applications to achieve our goals.

Objectives:
This session will help you to understand what support IBM have added to DB2 9 for z/OS to support storage of XML documents in relational DB2 tables

Outline:
What IS XML?
Why is XML document storage important?
How does DB2 9 store XML documents?
How do I query XML using SQL?
What happens next?

Full Abstract:
One of the biggest changes to DB2 for z/OS has been the support for storage of XML documents in DB2 tables. Join Phil to learn not just how to manipulate XML with SQL, but even discover the basics of what an XML document IS and why database support for XML is considered so important

Objectives:
Learn the basics of using DB2 Optimization Service Centre and Optimization Expert for z/OS and how they can solve common SQL Tuning problems.

Outline:
Introduction to Optimization Service Center (OSC) and Optimization Expert (OE)
Tuning workloads
Individual query analysis and tuning
Access plan graph
Query Annotation
The advisors – statistics, query and index
Visual Plan Hints

Full Abstract:
DB2 Optimization Service Centre and Optimization Expert for z/OS are SQL tuning tools with tightly integrated tuning advisors and advanced tuning tools to address both individual SQL statements and SQL workloads. Tuning advisors provide statistics, indexing, and query-rewrite recommendations, while advanced tuning tools like query annotation, access plan graph, query report, and visual plan hint facilitate deep SQL performance analyses when needed.

Objectives:
This presentation will describe the capabilities of the pureQuery technology, which makes application development for Java app easier. More importantly, pureQuery provides hooks in the Java application that tremendously simplify management, problem determination, and performance management of Java applications. The presentation will describe how customers can take advantage of these features. Material will also be presented that describes how pureQuery fits into the open source frameworks like Spring, iBatis, openJPA, and Hibernate.

Outline:
Overview of pureQuery APIs and capabilities
Integration into Spring
Integration into iBatis
Integration into openJPA

Full Abstract:
This presentation will describe IBM's new pureQuery technology, which provides a much more manageable infrastructure of Java applications that access databases. pureQuery has new Java API capabilities that make accessing the database much more flexible and powerful. Applications that exploit pureQuery are automatically enabled for superior problem determination, performance monitoring, and problem determination assistance for the IT staff. The presentation will also reveiw recent contributions from IBM to the open source (iBatis, Spring, OpenJPA) that allows IBM's JDBC and pureQuery solutions to run in the popular open source frameworks.
This presentation will describe IBM's new pureQuery technology, which provides a much more manageable infrastructure of Java applications that access databases. pureQuery has new Java API capabilities that make accessing the database much more flexible and powerful. Applications that exploit pureQuery are automatically enabled for superior problem determination, performance monitoring, and problem determination assistance for the IT staff. The presentation will also reveiw recent contributions from IBM to the open source (iBatis, Spring, OpenJPA) that allows IBM's JDBC and pureQuery solutions to run in the popular open source framework

Objectives:
Present DB2 9 for z/OS features that provide DB2 application programmers new options to improve performance, scalability and portability of programs accessing DB2.

Outline:
More efficient programming techniques
Better cross DB2 family compatibility
Enhanced programming with LOBs
Higher scalability by new locking mechanisms
Stored procedures enhancements

Full Abstract:
In DB2 9 for z/OS application programmers find numerous features that improve performance, scalability and portability of programs accessing DB2. Although pureXML functionality springs to mind first, there a many other attractive features such as rich new SQL capabilities, including additional data types and built-in functions, expanded SQL commonality with DB2 family, and enriched text handling with functions like caseless comparisons and cultural sort. There are also leading-edge standards-based capabilities to enable service oriented architecture (SOA) requirements.
This presentation focuses on the features that are particularly interesting to application programmers, but it is not limited to them. DB2 database administrators will find it helpful in their work to enable applications to get most out of the latest DB2 release.

Objectives:
We will start with a reference to part 1. We will then continue with a description of the messages and trace records that DB2 can provide for deadlocks, timeouts, and long running transactions respectively. We look at related system parameters that control the locking conflict resolution behaviour as well as the way DB2 produces messages and trace records. The presentation will hilite any differences between DB2 V8 and DB2 9. Finally there will be a discussion on how to implement “safe locking” in application programming.

Outline:
Understanding the type of information DB2 can provide in locking conflict situations
Understanding how to control DB2s behaviour in locking conflicts
Understanding how to get informed of potential locking problems generated by applications that doesn't behave as good DB2 citizens
Discussion on what tooling can be of help to automate the process of informing DBAs about locking conflicts
Best practices for application programs

Full Abstract:
In this second part of a two-part presentation we will dive into the information that DB2 for z/OS can provide you with in order to get hold of locking conflicts. Various system parameters controlling the behaviour of DB2 with regard to locking are described. Messages and trace records showing deadlocks, timeouts, and long running transactions will be looked at in detail. Finally there will be a discussion of best practices for handling locking in application programs.

Objectives:
Understanding Locking Parameters and Options
Understanding Lock Avoidance and Lock Escalation
Understanding Interaction Between Utilities and SQL
Understanding how to Catch the Culprits
Understanding New Locking Options in DB2 9 for z/OS

Outline:
We start with a discussion of various locking options and their impact.
This is followed by a description of Lock Avoidance and Lock Escalation.
Then we discuss locking in SQL and Utilities (claims and drain).
Various ways of discovering locking problems are presented.
The final part discusses new options in DB2 9 for z/OS

Full Abstract:
In this first part of a two-part presentation technical aspects of locking in DB2 for z/OS are presented. Various options and their impact are described, followed by a discussion about Lock Avoidance and Lock Escalation. Locking in utilities are handled differently than in SQL, so claims and drain will be presented. An overview of various ways of collecting information about locking problems will be given. Finally new locking options in DB2 9 for z/OS (Skip locked data and Optimistic locking) are introduced.
Detailed information about handling of Timeouts and Deadlocks will be given in "Lock Out Your Locking Problems - Part 2"

Objectives:
This presentation is based on real life query examples. It will take the audience on a trip through different ideas and tiny tricks that we have used in our shop to deal with special situations, hard-to-explain optimizer behaviour and “unsolvable” performance issues. It will go through examples of performance issues and ways we solved them – covering issues caused by unexpected data type conversions or lack of them, issues caused by padded or not padded indexes (why don’t they work?!) and issues caused by joining multiple tables on range predicates (and MQTs that saved us).

Outline:
Example
Example
Example
Example
Example

Full Abstract:
Query optimization today is hardly what it used to be. Queries are no longer comprised of two or three equal predicates. With today’s query generators and new (outsourced) applications comming in, query optimization is becoming highly valued skill. While trying to find their way through the mess of joins, subqueries and all the new functionality that comes in with every new DB2 version, DBAs could often use some tips and tricks to make their lives easier. This presentation offers not really ready to use cookbook, but rather gives ideas that could help DBAs to solve their performance issues.

Objectives:
DB2 buffer pools are a key resource for ensuring good performance. This is becoming increasingly important as the difference between processor speed and DASD response time for a random access IO widens in each new generation of processor. z/OS can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid IO.

The purpose of this session is to:
describe the functions of the DB2 buffer pools
outline four methods for measuring the performance of a buffer pool
make recommendations on how to set up and monitor the DB2 buffer pools

The session is intended for DB2 system administrators but may be of interest to any z/OS performance specialist. It is assumed that the attendee is familiar with DB2 and performance tuning but if that is not the case then the DB2 manual “Performance Monitoring and Tuning Guide” is recommended reading and can be found here:
http://www-306.ibm.com/software/data/db2/zos/library.html

Outline:
Bufferpool Functions and Operation
Instrumentation and Monitoring - Hit Ratio, Page Residency time, Reread Count
Buffer Pool Analyzer
Results from customer studies

Full Abstract:
This session will describe the primary functions and operation of the DB2 bufferpools including the parameters that are used to control their behaviour. Four methods for measuring the performance and efficiency of each pool are described along with their advantages and disadvantages. Recommendations are then made for how to use the bufferpools to ensure good performance. Lastly some resullts are used to illustrate the points discussed during the presentation