Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #Z04: What's new from the optimizer

May 23, 2011, 11:57 am
Posted by klaas in DB2 z/OS

Special guest Terry Purcell, Senior Technical Staff Member SVL

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.

Show Host Klaas Brant Commentary

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...

Join The DB2Night Show™ LinkedIn Group

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! Join The DB2Night Show LinkedIn Group!

A message from our sponsor KBCE

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 special in-house training page which includes all the benefits and a frequent asked questions section.

Get the Download Replay

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!

Printer friendly