Posted on 5/23/2011
Special guest Terry Purcell, Senior Technical Staff Member SVLWant to know all about the DB2 10 optimizer improvements? Is the DB2community using Hints? In episode #Z04, special guest Terry Purcell, a Senior Technical Staff Memberof the IBM SVL Lab, is telling us all about the optimizer improvements in DB210. Terry is a great presenter and, as always, his sessions are packed with alot if great technical information. Watch episode #Z04 and get some freeeducation on DB2 10 optimizer improvements.
Show Host Klaas Brant CommentaryLet's be honest - a relational database is 50% tricks (e.g. compression orrecovery) and 50% creating a great optimizer. Tricks can be copied (althoughsome 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 aMercedes is a different car than a BMW. The same applies to relationaldatabases, DB2 is different from Oracle. And the optimizer is the piece thatmakes 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 Purcellsince the late 90’s and was very pleased when he told me many years ago that hejoined the IBM optimizer team. Terry’s knowledge about relational databases andthe way SQL can and must be optimized is more than just great. And… he is alsoa great presenter, which you can experience again in today’s episode. Missedthe live show? Then please watch the replay to find out all the details aboutDB2 10 CPU, Memory and IO! Want to access the replay of today’s session? Keep reading... Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ has a LinkedIn Group. The "closed " group isopen to any LinkedIn member. Join to receive LinkedIn group updates includingfuture shows and replay information, and, if you like, start some discussionsabout the show! Join TheDB2Night Show LinkedIn Group! A message from our sponsor KBCEHave you ever attended a DB2 Symposium? The DB2 Symposium is a three daytraining 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 alwayshave the latest information about our events. You can read all about it at www.db2-symposium.com. Does your staff need DB2 training? Would you like to benefit from a cost-effectivetraining, tailored to the needs of your organization? If so, KBCE’s in-housetraining service can deliver a unique course for your organization. In-housetraining saves you time and money because our professional trainers comedirectly to you, ensuring there are no travel or accommodation costs incurredfor your members of staff.
Read all about the benefits of in-house DB2 Training on our special in-house training page whichincludes all the benefits and a frequent asked questions section. Get the Download ReplayTo download a recorded replay of Episode #Z04, right click on the link belowand choose "Save As... "
Episode Z04, 23 May 2011, What's new from the optimizer in DB2 10 for z/OS withguest Terry Purcell Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format! |