Phil Grainger

Speaker Details

Bio
Phil has over 30 years experience of Db2, from DB2 Version 1.2 to Db2 12.From being a DBA for the largest user of DB2 at that time in the UK, through his time at PLATINUM technology, his almost 10 years as Senior Principal Product Manager at CA and through to his final position at BMC Software, Phil has always supported user groups. His work with IDUG included being BMCs liaison to the European IDUG Planning Committee and he is an inductee into the IDUG Volunteer Hall of Fame.Phil has been honored by IBM as an Analytics Champion from 2009 to 2020. Currently Phil is enjoying a well-earned retirement.
Past presentation
05 October 2021
09:00 - 10:00
European SQLAdria Seminar – Šibenik 2021 It could happen to YOU - scary disaster stories, lessons learned, NOTHING is impossible
There are many presentations on recovering computer systems from disasters and the need for planning BUT what exactly ARE these disasters? 
This presentation will give you the opportunity to learn from other people’s misfortunes that NOTHING is impossible, and even the most improbable events can (and will) happen to someone 
Whilst the presentation doesn't really give any guidelines on how to plan for a disaster, you will certainly leave knowing that you must plan for the worst possible scenario and take nothing for granted 

04 October 2021
11:45 - 13:00
European SQLAdria Seminar – Šibenik 2021 Solving DB2 Performance Problems
This session looks at how you FIND performance problems, or more specifically, how you can eliminate DB2 problems from everyone elses. There is no need to spend exhaustive time looking for a DB2 problem only to find the solution lies somewhere else. So how can you QUICKLY (and easily) deflect attention when it is not warranted
We will also look at some techniques to make performance problem analysis easier – there are things you can do IN ADVANCE to help with fault finding
Lastly we will consider how to proof our DB2 subsystems and applications against performance problems in the future, and look at workload access path management

07 October 2020
10:00 - 11:00
Advanced Design Considerations
During the design of a DB2 application, there is now a lot more to consider than just “what should the tables
look like”. We need to take into consideration where we should create indexes, and why. We might think
about partitioning for performance or for manageability. What about partitioned and non partitioned
indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option
to create Materialized Query Tables, but when would these be good to use?
This presentation steps through some of the new (and not so new) elements of DB2 database design and
highlights pros and cons of each
Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in
your case will always “depend” on circumstances, but hopefully this presentation will give you the
information you need to make informed choices

05 October 2020
11:45 - 13:00
What's new in Db2 12 SINCE GA?

Db2 12 has been GA for over three years now, but due to the nature of Continuous Delivery, new features and functionalities have been added. This presentation summarizes these new deliveries, whether they have arrived as Function Levels or been added to the base Db2 12 functionality - which a significant amount has


29 May 2014
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2014 DB2 10 for z/OS - In Depth

More automated install
Catalog restructure (to UTS)
Deprecation of Plans with DBRMs, old plan_table formats, DB2 Private Protocol, classic partitioned table spaces
 
Performance
Out of the box up to 10% cpu savings
Hash access to data
Include columns in indexes
In-line LOBs
Dynamic statement cache improvements
Dynamis SQL stability and the access path repository
 
Availability
On-line schema evolution and deferred alter
Data "as of" last commit
Reorg Aux table improvements
Recover backout
Security
Row and column level access control
Finer administrator privileges
Administrator privileges without data access
New audit abilities
 
Productivity
Immediate compression
LISTDEF partition range support
REORG SHRLEVEL CHANGE enhancements
Temporal data
SQL PL improvements
Moving sum and average
 
XML
XML schema validation in z/OS
Multi versioning of XML data
XML update, insert and delete
XML schema as column modifier
CHECK DATA for XML
 
And much MUCH more


27 May 2014
10:30 - 11:30
European SQLAdria Seminar – Dubrovnik 2014 IBM MLC Pricing and our DB2 World

We always assume thet tuning, and thius saving cpu, will result in actual monetary savings

Well, with IBMs Measured Workload Pricing this is not the case - we need to target our tuning at specific times of the month to see real value

This presentation starts by explaining how IBMs MLC works in practice and what this means to our DB2 world, before looking at some methodolgies for SQL tuning that ill result in paying lower software license charges


26 May 2014
09:30 - 11:00
European SQLAdria Seminar – Dubrovnik 2014 Advanced Design Considerations

