V8-V9 design for high performance workshop

Date: 
Thursday, 26 June, 2008 (All day)
Speaker: 
Jan Henderyckx

Objectives:
Understanding which DB2 features and techniques exist to get the best performance and availability out of your application and system. Know which knobs exist at the database design level to get the most of your system. Be equiped with application design patterns that can deal with the most challenging application requirements.

Outline:
DATABASE DESIGN

REORDERED ROW FORMAT
New Datatypes
APPEND table attribute
NOT LOGGED TABLESPACES
IMPLICITLY HIDDEN COLUMN
INDEX ON EXPRESSION
LARGER INDEX PAGE SIZE
ASYMMETRIC INDEX PAGE SPLIT
RANDOM index keys
XML Data Type

PROGRAMMING TEMPLATES
Techniques to generate numbers
Native Stored Procedures
Instead of Triggger
Multi-row
Browsing
MERGE STATEMENT
Truncate

MANAGING CONCURRENCY
Overview of relevant zparms
OPTIMISTIC LOCKING SUPPORT
SKIP LOCKED DATA ON SQL statement

DESIGNING FOR 24x7
Clone Tables
Beyond Clone Tables

Full Abstract:
During this seminar Jan will take you through the important aspects that influence your application performance and high availability. In the last two releases many new features have been added that will have an important impact on the efficiency of your applications. There is a lot of information available in books and articles but this ODS is based on real life cases, many which have been implemented by Jan in customer engagements. All of this with the fundamental principle that we don’t tune and design for the sake of the tuning but to make sure we meet the application objectives.
 

 

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