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