Peter Backlund

Speaker Details

Company: 
Peter Backlund DB2-Konsult AB
Country: 
Sweden
Type: 
Consultant
Bio

Peter has more than 27 years experience of DB2, including an assignment at IBM System Center in Santa Teresa 1982-85 writing redbooks and teaching DB2 worldwide. Peter worked for IBM 1968-88, for Cap Gemini 1988-94, and is since then an independent DB2 consultant with multiple clients. One of them is IBM Learning Services where Peter is teaching all levels of DB2. Peter has been an volunteer for IDUG in various roles for the last 7 years. Peter is a member of IBM's DB2 GOLD consultants. His strong points are teaching, trouble shooting, and SQL Optimizer performance. Peter can be reached at BacklundDB2@telia.com

Past presentation
15 junij 2010
15:45 - 17:00		 SQLAdria Seminar – Dubrovnik 2010 XML in DB2 9 for z/OS

Introduction to XML
XML for the DBA
XML, SQL and COBOL
14 junij 2010
15:30 - 17:00		 SQLAdria Seminar – Dubrovnik 2010 Programming into and out of DB2 for z/OS

Multi-row Fetch
Fetch Continue
Multi-row Insert
Merge
Get Diagnostics
Select from Insert, Delete, Update and Merge
16 junij 2009
11:15 - 12:15		 SQLAdria Seminar – Dubrovnik 2009 Are You Trigger Happy?

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:
15 junij 2009
15:30 - 17:00		 SQLAdria Seminar – Dubrovnik 2009 NTE, CTE and Recursive SQL

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:
23 junij 2008
16:15 - 17:15		 SQLAdria Seminar – Dubrovnik 2008 Lock Out Your Locking Problems – Part 2

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.
23 junij 2008
15:15 - 16:15		 SQLAdria Seminar – Dubrovnik 2008 Lock Out Your Locking Problems – Part 1

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"
 

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 2024

VODICE -  10th - 13th June 2024