During the design of a DB2 application, there is now a lot more to consider than just “what should the tables look like”. We need to take into onsideration where we should create indexes, and why. We might think about partitioning for performance or for manageability. What about partitioned and non partitioned indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option to create Materialized Query Tables, but when would these be good to use?

This presentation steps through some of the new (and not so new) elements of DB2 database design and highlights pros and cons of each

Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in your case will always “depend” on circumstances, but opefully this presentation will give you the information you need to make informed choices


18 June 2009 (All day)
(All day)
SQLAdria Seminar – Dubrovnik 2009 DB2 9 for z/OS in depth

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.

 


17 June 2009
13:15 - 14:15
SQLAdria Seminar – Dubrovnik 2009 Where Did All My CPU Go?

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
 


15 June 2009
09:30 - 11:00
SQLAdria Seminar – Dubrovnik 2009 Disaster Recovery with CA Recovery Analyzer

Objectives:
This session will first look at how CA Recovery Analyzer can be used to define a disaster backup and recovery strategy and the jobs that will be generated to enable an off-site recovery.
Secondly, we will look at screenshots of an actual disaster recovery process that was performed at European IDUG in 2008. This performed a disaster recovery of a destroyed DB2 subsystem in under 30 minutes – and all without any of the complex disaster recovery knowledge that would normally be required

Outline:
How to define a Disaster Recovery strategy to Recovery Analyzer
Non-DB2 additions to the backup
The jobs created to run at your live site
A DISASTER HAS HAPPENED
The jobs to be run to recover your DB2 subsystem again

Full Abstract:


14 June 2009
17:00 - 17:50
SQLAdria Seminar – Dubrovnik 2009 State of Mainframe Database Management

Objectives:
We will look at CAs Mainframe 2.0 initiative the exciting new drive to resolve many of the issues faced by todays mainframe data centers.
The second part of this presentation covers the mainframe Database Management section of CAs Mainframe Business Unit and the changes in the IMS and DB2 tools.
Finally we will review CAs new Annual Delivery Model, which will provide a new release of ALL mainframe software from CA on an annual basis - allowing customers a better ability to plan for upgrades.

Outline:
What is Mainframe 2.0
What has the Database Management team been doing
The Annual Delivery Mode

Full Abstract:
Join Phil Grainger, Senior Principal Product Manager for the DB2 tools at CA, for this look at the current state of CAs Mainframe Database Management solutions. We will start the session with look at CAs Mainframe 2.0 initiative. This exciting new drive aims to resolve many of the issues faced by todays mainframe datacenters. From a simpler installation mechanism to smarter configuration, Mainframe 2.0 will be 'Valued Today, Essential Tomorrow'.
The second part of this presentation will examine the mainframe Database Management section of CAs Mainframe Business Unit - summarising the changes in the IMS and DB2 tools.
We will also review CAs new Annual Delivery Model, which will provide a new release of ALL mainframe software from CA on an annual basis - allowing customers a better ability to plan for upgrades.


26 June 2008 (All day)
(All day)
SQLAdria Seminar – Dubrovnik 2008 DB2 Version 9 for z/OS In Depth

Objectives:
This seminar will give you a good all round understanding of the new features and functions of DB2 9 for z/OS

Outline:
New Objects in DB2 9
DB2 9 performance improvements
New security options
Support for XML data storage
.. and more!

Full Abstract:
This one day class will look through all of the new items IBM have released in DB2 9 for z/OS. From new relational objects (such as table clones, universal tablespaces and trusted contexts) to the new non-relational XML document storage, Phil takes us though the whold range.
Even if DB2 9 is still some way in your future, there is almost certainly something here of interest.


25 June 2008
13:15 - 14:15
SQLAdria Seminar – Dubrovnik 2008 How to Choose A DB2 Tool Solution for YOU?

Objectives:
To gain an understanding of how to choose a software tool to assist with your daily jobs. This presentation is not aimed at any particular tool choice, nor at any particular vendor (honest!) but is a summary of my experiences over the years of why people choose some tools over others

Outline:
Who makes the choices anyway?
What makes a good choice?
What is “value for money”?
Why do some vendors “muddy the waters”?
Who has the most negotiating power?

Full Abstract:
You might think that finding the right software tool to help you do your job would be simplicity itself. This presentation looks at some of the ways you may be losing control of your choice without even realising it and how to get that control back. The session will be a completely open and independent consideration of the processes you should be working through as you make your tools choice


