Mike Bracey

Speaker Details

Bio

Mike Bracey is part of the IBM Software Business in Europe providing technical support for DB2 for z/OS and related topics. He has extensive practical DB2 experience, gained over 18 years, of DB2 application design, data modelling, and performance monitoring and tuning. His recent roles have included technical support for IBM Data Management Tools and for the DB2 for z/OS beta programs in Europe.

Past presentation
25 November 2011
11:15 - 12:00
SQLAdria Seminar – Opatija 2011 Improve Development Productivity ‐ continued

25 November 2011
09:45 - 11:00
SQLAdria Seminar – Opatija 2011 Improve Development Productivity

25 November 2011
09:00 - 09:45
SQLAdria Seminar – Opatija 2011 Improve Development Productivity

24 November 2011
17:00 - 18:00
SQLAdria Seminar – Opatija 2011 Hand on Lab continuation ‐ optional

24 November 2011
15:00 - 17:00
SQLAdria Seminar – Opatija 2011 Improved Performance and Reduced CPU

24 November 2011
14:00 - 14:45
SQLAdria Seminar – Opatija 2011 Improved Performance and Reduced CPU

24 November 2011
13:30 - 14:00
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements ‐ continued

24 November 2011
11:15 - 12:30
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements

24 November 2011
10:15 - 11:00
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements

24 November 2011
10:00 - 10:15
SQLAdria Seminar – Opatija 2011 Introduction

26 November 2010
09:30 - 10:15
SQLAdria Seminar – Opatija 2010 P6: Optimizing, managing and securing data access of Java applications

26 November 2010
09:00 - 09:30
SQLAdria Seminar – Opatija 2010 P5: IBM Optim Query Tuning Offerings - Optimize Performance and Cut Costs

25 November 2010
17:00 - 18:00
SQLAdria Seminar – Opatija 2010 L2: Continue with L2 if required

25 November 2010
16:30 - 17:00
SQLAdria Seminar – Opatija 2010 P4: DB2 Dynamic Statement Caching and interaction with Websphere

25 November 2010
15:30 - 16:30
SQLAdria Seminar – Opatija 2010 P3: How to Set up Websphere Application Server to Access DB2 z/OS with High Availability

25 November 2010
13:30 - 15:15
SQLAdria Seminar – Opatija 2010 L2: Optimizing an existing Java application using pureQuery client optimization

25 November 2010
10:45 - 11:15
SQLAdria Seminar – Opatija 2010 L1: Introduction to Optim Development Studio

25 November 2010
10:10 - 10:45
SQLAdria Seminar – Opatija 2010 P1: IBM Integrated Data Management

21 November 2008
11:15 - 12:00
SQLAdria Seminar – Opatija 2008 P5: XML Indexing and Performance Considerations

21 November 2008
11:00 - 11:15
SQLAdria Seminar – Opatija 2008 Lab 7: XML Schema creation, Validation and Decomposition

21 November 2008
10:00 - 10:45
SQLAdria Seminar – Opatija 2008 Lab 6: SQL/XML Tuning using XML indexes Lab 7: XML Schema creation, Validation and Decomposition

21 November 2008
09:00 - 10:00
SQLAdria Seminar – Opatija 2008 P4: Querying XML with XPath and SQL/XML

20 November 2008
16:00 - 17:00
SQLAdria Seminar – Opatija 2008 Lab 4: Querying XML Data Lab 5: Updating and Deleting XML Data

20 November 2008
15:30 - 16:00
SQLAdria Seminar – Opatija 2008 P7: pureXML on DB2 9 for z/OS continued

20 November 2008
14:45 - 15:15
SQLAdria Seminar – Opatija 2008 P7: pureXML on DB2 9 for z/OS

20 November 2008
14:15 - 14:45
SQLAdria Seminar – Opatija 2008 P3: DB2 pureXML: Features and Externals

20 November 2008
13:45 - 14:15
SQLAdria Seminar – Opatija 2008 Lab 2: Creating XML data Lab 3: Creating, Altering and Loading XML Objects

20 November 2008
12:15 - 12:45
SQLAdria Seminar – Opatija 2008 Lab 1: XML Publishing; Create an XML Column

20 November 2008
12:00 - 12:15
SQLAdria Seminar – Opatija 2008 Lab 0: Introduction to Lab exercises

20 November 2008
11:30 - 12:00
SQLAdria Seminar – Opatija 2008 P2: XML Fundamentals continued

20 November 2008
10:30 - 11:15
SQLAdria Seminar – Opatija 2008 P2: XML Fundamentals

20 November 2008
10:10 - 10:30
SQLAdria Seminar – Opatija 2008 P1: The value of XML in SOA and Information Management

