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:
Books can be expensive… I know because I’m an avid reader and having go used to using a library! I tend to look for books on sale but also I have switched primarily to ebooks as the price is normally quite a bit lower than the printed book.
Check out the great prices offered by IBM Press for a wide selection of eBooks: There are 58 books in the list! Here are a few that I want to highlight:
Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
- List Price: $47.99
- Your Price: $28.79 (Save 40%)
New Era of Enterprise Business Intelligence, The: Using Analytics to Achieve a Global Competitive Advantage
- List Price: $35.99
- Your Price: $21.59 (Save 40%)
Art of Enterprise Information Architecture, The: A Systems-Based Approach for Unlocking Business Insight
- List Price: $47.99
- Your Price: $28.79 (Save 40%)
Understanding IBM SOA Foundation Suite: Learning Visually with Examples
- List Price: $39.99
- Your Price: $23.99 (Save 40%)
DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server, Adobe Reader
- List Price: $43.99
- Your Price: $26.39 (Save 40%)
Viral Data in SOA: An Enterprise Pandemic, Adobe Reader
- List Price: $31.99
- Your Price: $19.19 (Save 40%)
Enterprise Master Data Management: An SOA Approach to Managing Core Information, Adobe Reader
- List Price: $43.99
- Your Price: $26.39 (Save 40%)
Understanding DB2®: Learning Visually with Examples, Adobe Reader, 2nd Edition
- List Price: $51.99
- Your Price: $31.19 (Save 40%)
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, Adobe Reader, 6th Edition
- List Price: $51.99
- Your Price: $31.19 (Save 40%)
Enter coupon code IBMEBOOKS40 at step 3 of checkout to save 40% off all IBM Press eBooks in your shopping cart.
To help you decide, listen to a podcast featuring an author: Podcast Series, or get the e-Sampler with select chapters for you to read to decide. Still not sure about reading an e-book? Check out my blog, Can you possibly love reading more than you already do?
Another great show. Five more educational and entertaining presentations. What an excellent finale. You have two weeks to watch the replay and to vote for your favourite. Remember that the overall winner gets a free pass to an upcoming IDUG conference! The winner will be revealed on the next DB2Night Show, Friday, April 8.
Let me tell you about the presenters today:
Norberto – From DBA to DBA: Tips to Make your Life Easier
Another great presentation from Norberto, filled with amazing tips that will help any DBA. Luckily for us, Norberto has started to blog about his tips and experiences. I predict that you’ll want to follow his blog: Insights on DB2 LUW database admin, programming and more
Momi – Pressure Makes Diamonds
Momi’s presentation encourages DBAs to practice and prepare for possible problem areas that can cause a DBA to be under enormous pressure. Good advice in terms of preparing for a recovery after a disaster and more. Momi’s wise tips can also be found in a blog: B-Advised DB2 Blog
JB – CIO – Best Practices
Many of us, including me, thought that CIO was Chief Information Officer, but in the context of JB’s presentation it means Concurrent I/O. As usual JB covered the topic very thoroughly and very convincingly. I don’t think that JB has a blog, but don’t worry, I’m hoping to turn her into an author so she can share her talent of explaining complex topics with everyone.
Mary – How the DB2 Load Utility is Like Green Eggs & Ham
Mary is also an amazing presenter and is a pro at making topics very interesting with appropriate comparisons to popular interests. In this case, she encourages people to try something new, like was done in the Dr. Suess book “Green Eggs & Ham”. She encourages you to use named pipes to load data. Mary is a former Oracle user and has discovered the power of DB2 and has become a huge fan. I couldn’t find a blog for Mary… but she’d be good at it!
Thiru - Data
Thiru dug deep and found another command that is not very well known but is very useful. This time he taught us about using DB2cat. I also couldn’t find a blog for Thiru, but I do know that he attended the DB2 Symposium in Dallas earlier this week, so hopefully he’ll be active in local DB2 events in the future.
We judges, Martin Hubel, Klaas Brant, and myself had a very tough time deciding which of the bottom two presenters we were going to keep. There were many conversations going on between the judges. Then Scott did the poll and found that the audience was pretty split as well. In the end we chose Thiru. We really wanted to keep both, but needed to follow the rules. This ends Mary’s amazing run and anyone who saw her presentations over the past couple of months will agree with me that Mary will do very well at anything she chooses to do!
Once again 100% of the audience said that they learned something new that would be helpful in their job! What a big win/win experience this has been: audience is learning & contestants are fine tuning their presentation skills.
Please watch or re-watch the shows from the past 4-8 weeks and vote for one of the last remaining contestants to help us choose the overall winner. My sincere thanks to Scott Hayes for creating this entertaining and educational format for learning and training.
I know several patent holders and Master Inventors who work at IBM: Sam Lightstone, Mike Winer, Cathy McArthur, Joanna Ng, Arthur Ryman, Andrew Trossman, Mark Wilding, Danny Zilio, and Calisto Zuzarte. Did I ever tell you how much I like working at IBM? To be surrounded by so many smart people is incredible.
I read an interesting article today on eweek.com about IBM’s patents: IBM Patent: 100 Years of High-Tech Innovations. They listed 10 important patents and I was surprised by some of what they picked, including Ultraviolet Surgery! From the Centennial films we learned that IBM invented the punch card, UPC codes, airline reservation systems, and much more.
This is IBM’s 100th year in business and as a company, IBM has been earning many patents every year, but recently has surpassed 5000 patents in a single year! IBM inventors received a record 5,896 U.S. patents in 2010—which marked the 18th consecutive year the company topped the list of the world’s most inventive companies.
Even if you’ve watched the two Centennial films already, I encourage you watch them a second or third time. The films are well done, educational and very inspirational. The my blog for links to the films: Some Important / Cool IBM Events in 2011.
How do you keep up to date with the massive amounts of technology when your life is already filled to the max? Have you tried listening to a podcast? The advantages of podcasts is that they’re short, concise and portable. I think these three qualities are critical to making a podcast useful. Using a portable device for this learning content will allow you to listen in your car, on transit, while walking, or doing chores around the house.
Here are a few you might want to check out:
IBM Press Podcast series
Hear directly from an author about their book and the topic of the book. For example:
Technical Tips for Enterprise Business Intelligence by Mike Biere
Top Business Intelligence expert and author Mike Biere provides a blueprint for creating winning BI strategies and infrastructure, and maximizing the value of information throughout the enterprise. Two parts
developerWorks Podcast Series
Scott Laningham, editor of developerWorks podcasts, talks with thought leaders
in many fields, paying extra attention to the computing and software element with each
focus. This feed also features other developer-related podcasts from IBM. For example,
Steven Adler: The path to smarter data governance with collaborative structures
Steven Adler, Program Director for IBM Data Governance Solutions, talks about what companies face in the data governance space and some key elements in a successful program.
There are many other podcasts available. In my research I found it a bit overwhelming! On IBM’s home page, I did a search on podcast and come up 1.5m hits. You can get podcasts on Audible.com, itunes.com, and Books 24x7. So much choice!
I hope you have the desire to give it a try.
Check out this great offer by IBM Press (Pearson Education):
Chapter 4: Enterprise Information Architecture: A Conceptual and Logical View
Data Integration Blueprint and Modeling
Chapter 3: A Design Technique: Data Integration Modeling
Enterprise Master Data Management
Chapter 5: MDM Architecture Patterns
Viral Data in SOA
Chapter 1: Viral Data
The New Era of Enterprise Business Intelligence
Chapter 5: Elements of BI Solutions: The End User Experience
Mining the Talk
Chapter 2: Mining Customer Interactions
If you’ve been wondering about the content of these 6 books, getting this sampler is a great way to preview the content so you can determine whether you want to read the entire book. I have a Kindle and preview all of the books I purchase. You should no longer find yourself purchasing a book only to find out once you get home that it isn’t what you thought it would be.
If you like to “Try before you buy”, also consider the offer for trying education classes before you sign up for them.
You haven’t tried ebooks yet? Go outside your comfort zone with an ebook, you’ll be glad you did!
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.
I’m looking forward to listening to Sam Lightstone’s latest webinar about his best selling book “Making it Big in Software”. This webinar is presented by Safari Books Online and is free.
Date: Wednesday March 16, 2011
Time: 1:00 pm EDT (10:00 am PDT)
Register Now: Safari Books Online
This webcast is perfect for anyone who wants to jumpstart their career in software! Individuals are all too easily confined by the scope of their current position. Gain insight into how to create your own path toward greater success through inspiring advice and real-life stories from author Sam Lightstone. Discover how to:
- Accelerate your career, and promotions, with integrity
- Master the nontechnical skills crucial to your success
- "Work the org" to move up rapidly
- Successfully manage your time, projects and life
- Move up to "medium-shot," " big-shot" and finally "visionary"
The software business is constantly changing, to make it big you need a finger on the pulse of today's realities.
Sam Lightstone is the creator of MakingItBigCareers.com as well as Program Director and Senior Technical Staff Member with IBM’s Software Group, where he works on product strategy and R&D for one of the world’s largest software engineering teams.
Sam is a sought-after public speaker, author, and prolific inventor who still spends a good part of his professional time recruiting and mentoring software engineers.
If you’re a regular reader of my blog, you’ll remember a few other entries I’ve posted in relation to Sam’s book.
Campus visit - how to improve technical writing skills
Wine and Cheese and Sam Lightstone at IOD
Meet author Sam Lightstone “Making it Big in Sofware”
Making it Big .... Live on the DB2Night Show!
Two live sessions coming up with author Sam Lightstone...
Making it Big in Software
Yes, I have heard Sam speak about his book several times, but can tell you that he changes the topic for each talk. His book is so rich with advice that he could do quite a few more sessions before he runs out of topics.
Congratulations on the success of your book Sam!
Besides the massive world events that are taking place and creating history,
there are many other events taking place in the month of March in the
Information Management area that you may wish to know about.
First of all, you likely know that today is Pi Day. OK, now
you know I’m a geek :)
Second, IBM’s Centennial. SVP Robert LeBlanc came and spoke to the employees of the Toronto
Lab this morning. He’s on an executive campus tour to tell people about the
innovation that IBM has been part of in the past 100 years and encouraged us
with his prediction that the next 100 years will also entail incredible
innovation. If you haven’t seen the centennial videos yet, I suggest you do. They are well done
and very motivating.
Next, there are two chats with the lab this month. One for Informix and
another for DB2:
Chat with the Lab: March 31: DB2
and Oracle - An Architectural Comparison
Chat with the Lab, March 17:
"Upgrading to Informix 11.7"
For DB2 for z/OS, there is also a webinar that sounds interesting:
Improve your ROI with DB2 for
z/OS and WebSphere, March 29
There are two final episodes
remaining in the “DB2’s Got Talent” Competition. Last Friday we had the
second of the 4 finalist episodes and there are still 7 contestants. During the
finalist episodes, it is you, the audience, who will “vote” for the winners.
Make sure you watch the replays and cast your vote. The talent and tips we’ve
seen over the past 6 weeks have been incredible.
On a personal note, it is March Break this week, so kids are out of school,
Saint Patty’s Day is this week and I’ll be visiting NYC to celebrate, and I have
a birthday coming. Is it this busy every March??
Have fun :)
I missed last week’s show due to vacation and thank Cristian Molaro for filling in for me. I haven't had a chance to watch the replay yet. If you’re in the same situation, you can find all the replays on the DB2Night Show Blog.
Today we heard from 8 contestants on a variety of topics. If you are thinking of creating a presentation, I highly recommend that you watch what these people do as they are becoming quite expert at showcasing technical information.
Here is a brief description of today’s show:
Mary – db2move
Loved her photos of elephants. Very well organized presentation.
Momi – The Report Utility for DB2 for z/OS
The usability for this function has improved in V10, but the function is still necessary.
Norberto – DB2TOP Tips
Tips for using DB2TOP to find out what’s going on in your database. I was really impressed with how Norberto explained a very complex screen capture. As he was going through each concept, he would highlight the corresponding text on the screen. I highly recommend using this technique during presentations as well as written documents. This is exactly how a complex diagram should be explained.
JB – DB2dart Techniques
JB has a knack for telling a good story. She lead listeners through her presentation via a story of how she was able to reclaim much space & improve performance. If you are looking to improve your presentations or writing in this area, pay close attention to how JB does it. I told her that she’d make an excellent author given this skill.
Raja – DB2Advise Utility
We couldn’t find Raja, so unfortunately had to miss his presentation.
Ahmad – db2look
Ahmad presented his experience in using the db2look command and as a result gave very creative uses for the command. The only thing that could have improved his presentation is with a comparison of using db2look vs the traditional method.
Thiru – db2caem tool for performance analysis
This is a very new command, from V9.7. caem stands for “Capture Activity Event Monitor” and this tool is used to capture activities with details of SQL Statements. I like the way Thiru compared traditional monitoring to using db2caem to monitor.
John – Db2look for z/OS with Federated Tables
Although Ahmad’s presentation was on the same topic, John’s was regarding the DB2 for z/OS version of the tool. I like the way John referred to Ahmad’s presentation where he could. John asked if “IBM was listening” as he had an option he’d like to see added to the command. I was listening, but I’m sure there were others who are more influential than me!
Bob – db2dart techniques
This presentation covered the same topic as JB covered , but from the perspective John’s experience. He wanted to reduce wasted disk space and the size of his backup. He gave the steps he used and marked up his presentation as he spoke to lead people through the data.
Only 8 finalists go to March 18 Finals, so we had to choose between Bob and John as they received the lowest number of votes. I can’t understand why either of these guys were at the bottom as both had very strong presentations this week. The audience asked that we save John, and the judges wanted to as well, but there was a leaning towards Bob…. so Bob it is.
Thanks very much to all contestants. I find this forum to be amazing for the learning and fun experience. I’ve seen some of the comments that were given by voters and see that they agree. I’ll go through the data and blog again. Can’t wait till next week’s show!
Earlier this week I was honoured to be a guest lecturer at York University. A few years ago, I made contact with Professor Franck van Breugel who teaches a master’s level course in computer science. Franck was interested in improving the quality of his student’s writing skills. Franck, like me, understands that being able to write or communicate well are important skills to take into any career.
So for the third year in a row, I met with Franck’s class and presented a slideshow created by Roger Sanders that corresponds with his upcoming book “From Idea to Print”. Roger used the slides as the basis for a full day writing workshop on how to create and publish technical documents. I’ve modified the slides so that I can teach them in a little more than an hour and touch on the basics of how to improve writing skills.
What are the basics?
1. Schedule time to write. If you wait until you’re “in the mood to write”, you’ll never get anything done! Set goals for how much you want to accomplish and move to another section if one is causing you grief. Reward yourself as targets are reached.
2. Have a strong outline before you start to write. I know it sounds cliché, but the more up front planning you do, the easier the writing will be. Even for technical documents, you should “tell a story”. Have a beginning, say a problem that needs to be solved; a middle, the search for a solution; and an end, a strong conclusion.
3. Let some personality show through in the writing. There are some cases where dry, factual writing is required, but where it’s not, let the writing be conversational or slightly casual to be of interest to the reader. Always think of your reader. Even if the writing is just for a school paper, the last thing you want to do is to bore the reader so that the ending is never reached.
4. Diagrams and tables are useful, but ONLY if they are tied tightly with the text. Don’t put them there just for filler because they’ll never be looked at. The best idea is to add reference numbers to the diagrams and have text to lead the reader from one point to the next. If that sounds like too much work, maybe the diagram isn’t really needed.
5. No one’s writing is perfect… every author needs to review and revise their work many times. Most authors get quite tired of reading what they’ve written by the time it is “finished”.
To make revision as easy as possible, I suggest that each time you go through your draft, look for one specific thing at a time. For instance, the first time through, check that you are using the active voice instead of passive. Next, go through and look to make sure headings and lists use parallel wording. Next, look for words that are commonly spelled incorrectly that will not be caught by a spell checker. And so on.
6. For everyone, but especially if you are English-second language, consider reading the text out loud or have the computer read it to you. You may be able to hear problems in the wording easier than you can read them. Also, look at past comments you’ve received on writing assignments. Likely you often make the same errors every time you write, so pay close attention to how your previous errors were corrected, and go through your document to specifically focus on improving these problem areas.
7. For the past month I’ve been acting as a judge on the “DB'2’s Got Talent” competition on the “DB2Night Show”. Much of the advice here about writing also came out on that show in terms of improving the quality of a technical presentation. Even if you don’t fully understand the topic being discussed (as was true for me many times) you’ll be able to see what makes a presentation “good”.
8. There are a lot more details that will help you, so I encourage you to get a copy of Roger’s book when it is published. One last piece of advice. If you’re writing a technical document, your goal is not to make it “beautiful”… your goal is clarity. You want to ensure that anyone who reads what you’ve written understands your technical messages.
After the lecture, I found out that Sam Lightstone had recently visited the campus to give career advice similar to what he wrote in his book “Making it Big in Software”. Apparently he had a massive audience and Prof Franck told me that the students were buzzing with excitement after the talk. Sam is recording a podcast to be featured on Safari Books Online. Once I have the details, I’ll post here.
Don't miss the next chat with the lab featuring Sal Vella and Burt Vialpando as they discuss the architectural differences between DB2 and Oracle.
Date: Thursday, March 31, 2011 (31.3.2010)
Time: 12:30 AM - 2:00 PM Eastern Time (ET)
11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
Many database professionals and DBAs often ask how DB2 and Oracle compare architecturally, that is, how they are different and similar at their core. They also ask what are the equivalent concepts, names, commands etc. in the other database system. This free webinar will answer those questions by covering the following topics in detail:
- Server architecture comparison (e.g. instances and database model, process vs. thread)
- Memory architecture comparison (e.g. Oracle SGA & PGA vs. DB2 instance, database and application memory)
- Parameters, environment variables and registry variables
- Database storage model comparison (e.g. table space types and layouts, compression approaches)
- Basic database administration comparison (e.g. terminology, create database, start/stop, dictionary vs. system catalog, performance)
- Compatibility mode for running Oracle applications with DB2
This webcast is intended for database professionals:
- familiar with Oracle and looking to learn more about DB2 (for Linux, Unix and Windows),
- familiar with DB2 and looking to learn more about Oracle
- who work in a heterogeneous environment and looking to expand their DBMS knowledge and career prospects.
Join Sal Vella and Burt Vialpando on Thursday Mar 31, 2011, at 12:30 PM Eastern to learn more.
Register and receive instructions for attending this webcast.
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
Thanks to Rav Ahuja for providing me with these details.
Want to make smarter decisions with easy to implement technology? According to Liz Epadula’s Blog, IBM customers are able to get business insights and make smart decisions by using IBM’s Smart Analytics System in a new format as part of Novell’s SUSE Appliance Program.
A Novell Press Release regarding this collaboration between Novell and IBM DB2 will be released this week. I’ll post the link as soon as I can.
New virtual appliances and templates have been built that include DB2 installed on SLES 11. This makes it very each for developers to get started on DB2 Express C or to build their own appliances on top. To get started, link to the SUSE Studio, log in, and search for DB2.
In addition, there will be a podcast made available to step you through the use of the templates. I’ll provide the link as soon as it’s available, but it will be place on developerWorks if you want to search for it before I mention the link.
Thanks to Jennifer Chen, Irshad M Raihan, Jason Chan, and Irina Delidjakova for making me aware of this important collaboration.
PS… I’m leaving on vacation in the morning, so if you don’t see new entries from me in awhile, don’t be worried. I’ll be back… and more relaxed!
There is a new white paper that I recently learned about that I thought I would pass on to you:
Continuous access to Read on Standby databases using Virtual IP addresses
The DB2® High Availability and Disaster Recover (HADR) feature is a database replication method that provides a high availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the Primary, to a target database, called the Standby.
The HADR reads on standby (HADR ROS) feature, allows applications to access the current Standby databases for reads. With the HADR ROS feature, read/write applications can access the HADR Primary database, and read-only applications can access either the HADR Primary or the HADR Standby database. This enables you to offload some of the read-only workloads running on the Primary to the Standby.
This paper shows how you can use the HADR ROS feature in conjunction with Virtual IP addresses to ensure continued, automatic connectivity for read-only clients.
For the full paper, see: Continuous access to Read on Standby databases using Virtual IP addresses
PS… Thanks to Louise McNicoll and Steve Raspudic for passing this information to me.