24 June 2008
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2008 DB2 9 for z/OS XML Support

Objectives:
This session will help you to understand what support IBM have added to DB2 9 for z/OS to support storage of XML documents in relational DB2 tables

Outline:
What IS XML?
Why is XML document storage important?
How does DB2 9 store XML documents?
How do I query XML using SQL?
What happens next?

Full Abstract:
One of the biggest changes to DB2 for z/OS has been the support for storage of XML documents in DB2 tables. Join Phil to learn not just how to manipulate XML with SQL, but even discover the basics of what an XML document IS and why database support for XML is considered so important


22 June 2008
15:15 - 16:15
SQLAdria Seminar – Dubrovnik 2008 CAs Database Management Product Roadmap

Objectives:
Join Phil to hear what has been happening in DB2 tools development at CA and what we have planned for the near future

Outline:

Full Abstract:
Join Phil to hear what has been happening in DB2 tools development at CA and what we have planned for the future. As well as further support for DB2 9 we have also introduced new features and functions through the product maintenance stream.


21 June 2007
09:00 - 15:00
SQLAdria Seminar – Dubrovnik 2007 DB2 for z/OS Version 8 - In Depth

20 June 2007
13:15 - 14:00
SQLAdria Seminar – Dubrovnik 2007 DB2 Version 8 Partitioning - Warts and All

We all know that Version 8 of DB2 for z/OS introduces a new way to partition your data - we now have Table Based as well as Index Based partitioning. Is it all good news though? This presentation looks at the new capabilities of table based partitioning, considers the advantages (and there are many) before looking at some of the pitfalls awaiting the unwary. As with all new features of DB2, there are some hidden surprises that may cause problems that are not immediately aparrent
 


19 June 2007
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2007 Scrolling Scrolling Scrolling - A Short History of Cursors

Cursors have been around since the birth of DB2, but many DBAs still struggle to come to terms with what they are and what they do. In addition, for the last few versions of DB2 there have been many enhancements - from scrollable cursors to multi-row operations, the cursors of today are very different from those of the "olden days".
 
 


18 June 2007
15:45 - 17:00
SQLAdria Seminar – Dubrovnik 2007 DB2 9 - An Independent Overview

This presentation takes a high level look at the new features and functions of the latest version of DB2 for the z/OS platform. As well as the much publicised XML support, there are many other new SQL, security and availability items. This session will give you a good overview of DB2 9 for z/OS
 
 


17 June 2007
16:00 - 16:45
SQLAdria Seminar – Dubrovnik 2007 CAs Database Management Product Roadmap

14 June 2006
09:45 - 10:45
SQLAdria Seminar – Dubrovnik 2006 A-Z of Performance

13 June 2006
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2006 Utilities for Applications Developers

11 June 2006
17:15 - 18:00
SQLAdria Seminar – Dubrovnik 2006 DB2 V9

11 June 2006
16:30 - 17:00
SQLAdria Seminar – Dubrovnik 2006 DB2 System Tuning

11 June 2006
15:00 - 15:45
SQLAdria Seminar – Dubrovnik 2006 CAs Database Management Product Roadmap

29 June 2005
10:00 - 10:45
SQLAdria Seminar – Dubrovnik 2005 DB2 Triggers - An Overview

Triggers have now been around for some time in DB2 for z/OS so perhaps it is time for a brief refresher. In this session, Phil will review the trigger mechanism of DB2 for z/OS and will make some recommendations on trigger usage. As well as simple trigger creation, the uses of transition variables and transition data will be covered. In addition, the performance enhancements of DB2 Version 8 will also be reviewed.


27 June 2005
09:30 - 10:30
SQLAdria Seminar – Dubrovnik 2005 DB2 Version 8 Partitioning Scary Stories

One of the major changes to DB2 for z/OS Version 8 is in the way partitioned tablespaces are created and managed. This presentation will introduce you to table-based partitioning, all of the new features that are available and some pointers on how these enhancements will benefit application design and operation. Unfortunately, there are one or two scares along the way, but these are easily understood and by the end of the session, Version 8 partitioning should hold no fears!


26 June 2005
16:40 - 17:40
SQLAdria Seminar – Dubrovnik 2005 CAs Unicenter Index Expert

