Jan Henderyckx

Speaker Details

Bio

Jan Henderyckx is an independent consultant, lecturer and author. He has more than seventeen years of experience with relational databases and has presented papers at several international conferences and local user-groups, all over the world. He was elected best overall speaker at the ’98 European IDUG and ’03 European IDUG which put him into the IDUG Hall of fame. He is the co-author of a book on “Application Design For High Performance” and has developed and thought several educational seminars covering many aspects of relational databases. You regularly find his articles in leading database magazines. His lively presentation style benefits from his thorough theoretical knowledge, combined with the practical experience he gains during his consulting engagements.

His areas of expertise include application design, performance, connectivity, (heterogeneous) replication, data-sharing, object-oriented in combination with DB2, data warehousing and application and system tuning. He is co-founder of the DB2 Times and frequent contributor to this publication.

Past presentation
26 June 2008 (All day)
(All day)
SQLAdria Seminar – Dubrovnik 2008 V8-V9 design for high performance workshop

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.
 


25 June 2008
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2008 Bringing your DB2 to V9 (and V8)

Objectives:

Outline:

Full Abstract:
Many DB2 systems are still running as if it where the 90's. There are many reasons for this lack of adaptation but one of the most important ones is lack of time. This means in many cases not lack of time but simply lack of priority. This presentation helps you to look at problem and to build a business case around it. How much will you gain if you make this change. Putting the numbers behind the change will greatly help you with the sell.


25 June 2008
10:00 - 11:00
SQLAdria Seminar – Dubrovnik 2008 Making the database group survive ITIL, Service management, etc

Objectives:

Outline:

Full Abstract:
Do you also find yourself being defined in terms of services? How can you best deal with that and structure your work to fit in such an organisation. Jan will give practical examples how you can define services for your DBA team and how you can more effectively manage your DB2 objects by defining proper responsibilities. The presentation includes a sample service registry for a DBA team and an example risk and gap analysis.


21 June 2007
09:00 - 15:00
SQLAdria Seminar – Dubrovnik 2007 Designing and building a modern information architecture with DB2

Architecture trends
SOA
WebServices
Master Data Management
Information as a Service

Information- and process-integration models
Message call to other business domain
Procedure call to other business domain
Direct access to data in another business domain
Replication of data to other business domain
Creation of ‘information broker-layer
Master Data Management

System z Data Serving Roadmap
Speciality engines

Database application interfaces
Stored Procedures, Triggers and UDF
XML integration
DB2 and SOAP
Federated databases

Information placement templates
Multi-platform- and network- impact on process and data placement
Data federation – solutions
Data replication - solutions

Summary


20 June 2007
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2007 Getting high availability and performance, the V9 update

As with every version of DB2 new features are introduced that introduce better and faster ways to get things done.
In the area of high availability and performance DB2 9 introduces a whole set of options that make life easier and faster.
But as usual not all problems are gone, what else would we get in version next.
This presentation goes into the V9 new functions and covers how this can help you and where you still need to pay attention.
 


20 June 2007
10:00 - 11:00
SQLAdria Seminar – Dubrovnik 2007 The alphabet soup of data integration technologies and overview of data access solutions

As a DBA you are faced with a lot of new terms such as SOA, EII, EIA and many others. This presentation takes you through these new buzzwords and tries to put them in perspective of the DBA.

Bullet Points:
Introduction
What is SOA
The data quality issue
Integration solutions EII, EAI
Information as a Service


12 June 2006
10:30 - 13:15
SQLAdria Seminar – Dubrovnik 2006 The best of the new redbook application design for high performance and availability

08 June 2004
16:00 - 17:00
SQLAdria Seminar – Dubrovnik 2004 High Availability - The things you can't ignore

During 2003 the world was shocked by the story of the longest outage in the history of DB2. How long can you afford to be down? Do you have the idea that your DB2 system is safe? During this day Jan will cover all angles of this multi-discipline problem. Since it requires a thorough planning and significant investment, technical people and managers should tackle it both. Make sure you don't get in the news and learn the latest about High Availability.

Topics:
The different dimensions of the problem:
Hardware solutions: PPRC (XD), XRC, SRDF, Sysplex
Software solutions: Data Sharing, Online utilities, (V8) schema evolution
Version management, Suspend/Resume, Backup/Restore system
Reducing Restart times, Storage Management, Application Design


08 June 2004
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2004 Recommendations for DB2 that can get you into trouble

You may still have those DB2 guidelines that where written ages ago. Do you really think they make sense in today's world with the latest version of DB2 installed? This session will take a look at some of the guidelines that people use but that are not longer applicable. Jan will cover application-related questions such as the effect of isolation levels on the result of the SQL, the use of parallelism, SQL coding hints. He will also cover system tuning and configuration questions regarding the IRLM, bufferpool settings and some of the misunderstood ZPARMS.


10 June 2003
15:45 - 16:30
SQLAdria Seminar – Dubrovnik 2003 Platform synergy: LUW and z/OS more than the sum of both

10 June 2003
13:30 - 14:30
SQLAdria Seminar – Dubrovnik 2003 SQL Management Techniques to influence the optimizer

11 June 2002
14:30 - 15:30
SQLAdria Seminar – Dubrovnik 2002 Speeding up your SQL

11 June 2002
11:00 - 12:00
SQLAdria Seminar – Dubrovnik 2002 Making the most out of your memory: Bufferpool Tuning

12 June 2001
14:30 - 15:30
SQLAdria Seminar – Dubrovnik 2001 Data sharing from a performance/design point of view

12 June 2001
11:00 - 12:00
SQLAdria Seminar – Dubrovnik 2001 Bufferpool tuning and the impact of V6 and Z/OS

 

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 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018