I found a guest blogger for today who can navigate through all the amazing IDUG sessions and recommend the best for a person who is from the z/OS side of the house. Thanks to Rebecca Bond for being my guest blogger for the LUW sessions: IDUG NA – The Geeky Vacation!
Before I pass the baton to my guest blogger Beth Zlotky, I’d like to thank Suresh Sane for connecting me to Beth. Now, here’s Beth:
Greetings IDUG bloggers. As an IDUG NA attendee for the past two years, I'm very much looking forward to a repeat great experience in Anaheim. The friendly atmosphere in the hallways, at the sessions, and, let's face it, while dining too, has made the week very comfortable and enjoyable for me in the past. For those of you perhaps new to the conference, you may be surprised at how quickly you start recognizing familiar faces. The value of the information presented in the sessions and while networking with peers makes this a fantastic learning experience.
My particular role at Blue Cross and Blue Shield of Kansas is that of a DB2 for z/OS systems programmer; thus, my session choices tend to lean towards overall subsystem performance, migration experiences, etc. That said, I'm always eager to also get familiar with those new features available to the DBAs and developers in new releases. (Of note, for you developers – I've had the privilege of hearing both of Suresh Sane's sessions in our area User Group meetings: B15 – DB2 Design Selected (Controversial?) Topics and E10 – DB2 10 Application Topics – A Sneak Preview. Go. It'll be well worth your time).
I'm fortunate this year to be able to attend one of the Monday sessions: Z03 – Optimizing DB2 for z/OS System Performance Using DB2 Statistics Trace, with John Campbell. By the way, did you know that if you attended an IDUG Regional Event in 2010, you can use the monies paid as a credit towards the IDUG 2011 NA conference? In our case, the credit nearly covered the cost of the Monday session.
In these days of ever-tightening budgets, I feel very thankful for the opportunity to use precious training dollars. I want to say thank you to my employer by thinking, "what sessions will best help me to help our company?" Of course, my track leans heavily towards z/OS, and our shop in particular has embraced (and is continuing to develop in this direction) distributed Java apps running under WebSphere on UNIX, using DB2 on Z as the data server. I'm constantly trying to better understand how those apps access DB2 on Z and how we can improve performance from a subsystem perspective. There are some great sessions along those lines this year. I've yet to completely flesh out my week's agenda, but have identified these for sure:
- Z03: Optimizing DB2 for z/OS System Performance Using DB2 Statistics Trace. John Campbell
- B02: Mastering Distributed Access to DB2 for z/OS. Cristian Molaro.
- A03: Continuous Monitoring of Dynamic Queries. Thomas Baumann.
- A04: IBM Reorg Utility and RTS – A Smooth Transition. Paul Walters.
- B05: The DB2 V10 Catalog – A Revolution. Steen Rasmussen.
- B06: DB2 for z/OS Migration Planning Survival Guide. Linda Claussen.
- F07: DB2 10 for z/OS – John Deere's Beta Experience. Bryan Paulsen.
- G08: Early Experiences with DB2 10 Metrics/Metadata. Terry Berman.
- B10: DB2 10 for z/OS Planning and Very Early Experiences. John Campbell.
- A11: A DB2 Hitchhikers Guide to RMF and SMF. Frank Petersen.
- B12: Omegamon PDB – Exploit the Power of the PDB to Solve Performance Issues. Billy Sundarrajan.
- A14: Cost Control Methods for DB2 for z/OS Workloads. Mary Beth Jeffords.
- G15: Monitoring and Troubleshooting Distributed Access to DB2 for z/OS. Cristian Molaro.
If you see a "Beth Zlotky" name tag, please say hello. It's always nice to compare notes and share experiences. See you in Anaheim.
Thanks so much Beth! I’m sure this will help people choose the best sessions out of the wonderful selection that is available. For details on the sessions, see my blog entry All about IDUG DB2 Tech Conference – Anaheim.
Friday on the DB2Night Show, host Scott Hayes invited Bryan Paulsen and Paul Turpin to talk about the upcoming IDUG conference:
- Bryan Paulson, John Deere, Volunteer of IDUG – current chair
- Paul Turpin – S1, Volunteer of IDUG - past chair
First thing to notice is that the name of the conference has changed. It is now the IDUG DB2 Tech Conference. They made the name change to help people get funding to attend the conference.
The conference takes place May 2-6, in Anaheim California. This is the first time an IDUG conference has taken place in Anaheim. I attended IBM conferences there a few times and quite enjoyed the lovely weather and restaurants… as well as the nearby Disney Park. (It is the best Disney park, in my opinion.)
Monday May 2 is a full day of education that costs an extra fee. The idea is to have in depth education that will go to a much deeper level than is normal during the much shorter conference sessions. There is the extra fee, but it is well worth the price. There are 6 classes available for you to choose from:
The next four days, May 3-6 are for the 105 technical sessions. The sessions are split across 7 tracks including: DB2 LUW, DB2 z/OS, and Application Development. Speakers are in three categories: Users, Consultants, and IBM experts:
- Users are DB2 professionals working in the field on DB2 on a daily basis. This includes DBAs, Application Developers, and more. Some of the notable speakers this year include: Bryan Paulson, Alexander Kopac, Tony Andrews, and Suresh Sane.
- Consultants are in the field selling education and services to the customers using DB2 and include Susan Lawson, David Buelke, Sheryl Larsen, and Fred Sobotka.
- IBM experts are people from various roles in IBM including the Development Lab, Product Management, Education, and more: Terry Purcell, Matt Huras, Roger Miller, Matthias Nicola, Paul Zikopoulos, Melanie Stopfer, Kate Kurtz, and Leon Katsnelson.
I recognize every name listed above. I think just about each of them has at one time or another earned Best Speaker awards. I don’t think people will be nodding off in any of these sessions!
Jeff Jonas is this year’s keynote speaker. His topic: “Sensemaking on Streams and What Makes Smart Systems Smart!”. Jeff is one of the most interesting people who I’ve had the pleasure of meeting in the past few years. He has much energy, enthusiasm and charisma all on top of his very high intelligence! IBM bought the company that Jeff founded that helped casinos reduce fraud and Jeff decided to stay with IBM. He travels the world talking to people including many very influential people. You’ll be very energized after hearing Jeff speak and believe me, you’ll be searching the web to find out more about this fascinating person!
There are three spotlight sessions led by Jeff Josten, Berni Schiefer, and Curt Cotner. Spotlight sessions are highlights of key technologies that will be discussed in depth throughout the week.
- Jeff Josten - DB2 10 Technical Overview
- Berni Schiefer – Saving Your Company Money with DB2 LUW
- Curt Cotner – Application Development
As usual, there are also free certification exams. This is how I first got to know IDUG, when I ran the certification program. This year each attendee is allowed to take 3 exams for free. That is a $600 value! Make sure you study before you go to get the best value. See an older blog entry I wrote for some Guidance: Certification 101. For the exams that are available, see this website.
The Vendor Exhibit has more than 20 vendors that you can explore. A fun event IDUG is doing to help you meet the vendors is the “Passport to Prizes”. You need to visit certain vendors to get a stamp on your card. The completed card is your ticket to a draw where you could win some cool prizes. Believe me, the prizes are much better than the free stuff you may pick up! One year a friend of mine won a Wii! I don’t know what the prizes are this year, but it is fun to get the stamps and even more fun to win. Good luck!
Vendor Solution Presentations (VSPs) are where vendors can showcase their suite of products. Don’t think of VSPs as marketing pitches… but rather in depth talks about the solutions being offered by the vendor. I see 16 sessions listed on the website!
Special Interest Groups (SIGs) are user community meetings where you can take part in discussions about successes, tips, and more with other users and subject matter experts. There are 10 SIGs scheduled. See the website.
Besides what was mentioned already, there are four networking events set up:
- Exhibit Hall Welcome. This year the sponsor is DBI.
- Networking Event
Dine Around sessions where you can have dinner with popular speakers at an interesting local restaurant You pay for your own meal. Know that this has become a very popluar event, so you should sign up as soon as you can. Dine Around – look for the signup sheet immediately so you can get with your favourite speaker or restaurant OR signup on the web at this page. The spots get filled really fast!
- Bubba Gump Shrimp:
- Group 1: Terry Purcell and Daniel Luksetich
- Group 2: Burt Vialpando and Rebecca Bond
- California Pizza Kitchen:
- Group 1: Judy Ruby Brown and Phil Grainger
- Group 2: Chris Eaton and Scott Hayes
- P.F. Chang’s:
- Group 1: Bonnie Baker and Sheryl Larsen
- Group 2: Roger Miller and John Campbell
- Roy’s Hawaiian:
- David Beulke and Craig Mullins
There are a few offers that you should be aware of.
IDUG Mentor Program
If you’ve attended 3 or more conferences, you can sign up as a mentor and bring a new attendee at an 80% discount.
DB2Night show special offer $50 off conference fee for show attendees. Listen to the replay of today’s show to get the details on how to get a discount.
Moderators are needed, so if you are interested in volunteering, your efforts will be very appreciated.
See some of my previous posts about IDUG, most notably the two guest entries by Rebecca Bond:
Rebecca Bond: IDUG NA – The Geeky Vacation!
Budgeting for IDUG North America conference as viewed by the DB2 Locksmith
IDUG = International DB2 User Group
I think tomorrow I’ll have a guest blog by a DB2 for z/OS DBA to help you choose appropriate sessions.
There won’t be a bookstore on site at this event. Instead, order the books you need directly from the publisher at a discount. Members of IDUG get 45% off IBM Press books.
I’m trying to work out a special deal with MC Press on their collection of Certification Guides as well. We’ll be launching two new titles at the conference, so watch here for details.
Drum roll, please!!
The winner is: Norberto!
#4 = JB (7.3% of the vote). Shocking!! But considering the competition, #4 is outstanding. We’ll all remember her amazing presentations and value the knowledge we learned from her.
#3 = Momi (16.7% of the vote). Momi will be back in the fall with his great topics.
#2 = Thiru (31.1% of the vote). Thiru had to be saved a few times, but his topics were technical and thorough, and clearly pleased the audience.
#1 = Norberto (46.8% of the vote). Not surprised. He has a lot of knowledge, enthusiasm, and charisma. Very well done! I would very much like to see Norberto presenting at future conferences. He would like to attend the IDUG Anaheim Conference, but he may not have his Visa in time, and may have to choose Melbourne or Prague as backups. What a difficult choice that would be.
Comments from listeners was amazing… 1231 votes: 97.6 % indicated that they learned something that would help them in their job!
Congratulations to all of the contestants who took part in this 8-week series! Through the course of this very entertaining and educational experience, I can say will full confidence that we ALL learned something. Personally, as a judge for the competition, I learned how to critically watch each presentation and to make comments on it. This isn’t nearly as easy as you think it is! I also learned that there are amazingly talented people working on DB2 and a show like this can dramatically improve the presentation skills through practice.
I’ve known Scott Hayes, Martin Hubel, and Klaas Brant for some time now, but working with them on this show only improved my already high view of these people. This is true also for Cristian Molaro, although I only met him about 6 months ago. With all sincerity, I would highly recommend each of these gentlemen for there skills and knowledge. IBM is lucky to have such partners to work with.
And now for the contestants… Some of them created and presented 5 times. And this isn’t simply polishing up the same presentation and presenting it 5 times, this was creating a NEW presentation each time! Sure, they were only to be 5 minutes in length, but still very hard to do. I could see improvements being made by all presenters based on the judge’s comments.
Here are some of the amazing presentations that were delivered. I highly recommend that you watch the replays to get this education.
- DB2 Concurrent I/O - Best Practices
- A Terabyte of Data and Trouble with I/O
- Using HADR to migrate data
- Pressure Makes Diamonds (and Practice makes Perfect)
- A Different Approach to Table Partitioning
- DB2 z/OS report utility
- Managing z/OS DB2 REORGS
- "DATA" and the db2cat command
- Influencing the Optimizer for Success
- Explain from Actuals
- Green Eggs and Ham and the DB2 LOAD Utility
- Using SQL to Write SQL
- Using Sequences
- Fixing a Run Away Job and changing Developer's Mindsets
- High Speed Text Search
- Searching for the "Needle" in a CLOB "Haystack"
- SQL Tuning
Next Friday DB2Night Show returns to regular programming. See the full schedule.
April 15: DB2 LUW Workload Manager Hints, Tips, & How-to's from the IBM Developer
April 21: DB2 LUW vs Oracle Usability Study Part 1
April 25 Kickoff - The History of DB2 for z/OS
April 28: DB2 LUW vs Oracle Usability Study Part 2
Another DB2’s Got Talent Competition is planned for the Fall. I would love to be asked to be a judge again!
Here are my related blog entries:
Tips for DBAs from Guest Blogger Norberto.... DB2's Got Talent contestant
DB2, DB2Night Show and IDUG as viewed by JB
DB2’s Got Talent Finale
DB2's Got Talent - 3rd Episode of the Finals
DB2's Got Talent - March 11 Episode
Fourth Episode of "DB2 has Talent"
Third Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
First Episode of “DB2 has Talent”
My post yesterday featuring guest blogger Rebecca Bond was such a hit, that I thought I’d try again. My plan is to post something from each of the final contestants who took part in the DB2Night Show’s “DB2’s Got Talent” Competition. I’ve introduced you to the contestants in a series of blog entries, so I hope you feel like you “know” these people by now.
I would like to say a few words (I have a lot to say!, but I will try to keep it short) about the DB2 Night Show’s world wide db2 talent contest which concluded last Friday after several successful weeks and with many, many great DB2 tips and lots of useful information.
First, I would like to talk about my experience as a participant in this contest. This was my first time participating in such an event and it was such a positive experience for me. Apart from learning so many brilliant new ideas and creative ways of using DB2, this show has done so much to improve my personal skills in effective communication and has shown me how much more I can improve in that area just by listening to the other contestants.
I have listened to all the contestants from the beginning of the show and I am planning to do so again because some of the ideas were such brain teasers that I cannot resist going back to it. For example Ahmad’s tips on the high speed text search is going to be very useful to me and I am sure to everyone else working with XML data.
And I am going to miss Mary’s presentations, she has a unique style of presenting and I hope I can learn to be so creative in my future presentations. Norberto has a lot of expertise in visual communication skills apart from all his great technical tips and so on. I can keep going on all the contestants, everyone had something that I could learn from and I am sure all the audience feel that way too!
I want to thank the host of this event Scott Hayes and IDUG for a very unique experience! I think this was an innovative idea of conducting a contest through a webinar which I can predict is going to get very popular among all the technical communities!!
Thank you to all the judges Susan, Martin, Klaas and Cristian for their wonderful critique, it kept me motivated throughout this contest!
I still have a lot to talk about but I promised to keep it short , so I will stop here!
Susan, Thank you for letting me share my experience on this great show!
Have a great day everyone and don’t forget to register for the April 8th DB2Night Show event!
Hope to see everyone there!
She didn’t suggest that you watch the replays and vote, so I’ll do that! You’ll really enjoy the presentations and the tips you’ll learn. And as JB says, you can learn from the presenters to fine tune your presentation and teaching skills.
I've asked my good friend (and Information Champion) Rebecca Bond
to write a guest blog entry for me. She chose to write it about the upcoming IDUG conference
that is taking place May 2-5, 2011 in Anaheim California. As you will see, Rebecca is a gifted writer and I'm hoping she'll write another blog for me that talks about the sessions that she recommends.
Each year, in January, I look at my budget and try to determine if I can afford to go to IDUG. It occurred to me today that I am approaching this in the wrong way. The question I really should ask is “can I afford to NOT go to IDUG this year?” It paints the analysis in an entirely different way, doesn’t it?
Here’s why I think the IDUG value is … well … almost invaluable.
1. IDUG is an opportunity to learn from those who are “doing”. It’s not a sales convention. It’s not a marketing blitz. It’s just DB2 DBAs from all over the world doing what they do best….talking, presenting and learning about DB2.
2. The experience level of many of those attending is 20 years or more in their field. These DBAs have a LOT of practical DB2 knowledge and they are more than willing to share.
3. Since the sessions are related to 99% of my daily responsibilities, I am 100% sure I am going to learn tips, tricks and gotchas that will help keep me employed and employable.
4. The contacts I make are worth the conference cost. I can’t tell you how many times I have come back from IDUG with contact information for a new friend who was willing to share information long after IDUG was over. Ever had a puzzling DB2 question, but didn’t want to open a support ticket? These are the people who have the answers and I have never found a single one who wasn’t willing to help.
5. Free Certification Testing! Need I say more?
Ok, those were easy. Now let’s think about the cost of NOT going. That’s easy too.
1. I need knowledge to do my job effectively. I can’t go to training as often as I like, but at IDUG, I can get a LOT of information on a variety of relevant DB2 topics that will help me stay informed. It’s like multiple weeks of training rolled into one. That’s a cost advantage I cannot afford to miss!
2. Learning how other folks do things is going to give me solutions to make my tasks easier and potentially avoid errors. If I don’t attend IDUG, I’m missing out on these “lessons learned” opportunities.
3. I wouldn’t get access to those awesome presentation handouts that I am continually referring to. I save all my conference downloads, index them, and refer to them whenever I need to brush up on a skill. Not getting those would be a huge loss.
4. I wouldn’t find it as easy to stay “cutting edge”. We all know that technology is driven by innovation. Without access to “current”, how can I expect to think “future”?
I could go on, but these are the highlights. When I do the math, the cost of NOT going to IDUG North America is much greater than the conference cost! Hope I’ll see you at IDUG!
Here's some information about Rebecca that I'd like to share with you:
We’ve all heard the expression that practice makes perfect. I can prove that this is the case. Watch the seven episodes that we’ve done so far on the DB2’s Got Talent Competition on the DB2Night Show and you’ll see how each presenter and presentations gets better & better. You know what this show is actually doing? This competition is grooming many people to become future speakers at conferences such as IOD and IDUG.
The theme for today’s show was Personal DB2 Success Stories. Seven people presented. Let me tell you briefly about each:
Norberto – A Handmade ETL Solution
ETL = Extracting, Transforming, Loading. Like the pro he is now, Norberto laid out the problem, the need, and a creative solution using triggers, procedures and functions. Very well done.
Momi – Old School Table Partitioning
Momi used a fair amount of humour in today’s presentation and it worked very well. He clearly described the problem of having a table that continued to have more data coming in. Restrictions included a need to keep the table size constant and no time for maintenance. Momi gave us a few possible solutions and advantages of each.
JB – A Terabyte of Data & Trouble with I/O
This sounds like it could be a very common problem. JB showed us how she used the DB2 V9.7 rebalance feature to improve performance and contention by 90%.
Mary – Using SQL to Write SQL
Mary gave us a very creative way to use scripting. She gave very clear instructions with pointers as to what to watch out for. With a small amount of work, these scripts could be used on the mainframe as well.
Ahmad – Fix Runaway Job & Change Developer’s Mindsets
The SQL examples that Ahmad showed were very complex, but he did a nice job of taking us through the details. The suggestion that DBAs need to work with their developers was a good one.
Thiru – Influencing Optimizer for Success
Although this is a risky thing to do, Thiru did a fine job of taking us through how to create an optimizer profile that can improve performance of a statement that ran 4 hours. He succeed using the DB2CAEM utility (which he said is like a flight simulator) and now the statement takes 4 minutes to run.
Bob – Searching for the Needle in a CLOB Haystack
Last, but not least, Bob showed us how he created a Java application to do string manipulation to improve performance over using the LIKE option. This was a cookbook type of presentation that gave many tips on how to perform the actions.
This episode we had to send two people “home”, unfortunately. And just as it is on American Idol, this gets harder to do each week because the quality of each presentation is amazing and 100% of the audience said they learned something new during this show. The judges, Martin Hubel, Cristian Molaro (sitting in for Klaas Brant this week), and myself were in agreement with the results from the audience poll. We decide to send Thiru to the finals and said good bye & thank you to both Bob and Ahmad.
Now we need your help… now, more than ever. We need you to watch the replays and to decide which presentation you think is best. Vote for the best to decide who will go on and will get a free pass to an IDUG conference of their choice.
Click here to watch the replays.
To vote, use this URL: https://www.surveymonkey.com/s/DB2TalentFinals3
Thanks to Scott Hayes for putting this show together to Entertain and Educate us. Thanks to all the participants for your dedication to DB2 and for sharing your experiences with all of us. All of you are quite talented and should consider presenting to a live audience at a future IDUG event.
Join us next week for the final show of the competition. There will not be a show on April 1. The winner will be announced on the show on April 8.
Are you looking for some good technical books to read in order to enhance your skills? For the month of February, you can purchase a number of amazing books and save money while doing it.
Let me start with the offers from IBM’s publishing partner, IBM Press:
1) If you are a member of IDUG, you can always get 45% off of books published by IBM Press. How? Go to IDUG’s home page and click on the icon on the bottom right corner. This will give you the instructions needed to get your discount. See a previous blog entry for more information on IDUG: IDUG = International DB2 User Group
2) If you’re not a member of IDUG and don’t wish to join, you can take advantage of the following offer: New and Best-Selling Information Management Books at 35% off; http://www.ibmpressbooks.com/promotions/promotion.asp?promo=136211; Enter coupon code INFOMGMT during checkout to receive discount.
What books should you consider?
The latest IBM Press title in the Information Management area is:
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
by Anthony David Giordano
The IBM Press books that published in 2009 and 2010, include:
Art of Enterprise Information Architecture, The: A Systems-Based Approach for Unlocking Business Insight
- By Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, Michael Schroeck
- Apr 1, 2010
The New Era of Business Intelligence
Mike Biere, author of The New Era of Business Intelligence, contributes to the BI tools debate on IT World, offering some evaluation points for ROLAP solutions vs. OLAP.
Enterprise Master Data Management: An SOA Approach to Managing Core Information
- By Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, Dan Wolfson
Viral Data in SOA: An Enterprise Pandemic
- By Neal A. Fishman
- Jul 6, 2009
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server
- By Matthias Nicola, Pav Kumar-Chatterjee
- Aug 10, 2009
Understanding DB2®: Learning Visually with Examples, 2nd Edition
- By Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
- Dec 29, 2007
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition
- By George Baklarz, Paul C. Zikopoulos
- Nov 19, 2007
Understanding DB2 9 Security
- By Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
Next, MC Press, publisher of our ever popular DB2 Certification Series has a new online bookstore and are celebrating with FREE Shipping On Orders of $100 or More*; SAVE Up to 90%; BONUS $5 Savings On All “Scratch & Dent” Titles. Includes DB2 Cert Guides.
DB2 9 for Developers
DB2 9 for Linux, UNIX, and Windows Database Administration (Exam 731)
The IBM Data Governance Unified Process
DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade (Exam 736)
DB2 10 for z/OS
IBM Business Analytics and Cloud Computing
IBM Informix Dynamic Server 11
MDM for Customer Data
SAP DBA Cockpit
Driving Business Optimization with Trusted Information
Business Intelligence Strategy
DB2 9 for z/OS Database Administration (Exam 732)
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration (Exam 734)
DB2 9 System Administration for z/OS (Exam 737)
DB2 9 Fundamentals (Exam 730)
From Idea to Print
And finally, Packt. For the month of February, they are offering 4 eBooks for $75. Packt now has 17 IBM titles listed on site. Some suggestions:
Getting Started with IBM FileNet P8 Content Manager
IBM Lotus Quickr 8.5 for Domino Administration
IBM Rational Team Concert 2 Essentials
IBM WebSphere Application Server v7.0 Security
IBM Lotus Domino : Classic Web Application Development Techniques
IBM Cognos 8 Report Studio Cookbook
IBM Infosphere Replication Server & Data Event Publisher
IBM Lotus Sametime 8 Essentials: A User's Guide
WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7.0
IBM Lotus Notes 8.5 User Guide
For complete details, see Packt’s online bookstore: New IBM Books from Packt
It seems February is a great time to save on technical books. Happy shopping!
Congratulations to Matthias Nicola for being named the best overall speaker from the IDUG EMEA conference that took place last year in Vienna.
Here are the details for the Matthias’ presentation:
E15: The XMLTABLE Function – A Swiss Army Knife for Application Developers
What!? An entire presentation on just one SQL function? Yes! DB2 supports well over 200 functions that can be used in SQL statements, and one of them is XMLTABLE. What makes XMLTABLE different from most other functions are its powerful data transformation capabilities, its versatility, and its diverse set of use cases. Available in DB2 for z/OS and DB2 for Linux, UNIX, and Windows, the XMLTABLE function allows you to read XML data and return relational result sets to your application. Read more.
Matthias Nicola is a senior software engineer at IBM's Silicon Valley Lab, in San Jose, CA, USA. He focuses on all aspects of XML in DB2. Matthias works closely with the DB2 pureXML development team as well as with customers and business partners to help them design, optimize and implement XML solutions. Previously Matthias worked on data warehouse performance at Informix Software.
You can purchase a recording of this session by clicking here and searching for session E15.
Some other details about Matthias that you should know. Not only can he present well, but he wrote a great book too:
You can also keep up with Matthias more regularly through his blog:
Are you attending IDUG this year in Anaheim? It takes place the first week of May and if you’re attending, you can catch two of Matthias’ sessions:
E14 - The XMLTABLE Function – A Swiss Army Knife for Application Developers!
C04: Understanding and Tuning Page Cleaning in DB2
For more information about IDUG, see my blog entry: IDUG = International DB2 User Group
I’ve been seeing many upcoming events for the DB2 for z/OS product and decided to summarize in this post.
IDUG – Anaheim May 2-6. This isn’t an event specifically for DB2 for z/OS, but as usual there are some amazing sessions planned for that platform including:
- DB2 Doctor - Symptoms, Diagnosis and Cures for Poor Performance, Bonnie Baker, Bonnie Baker Corporation
- DB2 10 Application Topics - A Sneak Preview, Suresh Sane, DST Systems Inc.
- Why did the DB2 for z/OS Optimizer choose that Access Path?, Terry Purcell, IBM Corporation
Learn more: IDUG = International DB2 User Group
Upgrading to DB2 9 or DB2 10 for z/OS — How? When? What is the cost versus benefit?
Broadcast Date: February 22, 2010 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. GMT
Developed for: IT directors, managers and project managers; business analysts; enterprise architects; database administrators and managers; and application database administrators
On Oct. 19, 2010, IBM announced DB2® 10. This latest release of DB2 delivers the most aggressive package of CPU savings and performance improvements from IBM in more than 20 years, and for the first time since 2001, IBM has offered skip release. With the increased cost of support software licenses, the launch of DB2 10 and the announcement of DB2 V8 end-of-service, many DB2 users are considering migration and need direction in planning the right migration strategy for their business. But how do you approach a migration strategy? When is the best time to start? Is skipping a release a good strategy? What are the costs versus benefits for any scenario?
Join us for this complimentary webcast as we address the most critical business issues to consider such a migration, so you can develop a strategy and plan for your own migration. We will describe the options available and some of the potential risks versus benefits. Overall, this webcast will help you choose the best path for your situation, and get ready to migrate to the new version. Whether you are ready to migrate now or you are still years away, planning should start now so that you can use your time more effectively and minimize the ultimate cost of upgrading.
All webcast attendees will receive a free copy of “Executive Report of Business Value of DB2 10 - Smarter Database for a Smarter Planet” by Julian Stuhler, an Internationally recognized DB2 consultant and analyst.
In this webcast, we’ll discuss:
- * Defining migration plan details for each component in your environment — servers, clients, applications and routines
- * Incorporating steps from previous migration plans, including internal procedures to request access, software installation or other system services
- * Understanding product restrictions and recommendations in order to plan your migration strategy
Speaker: Roger Miller, DB2 for z/OS® Technical Evangelist, Designer and Architect, IBM Software Group
Why is DB2 for z/OS better than Oracle RAC?
Broadcast Date: January 25, 2011 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. UTC / GMT
Developed for: IT Directors, IT Managers, Enterprise Architects, IT Project Managers, Business Analysts, Database Administrators, Application Database Administrators, Database Managers.
In recent years, IBM DB2 has been under considerable pressure from its competitors, most notably Oracle RAC. These competitors claim to provide the same functionality and quality of service characteristics as DB2. DB2 specialists are often asked by the business decision makers to articulate the technical advantages of DB2 and justify the choice of DB2 as the database server:
- Why is DB2 for z/OS considered the ultimate database server?
- What are the technical differentiators by which it stands out, particularly against Oracle RAC?
- How does Oracle RAC process concurrent transactions as opposed to DB2?
In this webcast, we will offer answers to these questions. In addition, a complimentary whitepaper will be available for download. In the whitepaper IBM will size up the database clustering architecture provided by DB2 for z/OS with the Oracle RAC product. When all is said and done, compared and contrasted, DB2 for z/OS differentiates itself with superior characteristics.
Speaker: Namik Hrle is an IBM Distinguished Engineer and works in the IBM Boeblingen Laboratory. He is a member of the IBM Academy of Technology, Information Management Architecture Board, SWG Architecture Board Steering Committee and many other IBM expert teams. He specializes in information management technology and its usage by the enterprise applications. He works closely with the IBM labs worldwide and helps customers deploy and optimally exploit information management products. He is a regular speaker at conferences across the world.
REGISTER TODAY TO SECURE YOUR SPACE !
DB2 for z/OS Technical Seminars that you can attend in person, for free:
Toronto - Jan 27
Dallas - Feb 8
San Francisco - Feb 10
Washington DC - Feb 15
Atlanta - Feb 17
New York City - March 8
Costa Mesa - March 15
8:40am – Meeting the business analytics and data warehousing needs of your users
9:50am – DB2 for z/OS: Version 10 including migration strategy for DB2 9 or DB2 10
11:00am – Gain insight into DB2 9 and DB2 10 for z/OS performance updates and save costs
1:00pm – What’s new for SQL optimization in DB2 9 and DB2 10 for z/OS
2:10pm – Administering and Optimizing Your DB2 9 & 10 for z/OS Environment
3:20pm – How to streamline your DB2 for z/OS utility processing
Space is limited, so register now.
To stay on top of all the upcoming events, bookmark Surekha’s Blog.
And last but not least…. get your copy of the Flashbook:
DB2 10 for z/OS - Cost Savings ..... Out of the Box
by Roger Miller, David Beulke, Julian Stuhler, Surekha Pureka
Early this morning my blog received its 1 millionth view! What a great way to end the year! Thanks to everyone for viewing my blog. I really enjoy writing my blogs and intend to keep writing in the coming year.
Here are my top 5 blog entries:
Making it Big in Software
Certification: Getting Started Checklist
Trying to get fired?
What’s coming up next year:
I’ll be a judge on the DB2 Night Show in February.
"The DB2Night Show :: DB2'S GOT TALENT CONTEST" on the following dates:
Feb 4, 2011 11:00 AM - 12:30 AM EST
Feb 11, 2011 11:00 AM - 12:30 AM EST
Feb 18, 2011 11:00 AM - 12:30 AM EST
Feb 25, 2011 11:00 AM - 12:30 AM EST
Mar 4, 2011 11:00 AM - 12:30 AM EST
Mar 11, 2011 11:00 AM - 12:30 AM EST
Mar 18, 2011 11:00 AM - 12:30 AM EDT
Mar 25, 2011 11:00 AM - 12:30 AM EDT
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2011 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
- 2nd Prize: Xbox 360 250GB Console with Kinect (approximate value $500) provided by IDUG.
- 3rd Prize: $100 Amazon.com Gift Certificate provided by DBI.
- Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by DBI.
This is my last blog entry of the year. I with everyone a very happy holiday and HAPPY NEW YEAR!!
Have you been taking advantage of the rich content available from IDUG? IDUG is the Worldwide DB2 User Community and if you don’t yet know about them, but work with DB2, you should take a look at what they offer:
1) A very rich website filled with resources that you can access to deepen your skills. Resources include CDs filled with conference presentations, webcasts, videos, blogs, articles, Solutions Journal e-Magazine and more.
2) Three full conferences each year: one in North American, one in Europe, and one in Asia. In 2011, the conferences will be:
IDUG North America 2011, May 2-6, 2011, Anaheim, California, USA
EMEA - 14-18 November 2011 in Prague, Czech Republic
ASIA – To be announced.
3) Regional symposiums and events throughout the year and the world.
4) If your educational budget is limited, please remember IDUG's Mentor Program where you may qualify for a special low rate if you bring a first time attendee to an IDUG conference.
5) Volunteer opportunities. You can speak, teach, organize, plan, or get into leadership positions. More about this:
IDUG is a volunteer run organization. In order to appropriately recognize excellent work from our many IDUG volunteers, the Volunteer Management Committee of the Board of Directors is now accepting nominations for IDUG Volunteer of the Year. If you have seen exceptional effort, exemplary work, or outstanding performance from an IDUG Volunteer, please send the specifics to email@example.com.
Have you ever thought of serving on the IDUG Board of Directors? Do you know someone who might?
The IDUG Board of Directors is responsible for setting the overall strategy for our organization, and coordinating the activities of our various volunteer teams around the world. We are beginning the process of putting together the 2011/2012 slate, and would like to invite nominations for a role on next year’s Board of Directors. This is a great opportunity to help shape the organization and grow the worldwide DB2 community.
If you have a clear vision for IDUG’s future, can think strategically as well as tactically and are passionate about IDUG’s mission, we want to hear from you! If you know of someone else who fits these criteria and would like to nominate them, that’s fine too!
Please complete the form by clicking here and return it to firstname.lastname@example.org no later than Monday, 27 December 2010.
Join IDUG for free and get connected to a fabulous community of people who will quickly and easily become a second family to you.
If you're interested in social networking, take a look at this survey request from IDUG:
IDUG is looking to improve its social networking sites in order to better meet the needs of the DB2 community. To capture a true picture of how we're doing, we need your feedback! The survey will take no more than five minutes of your time and will provide us invaluable insight into your social networking needs.
Take the IDUG Social Networking Survey
We appreciate your feedback!
The IDUG Social Networking Committee
IOD EMEA which took place in Rome last week was a huge success. I'm working on my trip report and will post some of it here.
Monday and Tuesday next week, I'll be at the Toronto conference CCDB2UG where the Central Canada DB2 Users Group is celebrating their 25th anniversary! I'm quite looking forward to my annual visit with some of the most amazing people I've ever met. For more information, see this blog entry I did recently: Local Conference - Central Canada User Group.
I've already began planning for our huge IOD event that will take place in Vegas the last week of October. I'm looking forward to see the sessions and speakers who have been chosen for the event. The bookstore is arranged already, so just the signings are left to plan. I'm hoping this year that we have the book signing events included in the agenda builder so you won't miss what the signings that you want to attend. More on this conference coming up.
I've talked to a few people about the IDUG conference that is taking place in Vienna the second week of November. I'm not sure what my involvement will be at this point, but it would be a nice one to attend, don't you think?
There are many free webinars that are coming up soon... I hope you are able to take advantage of the amazing content that is available to you for free! I know time is always a factor, but most of the webinars are recorded so you can benefit from the content after the fact.
My favourite ones are:
1) DB2Night Show
- tomorrow is Sam Lightstone
, and there are several more speakers planned for the coming weeks.
2) Chat with the Lab - there was an event today, but you can keep on top of the scheduled and recorded events by joining this group: Channel DB2 Chat with the Lab
3) Surekha Parekh
does a fine job of informing the world of the events surrounding DB2 for z/OS. I strongly suggest that you join one of the groups that she posts to in order to stay on top of what's happening. The World of DB2 for z/OS
is one of the places she updates regularly.
Check out this amazing contents that is sponsored by IDUG:
Tell us your best DB2 stories and win big prizes – yes, it’s as simple as that. In your own words, tell us your experience with DB2, and if our judging panel finds your story interesting you could be taking home a Wifi enabled Vizio HD TV or an Apple iPad.
“Do You DB2?”
is open to anyone in North America – DBA’s, developers, testers, students, professors, or even managers, CIO’s and CEO’s. All we want to hear is your DB2 stories, whether technical or business oriented. (Make sure you check out the official website and rules. )
Speaking of IDUG, have you registered for the annual conference that is taking place in Tampa Florida from May 10 - 14? That's next week, so rush if you haven't yet registered. Check out my previous posts about this conference:
7) If you have registered, you are eligible to take an assessment exam for free. Those who are registered will get an email with the special promo code: http://bit.ly/dftRin
8) As usual, there will also be a bookstore on site. Check out the books that you should be able to purchase while at the conference: http://bit.ly/c2CdMy
So... DO DB2 (and Win)
and LEARN DB2 at IDUG :)
I asked my wonderful friend Rebecca Bond to give me her IDUG Conference
schedule for the Tampa conference during the week of May 10th. I asked Rebecca because she is working as a DBA and has for many years. I figure that her schedule will more closely match the target audience than a schedule I'd put together.
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
The educational seminars
are taking place that on Monday, May 10. Be sure to check out the offerings.
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
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 Paul Zikopoulos, Chris Eaton, George Baklarz, Enzo Ciallini, and others. Three notable books missing from this list are by IBMers who are not attending the conference, but their books will be available:
Monday isn't listed above, as the educational seminars
are taking place that day. Be sure to check out the offerings.
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:TUESDAY
756: Hell’s Kitchen; DB2 9, A DBA’s Recipe for Success , Rob Crane II
360: Crossing Over - A Mainframers Guide to DB2 LUW, Jim Wankowsk
i, 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,
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
782: Table and Index Design Strategies: Looking Forward to DB2 9, Susan M Lawson
784: Mainframe DB2 Data Warehousing 2010, Robert Catteral
l, 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
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
550: Unlocking the Mysteries of the DB2 Log, Paul Turpin
, S1 Corporation
408: Scaling Enterprise Data in the Cloud, Albert Lee
448: Rev up your SQL Applications with Enhanced Statistics!, Jim Dee
288: DB2 9 Package Stability: Migration, System and Daily Database Maintenance, Ulf Heinrich
736: DB2 z/OS – Hands free approach to maintenance of multi terabyte
tables, Billy Sundarraja
n, Fifth Third Bank
402: DB2 LUW Index Design and Best Practices, Scott Hayes
347: Java DB2 Developer Performance Best Practices, David Beulke
Beulke & Associates
345: Exploiting DB2 9.7 Monitoring and WLM Functionality, Philip Nelson
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
312: Do you really want NOT to LOG ?, Steen Rasmussen
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
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
624: Best Solution in DB2 for z/OS , Frank Petersen
566: DB2 Compression and performance impact, Robert Donaldson
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 SoftwareFRIDAY
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
EU2009 Best Speaker: 623: How to Cope with Soap? WebServices on DB2 for z/OS, Frank Petersen
565: High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7, Robert Donaldson
618: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks, Alexander Kopac
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
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
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!
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.
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.
Learn plenty, but have fun by meeting people and getting involved!
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
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!
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
* InfoSphere MDM Server for PIM
* InfoSphere Traceability Server
* InfoSphere Dynamic Warehouse
* InfoSphere Streams
* InfoSphere Dynamic Warehouse
* InfoSphere Foundation Tools
* InfoSphere Information 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
DB2 9 DBA for Linux, UNIX, and Windows Exam 731
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 for z/OS Database Administration Exam 732
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
IDUG's pre-conference educational seminars provide in-depth DB2 education that both enhances your professional development and offers the information you need to better achieve significant business results. Pre-conference educational seminars are available to both conference and non-conference attendees, so don’t miss out on this great opportunity of fantastic one-day education.
Register today for one of the nine educational seminars before it’s too late. Registration is based on a first-come, first-served basis.
|Conference Attendee Seminar Fee:||$425|
|Non-Conference Attendee Seminar Fee:||$475|
The 2010 Pre-Conference Educational Seminars are:
- Z01: DB2 9 for z/OS Cert Exam, Susan Lawson
- Z02: Save CPU Costs by Tuning your SQL, Bonnie Baker
- Z03: SQL: What To Use When You Can and Cannot Touch It, Sheryl Larsen
- 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 (IBM)
- Z06: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes (DBI)
- Z07: DB2 9 for z/OS In-depth, Phil Grainger (Independent Consultant)
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.
Objective 1: Provide the student with an overview of the DB2 Certification Exam testing program.
Objective 2: Introduce the student to basic DB2 9.7 Database Administration fundamentals.
Objective 3: Provide the student with information on new features and functionality that were introduced with DB2 9.7.
Objective 4: Provide the student with the information needed to correctly answer questions they are likely to see on the DB2 9.7 for Linux, UNIX and Windows Database Administration Certification Exam (Exam 541).
Objective 5: Provide the student with an overview of the certification testing software.
Z01: DB2 9 for z/OS DBA Certification Crammer Course
Date: May 10, 2010 09:00 AM – 04:30 PM
This is a high-level certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 9 for z/OS Database Administration exam (732). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 V9 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 z/OS V8 and basic knowledge of V9 features. This will be a lecture-only class with no labs.
This session offers an intense, overall review of those areas that will be on the certification exams (both the 730 – DB2 9 Family Fundamentals and the 732 – DB2 9 for z/OS), providing a comprehensive review for those planning on taking the certification exams to become an IBM Certified Solutions Expert - DB2 9 for z/OS Database Administration.
Objective 1: Present information to help students pass the 730 and 732 exams to become a DB2 9 for z/OS Certified DBA.
Objective 2: Relevant Database Administration Topics
Objective 3: Relevant Application Programming Topics
Objective 4: Relevant System Administration Topics
Objective 5: Relevant SQL Topics
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
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.
- Unique and comprehensive coverage of pureXML on all supported
platforms: DB2 9.x for Linux, UNIX, and Windows and DB2 9 for z/OS.
- Written for database administrators and application developers, beginners and advanced DB2 users.
- More than 700 "recipe-style" examples of XML queries, updates,
schemas, indexes, storage objects, application code, and database
- DB2 pureXML best practices, tips, and tricks based on the author's extensive hands-on experience in pureXML deployments.
- Coverage of brand-new XML features that IBM intends to make available in the current release of DB2 (http://www.ibm.com/software/data/db2/technology-sandbox/)
Save 35% when you purchase this book!!
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... DB2 9.7: Get the Inside ScoopWednesday, June 2412:00pm Eastern
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
2. lowering management costs
3. enhancing workload management
4. compatibility with Oracle Database SQL, PL/SQL, data types, scripting and more
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.
IDUG membership and these benefits can be accessed with free membership sign-up on www.IDUG.org.
Register now and plan to attend!
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.
To see the topics that these and other speakers are scheduled for, see the Agenda for IDUG
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.
- DB2 Chat with the Labs session featuring a panel of DB2 experts who will discuss cloud computing. Listen live on March 25, 2009 10:00 am PDT/1:30 pm EDT.
Cloud Computing and Virtualization have been named the top 2 strategic technology trends for 2009 by various analysts. With the current climate of tight IT budgets and restraints on capital expenditure, Clouds can come to the rescue with pay-as-you-use models for compute, storage and software resources, and offer flexibility to scale-on-demand. You can now lower the costs of your database solutions by taking advantage of Cloud computing with DB2.
A replay of this and prior DB2 Chat with the Labs are available for approximately one year.
- Safari Books Online is holding an exclusive webcast with Thomas Erl during which he will discuss some of the most important SOA design patterns in use today. Register today for the event that takes place Thursday, March 26 10:30 am PDT/1:30 pm EDT.
Don’t miss this opportunity to hear Thomas Erl, author of the newly published SOA Design Patterns, a catalog of 85 design patterns for service-oriented architecture and service-orientation. In development for over three years, the catalog has been subjected to comprehensive reviews by hundreds of industry professionals and is in use by many of the world’s leading technology companies.
Erl will reference design principles and technologies covered by his previous two titles, SOA Principles of Service Design and Web Service Contract Design & Versioning for SOA and will further highlight some of the recent contributions to the SOAPatterns.org community site.
- Register before March 27 to qualify for the early bird discount for the IDUG 2009 NA conference taking place in Denver Colorado from Tuesday May 12 until Friday, May 15.
The IDUG 2009 North America conference features 120 hours of peer-reviewed technical presentations, written and delivered by the most sought-after DB2 experts in the world: DB2 Gold Consultants, vendor experts, IBM Distinguished Engineers, IBM Fellows, IBM Vice Presidents, and a keynote by General Manager Ambuj Goyal.
During IDUG 2009 NA, IBM is waiving their $200 certification test fee for conference attendees. There is no limit on the number of free certification tests attendees can take (or re-take, if they do not pass on their initial attempt). IBM will offer 40 different certification tests during the conference, covering DB2, Cognos, InfoSphere, content management, and U2. During a down economy, re-certification can be an effective way for database professionals to lock in their skills and value.
- The Assess and Save Offer expires on April 30, 2009. With this offer, candidates who purchase, take and PASS an Information Management Online Assessment Exam during the offering period, will automatically receive a 50% off certification voucher good for the corresponding exam. That's $100 USD right back in your pocket!
IBM offers these online assessment exams for each Information Management Professional Certification. These "practice tests" enable you to test your readiness for a minimal fee, helping you to be successful on exam day.
- Register now for the IBM Information on Demand, Berlin Germany taking place June 2 - 5, 2009.
The IBM IOD EMEA Conference is the premier Information Management conference in Europe, Middle East & Africa (EMEA). It is the annual forum for leading organizations across the region - including our key Customers and Business Partners, Press, Analysts and employees to come together to explore the latest in Information On Demand and to share their experiences and expertise with others in this ever-growing community.
If you only attend one Conference this year, here are just some of the reasons why the IBM Information On Demand EMEA Conference 2009 is the one to attend!
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.