39

Objectives:
Learn how to use the new EXPLAIN tables to help with query tuning efforts.

Outline:
Discuss IBM Visual Explain and Optimization Service Center
Discuss the tables that support them for information
Discuss how to use these tables without the tools
Discuss the DSN_STATEMENT_CACHE_TABLE for dynamic SQL tuning

Full Abstract:
DB2 z/OS V8 and 9 have introduced us to many new EXPLAIN tables. This session will introduce users some of the new EXPLAIN tables to be used for advanced query analysis, and demonstrate how SQL queries can be used to gather and analyze the this information. The session will also include information about using the DSN_STATEMENT_CACHE_TABLE to perform analysis on the dynamic SQL cache.

Objectives:
To give the audience an overview of the implementation of triggers in DB2 for z/OS.
A number of examples will be given.

Outline:
What is a trigger?
Implementation
Examples
Some warnings

Full Abstract:

Objectives:
To firstly look at the real business reasons behind why we tune and why a little knowledge can be a dangerous thing when it comes to SQL. The bulk of the presentation will concentrate on illustrating how SQL can be ‘tweaked’ to produce better performance at a cheaper cost.

Outline:
Why do we tune?
What are the benefits?
Tuning SQL
Tips, techniques and pointers

Full Abstract:
Get more from your SQL, this section will cover how to tune your statements to provide the best return with the least resources. It’s often easy to get SQL to return the data you are looking for...but could you be doing it better?

Objectives:
Get a detailed understanding on how to get most out of the dynamic statements cache.

Outline:
How dynamic statements cache works
Virtual storage impact
Common access path challenges
Monitoring

Full Abstract:
The use of dynamic SQL continues to grow. Enterprise packaged applications as well as web applications use almost exclusively this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning of SQL statements. This presentation focuses on dynamic statements cache – the key factor of a well performing dynamic statements environment. It covers all the relevant aspects of the statements cache: how it works, how to control its CPU and memory utilization, and how to monitor and tune it.
 

Objectives:
To give the audience an understanding of new elements introduced in DB2 for z/OS V8:
Scalar fullselect
Common table expression
Recursive SQL

Outline:
The result of a Select is a table
Scalar fullselect
View
Nested table expression
Common table expression
Recursive SQL

Full Abstract:

Objectives:
To give an overview of the importance of collecting and providing DB2 with good statistics and ensuring filtering takes place as early as possible. The session also looks to introduce some of the new statistics related features available in DB2 9 as well as highlighting the problem of column correlation and providing steps to both detect and fix it.

Outline:
The DB2 Catalog
A brief History
Real Time Statistics
Distribution Statistics
Including Histogram Statistics
Defining, detecting and fixing column correlation
A look at the importance of good filtering

Full Abstract:
We spin a lot of cycles collecting them, how can we get the best out of them? A look back at how the catalog has grown in recent releases and what DB29 brings us in this area. We will also take a look at column correlation, what it is, how to detect it and how to fix it. Real Time Statistics, filtering and the importance of Distribution Statistics are also covered.

Objectives:

Outline:
Introduction – who wants what and why?
What have we done about it?
What are we doing about it?
What is the overhead and what are the benefits?
Real life example – or how do I get that certificate?

Full Abstract:
For years DBA at Zagrebacka banka tried to follow different best practices we have learned about in database management, security, data privacy, availability and so on being unaware of different regulations. However, looking back at last few years and all the things DBA at Zagrebacka banka were involved with, it seems that number of regulations in effect are already met. However there is also a number of those we're still working on.Come join me in this presentation and I'll show you the steps undertaken at Zagrebacka banka to be in compliance.

Objectives:
Improve efficiency and productivity of DB2 administrators and programmers by exploiting the full power of DB2 9

Outline:
Rationale behind implementing selected DB2 9 features
Usage recommendations for optimal exploitation of new functions
Less known techniques to address specific programming tasks
More efficient programming practices

Full Abstract:
DB2 9 brings a wealth of new features that improve productivity of administrators and programmers. This presentation shows how some of the common database administration and programming tasks can be done more efficiently in DB2 9. It also presents numerous hints and tips about less obvious usage capabilities of selected DB2 9 features that efficiently solve some long standing programming challenges such as application controlled locking, destructive reads, efficient mass deletes etc

Objectives:
This session will first look at how CA Recovery Analyzer can be used to define a disaster backup and recovery strategy and the jobs that will be generated to enable an off-site recovery.
Secondly, we will look at screenshots of an actual disaster recovery process that was performed at European IDUG in 2008. This performed a disaster recovery of a destroyed DB2 subsystem in under 30 minutes – and all without any of the complex disaster recovery knowledge that would normally be required

Outline:
How to define a Disaster Recovery strategy to Recovery Analyzer
Non-DB2 additions to the backup
The jobs created to run at your live site
A DISASTER HAS HAPPENED
The jobs to be run to recover your DB2 subsystem again

Full Abstract: