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!
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.
Today marked the 4th episode of the popular “DB2 has Talent” series of webcasts featured on the DB2Night Show. This was the first of the episodes that featured presentations for DB2 for z/OS. MISSED IT? No worries. Replays HERE.Let me tell you about the contestants we met today:
Mobi -“DB2 Online REORG”
Mobi stepped us through the reason to use REORG, the process for using it and problems that can be experienced. His conclusion gave tips on how to resolve and fix common problems with using this utility. If you’re interested, Mobi gave links to his blog entries about the topic.
David– High Performance Application Reusability Techniques
David is clearly very experienced in using DB2 and has been working with it for 26-27 years. His talk discussed encapsulating stored procedures into COBOL programs. The main issue with David’s “talk” is that there were no slides. There are some talks that can be done audio only, but I don’t think this one was. I listen to audible books in my car and am about to work on a series of podcasts…so I like audio only, but not all topics will work.
Vivekanadan – DB2 Administration Server for z/OS (DAS)
Vivek gave very complete information on this subject, but there wasn’t much in the way of personal experience from what I saw. I was having a case of Deja Vu when I was looking at the slides. I wrote the book “Teach Yourself DB2 in 21 Days” for DB2 LUW V8. I remember researching and documenting the DAS and am pleased that I still remember and that the DAS works the same on all platforms. My colleagues tell me that DAS is no longer in DB2 V10, so many people will no longer need this information.
Haris – DPF Communication between Sharing on DB2 z/OS Data Sharing Group
Haris stepped us through all the steps of setting up the parameters and other items that needed to be customized to use DPF Communication. The presentation seemed a bit too much like documentation rather than tips from experience. Martin suggested that the presentation would have been more valuable if it gave information on using DPF without RACF.
Shashank – Save Time, Cut Costs and Work Smarter: Monitor Mission Critical DB2 LUW Processes
This was the first presentation today that covered LUW. Shashank did very well by giving us the impact to the business if there are problems and then suggested using db2pd to discover the cause of the problems. I got lost during Shashank’s presentation as I didn’t see a clear link from the problem stage to the solution stage. It more seemed like a guide as to what db2pd is, without showing an example of db2pd being used to solve an actual problem. Shashank ran out of time, and Scott mentioned that there will be an entire show about this utility later this fall.
Bob (Robert) – SQL Tuning Tricks – Perils of Using “not in”
If you read my blog last week, you’ll remember that Bob had tried to present, but ran into technical difficulties. I’m happy that Bob was able to overcome these issues to present to us today. Bob did something that I’ve never seen before. He interactively underlined text in his slides to emphasize the point he was trying to make. I’m going to see if I can figure out how to do this! As to his actual content… it was very good. He showed SQL statements that used the very inefficient “not in” clause and how to change it to “except” clauses. My only suggestion to Bob is that he make his conclusion crystal clear… which was his first statement took 20 minutes to execute, but the revised one… only 5 seconds. If you hear this conclusion, it is very clear that this simple change is very worth the effort!
If you attended, you can fill in our survey
If you missed this show or the previous three, you can get the replays on the DB2Night Show page.
After much deliberation, we judges, Martin Hubel, Klaas Brant, and myself were able to inform host Scott Hayes that the following contestants should move on to the next round:
Momi and Bob
First & last of the day :) Way to go! We are very much looking forward to seeing you present at the next round.
See also my previous blogs about the DB2 has Talent Competition:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
Third Episode of “DB2 has Talent”
Next week we begin the finals. The format will continue to be 4 minute presentations by the contestants, but only contestants who we have moved to the second round will present. That means we’ll hear from:
Mary, JB, and Norberto – 1st Episode
Raja and Ahmad – 2nd Episode
John, Sameer, and Thiru - 3rd Episode
Momi and Bob – 4th Episode
Congratulations to all TEN finalists. I am looking forward to hearing you present again. I’ll be away on March 4 (on vacation), so Christian is sitting in for me. I’ll make sure to listen to the replay as soon as I return.
Voting will be done by other attendees… so if you are one of the finalists, you may wish to invite everyone you know to join the show to vote for you!
Good luck all!
One day I’ll visit India, but right now I’m satisfied with eating the fabulous India food at nearby restaurants and building my network of talented people who live and work in India.
The first group of people I want to mention are the contestants who have competed in the “DB2 has Talent” competition that has taken place this month on the DB2 Night Show. I didn’t take note of how many of the contestants were in India, but I’m thinking nearly half… If you’ve missed any of the sessions, I highly encourage you to listen to the replays. You’ll benefit from the educational and thorough presentations that have taken place.
First Episode of “DB2 has Talent”
Second Episode of “DB2 has Talent”
Third Episode of “DB2 has Talent”
Next, Shroff Publishers who have built a substantial collection of books that range from printed IBM Redbooks to IBM Press to MC Press books. These are produced locally in India and priced in the local currency. You’ll be surprised at the selection of books that are already available and I’m working on getting more added all the time.
And last, but not least are my IBM counterparts. They have been busy planning the IBM Information Management Technical Conference which will take place in Bangalore the week of March 16. The sessions look amazing, so if you are in the area, you should plan to go.
For more information see these links:
If I've forgotten to mention events & resources that I should know about, kindly let me know and I'll be happy to blog about it. This is true for other countries as well.
Me neither, until today. I guess the world was focused on a few other highly hyped events (like Watson & Egypt) to notice.
But notice we should! Thanks to Leon and his team, I’ve become educated and would like to share what I’ve learned.
The Early Experience program began last summer and Alpha 4 was release a couple of weeks ago and has proven to be very stable. The Early Experience program is under NDA (non-disclosure agreement ) and we’re unable to release any details at this time. You must apply to participate in the program.
Also… and this is a biggie…The Early Experience program is being offered in the cloud. That means that you do NOT need to find hardware, install and patch OS, and then download and install DB2 code. INSTEAD you simply need to go to the cloud and in less than 30 minutes you get your very own DB2 server! The cost? 34 cents per hour and you pay only for the time that your server is up and running. Need more details, see Leon’s Blog or Antonio’s Blog.
If you are interested in previewing what is new in the upcoming version of DB2, or if you are curious about the cloud delivery, fill out a very simple application form. Once approved, you will spend less than 30 minutes to get up and running and will begin your exploration process.
Personally I think this is brilliant! What a painless way to try out new software!
Tomorrow (Feb 28) is the next Chat with the Lab webinar with Sal Vella. The topic is “What's going on with DB2?” Maybe this Alpha in the Cloud will be mentioned?
I wrote one blog entry about Watson competing on Jeopardy against former champions Ken Jennings and Brad Rutter on Dec 15: Watson competing on Jeopardy - who will win? and have wanted to blog a few times since, but thought… what’s the point?
There are so many amazing articles being written about this event that there is really nothing I can add. So, instead of telling you what you likely have already read somewhere else, let me give a few personal notes and then point to some of the articles I’ve read.
I watched the first episode last night with my 12 year old son. We enjoyed the format of the show in that it gives the technical background to how Watson was created and the value Watson brings to the future of computing. My son could answer some of the questions faster than the competitors, but I was amazed at how fast the round went. It was disappointing when it ended because it seemed way too short. Good thing we have two more nights to watch.
Was it a bug that Watson gave the same answer as one of the other competitors? Or is that a result of the fact that Watson can’t actually hear what is going on? It seems like this is something that could be taken care of.
On Thursday in the Toronto Lab, we are having a session with the creators of Watson. We’ll be asking questions and recording the whole encounter as a podcast. If you have questions you want us to ask, post them in the comments and I’ll see what I can do.
Ok, here are some of the links that I’ve recently checked out. I’ll need as many power7s as Watson to be able to read all the articles that have been written so far!
Official IBM Watson Site from IBM Research
IBM’s Watson Challenge – No Gimmick by Jim Ericson; Information Management Online
Thousands of Tweets! Use #IBMWatson to add your say. My tweets (from susvis) will be fed to this site.
Watson on Jeopardy! Day One: Man vs. Machine for Global Bragging Rights -- a smarter planet blog (Steve Hamm will post daily responses here)
Ferrucci on Watson's Jeopardy performance: Day One -- Stephen Baker
Jeopardy site where you can see the preview where Watson was the champ.
Delaney Turner’s blog site.
Want more? Follow the tweets or do a google search on “IBM Watson on Jeoparday” and you’ll have no end of stuff to read!
On today’s DB2Night Show, we had the second set of competitors who are competing in the DB2 has Talent Competition. This week we had 6 amazing competitors who made it difficult for we judges (Martin Hubel, Klaas Brant, and I) to choose who would move on to the finals.
Before I tell you who was chosen to move on as a result of this episode, let me tell you a bit about all the competitors.
Vijay’s presentation was titled “Keeping Critical OLTP Databases Up and Running”. Vijay’s primary tip was to gather data when your database is running well and at peak. Having this data available will help you decipher problems when the database is running slower than it should. I’m reading the book “Switch” right now and one of the things the authors recommend that people do in their every day life is to look at the bright spots… that is, analyze a situation that goes well and find out why so that you can repeat it. It seems to me that Vijay’s presentation was suggesting that people do just that. Well done.
Mustafa presented “Consolidating Three Databases into One”. Mustafa ran out of time… but only by a few minutes. It seemed that the last couple of slides were critical to the presentation, but as it was, it was difficult to follow. Klaas gave Mustafa some advice to improve and I think that the presentation would be much better once Mustafa takes Klaas’ advice.
Ahmad was next with the presentation “OLTP Queries Timing Out”. Ahmad gave a very creative solution for searching for character strings in a table. He showed how he brought the search costs down significantly in his query. After Ahmad presented, both Klaas and Martin mentioned that they have many customers who were looking for solutions to this common problem.
Sameer presented “Optimizing Application Performance and Performance Monitoring”. This presentation was filled with incredible tips. Many incredible tips. The only thing I wanted to see in addition to what Sameer provided was examples and what if scenarios as to why these tips should be used and why they are better. Sameer says that he had a much bigger slide deck with that kind of content, but cut it out to fit in the 4 minutes he was allotted.
Greg’s presentation “Want to Improve Your DB2 Availability” was A++ on the definitions of HADR and HACMP, but there weren’t enough examples and pictures, so people with short attention spans, such as me, had trouble following. With a bit more effort, Greg’s presentation would have taken him to the finals.
Raja was last today. Presentation: “A Miss is as good as a Mile”. Did I get the title right? It doesn’t seem to make sense to me right now. Raja very nicely laid out problems related to performance and came up with solutions and clear details on how to get from problem to solution.
So, who did we choose? We decided that we liked Raja’s and Ahmad’s presentations best of all and asked the two of them to come back in March. We also decided to invite Sameer back next week to give us his presentation again next Friday after he takes the advice that he was given in this week’s show.
Did you miss this episode or last weeks? No worries! These are recorded and you can watch the replay. You’ll be glad that you did. One of the polling questions that we had today asked the audience if they learned something in today’s show that they didn’t yet know. 93% of the audience responded saying that they did in fact learn something valuable in the show. Even if you are an experienced DBA, I would say that you could learn something from these shows. The creativity of the people on the front line are amazingly creative!
Check out the blog entries of my fellow judge:
(I’m still waiting for new posts from Klaas Brant and our host Scott Hayes).
See you next week on the show for Episode #3!
In Dec 2009 I posted a blog entry called “Tis the Season to be Social” and it was primarily about the books that were then available for the Social side of business. I thought this post needed updating for a number of reasons:
1) Is there an area of business that is changing as fast as social media? Or being talked about as much?
2) I just attended IBM’ Social Business Jam, which is about to end and was pleased to see the brainstorming that people from a wide variety of backgrounds were doing this week on the Jam. I was interested in primarily ROI issues, and I found much to read. What’s a Jam? Read here. There’s one day left in the Jam, so join in the discussion.
One of the comments that I really liked was this one:
Recalled from our Lotusphere 2011 event where Sandy Carter our VP, IBM Social Business says at IBM we do not have "ROI" but "ROE" i.e. return on everything.
Miss Lotusphere? You may want to replay some of the keynote sessions: IBM Software Channel Video Library. Many of the sessions were about collaboration and social business. If you’re interested in this topic, you don’t want to miss the insight given at this conference.
3) I had to present to my management team about where our team should be going in terms of social marketing. To do my research for this presentation, I read the book “Inbound Marketing – Get Found using Google, Social Media, and Blogs”. I was in a hurry and found it to be an easy read, so I sped read it in one night. I read the electronic version on Books 24x7. The premise of the book is that we need to do everything different when using social media to reach people than we did in traditional marketing.
4) I recently joined IBM’s Social Media Community group and have attended several meetings and met some truly amazing people who are looking at how to improve our social interactions to improve everything about our business by connecting with people who use our products.
Some of the articles that I read that you may find interesting are:
My conclusion? There is much value in interacting with our customers, partners, competitors, collaborators, and fellow employees around the world. We can only benefit in all of our objectives by embracing ideas from the many people in the world that have opinions on what we do.
Will you see changes? Yes, there are a few things we’re going to change immediately and once they are made, I’ll blog about the changes so you won’t miss a beat.
5) 14 months is a long time in terms of book publishing, so what books are available that I could recommend.
I need to read more of these books before I’m comfortable recommending them! I do recommend the following books, but I’ll do some reading and get back to you on what else I’d recommend.
Web 2.0 and Social Networking for the Enterprise: Guidelines and Examples for Implementation and Management Within Your Organization
by Joey Bernal
This book provides hands-on, start-to-finish guidance for business and IT decision-makers who want to drive value from Web 2.0 and social networking technologies. IBM expert Joey Bernal systematically identifies business functions and innovations these technologies can enhance and presents best-practice patterns for using them in both internal- and external-facing applications.
Save 35% and Free Shipping with the Following Coupon Code: IBM4898 (coupon codes are case sensitive)
The Social Factor
Harness the Power of Social Networking to Promote Innovation and Drive Growth
A treasure trove of strategic and tactical insights for the business leader
Provides relevant experience from a host of powerful case studies and compelling business scenarios
Secrets for avoiding costly mistakes that can cripple a social networking initiative
Millions of people use social networking sites, and companies are increasingly turning to social networking to build relationships with customers. But companies routinely miss the best opportunities to create value and promote innovation–by using social networking to build thriving communities of employees, partners, and customers.
Business leaders and strategists can drive immense value from social networking “inside the firewall.” Drawing on her unsurpassed experience deploying innovative social networking systems within IBM® and for customers, Maria Azua demonstrates how to establish social networking communities, and then leverage those communities to drive extraordinary levels of innovation. Azua offers specific techniques for promoting mass collaboration in the enterprise and strategies to monetize social networking to generate new business opportunities.
Whatever your industry, you’ll learn how to choose and implement the right social networking solutions for your unique challenges...how to avoid false starts and wasted time...and how to evaluate and make the most of today’s most promising social technologies–from wikis and blogs to knowledge clouds.
Purchase this title enter coupon code MARKETING during checkout to receive your discount.
Join Sal Vella, (VP) and Jamie Watters (Senior Product Manager) as they give you an update on DB2. Specifically, what’s new since V9.7 GA .
IBM released DB2 9.7 for Linux, UNIX, and Windows (LUW) in June of 2009. Since that time we have been hard at work enhancing DB2 and adding new capabilities through a series of fixpacks, releasing DB2 pureScale, as well as introducing a high-value new edition called DB2 Advanced Enterprise Server. Attend this Chat with the Lab and learn about some of the improvements to DB2 LUW since the release of 9.7, as well as the outstanding value you can receive by upgrading to the new DB2 Advanced Edition.
Date: Mon, February 28, 2011 (28.2.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
Speakers: Sal Vella (IBM), Jamie Watters (IBM)
Will be downloadable just prior to the webcast from ibm.com/db2/labchats.
Click here to register and receive instructions for attending this webcast.
Want more content on DB2 pureScale?
Flashbook: DB2 pureScale: Risk Free Agile Scaling
Blog entry: More on DB2 pureScale.
developerWorks: DB2 pureScale.
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
Friday January 21, 2011, 11:00 - 12:00 EST
DB2 LUW MDC Tables "in the REAL World" - IBM DB2 GOLD Consultant Experiences
IBM Gold Consultants
Susan Guasden and Terry Mason
In this Episode, Scott Hayes is joined by two very special guests from the UK, both IBM DB2 GOLD Consultants, who will share with us their field (real world) experiences for using MDC successfully to achieve outstanding performance results. We are pleased and honored to have Susan Gausden and Terry Mason from Brooklands Technology Limited join us. In addition to sharing MDC tips and best practices, they have a few horror stories to share as well - this is a great opportunity to learn from the mistakes of others!
Susan Gausden is a certified database consultant experienced in data warehousing, database performance and multi-platform architectures. Susan is English and French bilingual and previously worked for major software and hardware vendors in North America.
Terry Mason is a certified database consultant, experienced in data warehousing, performance assurance, and database migrations. He was a founding director of the International DB2 Users Group (IDUG) and has worked extensively in the UK and North America.
Friday January 28, 2011, 11:00 - 12:00 EST
Top DB2 LUW Support Issues and Solutions - Real World Experiences
IBM Gold Consultant and IBM Information Champion
In this episode, special guest Julian Stuhler, Director Triton Consulting and IBM DB2 GOLD Consultant, shares with us his views and experiences on the top DB2 support issues and recommended solutions.
While most of us eventually become adept at handling challenges in our own organizations, you can get a head start and be more proactive by joining us for this unique show. As Julian checks off the most common problems he and his teams run into, you may likely learn how to avoid a problem. Or, you might learn a clever or efficient solution to a common challenge.
They say the difference between stupidity and ignorance is how many times you make the same mistake. Well, here is another great opportunity to benefit from the mistakes and ensuing wisdom of others.
DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us 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.
I’m looking forward to a fun & rewarding new year and wish all the best for you and your families as well!
Have you missed a show? Don’t worry, they’re recorded, so you can catch up on all your favourite topics. See my blog entry The Top 10 Most Highly Attended Shows for details.