Keep on Learning
Bigger Big Data, Big Thoughts, and Big Ideas
Last week, Leon Katsnelson was the guest on The DB2Night Show with IBM Champion Scott Hayes. I missed it! Did you as well? If so, we’re both in luck! We can watch the replay and learn.
97% of our studio audience learned something! Leon gave us a fantastic presentation on BIG DATA. Not only did he explain what it is and why it is important, but finally, at last, some explained DB2's relationship with BIG DATA! Leon also talked about HADOOP and other important technologies.
Leon is the Program Director, Information Management Cloud Computing Center of Competence and Evangelism at IBM.
Be sure to browse through the large and growing library of replays of The DB2Night Show that are available for you to watch: REPLAYS.
Upcoming shows include:
Nov 16: DB2 XXL - How to handle large volumes of data? with IBM Champion Klaas Brant.
Nov 30: IBM DB2 LUW Data Warehouse & DPF Performance with Glenn Sheffield from IBM.
Mark your calendar so you don’t miss a single episode of these award winning webinars.
Friday January 21, 2011, 11:00 - 12:00 EST
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.
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:
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!
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.
IDUG's annual North American conference is taking place in Tampa Florida this year. May 10 - 14, 2010. Have you been able to get funding to attend the conference yet? If not, maybe this information will help you.
The educational opportunities available at the conference will help make you smarter! And if you're smarter about your job, you'll be more effective, make fewer mistakes and be a real asset to your employer! Right?
Take a look at the conference schedule that is now available online. With this tool, it is now easier for you to build your conference curriculum by allowing you to search by program or project to find sessions specific to your area of expertise.
Here is a sample of the sessions you’ll find this May in Tampa:
D06 (DB2 for LUW): "DB2 Security – Ammo From the Trenches", Rebecca Bond, Author of "Understanding DB2 9 Security"
B10 (DB2 for z/OS): "Package Versioning for High Availability", John Maenpaa, Health Care Service Corporation
C08 (DB2 for LUW): "Successfully Managing the DB2 LUW Workload Manager", Scott Hayes, Gold Consultant, DBI Software
C09 (DB2 for LUW): "DB2 pureScale: Why It's So Much Better than Oracle RAC", Paul Zikopoulos, IBM Corporation
S03 (Cross-platform): "The Vision of Integrated Data Management - Past, Present and Future of Tooling", Curt Cotner, IBM Fellow, IBM Corporation
New this year at IDUG, you will also find a full-offering of hands-on labs. Available all four days of the conference, the labs include individual work-stations that allow you to explore new DB2 features and try out products without the hassle of obtaining and setting up software. This year’s hands-on labs include:
DB2 Lab 1: DB2 for LUW - All About DB2 9.7
DB2 Lab 2: DB2 for z/OS - Getting Started with DB2 for z/OS pureXML
DB2 Lab 3: DB2 for LUW - DB2 9.7 Performance Metrics and Monitoring
DB2 Lab 4: DB2 for z/OS - Develop High-Performance Java Applications on z/OS Using IBM pureQuery
DB2 Lab 5: DB2 for LUW - Workload Management
DB2 Certification Exams:
Do you have your current certifications yet? The exams are available free of charge to attendees of the conference (3 exams per attendee). This is a HUGE savings of $200 PER EXAM!
Make sure you are ready to pass the exam by taking a crammer course on May 10 for last-minute preparation for the exam. These full day seminars require an additional fee.
Z04: DB2 for Linux, UNIX and Windows - DBA Certification (541) Preparation Course
Date: May 10, 2010 09:00 AM – 04:30 PM
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
Z01: DB2 9 for z/OS DBA Certification Crammer Course
Register now to qualify for discounts on your conference fees:
Early Bird Discount: Register on or before March 26, 2010 and save $150 on your full-conference registration.
IDUG Mentor Program: Need to get thrifty with your training dollars this year? Through this incomparable loyalty reward program, IDUG members who have attended five or more IDUG conferences in the past ten years have the opportunity to bring a first-time attendee from the same company for an unprecedented 80% discount!
Visit IDUG.org/na to learn more about IDUG 2010 North America.
Do you need more help justifying your attendance at this confernece? See IDUG.org/na for further tips.
If you read my blog, you’ll know that this is my conference planning time. The IBM Information on Demand Conference is a huge event for us and for those of us working at the conference, we have a one track job this time of year. Many hours are spent making sure everything will be perfect for next week.
So, now for something completely different! Unconference.
What “unconference” means to me right now is what I’ll be doing after IOD is over!
What it really means is something completely different: An unconference is where YOU do all the planning... rather than people like me :) Sound fair? OK, not all the planning, but certainly the agenda.
I think it is a great idea because those of us who planned IOD may have missed something that is very important to you. So, let us know!
The unconference will be held during the IBM Information On Demand Conference October 25 at the Mandalay Bay Convention Center in Las Vegas, NV. The Technical Unconference is open to conference attendees, students, professors, as well as local IT pros, developers, and architects. And... it’s FREE.
You and your fellow attendees will lead and participate in discussions around all facets of the future of data. We invite you to submit your ideas below for what topics should be on the Unconference agenda and vote on the best of your peers’ ideas.
To kick off the participant discussions, here are some big questions to think about:
For more information and to register, see Unconference.
I hope you choose to take advantage of this opportunity to share how you are shaping the future of data and learn how your peers are doing the same. Don’t miss this unique opportunity to join – and create – the conversation.
I found a few other blog entries about the Unconference that you may wish to view:
svisser1 2700018UK9 Tags:  blog best certification bestpractices db2 books techbooks 5,389 Views
I noticed that Conor O’Mohony just posted a similar entry so it gave me an idea to do the same. Thanks for the inspiration, Conor!
Last year on Dec 20, my blog had had 994,747 unique views since I started blogging on devworks. Today, I have 1,994,943. The difference is just over a million views! I will definitely reach 2 million views this week! Very exciting.
So, what posts did people like to read on my blog this year? Here are the entries based on number of views:
2. FREE stuff
I’m happy that these 5 entries were well-read since I think that they contain valuable information and reflect the type of content that I like to post.
To complete the list, here are the all-time most read entries:
I like these posts as well, but the certification posts are sadly out of date. I will update them in the next while so you have better content to read.
If you like what I tend to share, I encourage you to “follow” my blog. As of writing this entry, I have 192 followers and thank every single one of you. I’m in the midst of reading Antonio Cangiano’s book: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence and am learning tips from his expertise. I would like to put many of his tips into practices in the next few months…. I wonder if you’ll notice? Asking you to follow my blog is just one of his tips!
Ready to learn more about Netezza? Next week in Boston for 3 full days, you can attend Enzee Universe to learn from the experts, find out what’s going on, and add new people to your network.
The Westin Boston Waterfront
25 June - our Season 1 FINALE - YOU REQUESTED IT!!!
Berni Schiefer RETURNS to talk about DB2 LUW Storage Optimization and Best Practices. He will be joined by his peer Robin Grosman who is the manager of BPS development. What's BPS? Another IBM acronym of course! Berni tells me that "BPS is the DB2 code layer that does I/O to storage".
Registration links and additional details:
This week at the lab we had an event to celebrate our colleagues who work as Support Analysts providing product support to IBM’s customers. It’s not always an easy job, so it’s nice that we take the opportunity to thank these people for the hard work they put into making sure our customers remain happy about choosing IBM products.
I actually worked in the Support organization briefly as well. Only for 7 months, as a Level One Support Analyst. Sure, it wasn’t for a long period of time, but I did enjoy the people I met and learned more than you can imagine!
To bring more attention to this group and to my friends who work in that area, I’ve pulled together a list of the blog entries that the team has created to explain what they are offering this year at the IBM Information on Demand conference this year.
The team blog as a group to their blog: “Thoughts from Information Management Support”:
Blogging to benefit Information Management Support customers worldwide.
Here are the IOD Entries that have been posted thus far. Follow their blog to keep up with all the news from that team.
Along with the Thoughts from Information Management Support blog, the Support team also shares information on:
IBM IM Support: facebook.com/IBMInformationManagementSupport
IBM DB2 Support LUW: facebook.com/DB2Support
IBM Information Management Spt: youtube.com/IBMIMSupport
Thanks to Kate Dawson for providing me with this information.
svisser1 2700018UK9 Tags:  miller warehouse idug idugconference analytics db2 jonas 5,367 Views
Another entry from Kate Kurtz who is attending & presenting at IDUG for her first time.
Wow! What a day. It has gone by so fast, and yet it felt incredibly slow while it was happening. There is just so much to take in, and so much to learn.
The key note speaker was Jeff Jonas, founder of SRD and now Chief Scientist, Entity Analytics. His topic was "Sensemaking on Steams and What Makes Smart Systems Smart". He is a phenomenal speaker with lots of energy and passion about what he does. It was a great session. He also managed to start and end his keynote speech with a poop joke. You have to admire someone who can do that and also deliver an amazing talk about fascinating technology. If you are interested in learning more, check out his blog here -> http://jeffjonas.typepad.com/. I think that the research he does has just entered on my list "Cool jobs I wish I did at IBM". Don't get me wrong, I love what I do, but I am often amazed by the type of work people do at IBM and the sheer variety of interesting things to learn about.
The first session, Warehouse Best Practices in Action - The IBM Smart Analytics System, went well and there were lots of questions from the audience. I love that , it is much more fun to have a conversation with the audience than it is just talk all by yourself. I also learn a lot from the types of questions people ask. I was co-presenting with Eddie Daghelian, and Haider Rizvi was there as well, so the discussion was lively and very educational for everyone. I did a lot of informal surveys of the audience, and it was interesting, most people could remember the days of DB2 PE (parallel edition), most were taking on-line backups, but very few of them were exploiting the table space level backup and restore functionality. There were a lot of questions and curiosity about Work Load Management, and also about Data Ingest strategies.
I think that is the best part about IDUG - a bunch of people who are really interested in technology, all getting together and just having a conversation. The presentation was really just a jumping off point, as for the rest of the day I had customers coming up to me asking for more information about specific topics in the presentation.
And, on a closing note, I want to say Thank You to Rebecca Bond, Steve Rees, and Calisto Zuzarte, who all made the time to attend the session and were friendly faces I could look for through out the presentation. Thanks Guys - it was hugely helpful to see you there!
I’ve heard Jeff Jonas speak several times and completely agree with Kate that he is phenomenal! During and after Jeff’s keynote, the comments were flying in on twitter about his talk. If you want to keep up with what’s going on, I highly suggest that you open this URL: http://bit.ly/mO4svB.
I copied some of my favourite tweets and posted them on Jeff’s FB wall:
Jeff’s response: I spent 7 hours creating a one of a kind deck for today's 60 minute keynote. Glad someone liked it!
Speaking of Jeff, Kate gave a link to his blog, and I encourage you to read it. Also, here is a recent interview with Jeff along with a very cool video "200 countries in 200 years". http://bit.ly/lVW9ME
Apparently there was a retirement party for Roger Miller last night as well. Another reason I really wish I was able to join my IDUG friends in California this year!
Regardless of where you are on your journey towards mastering DB2, you can never neglect to learn the basics to the fullest. To help you learn the basics, we suggest that you use Ember Crooks as your mentor. She is experienced and is writing a blog series about what she knows. Here are the first 10 in the series:
You can count on Ember to add to this series: http://db2commerce.com/?s=db2+basics. Keep up with the latest by following Ember on twitter: @ember_crooks.
If you like watching videos with tips, be sure to check out the replays on the DB2Night Show. Not only did Ember take part in two seasons of the “DB2’s Got Talent” competition, she acted as a guest judge in the latest season and has been a guest star several times, including this one: The DB2Night Show #133: Why Low Cardinality Indexes (STINK), Ember Crooks.
More about Ember:
Over the last 13 years, Ember Crooks has become an IBM Gold Consultant and IBM Champion, specializing in DB2. Although she deals primarily with high volume transactions, she has taken an alternative route to write a series of blogs focused on the basics. In order to achieve greater level of success with anything, a fundamental foundation needs to be secured in place before building up to more advanced skills.
As usual, host & IBM Champion Scott Hayes has some interesting shows lined up on his award winning webinar series: The DB2Night Show.
October 5, 2012; 11:00 AM – 12:00 PM
"You CAN Teach an Old Programmer New Tricks” with Bonnie Baker, IBM DB2 Gold Consultant
October 12, 2012; 11:00 AM – 12:00 PM
BREAKING NEWS from IBM! Special guest, Les King, Director, Information Management Solutions & Warehouse Development at IBM, tells us he'll have some exciting "breaking" news to share!
October 19, 2012; 11:00 AM – 12:00 PM
“The Joys of Big Data” with Dave Beulke
If you’ve missed any of the shows in the past, remember that they have been recorded and are available for you to watch anytime you like. Here are a few that I’ve blogged about in the past:
In the world of big data, Hadoop is not the answer to every question. While the promise of big data is clear, selecting the right architecture and technologies to invest in is becoming a game-changer for a growing number of organisations. So how do you get ahead? Join IBM technical experts to learn how to maximize your IT opportunities using no nonsense presentations, live demonstrations and real-world performance comparisons.
For the invitation in Chinese, see these links:
Thanks to Steven Rubin for providing me with this information.
svisser1 2700018UK9 Tags:  iod11 db2 ibmchampions mdm ibmsoftware champions idug infosphere 5,358 Views
I bet you know an IBM Champion or two! I know I do. I’ve blogged about this wonderful group in the past and lovingly call them “IBM’s BEST Friends”. In IBM’s definition, IBM Champions are thought leaders and advocates who share their opinions and years of experience with people like you.
These people are recognized by IBM for their extensive contributions to the community and IBM Champions help make IBM communities a vibrant, meaningful and useful resource. IBM Champions are sought after experts in their field, and as such, have become renowned speakers at IBM and user group events worldwide.
At this year’s Information on Demand Conference (iod11), we will have 59 IBM Champions in attendance & speaking. An impressive 80 of the planned sessions across all the Forums and a variety of tracks is being led by one or more of our IBM Champions. The full list of 80 sessions can be found in this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
I’ve been attending conferences for many years now and I’ve become friends with many of these IBM Champions. Take a look at some of the events where a friend of mine is involved:
Roger Sanders: Pre-Conference Certification Class on Sunday Oct 23, 2 book signings: Idea to Print & DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes.
Susan Lawson: Pre-Conference Certification Class on Sunday Oct 23, Up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide.
Judy Nall: Pre-Conference Certification Class on Sunday Oct 23, Book: DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737.
Panel Discussion Speakers: Brian Green, Blue Cross Blue Shield of Tennessee, Manager, BI and Performance Management; John Boyer, The Nielsen Company, Enablement Team Lead; Kay Van De Vanter, The Boeing: co-authors of the book, "Business Intelligence Strategy", session BDS-1670B: How to Deliver BI Program Excellence, Tuesday, Oct 25, 3-4 pm.
Bernie O'Connor: IDUG Friend; Session IDB-3162A Anixter Uses IBM DB2 pureScale and Optim for Mission Critical Applications; 03:00 PM - 04:00 PM
Klaas Brant; Fellow judge on DB2’s Got Talent Competition & Host for DB2Night Show for DB2 for z/OS: Session IDB-2878A DB2 9.7: How to Create, Maintain and Monitor Huge Tables, Tuesday, Oct 25 04:30 PM - 05:45 PM
Cristian Molaro: Friend from DB2Night Show; Several sessions!
Cuneyt Goksu; Future Author; Session IDZ-1012A Practical Recipes for Daily Database Administration Activities Using IBM DB2 9 and 10 for IBM z/OS Monday, Oct 24 02:15 PM - 03:15 PM
Suresh Sane; IDUG Friend; Session IDZ-1179B DB2 10 Customer Experiences Part 1 What's New for the Developer? Monday, Oct 24 02:15 PM - 03:15 PM
Isaac Yassin; IDUG Friend; Session IDZ-1100A A Closer Look at IBM DB2 (z/OS) Member Cluster Tuesday, Oct 25 08:15 AM - 09:30 AM
Dave Beulke; Co-author of book: DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1731A IBM DB2 Temporal Database Performance Designs Tuesday, Oct 25 10:00 AM - 11:00 AM
Sheryl M. Larsen; Session IDZ-3504A More Lessons Learned from SQL Performance Review Tuesday, Oct 25 10:00 AM - 11:00 AM
Bryan Paulsen; Session IDZ-3138A IBM DB2 10 for z/OS: John Deere's Beta Experience Tuesday, Oct 25 10:00 AM - 11:00 AM
Julian Stuhler; Co-author of book DB2 10 for z/OS - Cost Savings ..... Out of the Box; Session IDZ-1425A The Business Value of IBM DB2 10 Top Features - Real Customer Experiences Tuesday, Oct 25 11:15 AM - 12:15 PM
Daniel L Luksetich; Author of up-coming book: DB2 10 for z/OS Database Administration: Certification Study Guide; Session IDZ-1561A Explaining the IBM DB2 for z/OS Dynamic Statement Cache Tuesday, Oct 25 11:15 AM - 12:15 PM
Craig S Mullins; Author of many books including an up-coming book; Session IDZ-1380A IBM DB2 for z/OS Performance Tuning Roadmap, Tuesday, Oct 25 03:00 PM - 04:00 PM
Phil Grainger; IDUG Friend; Session IDZ-1011A Hash Access: The Hierarchical Direct Access Method (HDAM) IBM DB2 Table? Wednesday, Oct 26 02:00 PM - 03:00 PM
Bonnie Baker; IDUG Friend; Session IDZ-3510A DB2 Doctor: Symptoms, Diagnoses, and Cures for Poor Performance Wednesday, Oct 26 04:30 PM - 05:45 PM
David Birmingham; Author of book: Netezza Transformation: Taming the dragon without alchemy, sorcery or strange potions ; Blogger: “Netezza Underground” ; Several sessions, including Unleashing Netezza - Netezza Solution Best Practices Wednesday, Oct 26 08:15 AM - 09:30 AM.
For complete details of the sessions that all the IBM Champions are involved with, see this IBM Champions for Business Analytics, Enterprise Content Management and Information Management PDF document.
Looking forward to going to the conference to see my friends… and to make more friends.
PS… If you follow my blog, you’ll notice that two of my friends are missing from this list: Rebecca Bond and Scott Hayes. Rebecca won’t be attending for personal reasons and Scott doesn’t have any sessions that he’s running, but I hope he’ll be at the conference. If not, I’ll see him in Prague for IDUG.
svisser1 2700018UK9 Tags:  data_quality data_govenance book iodgc article viral_data fishman 5,345 Views
Changing a data structure can be one of the simplest activities to physically perform. However, when considering the number of programs that act upon a data structure, any type of change to a data structure becomes a very complex activity - which may increase the potential for introducing viral data. Read this article by Neal to better understand how you can avoid the massive problems that will ensue if you introduce viral data into your database.
Neal adapted this article from his book, so if you like it, check out the book.
The title of the book “Viral Data” implies that the book is about Data Quality… but there is much more in the book! Check out these terms that also describe the content of the book:
For more information on Neal’s book, see my blog entry about his book signing. This entry contains some reader feedback that you’ll appreciate.
Neal had several sessions at the IOD conference this year. Did you catch any of them?
On Dec 15, you can take part in the Virtual IOD and can possibly “attend” one or more of these sessions. Sign up: IBM Information on Demand Virtual Conference on Dec 15: http://ow.ly/3iLxE