Keep on Learning
Today’s DB2Night Show featured the top 10 contestants who were chosen by the judges in February. They each had four minutes to impress the audience and replay listeners. That’s correct. This time the judges are giving feedback, but are not choosing the best competitor. I must say that I’m very glad I’m not choosing the best. If you were in the audience today or if you listen to the replay, you’ll see what I mean: All presenters were incredible Lots of learning happening today!
Here’s a summary:
The Fragmentation of DBADM
Noticed in DB2 9.7. DBADM is still a superuser of sorts, but there are granularities. SECADM and DATAACCESS authorities were added. Great presentation on the permissions for each user type. Great information presented in an educational fashion. AND, she finished in time.
Simple Steps for Substantially Reducing report execution time in a Data Warehouse Environment.
Great graphics, very clear description of the problem and how to fix it.
How to Configure an Efficient HA and DR on DB2 10.1
I like that the tradeoffs slide: puts the problem in perspective. Clear description of the solution. Seems like this could be a common problem that needs to be solved: good reasons to upgrade to V10!
Getting Siblings to Talk - Federating DB2 LUW and DB2 for i
Synchronized DB2 LUW on AIX to their legacy iseries system. Very good description on Federation and how it is set up.
My New Moving Vehicle DB2MOVE "With more POWER and Less Gas"
Lots of situations when you'd use DB2MOVE. Good description on what the command does, its options, actions and how to use them.
How do you work with Application Development to Ensure Performance
What do you do when performance problems arises after new features are added? Problem well defined and quantitative results shown.
SQL Performance Tuning using MQT Part 2
Interesting scenario created to define problem and how it was analyzed and solved using MQT. And... he spelled cheque correctly! Way to go!
Temporal Data Management in DB2 for z/OS
Good definitions and contrast between snapshot and temporal. Lots of details in the scenario that shows the problem and how it is solved. The topic was too large to complete in time.
DML = Data Manipulation Scanner. Great presentation style. I like how different approaches were discussed with pros & cons. Good use of examples and sample code.
The 8 Selects that All DBAs Want to Have
Unfortunately Juliano did not show up today. So without Juliano, we had 9 great presentations today.
Who was the best? Listen to the replay and VOTE. Remember if you complete the survey at the end of the replay, you’ll have a chance to win an amazon.com gift certificate.
Thanks to all the presenters for your hard work on creating these great presentations.
Judges present on the DB2Night Show "DB2's Got Talent" Competition
DB2 NightShow: Episode 3 of the DB2's Got Talent Competition
DB2 NightShow's 2013 DB2's Talent Competition
Promote yourself and DB2 with the help of my slides in SlideShare. Here’s where you can get them: Db2 night social_promoting_susan.
What are you sacrificing for the promise of big data?
Many of today's companies are making trade-offs in areas of security and governance to leverage the promise of big data. Can you have both?
There have been several responses to this question. First off, I’d like to point you to the tweetchat that took place on Wednesday, February 27. Several experts, including Jeff Kelly of Wikibon discussed the topic: Garbage In/Garbage Out and data governance’s role in the big data era. This was a very exciting event and all who participated said they had fun and are looking forward to the next tweetchat. I had to split the recap into two blog entries:
I plan to write a third blog entry from the information gathered by pulling out the list of related articles that were mentioned during the tweetchat.
Articles and blog entries related to this theme.
by Craig Mullins
Craig looked at the many aspects of managing change, including 9 requirements for successful change. He also shared his DBA perspective as the “custodian of database changes.”
by Dave Beulke
Dave notes, “While the new kid database Hadoop may be getting a lot of press, it needs more capabilities to keep up with the mature platforms and databases for data security, governance, archiving and temporal designs.”
by James Kobielus
Is your big data investment production ready? James shares five key considerations to help ensure your big data investment can function as a reliable business asset.
by Larry Dubov
As organizations move towards big data, privacy concerns become very real. Larry traces the history of privacy and explains why good governance can help reduce the need to compromise on privacy.
by Sunil Soares
This new flashbook provides an in-depth look at several aspects of governing your big data, with several case studies to offer guidance and best practices. Download your free copy.
by James Kobielus
Can you control the big data explosion? James argues that you can, with careful attention to three vital types of controls.
by Steven Adler
Steve is the Chairman of IBM Data Governance Council. His view is that companies who still treat their data as a raw resource rather than an essential product that they produce, should prepare to be obsolete. Steve has an ongoing blog related to the topic. You can find his blog behind a registration page. Here is an entry to look for: The Data Governance Report Card.
by Mike Martin
Mike wrote this blog entry a year ago, but it is still as accurate today as it was then: “I believe we should include Big Data in Information Governance, after all one of the major issues we try to solve with Information Governance is data volume and I consider Big Data solutions to be yet another tool in the arsenal of Information Governance.”
by James Kobielus
“When unstructured data (however defined) enters the enterprise big-data picture, data management professionals begin to quake in their boots. Governance of structured data is an established body of practices and tools, focusing on enforcing controls on schemas and contents of data deemed to constitute an official system of records in some subject area, such as customers and finances.”
A summary of the conversations focused on how and why big data challenges are posing a bit of a renaissance for databases. Some people see databases as a commodity, something that gets taken for granted. But as big data becomes a reality, databases are again taking center stage.
Follow us on twitter using the tag #bigdatamgmt and join in on the conversation.
* Originally published on July 30, 2012 by Crysta Anderson at MasteringDataManagement.
IBM Champion for DB2 Bjarne Nelson has trained DB2 users around the globe, from his home in Switzerland to multiple Korean engagements. Regardless of location, though, Bjarne bonds with students who really want to learn how to get more out of DB2.
Since 1985, Bjarne has consulted in multiple industries, becoming an IBM Gold Consultant in 1996 and working closely with IBM Labs. He also serves on the IDUG Board of Directors and has chaired the European Conference.
Many know Bjarne by his nickname, Kermit. Of course, we had to ask the origin of the moniker. Bjarne explained that he once had long hair, a “very green car,” and did a spot-on impression of Kermit the Frog as he introduced his rock band to crowds.
The name stuck, as has the role of mainframes. Bjarne disagrees that mainframes are going the way of the dinosaur. He explains, “Of course there are huge changes in technology, but the mainframe is capable of still surviving. It’s probably the longest living platform that we have in IT…that continues to maintain its virtue of stability, performance, high scalability. And at the same time, you can still build modern programming paradigm applications,” while letting the data reside safely on a “good old mainframe.”
Even while mainframes persist, organizations face evolving compliance and security needs that require new software and solutions. Bjarne has found DB2 10’s new features very helpful for meeting these needs, though new software means migrations.
“We all have to go through migrations,” Bjarne noted, explaining that conference and web sessions dealing with migration topics and best practices tend to stand the test of time long after their original presentation. Such migrations – which may lag several years after a release – make it more important than ever to collaborate throughout the year.
A migration is an educational experience, Bjarne said, and afterwards, many “are proud of what they know” and want to share their insights. Hence, Bjarne has worked with IDUG to assemble a content committee that shares information between conferences. The resulting IDUG DB2 Tech Channel on BrightTalk has proved very popular, with more than 1200 technical webcasts ready for viewing.
But that doesn’t mean conferences are going away. Face-to-face conversations and the opportunity to ask questions are very valuable. Bjarne explained, “If you go to an IDUG conference and pick up 3 or 5 good things you can go home and implement…that’s enough to pay for a conference because quite often, it’s the issues you’d otherwise spend hours and hours trying to solve yourself.”
In his spare time, Bjarne is an avid SCUBA diver, particularly in the Red Sea, and has an impressive music collection that he uses to bridge the generation gap with his children and granddaughter, Naia, when she gets old enough to choose her own music.
Watch Bjarne on a YouTube video as he talks about new initiatives and work underway in the DB2 community and IDUG organization.
We had 4 great presentations again this week! I’d really like to thank all participants... I know it isn’t always easy to present, but it is very important for us to share our knowledge with others!
Mikko - Summary Table Design & Monitoring
A little trouble following the story of the problem & solution. Summary tables are a huge topic. Well presented.
Umesha - Detailed steps to configure DB2 Distributed Data Facility (DDF) for z/OS
Good slides. Not practised? Went over time. Missing the “why”. Only “how” was covered in presentation.
Sreeharsha - High Data Availability: solutions and techniques
Environment clearly defined. Problem clearly defined. Presentation was well put togetehr and rehearsed. This is the way it’s done!
Armando - Dare to be Different (Against all Dogmas) SQL Performance Tuning
Be open minded on how to solve problems. You may find a creative solution that wasn't’ expected
Entertaining and engaging presentation with a great amount of style.
Congratulations to Sreeharsha, Armando, and Mikko for moving to the next level.
Be sure to join us next week to hear presentations from me, Martin, Klaas, and Martin. Your turn to evaluate us! Just for fun, of course. Come and have some fun!
Over 219,000 downloads of past DB2Night Show episodes! Congratulations Scott!!
If you missed the show, see the replay!
Be sure to fill out the survey when you do... you may be the lucky winner of a $25 certificate to use at Amazon.com. Perhaps there is a DB2 book you’d like to purchase?
Berni Schiefer is the guest on this week’s DB2Night Show. Berni is a DB2 performance legend and you’ll greatly benefit from hearing his talk. Berni will share the latest news, tips and advice about DB2 LUW 10.
Thanks to IBM Champions and hosts of this fabulous show: Scott Hayes and Martin Hubel
Remember, all shows are recorded, so if you miss it, you can still catch up at a later time.
Also remember that Feb 1 begins the 3rd "DB2's Got Talent Competition. For information, see my blog entry: Become a DB2 evangelist by being speaker!
I bet you do! If you follow my blog, you know that I often promote the fabulous work that our champions do to support IBM’s products. I like to call the champions IBM’s Best Friends!
Just announced today, the nominations for the 2013 IBM Champion for Information Management program are now open (worldwide) and are being accepted through February 28, 2013. Candidates may be nominated by another individual or they may self-nominate at https://www.surveymonkey.com/s/Nomination2013 .
The official call for nominations information:
A list of current 2012 IBM Champions
To get an idea of some of the work that Champions are appreciated for, take a look at some of my previous blog entries:
Attend IDUG DB2 Tech Conference 2013 - Apr 29 - May 3, 2013 in Orlando, Florida - Many of the speakers at this conference are IBM Champions, including Craig Mullins, Bonnie Baker, Martin Hubel, Scott Hayes, Roger Sanders, Judy Nall, Susan Lawson, Fred Sobotka, and many more!
DB2 Symposiums 2013 - Many of the champions who take part at large IDUG events, also take part in more regional events like the DB2 Symposiums. Klaas Brant is the leader in these education sessions.
Check out these Rising Stars in the DB2 Community! - I’m not sure how many of these “rising stars” are currently champions, but I think each and everyone of them should be nominated!
What's Happening in Your DB2 World? - In December, I was having much fun reaching out to many of the champions who I interact with via twitter and asking them about the DB2 activities they were involved with.
Best Selling Books, 2012 and Many IBM Champions are Authors - Many of our champions have written books, which I’m very happy about! I have more writing opportunities as well, so if you’re interested, you know where to find me!
Become a DB2 evangelist by being speaker! - IBM Champion Scott Hayes takes part in the DB2 community in many important ways, but I think that his grooming of future speakers / experts is outstanding. Perhaps taking part in this competition is a first step in becoming a champion!
Three DB210 for LUW Certification Exams are now available - Have you ever considered who creates the questions on these exams? Would you be surprised if I said IBM Champions did? People like Rebecca Bond, Roger Sanders, Dan Luksetich, Judy Nall, Susan Lawson, and others are critical to the success of the certification program.
IBM Champions at IOD: A perfect match and More IBM Champions - I’ve said it before and I’ll say it again... without champions, would there even be an IBM Information on Demand Conference?
I haven’t mentioned every champion, but be sure, they are very appreciated. If you think you contribute in ways such as these, be sure to nominate yourself or ask someone to nominate you.
If you have worked with me and I’ve promoted the work that you’ve done, feel free to use me as a reference, but give me a heads up. I look forward to working with all the IBM Champions who I can in the coming year!
developerWorks: a treasure chest full of great content from experts. Articles, tutorials, best practices, downloads, spotlights, podcasts, videos... so much is available to help you deepen your skills... all for FREE.
2012 was a busy year and I’m pleased to tell you the top 10 articles that were published. Were you one of the readers who helped make these articles to the top? Check it out. Read the ones you missed. Share the ones you liked.
Confused about the various editions of IBM® Informix®? In this article, get an introduction to each edition, then you can compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease of use, reliability, stability, and access to extensibility features.
IBM® DB2® 10 for Linux®, UNIX®, and Windows® has out-of-the-box support for Oracle's SQL and PL/SQL dialects. This allows many applications written against Oracle to execute against DB2 virtually unchanged. In this article, get a high-level overview of what Oracle compatibility means in DB2. Whether you want to switch your custom application to DB2 or extend your DBMS vendor support to DB2, now is your time. [2012 15 May: This article has been updated to include new resources.]
This article is focused on explaining Big Data and then providing simple worked examples in Hadoop, the major open-source player in the Big Data space. You'll be happy to hear that Hadoop is NOT a replacement for Informix® or DB2®, but in fact plays nicely with the existing infrastructure. There are multiple components in the Hadoop family and this article will drill down to specific code samples that show the capabilities. No Elephants will stampede if you try these examples on your own PC.
Since the IBM® DB2® Control Center tools have been deprecated in DB2 9.7, users have been encouraged to adopt IBM Data Studio and IBM InfoSphere® Optim™ tools for managing DB2 databases. IBM Data Studio 3.1 was released in October 2011 with several enhancements over previous versions, making it an excellent replacement for Control Center. This article aims to help DB2 users who are familiar with Control Center tools to quickly transition to IBM Data Studio.
Learn some considerations that new software as a service (SaaS) vendors need to take into account when developing applications or modifying existing ones to enable them for multi-tenancy on the cloud. The article discusses the considerations only from a database perspective — specifically, from an IBM® DB2® perspective. Six cases or methods are described.
This article focuses on physical database attributes that are affected by the specifics of DB2 database servers in online transaction processing (OLTP) environments
In a large modern enterprise, information is almost inevitably distributed among several database management systems. Despite considerable attention from the research community, relatively few commercial systems have attempted to address this issue. This article describes the technology that enables clients of IBM's federated database engine to access and integrate the data and specialized computational capabilities of a wide range of relational and nonrelational data sources.
Combine InfoSphere® DataStage® and InfoSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of InfoSphere Federation Server as a "data pre-processor" for InfoSphere DataStage, and demonstrates situations in which the combination reduces both the elapsed runtime (by as much as 91 percent) and overall resource consumption of the job. The article does not promote the combination of InfoSphere Federation Server and InfoSphere DataStage for all data consolidation scenarios, rather it attempts to characterize the situations in which the combination is most beneficial.
Learn about current free, online courses that are available at BigDataUniversity.com. Follow the suggested path to get started and grow your knowledge on big data, and get ready to implement it to meet your own business needs.
If you want to work with "big data" without writing code or scripts, you'll want to look into BigSheets. BigSheets is a spreadsheet-style tool for business analysts provided with IBM® InfoSphere® BigInsights, a platform based on the open source Apache Hadoop project. This article teaches you the basics of using BigSheets to analyze social media and structured data collected through sample applications provided with BigInsights. You'll learn how to model this data in BigSheets, manipulate this data using built-in macros and functions, create charts to visualize your work, and export the results of your analysis in one of several popular output formats.
Congratulations to all these authors for a job very well done! I hope you plan to write more this year because we’d like more great content from you!
There are three DB2 Symposiums planned for the first half of 2013. Hopefully you’ll be able to attend one of these as they are a great way to hear from industry leading experts on topics that most concern you. You may join for 3, 2 or just 1 day(s), depending on your needs and budget. Symposiums are different than a conference as they are full day learning sessions that will provide you with the depth you need on a particular topic.
The locations planned for this year are:
Dallas, TX - March, 13-15 2013
Boston, MA - March, 18-20 2013
Veldhoven, Netherlands - May, 28-30 2013
Although I enjoy Dallas and Boston, I highly recommend you combine education and vacation together to enjoy the tulips that will be in bloom in the Netherlands during last week of May! My family is Dutch, as I’m sure you can tell by my surname, and I’ve been lucky to visit this lovely country several times. It is quickly becoming one of my favourite parts of the world.
For detailed information on the locations and the sessions that will be offered, see the DB2 Symposium website.
IBM Redbooks are cherished by many, since they provide excellent technical content in electronic format, all at a price that is hard to resist: FREE! This year IBM Redbooks are also available in ePub format, allowing tablet owners a new way to read these books.
You can find the most popular downloads for Information Management on the IBM Redbooks site: IBM Information Management Redbooks.
Rather than give you this list, I’ve compiled my own list that includes the top downloads of the most recent DB2 or InfoSphere titles:
1. High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows
This IBM Redbooks publication describes the DB2 high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. The book provides a detailed description of HADR, including setup, configuration, administration, monitoring, and preferred practices.
2. Oracle to DB2 Conversion Guide: Compatibility Made Easy
This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2.
3. InfoSphere DataStage for Enterprise XML Data Integration
XML is one of the most common standards for the exchange of information. However, organizations find challenges in how to address the complexities of dealing with hierarchical data types, particularly as they scale to gigabytes and beyond. In this IBM Redbooks publication, we discuss and describe the new capabilities in IBM InfoSphere DataStage 8.5. These capabilities enable developers to more easily manage the design and processing requirements presented by the most challenging XML sources. Developers can use these capabilities to create powerful hierarchical transformations and to parse and compose XML data with high performance and scalability. Spanning both batch and real-time run times, these capabilities can be used to solve a broad range of business requirements.
4. Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS
This IBM Redbooks publication provides technical decision-makers with a broad understanding of the IBM DB2 Analytics Accelerator architecture and its exploitation by documenting the steps for the installation of this solution in an existing DB2 10 for z/OS environment.
5. Unleashing DB2 10 for Linux, UNIX, and Windows
This IBM Redbooks publication provides a broad understanding of the key features in IBM DB2 10 and how to use these features to get more value from business applications.
6. Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
In this IBM Redbooks publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage® and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.
7. Smarter Modeling of IBM InfoSphere Master Data Management Solutions
This IBM Redbooks publication presents a development approach for master data management projects, and in particular, those projects based on IBM InfoSphere MDM Server.
8. DB2 10 for z/OS Performance Topics
This IBM Redbooks publication provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates.
9. IBM InfoSphere Streams V3.0: Addressing volume, velocity, and variety
Still in draft format, learn how IBM InfoSphere Streams provides a development platform and runtime environment where you can develop applications that ingest, filter, analyze, and correlate potentially massive volumes of continuous data streams based on defined, proven, and analytical rules that alert you to take appropriate action, all within an appropriate time frame for your organization.
10. Managing IBM DB2 10 for z/OS Using the IBM DB2 Administration Tool for z/OS Version 10
This IBM Redbooks publication highlights the data administration enhancements introduced by DB2 Administration Tool for z/OS Version 10 by providing scenarios of their use with the new functions provided by DB2 10 for z/OS.
Stay tuned for next year for more great content from the IBM Redbooks team!
What have former contestants of “DB2’s Got Talent” competition been able to achieve since they improved their presentation skills as a result?
Some of the former contestants have been telling me about their published articles and IDUG presentation. If you haven’t contacted me already and you were a contestant, tell me about what you’ve been up to.
Before you read the list, I first want to say that I’m very proud of each and everyone one of these people as becoming presenters and writers isn’t always easy. I’m also very glad that I took a small part in encouraging these people to try something new.
was one of the finalists in the 1st year of the contest and had to withdraw due to a work project that involved travel. He says that his appearance on the DB2Night Show enabled him to connect with the Database community, build confidence & networking. Clearly he thoroughly enjoyed being part of this contest. In the second year Raja didn’t take part, but he mentored 5 people from his organization to participate. He’s been teaching DB2 for 8 years.
Jeyabarathi Chakrapani @JBChakra's presentation was accepted for IDUG 2013: "Evolution of the DB2 HADR Tool". JB has also had an article published on developerWorks: Use concurrent I/O to improve DB2 database performance And she wrote a guest blog entry for me: DB2, DB2Night Show and IDUG as viewed by JB .
Brian Fairchild @fairchild_db2has a blog Xtivia. His latest entry: "DB2 Update Anywhere Replication for Dummies". http://bit.ly/Y4OSnt. Brian will also be presenting at IDUG Orlando in May 2013: “A DB2 LUW Fitness Plan”.
Norberto Gasparotto Filho @norbertogf
published a tutorial on developerWorks: "DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning" and keeps a blog Insights on DB2 LUW database admin, programming and more.
Ember Crooks on her first developerWorks article: "Mining your package cache for problem SQL in DB2 for Linux, UNIX, and Windows" and maintains a blog:
DB2 for WebSphere Commerce: Expert tips on building and administering DB2 LUW databases for WebSphere Commerce. She will be presenting at IDUG in Orlando: "The 10 Commandments of Supporting E-Commerce Databases” . AND she is appearing on tomorrow’s DB2Night Show: "Do what I mean, not what I say! Back-Out Strategies for DB2 Database Changes" . (Note, if you miss the show on Dec 14, remember that you can watch all DB2Night Show episodes in replay... whenever you want.
Kohli Kshitij @kohli83 had a great year! He won the “DB2’s Got Talent Competition” from the DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says that his favourite sessions were:
He’s reviewing a book that will be published next year by IBM Press
Andres Gomez Casanov (@angoca) has a DB2 blog in Spanish, where he puts opinions, tricks & tips.
Would you like to be involved more in the community and achieve some of the successes that these people have? You can! Become a contestant on next year’s “DB2’s Got Talent” competition and build your skills, network, and possibly win a prize!
See my recent blog for details: Become a DB2 evangelist by being speaker!
It’s time for the annual IBM Press book sale, which is on from now until Friday December 28, 2012. This is a perfect time to stock up on great books that will help you become more effective at your job. Here’s a list I put together along with reasons why you’d want to read this book.
40% off from IBM Press:
—save 40% on print books, eBooks, and videos during our this Sale. Also, as a special reward for purchasing, you will automatically receive one free month's access to Safari Books Online via email confirmation. Use discount code HS2012 and start shopping now!
Reminder: If you’re in Europe, find these books are featured on the www.pearson-books.com/ibmpressbookshop website that offers 35% off and free shipping within the UK. Shipping fees to the rest of Europe are not free, but very small. Be sure to bookmark this page and share with others who buy technical books in Europe.
What’s happening in your DB2 world? I asked this question to many of the people I’m connected with on twitter and I got many responses that I’d like to share with you.
Rebecca Bond@DB2locksmith hasn’t had time to update her blog (http://www.securedb2.com) lately, but is thinking of topics she could write about. Is there something you want Rebecca’s opinion on? I’m sure she’d love to have some suggestions to help her write something.
Kohli Kshitij @kohli83 had a great year! He won the “DB2’s Got Talent Competition” from the DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says that his favourite sessions were:
Sanjeev Datta @1dsanjeev is very pleased with the publication of his new book: IBM Cognos Insight (http://www.packtpub.com/ibm-cognos-insight/book). He recommends Chapters 1 for anyone who is new to IBM Cognos and IBM business vision and strategy. Chapters 4 & 5 will help finance, sales, & marketing departments in usingCognos Insights to develop their own workspaces. If you find the book sold out on amazon, contact Sanjeev through twitter and ask him for other buying options & discounts.
Michael Schulz @mikeondb2 says DB2 is rockin' and rollin' and PureData for Transactions is taking it to a new level. Don’t forget to read this article that Mike recently wrote for IBM Data Management Magazine: "Achieving High Availability and Disaster Recovery with IBM DB2" .
@DB2Geek The DB2Geeks had a very successful year and celebrated at IDUG Berlin. Take a look at their blog and Beat The Geek photo gallery.
@CuneytG has just published another article in the IBM Data Management Magazine: “Gear up with IDAA: IBM DB2 Analytics Accelerator”
Sunil Soares @SunilSoares1 just finished the Data Governance Winter Conference. He’ll be speaking at IDMA conference in April 2013 on best practices for insurance data governance. He’s very happy with the publication of his latest books and the sales of all three of his books:
Philip Gunning @db2luw is finishing off his latest book that will publish in 2012 as well as performed a DB2 upgrade with TSAMP, HADR & wrote an article on Temporal Tables that will published on http://enterprisesystemsmedia.com/..
Vijay Sitaram @vijaykarti is organizing the IDUG 2013 conference in Orlando. Lots of exciting news: Complimentary workshops and Cert Crammer courses! Check out http://www.idug.org/NA
Craig Mullins @craigmullins Craig not only published two books this year, he’s also written many articles including this “presentation” style article “Ten Breakthroughs That Changed DB2 Forever” which let Craig talk about a lot of DB2 things without worrying about how I tie them together.
If you have an answer to my question “what’s happening in your DB2 world” and would like to share with me and others, either send me a tweet @susvis or post on the DB2 Facebook page.
I find it interesting to see what people buy at a bookstore. Personally I love bookstores and online book sites. I can spend hours researching books.
The bookstore at the IBM Information on Demand conference was very busy this year, and I’ve put together this blog to tell you want others were buying.
The biggest seller was Nate Silver’s book The Signal and the Noise: Why So Many Predictions Fail-but Some Don't. The best selling book at a conference tends to be one from a special guest. Nate was quite the guest to have given his predictions in the US election that happened shortly after IOD ended. I listened to the audible version of the book and quite enjoyed it. The book has a chapter for each area where predictions are normally made: weather, earthquakes, stock market, baseball, poker, and elections. Nate fully describes the reason why predictions either work or don’t work for the area. You’ll instantly be connected to the story and will learn how predictions can be made more accurate in this case and how you can improve predictions that you need to make yourself.
The next biggest seller was Sunil Soares’ latest book Big Data Governance: An Emerging Imperative. The store sold out of Sunil’s book, so clearly Sunil did a great job putting this book together. I haven’t read it yet, but would like to. Read a sample chapter from the book. Governance and Big Data are both huge and important topics, so take a look. Sunil’s first book also made the top 10 list: Selling Information Governance.
Next was the book by Jeff Ma, The House Advantage: Playing the Odds to Win Big In Business. If you watched the movie “21” with Kevin Spacey, you’ll remember Jeff Ma as the lead MIT student who counted cards. If you attended Jeff’s talk at IOD, you learned that Jeff played a dealer in the movie. I think I need to rewatch the movie!
Cognos books sold very well this year! Four different Cognos titles made it in the top 10 list:
and since the conference, a few more Cognos books were published:
And the top selling IM books this year were:
Note, if you’re in Europe, I’ve written a blog to help you figure out what online sites give you the best prices: I’m in Europe: How can I get a copy of that book?
Just published: Testing the Data Warehouse Practicum: Assuring Data Content, Data Structures and Quality
by Doug Vucevic and Wayne Yaddow
About the book:
The quality of a data warehouse (DWH) is the elusive aspect of it, not because it is hard to achieve [once we agree what it is], but because it is difficult to describe. We propose the notion that quality is not an attribute or a feature that a product has to possess, but rather a relationship between that product and each and every stakeholder. More specifically, the relationship between the software quality and the organization that produces the products is explored. Quality of data that populates the DWH is the main concern of the book, therefore we propose a definition for data quality as: "fitness to serve each and every purpose" Methods are proposed throughout the book to help readers achieve data warehouse quality.
About the authors:
Doug Vucevic: Upon an early retirement from the IBM Development Lab in Toronto, where he had worked as a software developer, Doug has been working as an independent consultant to major banks, insurance and retail companies in Toronto, in the field of Software Engineering. Doug's consulting assignments have been in leading quality assurance and testing efforts for: data warehousing, BI and Data Mining in financial, insurance and retail industries. Doug holds Masters' Degree in Electronics and Telecommunication and is a member of the Registered Professional Engineers of the province of Ontario.
Wayne Yaddow: Wayne Yaddow has spent more than twenty years developing and testing operating system code at IBM. During the most recent ten years, he devoted his time as an IT consultant, conducting QA on data migration and data integration for large data warehouse projects in the financial industry. While working as a consultant, he shared his data warehousing knowledge with many colleagues on the Internet and in work assignments in New York City.
More blog entries about Data Warehouse:
DB2Night Show, Nov 30: IBM DB2 LUW Data Warehouse & DPF Performance
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Largest data warehouse – Guinness World Record
April 30, 2012: GA of Version 10 products: DB2 for LUW and InfoSphere Warehouse
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights
This Friday Nov 30 at 11:00 am ET, join host Scott Hayes and guest Glen Sheffield from IBM for the next DB2Night Show. The topic of the day: IBM DB2 LUW Data Warehouse & DPF Performance
Glen will share the latest tips and advice on maximizing DB2 DPF Performance.
Click to Register.
For more information on this topic, see the following resources:
Download an evaluation copy: IBM InfoSphere Warehouse 10.1 Enterprise Edition
Best practices for DB2 for Linux, UNIX, and Windows and InfoSphere Warehouse
IBM Data Management Article:
Get the Most out of Your Data Warehouse
The critical role data quality plays in the ROI of a data warehouse
By Robert Routzahn | Published November 4, 2012
Upcoming shows include:
Willie's Brain Dump - Part 2
Again, after our first z/OS show of the season, the audience asked that Willie continue with his brain dump of helpful tips. Join us for this special continuation with IBM guest Willie Favero for his latest tips on DB2 for z/OS.
"Do what I mean, not what I say! Back-Out Strategies for DB2 Database Changes"
She's BACK! Episode #66 on e-Commerce database performance was our 3rd most popular show of Season #3! During this show, Ember has more sage advice for us!
2ND Annual Year-End EGGNOG Party! We'll be gathering up DB2 LUW & z/OS experts, top IBM people, and leading Industry Consultants to share a DB2 buffet of news and insights. In 2011, our Eggnog Party show ranked 4th in our Top 10 DB2 for z/OS rankings.
Why "to REBIND or NOT to REBIND" is STILL a QUESTION?
DB2 LUW 10 - Cool Stuff No One Else is Talking About!
DB2 LUW 10 - Performance Update with BERNI SCHIEFER! Berni is a DB2 performance legend. If you miss this show, maybe you should be working with another brand name database.
February begins the “DB2’s Got Talent” Competition. Improve your presentation skills by becoming a contestant!