24 June 2008
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2008 Optimisation Service Centre and Optimisation Expert

Objectives:
Learn the basics of using DB2 Optimization Service Centre and Optimization Expert for z/OS and how they can solve common SQL Tuning problems.

Outline:
Introduction to Optimization Service Center (OSC) and Optimization Expert (OE)
Tuning workloads
Individual query analysis and tuning
Access plan graph
Query Annotation
The advisors – statistics, query and index
Visual Plan Hints

Full Abstract:
DB2 Optimization Service Centre and Optimization Expert for z/OS are SQL tuning tools with tightly integrated tuning advisors and advanced tuning tools to address both individual SQL statements and SQL workloads. Tuning advisors provide statistics, indexing, and query-rewrite recommendations, while advanced tuning tools like query annotation, access plan graph, query report, and visual plan hint facilitate deep SQL performance analyses when needed.


23 June 2008
12:00 - 13:00
SQLAdria Seminar – Dubrovnik 2008 Buffer Pool Tuning

Objectives:
DB2 buffer pools are a key resource for ensuring good performance. This is becoming increasingly important as the difference between processor speed and DASD response time for a random access IO widens in each new generation of processor. z/OS can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid IO.

The purpose of this session is to:
describe the functions of the DB2 buffer pools
outline four methods for measuring the performance of a buffer pool
make recommendations on how to set up and monitor the DB2 buffer pools

The session is intended for DB2 system administrators but may be of interest to any z/OS performance specialist. It is assumed that the attendee is familiar with DB2 and performance tuning but if that is not the case then the DB2 manual “Performance Monitoring and Tuning Guide” is recommended reading and can be found here:
http://www-306.ibm.com/software/data/db2/zos/library.html

Outline:
Bufferpool Functions and Operation
Instrumentation and Monitoring - Hit Ratio, Page Residency time, Reread Count
Buffer Pool Analyzer
Results from customer studies

Full Abstract:
This session will describe the primary functions and operation of the DB2 bufferpools including the parameters that are used to control their behaviour. Four methods for measuring the performance and efficiency of each pool are described along with their advantages and disadvantages. Recommendations are then made for how to use the bufferpools to ensure good performance. Lastly some resullts are used to illustrate the points discussed during the presentation


19 June 2007
14:15 - 15:15
SQLAdria Seminar – Dubrovnik 2007 DB2 9 new SQL functions for application developers

Presentation will cover Intersect & Except, Instead of Triggers, Merge, Select from Merge, Update and Delete, Truncate, Order by and Fetch first in subselect; the new data types. Same presentation will be conducted at the DB2 Technical conference in Dusseldorf.
 


18 June 2007
14:00 - 15:30
SQLAdria Seminar – Dubrovnik 2007 Native XML support in DB2 9 for z/OS

Presentation will be based on the material presented by Guogen Zhang at the Anaheim IOD and it will include some worked examples.  Simple demonstration wil be included in presentation accordingly to the network access.  Primary goal would be to show that XML in V9 is a straightforward extension of existing relational technology, is simple to use and it works well.
 
 


30 March 2007
10:20 - 11:15
SQLAdria Seminar – Ljubljana 2007 DB2 for z/OS and SOA

17 November 2006
11:30 - 12:15
SQLAdria Seminar – Opatija 2006 DB2 V9 Overview

17 November 2006
11:00 - 11:30
SQLAdria Seminar – Opatija 2006 Multi-Level security

17 November 2006
10:00 - 10:45
SQLAdria Seminar – Opatija 2006 Stored Procedure enhancements

17 November 2006
09:00 - 10:00
SQLAdria Seminar – Opatija 2006 Unicode - what is it and how does it affect a DB2 V8 user

16 November 2006
16:30
SQLAdria Seminar – Opatija 2006 XML

16 November 2006
15:45 - 16:30
SQLAdria Seminar – Opatija 2006 New Java Driver and hints and tips

16 November 2006
14:45 - 15:30
SQLAdria Seminar – Opatija 2006 Miscellaneous SQL enhancements - Scalar Full Select, Multiple Distinct clauses, INSERT within SELECT

16 November 2006
14:00 - 14:45
SQLAdria Seminar – Opatija 2006 Identity Columns and Sequences

16 November 2006
12:15 - 12:45
SQLAdria Seminar – Opatija 2006 Common Table Expressions (CTE) and Recursive SQL

16 November 2006
11:30 - 12:15
SQLAdria Seminar – Opatija 2006 Scrollable cursors and GET DIAGNOSTICS

16 November 2006
10:15 - 11:15
SQLAdria Seminar – Opatija 2006 Multi row operations - SELECT and INSERT

 

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