26 June 2005
15:45 - 16:25
SQLAdria Seminar – Dubrovnik 2005 What's New in Unicenter Release 11 for DB2 for z/OS

Release 11 of the Unicenter Database Management tools for DB2 for z/OS is the first release of tools from CA (indeed from any major software vendor) that supports DB2 UDB for z/OS Version 8. However, there is much more to r11 than Version 8 support. In this session, Phil will summarise many of the key enhancements to our DB2 tools.


26 June 2005
14:00 - 14:30
SQLAdria Seminar – Dubrovnik 2005 CAs Database Management Product Roadmap

Join Phil as he looks at the roadmap for the Database Management tools from Computer Associates. As well as looking at the longer term vision, Phil will also look at the driving strategy and the recent achievements. If you want to know what is happening in the world of Database Management, then don't miss this session


07 June 2004
14:15 - 15:15
SQLAdria Seminar – Dubrovnik 2004 DB2 V8 Partitioning

OK, so we can have up to 4,096 partitions in a single partitioned tablespace and we can now add new partitions to existing partitioned tablespaces - this is simple, so what's the big deal with this presentation? Well, just as with on-line schema evolution, there are a number of "gotchas" just waiting for you to trip up. These little features are examined in this presentation whilst we look at the wider implications of a new type of partitioned tablespace management.


07 June 2004
09:30 - 10:30
SQLAdria Seminar – Dubrovnik 2004 DB2 V8 On-line Schema

One of the most eagerly awaited features of Version 8 is the considerable extensions to the ALTER statement. We now have the ability to alter far more than we could in Version 7, mostly without taking an outage. However, there are still some implications both for availability and for performance that must be taken into account when performing these alters. Does On-Line Schema evolution spell the end for change management tools such as RC/Migrator? You will find out in this presentation that it doesn't - in fact it makes the need for intelligent change management software even greater.


06 June 2004
17:30 - 18:30
SQLAdria Seminar – Dubrovnik 2004 DB2 V8 Overview

At last the next version of DB2 for the mainframe is available (or I hope it will be by the time of this conference!). This presentation takes a brief and high level look at the new features and facilities that are available with Version 8. We also look at the migration path, and consider some differences to a traditional DB2 version migration. Lastly, we look at the pre-requisites for Version 8 and summarise the features of earlier versions that have been removed.


06 June 2004
17:00 - 17:30
SQLAdria Seminar – Dubrovnik 2004 Modeling for Success with ERWIN

06 June 2004
16:15 - 16:45
SQLAdria Seminar – Dubrovnik 2004 News from the CA Labs

11 June 2003
11:00 - 11:45
SQLAdria Seminar – Dubrovnik 2003 What's New in Version 7 for Application Developer? Part II

11 June 2003
10:00 - 10:45
SQLAdria Seminar – Dubrovnik 2003 What's New in Version 7 for Application Developer? Part I

09 June 2003
14:45 - 15:30
SQLAdria Seminar – Dubrovnik 2003 DB2 Log - What's in it for Me?

08 June 2003
17:10 - 17:50
SQLAdria Seminar – Dubrovnik 2003 Disaster Recovery with CA

12 June 2002
09:00 - 10:00
SQLAdria Seminar – Dubrovnik 2002 Lights out housekeeping with Database Analyzer

11 June 2002
10:15 - 11:00
SQLAdria Seminar – Dubrovnik 2002 Performance Improvements in DB2 V7

10 June 2002
14:45 - 15:30
SQLAdria Seminar – Dubrovnik 2002 Scrollable cursors

09 June 2002
17:00 - 17:45
SQLAdria Seminar – Dubrovnik 2002 Tech Support Update

09 June 2002
15:15 - 16:15
SQLAdria Seminar – Dubrovnik 2002 What's happening in the labs

28 September 2001
11:15 - 12:00
SQLAdria Seminar – Zagreb 2001 eApplications DEsigning for Performance

30 June 2000
10:30 - 12:00
SQLAdria Seminar – Dubrovnik 2000 Understanding the DB2 Log

29 June 2000
15:15 - 16:05
SQLAdria Seminar – Dubrovnik 2000 Understanding Triggers in DB2 OS/390

28 June 2000
20:00
SQLAdria Seminar – Dubrovnik 2000 DB2 Solutions

28 June 2000
15:15 - 16:00
SQLAdria Seminar – Dubrovnik 2000 Database Design for DB2 for OS/390

 

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