Great articles by amazing contributors. Make sure you read every article in the latest edition of the DM Magazine. I’ve read the article about Roger Sander’s contribution to the DB2 Certification Exam Development team and the announcement of his latest certification guide, which is a supplement. I’ve bookmarked many of the other articles so I can read them over the coming week. I hope you find something interesting and useful in this edition!
Taming Big Data - The realm of huge information flows is governed by new rules. What changes in the multi-petabyte, microsecond response, multimedia world? And how will Big Data change your job?
by Lisa Stapleton
It’s not just huge volumes. It’s not just microsecond response times, it’s not just incredible variety. It’s all three. Dealing with “nice” data, stored in well-defined data warehouse structures and handled sometimes months or years after it is first collected, is an increasingly smaller part of the job of data management. Here’s how folks are learning to handle the rest of it—the unstructured data, and the data that constantly changes as customers take actions and applications process input.
Tuning SQL at the Senate: E Pluribus Unum - When the SQL flow in the United States Senate went from static to dynamic, the database team had to see many queries, but tune them as one.
by Ives Brant
“High-performance government” may sound like an oxymoron, but for the teams that monitor and tune databases for the U.S. Senate, high performance is absolutely necessary to handle the huge number of queries that hit the Senate’s financial management system. InfoSphere Optim Query Workload Tuner software running on IBM DB2 z/OS helps the U.S. Senate DBAs and software specialists reduce query response time from 20 to 30 seconds to less than 2 seconds when they generate new statistics for a workload of SQL queries.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
Get Your Head in the Clouds - Data Pros are adopting cloud computing concepts to offer databases as a service - easing management burdens and sending users to cloud nine.
by Jin Zhang
Tactics and strategies for moving away from traditional provisioning models in which DBAs function solely in reactive mode—responding to user requests in nonstop “database, clone, database, clone” activities—towards a database-as-a-service, or DBaaS (pronounced as “D-Baa-S”), model employing cloud computing practices.
To offer DBaaS on the cloud, enterprise IT departments must undergo a process of constructing and managing a private enterprise “data cloud”—a platform consisting of storage hardware, virtual images, database schemas and more—and making that cloud available to users through a services interface.
Smarter is… Making Watson Smarter…Faster
by Howard Baldwin
A deeper look at the Jeopardy-winning system and the technology that enables it to process information in near real-time.
IBM Information Governance Council - Information Governance Community growing worldwide - IGC draws 1500 members, solicits best practices ideas
by the Magazine Team
The wisdom of crowds isn't an oxymoron. Large groups have an uncanny ability to get the right answer - just see James Surowiecki's book on the subject for proof. So it's not unreasonable to say that the Information Governance Council (IGC) is getting smarter with each passing month.
Data Architect - Securing DB2 Data - Grant privileges to a what, not a who
by Robert Catterall
These days executives are more concerned than ever about unauthorized access to data entrusted to their organization. Their fears are justified: a recent study showed that a third of those polled would quit doing business with a company they perceived to be guilty of a data security breach.
Distributed DBA - Using the DB2 Problem Determination Tool
by Roger E. Sanders
Sooner or later, every DBA encounters problems. Consequently, a skill that every DBA must possess is the ability to perform a logical, systematic search of a database system for the source of any problems that might arise. The DB2 Problem Determination Tool can help.
Programmers Only - New Order by Information: Part 2. The Impact of using the RANDOM index option on ORDER BY sort avoidance
by Bonnie Baker
In the last issue, Bonnie Baker began a series of columns concerning new aspects of ORDER BY. This column - Part 2 - covers the impact of using the CREATE / ALTER INDEX RANDOM order option on sort avoidance.
Performance tuning on Informix - Fastest Informix DBA Contest III - Performance tuning an OLTP system
by Lester Knutsen
Performance tuning is a continuous process for every DBA. Advanced DataTools Corporation conducted three fastest Informix DBA contests to highlight and learn what goes on in this process.
Imagine What You Could Do - Free your mind, and your business will follow
by David Buelke
Big Data, Big Time - Series data, warehouse acceleration, and 4GLs
by Stuart Litel
In a year the support for DB2 for z/OS Version 8 will end. April 30, 2012 to be precise. Are you ready to upgrade to DB2 9 or 10? There is lots of help for you to make sure you are ready and to help you protect your mission critical data without little or no downtime.
This is the first time in the history of DB2 for z/OS where you can skip a level and upgrade directly to DB2 10 from Version 8.
There are many reasons to upgrade to DB2 10 beyond the fact that support is ending. One of the main reasons is cost savings. Beta Customers for DB2 10 have seen dramatic reduction in CPU usage (5-10% for traditional workloads and 20% for some specific workloads). New features in DB2 10 will save you time, money and increase productivity:
- Bi temporal support
- Simplified compliance
- Security enhancements
- Online schema enhancements
Listen to John Campbell, IBM Distinguished Engineer who will share first hand customer experiences to help you plan an upgrade strategy to DB2 10.
May 17, 11:00 am EDT: DB2 10 for z/OS Migration Planning and Early Experiences
This is a complimentary webcast that will share early experiences and lessons learned with DB2 10 for z/OS. The objective of this webcast is to provide hints and tips that will help you prepare for and execute your migration, while preventing pitfalls and addressing some myths you may have heard. John will also share valuable planning information and usage guidelines and share IBM positioning on new enhancements.
In this webcast, we’ll cover these topics and more:
- Performance expectations and opportunities
- Virtual storage constraint relief
- Some instrumentation changes
- Use of 1MB real storage frame size
- Use of hash access
- The value of rebind
After the webcast there will be a live question-and-answer session with speaker John Campbell. John is one of IBM’s foremost authorities for implementing high-end database, transaction-processing applications. Over the past 12 months he has been working closely with DB2 10 Beta customers. This webcast offers a unique opportunity to learn from one of the leaders in this industry.
Other resources available to help you decide & then migrate:
DB2Night Show: DB2 V10 Migration Planning and Early User Experiences
Monday, 06-JUN-2011, 11am DT, 60 minutes
In this episode, host Klaas Brant and guest John Campbell will introduce and discuss early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hints on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc. Key topics covered will include:
1. Lessons learned,
2. Surprises and pitfalls;
3. Provide hints and tips;
4. Address some myths;
5. Provide additional planning information;
6. Provide usage guidelines
7. Provide positioning on new enhancements
by Roger Miller, David Beulke, Julian Stuhler, Surekha Pureka
This page includes links to
- DB2 10 for z/OS Business Value Whitepaper
- Discover Savings Right out of the Box Demo
- Learn How To Reduce Costs and Improve Performance Whitepaper
- DB2 10 Demo
- Why is DB2 for z/OS Better than Oracle? Whitepaper
- Temporal Data Management Whitepaper
- Hear What our Customers are Saying Whitepaper
- Link to join LinkedIN Group: DB2 10 for z/OS
Thanks again to Kate Kurtz who is guest blogging for me this week as a first time attendee & presenter at IDUG.
Today was my last full day at IDUG. There are still some sessions tomorrow, but I have an early flight, so I won't be able to attend any of them. I really hope I can make it back to IDUG next year - it was an amazing experience and I had a wonderful time. I am already thinking of topics! :-)
First up today was Haider Rizvi's session on "IBM Smart Analytics System - A Technical Update". Haider invited me to cover a section in that presentation as well, and it was great to have another opportunity to present and participate in the customer discussions. I covered the overview section, and then Haider did a deep dive into the architecture and design of the IBM Smart Analytics System. The people in the room loved it, and there were a lot of questions about the system design and how to plan for system growth with multiple generations of an IBM Smart Analytics System.
Later on in the day I attended Albert Grankin's session, "DB2 LUW Operational Performance Troubleshooting - Finding CPU Bottlenecks". Albert's session was very detailed, giving a thorough overview of the tools you can use for performance analysis, as well as really good case study through which he illustrated how to use all the utilities he introduced in the first part of his session. There was also some solid common sense tips:
- Make sure you collect baseline information so you know what "normal" is for your environment.
- Plan a data collection strategy - don't wait until you have a problem.
I also attended Chris Eaton's session, "Workload Optimized Systems: Don't Run a Marathon in High Heels". A great title and a great session! Chris' session was a competitive analysis of Oracle Exadata, the IBM pureScale Application System and the IBM Smart Analytics System. I asked Chris afterwards if he would be willing to give this session again, for our development teams, since I think it would be interesting for them, and also useful to understand the market in which our products compete. (He said yes :-) Chris is in the Speaker Hall of Fame for IDUG, and I paid a lot of attention to how he presented his sessions, as it was a great chance for me pick up some tips from an expert speaker.
One of the best parts of the day was the number of customers that stopped me to ask a question in the hall, at lunch or in the expo. I really enjoy getting to meet new people, and having a chance to talk about data warehouse, best practices, DB2, IBM Smart Analytics System ... Well, it was just a lot of fun. The ideas were all interesting, and there were a lot of people here who had passion for their work and that led to some great conversations.
After all of that, I finished the day participating in a Special Interest Group: IBM DW Trends - LUW, z/OS and Netezza. This session was an informal discussion group where customers could come in and ask anything they wanted about data warehousing. There was a panel of experts - Beth Hamel (z/OS), Namik Hrle (z/OS), Haider Rizvi (IBM Smart Analytics System/DB2 LUW), Michael C Lee (Netezza) - and then the not-so-expert me :-), all there to discuss whatever came up. There were a lot of questions about the Smart Analytics Optimizer for z/OS, as well as Netezza.
It really was a privilege to be able to attend IDUG and have the core concepts of pureScale, IBM Smart Analytics System, DB2 LUW and DB2 for z/OS explained by the people who developed the code and designed the systems.
Thanks Kate! I don’t have much to add today… just a couple of things:
- I’ve been getting twitter messages about the lack of a bookstore this year. If you missed the bookstore, make sure you put it on your feedback forms, and maybe I’ll be able to come next year to show you all the books that are available.
- If you are a member of IDUG, you can get 45% off IBM Press books? Find out more: http://ibm.co/fhR46O
- Get Certified for Free at IDUG in the Grand Ballroom A & B. Open 7:30 to 11:00 Friday. New exam 617 (DBA for z/OS) is available.
- For more live coverage of the IDUG conference, see Leon Katsnelson’s blog entries, check out the DBI Live Feed, the IDUG Daily Summary, and of course the best blog aggregotor, http://planetdb2.com/.
Another guest post from Kate Kurtz who is attending IDUG for the first time. I’m really glad that she’s doing this for me as I can’t be there this year.
Phew! The time is flying by and my only regret is that I do not have enough time to attend all the sessions. I also should have brought more comfortable shoes! Today I was lucky enough to get to see Matt Huras (Distinguished Engineer, DB2 Development) speak. He was discussing "The latest from the Lab and Customers on DB2 pureScale".
Matt was able to take a complicated concept and explain it in a simple straightforward way, making it easy to understand. In his session he mapped all the things that you know about how to manage a traditional DB2 LUW environment, to how they are implemented in DB2 pureScale, and the differences. The management concepts are straightforward, and wherever possible processes are automated. The complicated part (which does not affect the user) is the technology behind the scenes that makes it all work. With a simple, straightforward manner and excellent automated build slides, Matt made all the technology easy to understand.
Recently there have been some best practice papers published for DB2 pureScale, so if you want to read more, take a look:
In the afternoon, Kelly Rodger and I ran the session "Best Practices for Your Database Recovery Strategy". It was lively session with lots of questions from the audience. As you can imagine, database recovery planning is something that people are very passionate about. All the concepts that we covered in the session are discussed in detail, in the best practice paper: "Building a Recovery Strategy for an IBM Smart Analytics System Data Warehouse". We also added some additional content about compression which we plan in incorporating in the next update to the paper.
The presentations are amazing and IDUG is excellent networking opportunity. In addition to that, while you are IDUG you can take the DB2 Certification exams for free. What a great opportunity to test what you know!
A note about the certifications at IDUG. Roger Sanders has a new book for DB2 9.7 Certification Exams coming soon. We were hoping it would be done for IDUG, but alas. The latest DB Magazine has an article about Roger & certification that you might want to read.
Susan Lawson and Dan Lutsetich have also updated their DBA Certification for DB2 10. The book will be ready in June, so check back for ordering information.
For more live coverage of the IDUG conference, see Leon Katsnelson’s blog entries, check out the DBI Live Feed, the IDUG Daily Summary, and of course the best blog aggregotor, http://planetdb2.com/.
PS… speaking of Roger Sanders, I’m reviewing the last chapter for his upcoming book “From Idea to Print”. See a blog entry I wrote about part of the book: Campus Visit: How to improve technical writing skills. Anyway, the chapter I’m reading is about the author contract and how to best negotiate the terms so that they are favourable to the author. I am completely blown away by the content and think that this chapter alone will sell the book!
Another entry from Kate Kurtz who is attending & presenting at IDUG for her first time.
Wow! What a day. It has gone by so fast, and yet it felt incredibly slow while it was happening. There is just so much to take in, and so much to learn.
The key note speaker was Jeff Jonas, founder of SRD and now Chief Scientist, Entity Analytics. His topic was "Sensemaking on Steams and What Makes Smart Systems Smart". He is a phenomenal speaker with lots of energy and passion about what he does. It was a great session. He also managed to start and end his keynote speech with a poop joke. You have to admire someone who can do that and also deliver an amazing talk about fascinating technology. If you are interested in learning more, check out his blog here -> http://jeffjonas.typepad.com/. I think that the research he does has just entered on my list "Cool jobs I wish I did at IBM". Don't get me wrong, I love what I do, but I am often amazed by the type of work people do at IBM and the sheer variety of interesting things to learn about.
The first session, Warehouse Best Practices in Action - The IBM Smart Analytics System, went well and there were lots of questions from the audience. I love that , it is much more fun to have a conversation with the audience than it is just talk all by yourself. I also learn a lot from the types of questions people ask. I was co-presenting with Eddie Daghelian, and Haider Rizvi was there as well, so the discussion was lively and very educational for everyone. I did a lot of informal surveys of the audience, and it was interesting, most people could remember the days of DB2 PE (parallel edition), most were taking on-line backups, but very few of them were exploiting the table space level backup and restore functionality. There were a lot of questions and curiosity about Work Load Management, and also about Data Ingest strategies.
I think that is the best part about IDUG - a bunch of people who are really interested in technology, all getting together and just having a conversation. The presentation was really just a jumping off point, as for the rest of the day I had customers coming up to me asking for more information about specific topics in the presentation.
And, on a closing note, I want to say Thank You to Rebecca Bond, Steve Rees, and Calisto Zuzarte, who all made the time to attend the session and were friendly faces I could look for through out the presentation. Thanks Guys - it was hugely helpful to see you there!
I’ve heard Jeff Jonas speak several times and completely agree with Kate that he is phenomenal! During and after Jeff’s keynote, the comments were flying in on twitter about his talk. If you want to keep up with what’s going on, I highly suggest that you open this URL: http://bit.ly/mO4svB.
I copied some of my favourite tweets and posted them on Jeff’s FB wall:
Jeff Jonas opened and closed the keynote with a poop story and in the process told everyone how to make sense of data. Brilliant!
- #IDUGNA opening session....worth the full conference fee by ITSELF ! #DB2
Jeff’s response: I spent 7 hours creating a one of a kind deck for today's 60 minute keynote. Glad someone liked it!
Speaking of Jeff, Kate gave a link to his blog, and I encourage you to read it. Also, here is a recent interview with Jeff along with a very cool video "200 countries in 200 years". http://bit.ly/lVW9ME
Apparently there was a retirement party for Roger Miller last night as well. Another reason I really wish I was able to join my IDUG friends in California this year!
I wish I was in California with my IDUG friends… Kate, Rebecca, Scott, Leon, Eddie, Kermit, and others! Not just for the learning and company, but to get away from this constant spring rain we are getting.
Kate sent me a note today to tell me about her first day at her first IDUG:
Anaheim is beautiful! The weather is sunny, with a clear blue sky and WARM! A big difference from the cold wet rain I left behind in Toronto.
The flight down was great, and it is unbelievable how much work you can get done in 4 hours when you don't have a network connection. I spent most of the flight reviewing presentations and making small updates. Last week, Simon Woodcock kindly reviewed my session and spent some time listening to me practice. He had some really good suggestions, so luckily I was able to spend the flight down making some last minute changes and quietly rehearsing in my head.
I also read the latest draft of the Workload Management Best Practice Paper - which is looking really good. I also made some changes to the Warehouse Recovery Planning session, adding in some of the usability slides that were put together based on the Triton Consulting study that was done. (Thanks Rick Sobesiak!)
Tomorrow To Do List:
- Register for the conference & plan what sessions I want to see
- Meet with Eddie Daghelian for further presentation tuning & practice
- 3:15 - present! (Susan, send me your best wishes, ok? I know I should not admit this, but I am kind of nervous...)
- 4:30 video taping session
I'll let you know how my presentation goes tomorrow :-)
I’m hoping to post again today to tell you about what’s going on with the certification team. I do have some book news to go with that, but more on that later.
For more live coverage of the IDUG conference, see Leon Katsnelson’s blog entries, check out the DBI Live Feed, the IDUG Daily Summary, and of course the best blog aggregotor, http://planetdb2.com/.
Sadly I’m not at IDUG this year. I’ll definitely miss many very special people, the education, the networking, and the dine around event. For those of you who are there, let us know how it is going, and get full use out of your visit!
My good friend Kate Kurtz is attending IDUG this year. It is her first time and she is presenting a session. I’ve asked her to guest blog for me while the conference is going on. This is the first of her entries. I hope you enjoy:
My name is Katherine Kurtz, and it is my first time going to IDUG!
Susan invited me to write some guest blogs, to give the inside scoop on the various sessions at IDUG and what the experience is like. I work with a great team of people developing best practices for the IBM Smart Analytics System and InfoSphere Warehouse Environments, and I am currently a manager for DB2 and IBM Smart Analytics System Information Development.
I really believe that we should educate people - ourselves and our customers - about the best way to use our products, which is how I ended up submitting several sessions to IDUG. (Note to self: Be careful what you ask for! Preparation for IDUG was about 5x more work than I expected). Best Practices are all about taking what is tried and tested in the field, putting it together with the future directions our development team is working on and then working together to make a great product even better.
I love what I do - and it is great to always be learning.
It is the night before I leave and I am currently building my checklist.
- presentations ready? check (well - maybe not quite, I think I still want to tweak a few things)
- packed? check
- American $$ , just in case I get to go shopping... :-) check
What will I be doing while I am at IDUG?
I have two sessions I am co-presenting. Warehouse Best Practices In Action - The IBM Smart Analytics System and also Best Practices for Building a Recovery Strategy for your Data Warehouse. I was also asked to participate in a Special Interest Group panel discussion, focusing on Data Warehousing. I am sure there will be lots of interesting debate - and I hope I can think on my feet! There is also the first timer luncheon on Wednesday - where I get to go as an IDUG first timer and as an IBMer, plus I get food, which is always a good thing.
One of the things I liked the most about IOD last fall (which was also the first time I attended IOD) was the conversations I had with customers I met during different sessions. It was always interesting to hear their point of view, and I think it really changes the way I think about the products that we are developing. I hope IDUG will be the same way - lots of great discussions, and chance to learn a lot from others.
If you are attending IDUG, please be sure to stop by and say hi,
Thanks Kate! Looking forward to hearing more from you.
Others who are at IDUG and are blogging include:
Rebecca Bond: What do your car keys, Nemo and IDUG NA have in common?
There already seems to be a lot of traction for the hash tag #IDUG, so I put together a web page that searches for Twitter updates containing #IDUG. It’s pretty cool: http://bit.ly/kW3MoM or http://www.dbisoftware.com/idugna11.php
This tracks something like the newest/most recent 50 tweets, 8 second continuous updates.
Cristian Molaro: DBBuzz
See my previous entries about the conference. If you are there and would like me to blog about your experiences, let me know :)
Just a bit more about IDUG
Guest blogger: Beth – What IDUG Sessions are recommended in the DB2 for z/OS track?
All about IDUG DB2 Tech Conference - Anaheim
Rebecca Bond: IDUG NA – The Geeky Vacation!
Budgeting for IDUG North America conference as viewed by the DB2 Locksmith
PS… If you see Roger Miller, please give him a big kiss goodbye as he is retiring very soon …
Can you tell that I love IDUG yet? OK, one more post and then maybe you’ll be convinced.
Cristian Molaro, an IBM Best Friend from Belgium (my mom’s home country :) sent me a link to a blog that he did similar to the one I posted from Beth yesterday. Like Beth, he’s listing the sessions that he’d like to go to given his affinity to DB2 for z/OS. Cristian’s blog entry: “A Travel Guide to IDUG DB2 Tech Conference – Anaheim 2011”.
Instead of repeating any of his post, or the other posts, let me tell you a few things that I’ve learned about the IDUG conference thanks to my guest bloggers:
A link to the Conference Event Grid.
A link to the Online Conference Schedule.
Budgeting tip: 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?
Bryan Paulsen and Paul Turpin:
The DineAround event is very popular and spots fill up very fast! See post (All about IDUG DB2 Tech Conference - Anaheim )for a list of restaurants, leaders, and how you can sign up.
The name of the conference has changed to the IDUG DB2 Tech Conference to help people get funding to attend the conference.
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.
She loves IDUG as much as I do and considers it her Geeky Vacation.
The keywords for me for this IDUG are: pureScale, Performance Tuning, XML, Cloud, and, of course, Security.
This time, she’s looking for sessions that will help round out her resume.
When I do the math, the cost of NOT going to IDUG North America is much greater than the conference cost!
I hope you’ve found this set of posts helpful to you. If you are going to IDUG, I hope you have a wonderful and educational week.
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.
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”
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!
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
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 firstname.lastname@example.org.
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 email@example.com 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.