Martin Wildberger; Vice President, IBM Data Management Development
Yesterday I listed all the IDUG sessions that are presented by a user. Today I'll post all the sessions that are being presented by IBMers. I'm sure you'll recognize all the names! The IDUG Conference is taking place this year from May 10-14 in Tampa Florida.
K01: DB2 Innovation: Powering Information Workloads for Smarter IT
Martin Wildberger; Vice President, IBM Data Management Development
S01: Spotlight Session: DB2 10 for z/OS Overview
S02: Spotlight Session: DB2 for Linux, UNIX and Windows - Trends and Directions
S03: Spotlight Session: The Vision of Integrated Data Management - Past, Present and Future of Tooling
476: DB2 10 for z/OS DBA Improvements, Roger Miller
407: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation, Bill Minor
730: Data Studio and Optim Administration Tooling for DB2 for z/OS DBAs, Bryan Smith
748: Making Your CIO Successful with Analytics, Greg Lotko
438: What's new from the optimizer in DB2 10 for z/OS?, Terry Purcell
419: Defend your Turf – DB2 Technical Advantages over Oracle, Chris Eaton
785: Introduction to Smart Analytics for DB2 & Power Systems, IBM, IBM, Eddie Daghelian
394: DB2 10 for z/OS Performance Preview, Akiko Hosihkawa
718: Diagnosing and Improving Query Performance through EXPLAIN plan analysis, Calisto Zuzarte
786: Infosphere Warehouse Deep Dive, Bill O'Connell
379: A VIsual Tour of DB2 9.7 SQL and PL SQL Enhancements, George Baklarz
793: Maximizing the Value of DB2 for z/OS in Data Warehousing, Beth Hamel
783: An Indepth Technical Look at pureScale, Matt Huras
738: Partitioned Tables: Significant Enhancements in DB2 9.7 (and beyond), Mike Winer
478: Extract the most value from .NET and ODBC Applications, Brent Gross
446| DB2 and System z Synergy, Chris Crone
316: DB2 for z/OS Optimizing Insert Performance - (Two Parts), Frances Villafuerte, John Campbell
791: An Insider's Look at the DB2 V9.7, Matt Huras
339: DB2 in the Cloud: The Hottest Topic for 2010, Leon Katsnelson
663: Stuffed with Great Enhancements - DB2 9.7 Fix Pack 1 New Features, Melanie Stopfer
403: DB2 10 for z/OS Availability Enhancement, Haakon Roberts
253: Upgrading DB2 9.7 – Best Practices and Lessons Learned, Melanie Stopfer
54: DB2 9.7 LUW Newest Online Schema Change Capabilities, Burt Vialpando
V01: Optimizing Data Storage Efficiency with Multi-Temperature Warehouse Principles, Enzo Cialini
V02: Cloning & Backup/Recovery on DB2 for z/OS: The Cutting Edge, Jay Bruce
V03: Understanding Information Governance, Tom Howell
V04: DB2 Has Always Been the Next Generation Database Software, Conor O'Mahony, Irshad Raihan
333: pureScale - Why It's So Much Better than Oracle RAC, Paul Zikopoulos
481: Best Practices for Query Performance In a Data Warehouse, Calisto Zuzarte
477: Enterprise Client Connectivity with DB2, Brent Gross
571: DB2 for z/OS Optimizer - What have you done for me lately?, Terry Purcell
739: Locking - What Locking? Currently Committed and other Lock Avoidance enhancements to Increase Performance and Throughput, Mike Winer
421: DB2 LUW for a z/OS DBA, Chris Eaton
330: A Day in the life of a DB2 for z/OS Page, Randy Ebersole
670: Enabling from Oracle to DB2 Cobra the Easy Way., Serge Rielau
225: DB2 DBM1 Virtual Storage: How to use MEMU2, Judy Ruby-Brown
277: Data Studio and Optim Administration Tooling for DB2 for LUW DBAs, Bryan Smith
657: DB2 Back and Recovery - What Do I Really Need to Know?, Dale McInnis
534: IBM Smart Analytics Optimizer -- Not Your Father's Database System!, Guy Lohman
V08: Going Active - Taking DB2 DR from Standby to Continuous Availability, Serge Bourbonnais
V09: Keeping Your Business Resilient in an Uncertain World, Tom Ramey
V10: End-to-End Monitoring & Problem Determination with Optim Performance Solution, Tom Howell
455: WLM Best Practices, Kevin Beck
334: All the FREE Things you can Do with Data Studio, Paul Zikopoulos
391: Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution, Namik Hrle
717: DB2 LUW LOBs - Past, Present and Future, Bill Minor
487: Auditing Options on DB2 for z/OS, DB2 for z/OS, Ernest Mancill
656: DB2 High Availability Features and Directions , Dale McInnis
53: DB2 9.7: The Latest And Greatest in Database Security, Walid Rjaibi
Check out the bookstore that will be onsite where you can purchase books from
1) Making it Big in Software, by Sam Lightstone
2) The Art of Enterprise Information Architecture by Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, and Michael Schroeck
3) DB2 pureXML Cookbook by Matthias Nicola and Pav Kumar-Chatterjee
Don't forget about the
Check out my previous blog entries for a list of all the
svisser1 2700018UK9 Tags:  sessions presenters users books idug conference 1 Comment 7,822 Views
IDUG = International DB2 User's Group, so you'd expect there to be many presentations at the annual conference that are done by users. And you're right. And what a great bunch of users who are part of the IDUG team! Here are some who I haven't mentioned on my previous blog entries:
756: Hell’s Kitchen; DB2 9, A DBA’s Recipe for Success , Rob Crane II, FedEx
360: Crossing Over - A Mainframers Guide to DB2 LUW, Jim Wankowski, Quest Software
533: Varsity SQL for the Busy DBA, Fred Sobotka, FRS Consulting, Inc.
434: DB2 Z/OS V8 Data Warehouse Conversion to DB2 LUW 9.5, William Gannon, Palm Beach County School District
547: Spatial Data Management on DB2 for z/OS; Customer Experiences at John Deere, Sooraj Ali, John Deere
397: Auditor's Guide to DB2, Thomas Baumann, Swiss Mobiliar
735: De-mystifing JDBC Universal Drivers - for the z/OS DBA, Billy Sundarrajan Fifth Third Bank
613: DB2 9 for z/OS: What's New Since GA?, Phil Grainger, Independent consultant
572: Enabling Oracle Applications on DB2 - an Early User Experience, Bernie O'Connor, Anixter Inc.
450: Squeeze the Most Out of your Indexes in DB2 9!, Jim Dee, BMC Software Inc.
590: DB2 for z/OS SQL Performance Choices, Daniel Luksetich YL&A
782: Table and Index Design Strategies: Looking Forward to DB2 9, Susan M Lawson, YL&A
784: Mainframe DB2 Data Warehousing 2010, Robert Catterall, Catterall Consulting
294: Where my requests spend time? --- First taste DB2 9.7 Time Spent metrics, Pak Kwan Fifth Third Bank
495: DB2 for the Oracle DBA, Jim Wankowski Quest Software
447: Understanding Your DBA?? It Can Be Done!!, Brad Price, Werner Enterprises
351: Solving Warehouse Source Data Issues Using DB2 on z/OS , Robert Goodman, Florida Hospital
91: An A to Z of DB2 for z/OS Backup and Recovery, Phil Grainger, Independent consultant
574: Static SQL and Access Path Review - Tips and Tricks , Paul Walters, Sallie Mae
576: Major Locking Issues with New SQL (2 Parts), Bonnie Baker, Bonnie Baker Corporation
558: DB2 Security – Ammo From the Trenches, Rebecca Bond
321: DB2 9 tricks for COBOL programs, David Churn DST Systems, Inc.
343: A Few Things to Know Before Migrating to DB2 9 for z/OS, David Simpson Themis Inc.
550: Unlocking the Mysteries of the DB2 Log, Paul Turpin, S1 Corporation
408: Scaling Enterprise Data in the Cloud, Albert Lee xkoto, Inc.
448: Rev up your SQL Applications with Enhanced Statistics!, Jim Dee BMC Software
288: DB2 9 Package Stability: Migration, System and Daily Database Maintenance, Ulf Heinrich SEGUS Inc.
736: DB2 z/OS – Hands free approach to maintenance of multi terabyte tables, Billy Sundarrajan, Fifth Third Bank
402: DB2 LUW Index Design and Best Practices, Scott Hayes, DBI
347: Java DB2 Developer Performance Best Practices, David Beulke, Dave Beulke & Associates
345: Exploiting DB2 9.7 Monitoring and WLM Functionality, Philip Nelson ScotDB Limited
V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!, Scott Hayes - DGI, Phil Grainger - Grainger Consulting
V07: Reveal Your Inner Genius with BMC Software, Rick Weaver - BMC
312: Do you really want NOT to LOG ?, Steen Rasmussen CA
570: John Deere's User Experience with DB2 9 New Features, Bryan Paulsen, John Deere
297: Wake Up to Hibernate, John Mallonee, Highmark Inc.
491: Optimize DB2 Buffer Pool performance with the new Performance Wizard and Buffer Pool Tool® for DB2, Joel Goldstein, Responsive Systems
467: Package Versioning for High Availability, John Maenpaa, Health Care Service Corporation
346: Moving to DB2 9.7 : User Experiences, Philip Nelson, ScotDB Limited
311: RTS is your friend – Optimize DB2 housekeeping., Steen Rasmussen, CA
631: A 411 on the DB2 Directory, William Arledge, BMC Software
628: Ask not what the Optimizer can do for you ? ask what you can do for the Optimizer!, Suresh Sane DST Systems Inc
445: The Caveman Chronicles: How We Took our DB Performance from Ice Age to New Age!!, Brad Price, Werner Enterprises
639: IFI you don't know, ask!, Jeff Gross, CA
624: Best Solution in DB2 for z/OS , Frank Petersen Bankdata
566: DB2 Compression and performance impact, Robert Donaldson LSSiData
466: DB2 Attachment Facilities, John Maenpaa Health Care Service Corporation
298: DB2 LUW and Oracle Environment Standardisation (CA-IDUG Award 2009), Peter Suhner, AXA Technology Services Switzerland AG
151: Solving the DB2 Database Administration Dilemma, Randy Goering, DST Systems Inc.
V11: Improving the Performance of the Enterprise, Raymond Meza - Eccox Software Group
V12: Tune Mainframe SQL Like a Genius , Bill Arledge - BMC Software
563: Generic Attach on Z/OS (or attachment demistifyed), Jack Bailey, BlueCross BlueShield of South Carolina
59: The Return of the DB2 Top Ten Lists, Craig Mullins
620: DB2 LUW Design Advisor - db2advis ? Miracle-Worker or Monster-In-Law, Alexander Kopac, Home Depot
485: How a Performance Database Can Help Save the Day! , Mark Wilkinson, AMICA Mutual Insurance Company
484: A practical guide to storage tiering with DB2 for z/OS, Paul Pendle EMC
EU2009 Best Speaker: 623: How to Cope with Soap? WebServices on DB2 for z/OS, Frank Petersen Bankdata
565: High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7, Robert Donaldson, LSSiData
618: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks, Alexander Kopac Home Depot
526: Lessons Learned from SQL Performance Reviews , Sheryl Larsen, Sheryl M. Larsen, Inc.
794: DB2 9 for z/OS Migration Planning Survival Guide, Linda Claussen, Themis
627: Real-world strategies for managing undesirable access paths, Suresh Sane, DST Systems Inc
743: My Memorable Moments with DB2 LUW, Debra Wong, Marriott International
210: The Power SQL PL, Herb Vogel, JB HUNT Transportation
436: DB2 Administration for Better Performance and Low Cost, Sigen Chen, Lockheed Martin
I recognize a few new names here, which is wonderful! Thanks to all speakers and good luck at your session! I hope you are filled to capacity :)
Check out the bookstore that will be onsite where you can purchase books from Rebecca Bond, Susan Lawson, Daniel Luksetich, Craig Mullins and others.
Monday isn't listed above, as the educational seminars are taking place that day. Be sure to check out the offerings. Don't forget about the free certification exams you can take!
Check out my previous blog entries for a list of all the InfoSphere sessions as well as details about the fun events that are planned.
My second favourite thing to do when at a conference is to network with the other attendees. First is taking advantage of all the learning opporuntiies, of course!
IDUG is my favourite conference to go to as well because the organizers and attendees are so friendly and easy to meet. In the true sense of the word, IDUG is a community... and sometimes feels like a family. I'm sure if you've been to a conference, you know what I mean. If you haven't, I hope you get a chance to go. It might change the direction of your career. For instance, perhaps you will be encouraged to follow in the footstep of the IDUG board members and get more involved, or put together a presentation for future years! I hope you do!
The IDUG committee has arranged a fun way for you to meet others while at the conference. They call it Dine Around with DB2 Experts. Here is what's on the agenda so far:
Phil Grainger and Judy Ruby-Brown at Thai Thani;
Phil Nelson, Dave Beulke and Fred Sobotka at Stumps;
Bill Minor and Mike Winer at Tampa Bay Brewing Company;
Bonnie Baker and Sheryl Larsen at the Spaghetti Warehouse;
Chris Eaton and Scott Hayes at the Laughing Cat.
What a tough decision! My suggestion is that you choose a location based on the food that you like. Or, how about you choose to hang out with the people you know the least? Since I know all the people who are hosting, I wouldn't be able to select based on who I liked... because I like them all and would be very happy to hang out with them for hours!
This event is taking place on Thursday evening at May 13. Have you joined the LinkedIN IDUG group? Join to get more information about this event from those taking place.
Become a fan of IDUG on Facebook to keep up to date with what is going on.
One more thing that I'd like to mention.... If you aren't very comfortable traveling alone, consider this new program offered by IDUG that can help you bring someone new to the event: IDUG Mentor. Bottom line? You can bring a newbie to the conference for an 80% disount. See the website for details.
Check out my previous entries this week: Get Certified, Learn about InfoSphere, and Take a Education Seminar before the conference begins.
Learn plenty, but have fun by meeting people and getting involved!
Yesterday I mentioned the InfoSphere sessions that are taking place at the IDUG Tampa conference (May 10 - 14)and Monday I blogged about the free certification exams that are available.
Today I'll tell you about the 7 education seminars that are taking place on Monday May 10. Note that all these sessions take place the same day and same time, so the hard part will be to choose which one you want to participate in!
Z01: DB2 9 for z/OS Cert Exam, Susan Lawson, YL&A
Z02: Save CPU Costs by Tuning your SQL, Bonnie Baker, Bonnie Baker Corporation
Z03: SQL: What To Use When You Can and Cannot Touch It, Sheryl Larsen, Sheryl M. Larsen, Inc
Z04: DB2 9.7 for Linux, UNIX and Windows DBA Certification Exam Preparation (Exam 541), Roger Sanders, EMC
Z05: Deep dive into DB2 LUW Problem Determination and Troubleshooting, Pavel Sustr, Samir Kapoor, IBM Toronto Lab
Z06: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
Z07: DB2 9 for z/OS In-depth, Phil Grainger, Independent Consultant
Z08: Optimizing System Performance Using DB2 Statistics Trace
You can view session details and build your curriculum with the on-line conference scheduler.
At the conference bookstore, you'll find books by Roger Sanders and Susan Lawson to accompany the course material that they are delivering.
Stay tuned for more information... coming up soon!
Yesterday I blogged about getting certified for free at the upcoming IDUG conference in Tampa Florida. Today I'd like to tell you about the number of InfoSphere Warehouse sessions that will be available so you can leave the conference a step closer to being an InfoSphere expert.
Here are the InfoSphere sessions that you can attend while at the conference (user submissions in this colour):
748: Making Your CIO Successful with Analytics, Greg Lotko, IBM, IBM, Cross Platform
434: DB2 Z/OS V8 Data Warehouse Conversion to DB2 LUW 9.5, William Gannon, Palm Beach County School District, Company/Organization That Uses DB2, Cross Platfor
785: Introduction to Smart Analytics for DB2 & Power Systems, IBM, IBM, Eddie Daghelian, DB2 for Linux, UNIX, Windows
786: Infosphere Warehouse Deep Dive, Bill O'Connell, IBM, IBM, DB2 for Linux, UNIX, Windows
793: Maximizing the Value of DB2 for z/OS in Data Warehousing, Beth Hamel, IBM, IBM, DB2 for z/OS
784: Mainframe DB2 Data Warehousing 2010, Robert Catterall, Catterall Consulting, Consultant, DB2 for z/OS
351: Solving Warehouse Source Data Issues Using DB2 on z/OS , Robert Goodman, Florida Hospital, Company/Organization That Uses DB2, DB2 for z/OS
339: DB2 in the Cloud: The Hottest Topic for 2010, IBM, IBM, Leon Katsnelson, Cross Platform
534: IBM Smart Analytics Optimizer -- Not Your Father's Database System!, Guy Lohman, IBM, IBM, DB2 for z/OS
481: Best Practices for Query Performance In a Data Warehouse, Calisto Zuzarte IBM, IBM, DB2 for Linux, UNIX, Windows
391: Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution, Namik Hrle, IBM, IBM, DB2 for z/OS
You can view session details and build your curriculum with the on-line conference scheduler.
While you're at the conference, stop by the conference bookstore and consider picking up a copy of:
This is the only book with a large amount of InfoSphere content, including coverage for the following products:
* InfoSphere MDM Server
Are you going to IDUG in Tampa, Florida this year? The conference takes place May 10 - May 14 and if you are going, you have 4 weeks to prepare to pass the free exams that you can take while attending the conference.
Why get certified? It's getting harder to keep your skills up to date these days with everything changing so quickly and the huge volume of information that you are bombarded with every day. Certification exams are focused on a specific topics and cover a limited number of objectives that are related to the tasks performed in that job role. So when you are studying for the exam, you are studying only a subset of the content that is available for the product. This targeted studying can be a more achievable way to increase your skills as you'll do a piece of learning and then testing at a time.
To help you target your studying, we have a set of study guides that you can use to prepare to pass the exam.
Here are the books:
DB2 9 Fundamentals Exam 730
Roger Sanders' book: DB2 9 Fundamentals Certification Study Guide
DB2 9 DBA for Linux, UNIX, and Windows Exam 731
Roger Sanders' book: DB2 9 Database Administration Certification Study Guide
DB2 9.7 DBA for Linux, UNIX, and Windows Exam 541
This exam was updated to the V9.7 level, while the book is at the V9 level. This might cause you a slight problem on some of the questions but overall, you should still be able to pass the exam with this book. If you're concerned, you should examine the exam objectives to see what was added. You could also take the Exam Prep for Exam 541 course that will be taught by Roger Sanders on May 10 at the Conference.
DB2 9 Advanced DBA for UNIX, and Windows Exam 734
DB2 9 Advanced DBA Certification Study Guide by Roger Sanders and Dwaine Snow
DB2 9 for z/OS Database Administration Exam 732
DB2 9 for z/OS Database Administration Certification Study Guide by Susan Lawson and Dan Luksetich
These books will be for sale at the conference, but if you can, purchase the books before the conference so that you have time to read them and study to the degree that you need to.
If you aren't able to purchase the books outright, check amazon or other sites for used copies of the books. Also, libraries might have copies of the books. I know our skill's center library has many copies of these books... and they are VERY well used!
Check to see if your company has a subscription with Safari Books Online or Books 24x7. Both of these electronic book engines carry these books which will allow you to read the entire book or to search and read parts of the book as needed.
The publisher of the Certification Study Guides, MC Press, is working on getting the books available in Kindle format, so that could be an option for you as well.
If you are working with DB2 in your daily job, you may be ready to pass the exam with minimal studying. I suggest that you try an assessment exam to guage your readiness. You may also wish to answer the sample questions that are in the Certification Study Guides. If you are able to pass these questions correctly and easily, you may be ready to pass the exam.
If you want a little more help, consider taking the Exam Prep courses that take place on May 10 at the conference. You can prepare for Exam 541 or Exam 732.
For more information about getting certified, see my previous blog entry: Certification 101.
Have fun in Tampa! Get certified :)
I'm sorry that I missed the fact that there IS a fee for the Crammer courses. Please see the CORRECT information below. I'm sorry for any confusion I may have caused. Thanks to Bryan for pointing out my mistake in this matter.
IDUG Pre-Conference Educational Seminars
The 2010 Pre-Conference Educational Seminars are:
IDUG's annual North American conference is taking place in Tampa Florida this year. May 10 - 14, 2010. Have you been able to get funding to attend the conference yet? If not, maybe this information will help you.
The educational opportunities available at the conference will help make you smarter! And if you're smarter about your job, you'll be more effective, make fewer mistakes and be a real asset to your employer! Right?
Take a look at the conference schedule that is now available online. With this tool, it is now easier for you to build your conference curriculum by allowing you to search by program or project to find sessions specific to your area of expertise.
Here is a sample of the sessions you’ll find this May in Tampa:
D06 (DB2 for LUW): "DB2 Security – Ammo From the Trenches", Rebecca Bond, Author of "Understanding DB2 9 Security"
B10 (DB2 for z/OS): "Package Versioning for High Availability", John Maenpaa, Health Care Service Corporation
C08 (DB2 for LUW): "Successfully Managing the DB2 LUW Workload Manager", Scott Hayes, Gold Consultant, DBI Software
C09 (DB2 for LUW): "DB2 pureScale: Why It's So Much Better than Oracle RAC", Paul Zikopoulos, IBM Corporation
S03 (Cross-platform): "The Vision of Integrated Data Management - Past, Present and Future of Tooling", Curt Cotner, IBM Fellow, IBM Corporation
New this year at IDUG, you will also find a full-offering of hands-on labs. Available all four days of the conference, the labs include individual work-stations that allow you to explore new DB2 features and try out products without the hassle of obtaining and setting up software. This year’s hands-on labs include:
DB2 Lab 1: DB2 for LUW - All About DB2 9.7
DB2 Lab 2: DB2 for z/OS - Getting Started with DB2 for z/OS pureXML
DB2 Lab 3: DB2 for LUW - DB2 9.7 Performance Metrics and Monitoring
DB2 Lab 4: DB2 for z/OS - Develop High-Performance Java Applications on z/OS Using IBM pureQuery
DB2 Lab 5: DB2 for LUW - Workload Management
DB2 Certification Exams:
Do you have your current certifications yet? The exams are available free of charge to attendees of the conference (3 exams per attendee). This is a HUGE savings of $200 PER EXAM!
Make sure you are ready to pass the exam by taking a crammer course on May 10 for last-minute preparation for the exam. These full day seminars require an additional fee.
Z04: DB2 for Linux, UNIX and Windows - DBA Certification (541) Preparation Course
Date: May 10, 2010 09:00 AM – 04:30 PM
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
Z01: DB2 9 for z/OS DBA Certification Crammer Course
Register now to qualify for discounts on your conference fees:
Early Bird Discount: Register on or before March 26, 2010 and save $150 on your full-conference registration.
IDUG Mentor Program: Need to get thrifty with your training dollars this year? Through this incomparable loyalty reward program, IDUG members who have attended five or more IDUG conferences in the past ten years have the opportunity to bring a first-time attendee from the same company for an unprecedented 80% discount!
Visit IDUG.org/na to learn more about IDUG 2010 North America.
Do you need more help justifying your attendance at this confernece? See IDUG.org/na for further tips.
I hope all my IDUG friends who are in Rome this week are enjoying the city, weather, and of course the amazing conference!
If you are an IDUG member, I'd like to bring this information to your attention:
IDUG members save $100 on registration for the Information On Demand 2009 global conference.
Not a member... become one today.
Visit IDUG for promo code.
I hope to see you in Vegas!
IDUG Solutions Journal July 2009 : Volume 17 Issue 2 provides Chapter 11 (Chapter 11 - Converting XML to Relational Data) for free from the book:
DB2 pureXML Cookbook: Master the Power of IBM's Hybrid Data Server
Authors: Matthias Nicola, Pav Kumar-Chatterjee
In DB2 pureXML Cookbook, two of IBM's leading experts provide the single most comprehensive coverage of DB2's pureXML capabilities. This book explains DB2 pureXML in over 700 practical examples, including 250+ XQuery and SQL/XML queries, taking the reader from simple introductions all the way to advanced scenarios. The authors have distilled their hands-on experience with many pureXML applications so that you can benefit from best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere.
This book is invaluable for database administrators and application developers, beginners and DB2 experts. The topics are organized by typical user tasks throughout the life cycle of XML database projects, from planning, designing, and implementing databases all the way to tuning, problem determination, and application development. It includes code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers.
The DB2 pureXML Cookbook provides proven recipes rather than a mere reference of ingredients.
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server
Use Coupon Code when checking out:
I'm expecting this book to be a BEST SELLER this year! Make sure you get your copy before they run out! Also, meet Matthias Nicola and get your book signed at theIOD Global Conference.
Register for this exclusive, free IDUG Webcast...Register now and plan to attend!
DB2 9.7: Get the Inside Scoop
Wednesday, June 24
Presented by Paul Zikopoulos
The release of DB2 9.7 for Linux, Unix and Windows is creating quite a stir in the industry. CNET said that "IBM puts Oracle to the Sword." ZDnet commented that "IBM's latest DB2 woos Oracle customers." Industry analyst Merv Adrian said, "This is a BIG deal." Beta participants claim that "this is a paradigm shift" and "simply amazing."
IDUG is pleased to host this unique 60-minute webcast on Wednesday, June 24 at 12:00pm Eastern. In this free event, you'll discover the new features of DB2 9.7 that will save you time, improve performance and lower your management costs. You'll be the first to know about the new technology your peers will be buzzing about by hearing it directly from the source.
Join renowned DB2 evangelist and respected author Paul Zikopoulos as he explains what the DB2 9.7 buzz is all about. Along with live Q&A, Paul will discuss DB2 9.7's new features for:
1. increasing performance, reliability and ease of use
In addition, IDUG President Michael McBride will discuss how this webcast is just one example of the many technical DB2 resources offered through IDUG's worldwide DB2 community.
Sadly I will not be attending IDUG in Denver next week. At first I was OK about this, but when I started going through the speaker list, it made me realize all the great people I'll be missing! I can't mention all the people who I'll miss... but let me tell you about the authors who will be there. Breakpoint books will be there as well providing a wide selection of books for you to browse and buy. Note that all attendees get a 10% discount on their book purchases.
For a laugh... you need to check this out: Kitchen Perfect.
I hope everyone has a great time while you are learning!
Did you know that you have a chance to attend IDUG 2009 – North America for absolutely no charge? Simply fill out this brief survey for your chance to win a FREE registration to IDUG 2009 – North America, May 11-15, in Denver, Colorado.
Already registered? You still have a chance to win! Any previously registered attendee announced as the raffle winner will receive a full refund of their registration costs provided payment has already been received by IDUG Headquarters.
Not registered yet? Don’t delay – register for IDUG 2009 – North America before Friday, March 27 and save $150 on full-conference registration rates. For a sneak peek at all the great content available at this year’s conference download a copy of our Advance Program or visit online at www.idug.org/na.
IDUG conferences and Denver Colorado... a perfect combination. You won't regret your decision to go to this conference in this location!
Can you believe that it is already late in March! I've just returned from vacationing with my son for his March break from school... and am refreshed from the vacation... and pumped because SPRING is here!
There are several deadlines approaching quickly that you must take action on to avoid missing important opportunities.
If you were lucky enough to take a break... welcome back! I hope spring is inspiring you to change like it is for me.
You may have taken part in this survey of IDUG members on the topic of evolving roles and eduction / training needs. I can't say that the results are unexpected, but I can say that it is very helpful to see the analysis and results as they are discussed in the final survey report, "Data Professionals Broaden Their Skills,". The document is currently posted on IDUG's Web site and can be downloaded free-of-charge.
IDUG partnered with Unisphere Media to conduct the survey of IDUG members on this important topic. Sponsored by CA, the survey gathered input from more than 850 data professionals, with some enlightening results that will help IDUG further serve your needs.
From a publishing perspective, I was encouraged to see that many of the books that are currently available, along with those that are in the works, meet the needs of most of the respondents.
For example, it was mentioned several times in the document that DBAs need the following types of information: database performance and tuning, SQL performance, backup and recovery, and data availability. The recently published book by George Baklarz and Paul Zikopolous, DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) covers all of the topics and confirms to me that this book is the must have book for all DBAs! The upcoming book by Roger Sanders and Dwaine Snow, DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide will make an excellent companion book for this audience as it may go into more depth on some of the topics mentioned.
The document also mentioned that more DBAs are finding the need to perform application development tasks such as SQL statement development, data modeling and design, and data access methods. In addition to the Baklarz/Zikopolous book already mentioned, you should consider the book by Philip Gunning: DB2 9 for Developers . As the title implies, the book covers the application development tasks that a DBA is required to perform.
Always an important topic is database security: "Forty-one percent reported their time engaged in data security activities has grown over the past year. Most activity in this area has been focused on access control and user authentication, and managing users, roles and permissions." I would recommend the following book: Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, and Yuk-Kuen Henry Chan
Certification was also mentioned in the survey results, but the message was: "Certification, while valuable, is only prevalent at a minority of sites, the survey found. About 47 percent of respondents - the largest segment - said a quarter or fewer of staff members are certified or working toward certification. Another 21 percent have no certified staff at all." I found this to be surprising as certification exams are extremely popular with the IDUG conference attendees. The books that support our certification program are: DB2 Certification Study Guides.
Lastly I found the difference between database consultants and database administrators interesting: "The priorities of respondents who spend most of their time in business consulting-related activities differ sharply from those mainly engaged in traditional database administration. While both types of data professionals are likely to be focused on managing explosive data growth, data managers engaged in business consulting are far more likely than traditional database administrators to be focusing on developing service-oriented architectures (34 percent versus 18 percent). Likewise, respondents engaged in business consulting roles are more likely to be moving forward business intelligence initiatives (33 percent versus 18 percent). Enterprise information integration is also more of a top concern among professionals engaged with the business (31 percent versus 21 percent)."
For this audience, I'd highly recommend the growing list of SOA titles from IBM Press, especially Enterprise Master Data Management: An SOA Approach to Managing Core Information which I was closely involved with.
I encourage everyone to read and interpret the results from this survey for themselves. The document is 23 pages in length and worth the time to read.