39

DB2 9 for z/OS in depth

Date: 
Thursday, 18 June, 2009 (All day)
Speaker: 
Phil Grainger

Objectives:
To learn ALL of the new features and functions of DB2 9 for z/OS. Although it has been GA for almost 2 years, DB2 9 IS still new for most people. Not only that, but IBM are continuing to add new items to DB2 9 during maintenance, so we will also take time to look at what has been added recently

Outline:
How to migrate to DB2 9
What has been removed and what might be removed in the future
What is new in Performance, SQL, Availability, Security
What has been added since GA

Full Abstract:
This session covers everything (and I mean EVERYTHING) that is new in DB2 9 for z/OS. We'll cover Universal Table Spaces, Clones, Utility enhancements, new SQL and XML support. As well, there is a growing section of what's BEEN ADDED to DB2 9 since GA. So, you can come to this session safe in the knowledge that afterwards there will be no secrets in DB2 9.

 

DB2 System Tuning 2009

Date: 
Thursday, 18 June, 2009 (All day)
Speaker: 
Klaas Brant

Objectives:
Gain more insight in the way DB2 works and obtain skills to analyze performance data in order to make the right decision for system tuning.

Outline:
 How to do tuning and monitoring
 CPU resource

       TCB / SRB / ZIIP Concept
       Where various CPU type are used

       Thread CPU breakdown
       Types of parallelism and when (not) used
       Stored Procedures

 Memory resources
      
Virtual v.s. Physical
       Signs of Stress
      
DB2 Buffer Pools
       DB2 EDM Pool 
       DB2 Sort Pool
       DB2 RID Pool
       Other DB2 Memory areas
       Impact of DB2 V8 on memory tuning

I/O Efficiency
      
Signs of stress
       Logging and how to improve
       Does dataset placement & extents matter
       using VSAM Striping
       Impact of FICON and PAV
       Compression

Full Abstract:
The more you understand how DB2 is internally structured, the easier it will be to do system tuning. This presentation will teach you the different components that make up DB2 for z/OS. With every part we examine, we also will look how we can tune this component to achieve maximum performance. This seminar is unique since it focuses completely on the system side of DB2. Once you know how DB2 services your requests you also will find it easier to understand application tuning and the recent DB2 enhancements. The target audience is people who have multiple years of experience with DB2 and who want to learn more about the internal structure of DB2. During previous presentation at the DB2 Symposium this seminar was rated with 8.2 on average!

DB2 High Performance Design and Tuning (DB2 9 Update)

Date: 
Thursday, 18 June, 2009 (All day)
Speaker: 
Susan Lawson

Objectives:

Outline:

Full Abstract:
Achieving maximum performance from DB2 requires a different approach and stricter methodologies than simply getting a DB2 application to perform well. In today's web and e-business environment the rules have changed and we must find every tuning knob in order to get another transaction through the system. This seminar focuses on specific issues of system design, physical object design, application design and tuning methods used to achieve high performance. The performance techniques of the some of the new object-relational SQL features are also covered. Focus is on the complete set of design points of DB2, and how they will affect performance of your applications. Discover why many old guidelines no longer apply, how old standards can actually hurt us and learn the approaches to systems management and tuning for the DB2 environment. The rules have changed and certainly in DB2 9 there are many more features to take advantage of and to be careful with.

 

Where Did All My CPU Go?

Date: 
Wednesday, 17 June, 2009 - 13:15 - 14:15
Speaker: 
Phil Grainger

Objectives:
To learn how CA Detector helps you not only find your high cpu consumers but also helps you find those that you will get the most benefit from tuning. We will look at the work flow process used to track down the best tuning candidates.
We will also look at some ways you can use the Detector information to track your tuning successes over time and to help your company get the best use out of your valuable cpu resources.

Outline:
What is CA Detector?
And what it isn’t
Why is proactive better?
Examples of Detector screens – finding those cpu hogs
Advanced categorisation of activity
Externalising the data
Summary

Full Abstract:
One of the best tuning measures is to look at high cpu consumers and tune them so that they consume less. The snag is, how DO you find them? In fact, is it good enough to just find the highest cpu consuming statement or program – surely you also need to consider how often the application or statement is being used. Tuning a statement that is only executed once per hour, might give you a good feeling, but you would have been better looking for highly active things to tune.
This presentation looks at how CA Detector helps you not only find your high cpu consumers but also helps you find those that you will get the most benefit from tuning
 

Exploiting V9 Performance Features

Date: 
Wednesday, 17 June, 2009 - 12:15 - 13:15
Speaker: 
Susan Lawson

Objectives:
Learn about some new features in DB2 9 that will help us achieve high performance in our applications and database designs

Outline:
Application Features
Database Features

Full Abstract:
This presentation will look at the features of DB2 9 that we can use achieve maximum performance. We will look at new SQL features, database features as well as a few new enhancements our overall subsystem performance.
 

What’s new in security

Date: 
Wednesday, 17 June, 2009 - 11:15 - 12:15
Speaker: 
Klaas Brant

Objectives:
Obtain some knowledge about DB2 security using RACF and the new V9 role and trusted context

Outline:
Using RACF for DB2 Security
New options in V9 security
Roles
Trusted context

Full Abstract:
During this presentation Klaas will review the “new” options of DB2 in the security area. Many companies have started to use RACF to replace DB2’s native security. What are the benefits and what downsides of such an approach? DB2 version 9 makes a leap forward in security options. New facilities like trusted context and roles are introduced. These are perfect option to make DB2 more secure but also require some thinking as they require a new way of working with DB2 security. To end the session we will look a bit forward in time to see what DB2 (possibly) has for us in future releases with regards to security

Practical SQL performance tuning, for developers and DBA’s

Date: 
Wednesday, 17 June, 2009 - 10:00 - 11:00
Speaker: 
Kurt Struyf

Objectives:
Understand the basic rules of writing performing SQL

Outline:
To index or not to index
Access paths explained
Predicate solving when and how
Suboptimal coding and their improvements
Other easy to use CPU saving techniques
Mips and money

Full Abstract:
This presentation is a PRACTICAL, HANDS ON way to SQL performance tuning and SQL improvement. When logically correct SQL will always return and answer, the statement might be expensive or cheap but is quite often suboptimal. This presentation will explain the ground rules to writing performing SQL and has numerous EASY-TO-FIX, REAL LIFE improvements. If you are a developer or a beginning DBA, you’ll gain an understanding to better SQL writing and tuning. If you are a more experienced DBA you’ll get a thorough refresh, learn something new and walk a way with an idea of “how to explain SQL to your developers”.

When Hell breaks loose - a real life data sharing disaster story

Date: 
Wednesday, 17 June, 2009 - 09:00 - 10:00
Speaker: 
Isaac Yassin

Spice up your application with hot SQL

Date: 
Tuesday, 16 June, 2009 - 15:45 - 17:00
Speaker: 
Klaas Brant

Objectives:
Learn how to use efficiently the new programming facilities like wide cursor, array insert, merge final table.

Outline:
Wide cursor
Group insert
Atomic vs non-atomic
New error processing
Merge
Final table usage

Full Abstract:
Have you started to use wide cursors under DB2 version 8? It is pretty easy and the CPU savings can be shocking! It is not very difficult to use them but there are a few things you should know about them before using them. Slightly more difficult are array inserts but also in this area you can save CPU again. DB2 version 9 bring another great feature: the MERGE statement. Complex programs can be condensed into a single, fast statement. Finally Klaas will review the so called FINAL TABLE which was introduced in version 8. Its use has been extended in version 9 and can be a great help in making your programs smaller and less complex.

Syndicate content  

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023