Want to know all about the DB2 10 optimizer improvements? Is the DB2
community using Hints?
In episode #Z04, special guest Terry Purcell, a Senior Technical Staff Member
of the IBM SVL Lab, is telling us all about the optimizer improvements in DB2
10. Terry is a great presenter and, as always, his sessions are packed with a
lot if great technical information. Watch episode #Z04 and get some free
education on DB2 10 optimizer improvements.
Want to know all about the DB2 10 optimizer improvements? Is the DB2
community using Hints?
In episode #Z04, special guest Terry Purcell, a Senior Technical Staff Member
of the IBM SVL Lab, is telling us all about the optimizer improvements in DB2
10. Terry is a great presenter and, as always, his sessions are packed with a
lot if great technical information. Watch episode #Z04 and get some free
education on DB2 10 optimizer improvements.
Let's be honest - a relational database is 50% tricks (e.g. compression or
recovery) and 50% creating a great optimizer. Tricks can be copied (although
some vendor make a mess doing so), but the optimizer remains the best secret.
The optimizer is what sets relational databases apart from each other.
Relational database are like cars. In the top 4 there are no bad cars, but a
Mercedes is a different car than a BMW. The same applies to relational
databases, DB2 is different from Oracle. And the optimizer is the piece that
makes the difference. And although the optimizer internals will remain a secret,
there is a lot you can learn about the optimizer. I have known Terry Purcell
since the late 90’s and was very pleased when he told me many years ago that he
joined the IBM optimizer team. Terry’s knowledge about relational databases and
the way SQL can and must be optimized is more than just great. And… he is also
a great presenter, which you can experience again in today’s episode. Missed
the live show? Then please watch the replay to find out all the details about
DB2 10 CPU, Memory and IO!
Want to access the replay of today’s session? Keep reading...
The DB2Night Show™ has a LinkedIn Group. The "closed" group is
open to any LinkedIn member. Join to receive LinkedIn group updates including
future shows and replay information, and, if you like, start some discussions
about the show!
target=NEW title="New Window: Join The DB2Night Show LinkedIn Group">Join The
DB2Night Show LinkedIn Group!
Have you ever attended a DB2 Symposium? The DB2 Symposium is a three day
training event with one day seminars presented by industry leading consultants.
The DB2 Symposium fills the gap between a conference and a multi-day training.
The DB2 Symposium is unique because you can join us for 1, 2 or 3 days,
depending on your needs and budget. If you follow us on twitter, you'll always
have the latest information about our events. You can read all about it at
Does your staff need DB2 training? Would you like to benefit from a cost-effective
training, tailored to the needs of your organization? If so, KBCE’s in-house
training service can deliver a unique course for your organization. In-house
training saves you time and money because our professional trainers come
directly to you, ensuring there are no travel or accommodation costs incurred
for your members of staff.
Read all about the benefits of in-house DB2 Training on our
title="KBCE In-house Training">special in-house training page which
includes all the benefits and a frequent asked questions section.
To download a recorded replay of Episode #Z04, right click on the link below
and choose "Save As..."
Episode Z04, 23 May 2011, What's new from the optimizer in DB2 10 for z/OS with
guest Terry Purcell
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!