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.
The IDUG DB2 Tech Conference 2013 is scheduled for April 29 - May 3, 2013 in Orlando, Florida. Make your plans to attend now. The IDUG.org website has been updated with detailed information about the conference, including:
This year’s conference will be special for a number of reasons. First of all, this year is the 25th anniversary of IDUG. That’s right, 25 years of great technical education for users, by users. This is also the 30th anniversary of DB2. You can be sure that attendees and organizers will be in celebratory moods throughout the event! Why not come out and join the celebrations?
Also, any IDUG conference that takes place in Orlando tends to be special? Why? Many people like to attend conferences in Orlando so that they can bring their families for part of the week to combine the business travel with a bit of vacation. Orlando has plenty to offer, so while you’re learning, enjoy the weather and the attractions.
Full Day SeminarsIDUG One Day Seminars allow you to take a deep dive into specific aspects of DB2 with some of the most renowned speakers in our industry. Listen to these speakers and ask them your specific questions as well. This year the seminars will be held on Monday, April 29 2013 and the full day experience includes lunch as well as hard copies of the course materials. There is an additional registration fee for these seminars. For details and to register, see: Full Day Seminars at IDUG.
Here are the topics and speakers you can choose from:
Complementary WorkshopsYes, these are free, but be sure to register quickly since they tend to fill up very fast! There are two to choose from and they take place after the official conference is over, on Friday, May 3; from 8 - 2.
For details and to register, see Complementary Workshops.
Technical SessionsThere are hundreds to choose from over 6 different tracks. The list can be found on Agenda, but follow my blog to get highlights and details of many of the sessions.
The first step is for you to get funding from your boss to come to the conference. If you need help with your justifications, see:
Stay tuned for more highlights and details!
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.
I know it seems early to start planning for a fall conference, but I’m sure you’ll agree that time flies! Not only does it fly, but it takes time to put together a justification proposal to attend the conference and to get it approved. If you do it now, you still have a month to take advantage of the early bird special. Register by August 31 and you’ll save $300.
IBM Information on Demand 2012 (#ibmiod on twitter)
Sunday, October 21, 2012 - Thursday, October 25, 2012
Location: Mandalay Bay, Las Vegas, Nevada
Once you register, you can begin building your agenda: Explore the IOD conference with the Sample Agenda Builder that lets you search for sessions by program, track, date or industry. Crysta Anderson shares her sample agenda with an Information Management focus. Read more: http://ibm.co/OhKcEW
I have plans for many blog entries that will drill down into the items mentioned in this entry, so follow my blog to avoid missing any details.
Have you ever been to a DB2 Symposium? They are quite different than a normal conference since they provide 3 full days of learning. This one takes place in Chicago from October 16-18 and provides three-days of training with three parallel tracks.
Each day there are three one day seminars presented by industry leading consultants. You may join for 3, 2 or just 1 day(s), depending on your needs and budget.
There are nine great sessions lined up with award-winning speakers:
Tuesday 16 October
Wednesday 17 October
Thursday 18 October
For further information, use the menu on the left hand side of the DB2 Symposium webpage where you can navigate to the sessions, pricing, location and more.
Thanks to Klaas Brant, KBCE – DB2 Symposium Organizer, for providing me with this information.
You can save up to 35% off the normal prices of IBM Self-paced Training Courses.
IBM's self-paced virtual classes (SPVC) are classes that allow you to set your own schedule yet still deliver the same content, interactive exercises, and hands on labs as IBM’s classroom training.
It allows you to take control of your learning --when and where you want.
For products in the Information Management area, you can choose courses that correspond to 17 different tasks, including Administration, Troubleshooting, and Usage.
Here are the courses that I found that were listed as New:
Register your interest before June 22 to get the Promo code.
When 365 people register their interest, your savings will increase from 25% to 35%.
You benefit by sharing this offer with others. Register now!
svisser1 2700018UK9 Tags:  signings podcast certification authors books education iod11 6,232 Views
I’ve been working on these for the last month and I’m happy to announce that I have the first 7 podcasts finished and ready for you to download and listen to.
At this time I focused on the upcoming book and certification events that are taking place at the IBM Information on Demand Conference later this month. I hope to add many more podcasts to the series and plan to interview experts throughout the IM education area.
As I say in the introduction, this is the series that introduces you to authors, instructions and other subject matter experts in the IBM Information Management area. Here is what I’ve competed so far:
This is a discussion I had with Roger Johnson and Filip Draskovic about their latest book: “IBM Cognos 10 Report Studio: Practical Examples”.
Episode 2: Conversation with Roger Sanders
This is a discussion I had with Roger Sanders about his latest book “DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes”.
Episode 3: Conversation with Bob Laberge
This is a discussion I had with Bob Laberge about his latest book "The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights".
Episode 4: Conversation with Susan Weaver
This is a discussion I had with Susan Weaver, the program manager for the IBM Information Management Certification Exams and the procedure to take them for free at the IBM Information on Demand Conference.
Episode 5: Conversation with Sunil Soares
This is a discussion I had with Sunil Soares about his latest book: “Selling Information Governance to the Business: Best Practices by Industry and Job Function”.
Episode 6: Conversation with Roger Sanders
This is a discussion I had with Roger Sanders about his latest book "From Idea to Print - How to Write a Technical Book or Article and Get It Published".
Episode 7: Conversation with Martin Keen
This is a discussion I had with Martin Keen from the IBM Redbooks team. We discussed what the IBM Redbooks are and the books that will be handed out at the IBM Information on Demand 2011 Conference.
There are so many people I’d like to interview for this series and now that my editing skills are improving, I’ll be able to do them more often with increasing levels of quality. If you’d like to do a podcast with me, let me know.
I hope you like these. Share your feedback.
svisser1 2700018UK9 Tags:  infomgmt education books facebook im certification information_management fan 5,523 Views
And… here’s another Facebook change:
We have a NEW Facebook page!
Enjoy the new page!
svisser1 2700018UK9 Tags:  ibm mdm education im infosphere db2 web-based courses elearning wbt 10,293 Views
At this time there are 82 Web-Based Training (WBT) Courses available for you to take to sharpen your skills on IBM Information Management (IM) products and technologies. Eighty-two is a LOT of courses! More are being created and being updated, so if this is the way you like to learn, make sure you stay in touch with all the latest as they are released.
IBM’s Education is known for its high quality content and excellent instructors. Although with WBT courses you won’t be in a classroom environment, you’ll get the same quality of content that you expect. WBT courses allow you to learn at your own pace and on your schedule with training that is completely self-contained from your desktop. Most courses provide introductory and overview training that serves as the foundation for more technical and follow-on training. Courses include expert instruction but do not include hands-on labs.
How do you get there?
DataStage Essentials - Web Based – UpdatedProgramming for InfoSphere Streams V2 - Web Based - New
I hope you’ve found one or two in this massive list that interest you! Take the course and let me know what you thought of it.
svisser1 2700018UK9 Tags:  newsletter soliddb courses ibm education training skills db2 learning infosphere 5,953 Views
I got this information from a newsletter that I subscribe to and thought that you may be interested. IBM continues to invest in creating education that is timely, well-designed, and highly-rated, therefore you can continue to expand your skills so that you can perform at your optimal level.
Here are the IBM Information Management courses have recently been updated:
You can view all IM training classes from this link: View all Information Management training
The newsletter I subscribe to is: IBM Training News.
To subscribe to this newsletter and many others, click here: Subscribe. Once on this site, you can choose the product and technology areas that you are interested in seeing in your newsletter and the newsletter is custom-built to your requirements.
Keep your skills as sharp as they can be!
svisser1 2700018UK9 Tags:  learn webinar hayes free hornibrook db2night db2 statistics education 5,896 Views
Sadly I missed John Hornibrook’s fourth appearance on the DB2Night Show that took place on Friday, Sept 9th. Did you miss it as well? There is a replay available (Thanks Scott!). You can find it here:
To download a recorded replay of Episode #57, right click on the link below and choose "Save As..."
What was John talking about? DB2 LUW Vital Statistics. 94% of the audience said that they learned something new during the talk… so you can expect it to be very informative. John’s previous visits:
This show, #57 in the DB2 for LUW series, marks the kickoff of Season #3. Since the show's inception, there have been over 90,000 downloads of replays to date. The library of FREE DB2 LUW Education is enormous and growing! Check out these valuable educational resources by watching REPLAYS whenever and as often as you can.
Also, never miss another show. They take place pretty much every Friday from 11:00 – 12:00 ET, so block your calendar to make time for a weekly learning opportunity. Take a look at the schedule of upcoming shows. As always, a very impressive line up.
Thanks to host Scott Hayes for Engaging, Entertaining and Educating us!
svisser1 2700018UK9 Tags:  exam mastery education biginsites apache iod11 certification bigdata hadoop conference 8,088 Views
What do you know about IBM InfoSphere BigInsights?
BigInsights brings the power of Apache Hadoop to enterprises. This means that by using InfoSphere BigInsights, you can manage and analyze data in ways that were previously unimaginable. You an extract deep insights that can lead to greater efficiencies, value-add services, and opportunity for transformation.
That’s not much to go on, but what I can tell you is if you’re interested in learning more, take advantage of the special one-day class on Sunday, October 23, 2011 in conjunction with the IBM Information on Demand 2011 Conference in Las Vegas, Nevada. Registration for the IOD Conference is NOT required to attend this Sunday class.
This one-day training course is for system administrators and developers responsible for managing Apache Hadoop. Not only will you learn about this new technology, but after you’ve taken the course, you’ll be prepared to take and the BigInsights Technical mastery test, which you can take for free at the IOD conference.
More about the Mastery Exam: Test M97: IBM BigInsights Technical Mastery Test v1
This proctored technical mastery test examines IBM BigInsights knowledge regarding the ability to identify, manage and close sales opportunities.
This technical mastery test meets one of the technical requirements for SVP (Software Value Plus) and counts as a skill towards Advanced and Premier PartnerWorld Membership levels. It is strongly advised that the candidate complete the recommended education prior to attempting this technical mastery test.
Other Pre-Conference Education available at IOD this year: Other blog entries about IOD Events: Susan
Other Pre-Conference Education available at IOD this year:
Other blog entries about IOD Events:
Today I registered for the IOD conference, requested a hotel room and certified that I’ll be presenting this year. Now it is time to start using the SmartSite to schedule my time. The conference takes place in Las Vegas, Nevada at the Mandalay Bay Hotel during the last week of October 2011. I hope you plan to come!
If you are planning to register, remember that you can save $300 by registering by Aug 31!
As you may know, I manage the book signings that take place at the bookstore conference, and as in previous years, we have a very full schedule planned. I’m busy building the schedule right now, so I can get the book signings added to SmartSite as we did last year.
As a teaser, I’ll tell you this:
1) We will be launching 2 new certification guides.
2) We’ll be giving out 3 brand new Flashbooks.
3) Michael Lewis will be signing his many books… some of which have been made into movies.
4) There are 8 new technical books launched at the conference that will appeal to you.
Stay in touch and I’ll reveal details as I can.
There are many reasons to attend! Amazing speakers, deep technical education, free certification exams and more. See the Justification information on the website for more reasons.
svisser1 2700018UK9 Tags:  testimonials db2 information_management education books im 5,974 Views
I quite often talk to people who have achieved some sort of benefit from taking advantage of the many training resources that IBM provides in the Information Management area. My team is trying to pull together some testimonials from people who have used and liked one or more of the resources that are available. We’d love to talk to you if you have a story. Simply send me an email and we’ll go from there!
One thing about IBM is that there is NO shortage of options for you to choose to increase your skills and learn about IBM products and technologies! You can find options that are free and easily accessible to custom designed courses to suit the specific learning needs of your employees.
Why are there so many options? Learning is one of the most important things you will do in your lifetime and is something that you do from the day you are born until you die. We don't all learn the same way though, so having a choice of options is very important so that you can find the learning method that is best for you.
Here is a list of the learning options that are available for the Information Management products and technologies.
e-books - Many choices are available ... many are free, but you can also read books on electronic reading devices such as Kindle. See my blog entry "The Year of the e-Book".
IBM Redbooks - The PDF versions can be downloaded for free and books are available for a very wide range of topics. See the IBM Redbooks web page and my blog entry with a few IBM Redbook recommendations.
Gaming - 3 games are available to help you learn SQL in a fun way.
White papers - A white paper is an authoritative report or guide that often addresses problems and how to solve them. White papers are used to educate readers and help people make decisions. For a list of whitepapers, google search "db2 whitepapers".
Virtual Conferences - Last year there were several virtual conferences that were run by IBM that allowed you to "attend" a conference via your computer. I don’t know of any that are active right now, but will post a future blog entry when one is available.
Retail books -IBM Press, MC Press, McGraw-Hill, Apress, O'Reilly, Packt are the publishers who have invested in publishing about IBM products and technologies. For a listing of books by topic, see our bookstore website . For a list of books that were recently published, see my previous blog entries.
Instructor-Led Training (ITL) classes are traditional classroom courses where students are in the same room as the instructor who guides the students through classroom material and hands-on lab exercises. Students are able to interact with fellow students and the instructor and are provided with printed course material.
Instructor-Led Online (ILO) classes are equivalent to ILT classes in terms of classroom material, labs, instructor and fellow students, only you won't need to leave your home or office as you will connect to the classroom via your computer. See my blog entry about ILO classes.
Self-Paced Virtual Classes (SPVC) are for students who don't need the instructor or don't want to be tied to a class schedule. These classes are typically lower priced than ILO or ILT classes meaning that you save on travel and tuition costs. Content, labs and instructors are the same as ILO and ILT classes, but it is recorded so the class can be taken at your pace, where and when you want it. See my blog entry about SPVC.
Web-Based Training (WBT) are standalone courses on the web that provide 6-8 hours of instruction. These are typically voice over power-point format.
Custom Classes are available for companies that want training to take place on their premises with course material that is taken from multiple existing courses and changed to suit specific needs.
We REALLY want to hear from you…. so if you’ve used any of the above resources and have a story to tell, let me know! Emal: firstname.lastname@example.org
Read through my previous blog entries for more free or almost free resources:
Here are articles and white papers that I've read that emphasize the importance of continued learning:
Whitepaper The Value of Training shows that by cutting skills development and training budgets in the hopes of improving gross margins will cause higher attrition, higher support costs, and the risk of falling behind in technological advances.
Article 5 surefire ways to get fired by Denise Dubie shows that the best way to KEEP your job is by continually growing your skills.
Whitepaper DBA Certification: Is It Worth It? by Howard Fosdick compares the costs to the benefits of earning a DBA certification. This white paper is a few years old, but the message is still valid.
Article "Is certification valuable, or not? We have the definitive answer" by Linda Musthaleris says that companies need high-functioning teams that are able to transform and grow the business like never before. These teams consist of highly skilled professionals who have current and relevant knowledge. Certifications are designed to encourage people to keep learning and then to validate their skills.
The results of the IDC study in the November 2009 report by Cushing Anderson called "Impact of Training on Network Administration: Certification Leads to Operational Productivity" shows "a direct relationship between higher levels of certification and improved performance -- when team skills improve, organizational performance increases proportionally."
svisser1 2700018UK9 Tags:  best_practices db2night education webinar free performance warehouse 5,564 Views
The DB2Night Show first launched in September 2009, and since that time, there have been many requests from the DB2 LUW community for an episode on DB2 LUW Data Warehouse Performance Tuning. It took a while to find the best speakers, but the ideal guests will be on Friday’s episode, which is the Season 2 Finale.
Join Kate Kurtz, Haider Rizvi and Gregor Meyer as they share with IBM recommendations and suggested best practices for optimizing performance of Data Warehouse Databases. If you're trying to make DPF or multi-partition databases run queries as fast as possible, then you should sign up for this show.
Topic: Recommendations and suggested best practices for optimizing performance of Data Warehouse Databases
Speakers: Kate Kurtz, Haider Rizvi, Gregor Meyer. Host: Scott Hayes
Date: Friday, June 24
Time: 11:00 ET
About the speakers:
Haider Rizvi is a Senior Technical Staff Member (STSM) in the Information Management division at the IBM Toronto Lab. He is responsible for the IBM Smart Analytics System architecture and design, a data warehousing solution built using the InfoSphere Warehouse software, IBM servers and storage systems. He is interested in data warehousing performance issues both at the code level as well as systems configuration and tuning.
Haider joined IBM in 1994 in the DB2 Parallel Edition development team. Since then Haider has been working towards improving the DB2 product for data warehousing workloads. He has an M.S. in Computer Engineering from Rice University, Houston and an M.B.A. from the Ivey School of Business, University of Western Ontario.
Gregor Meyer: Data Warehouse Architect, Boeblingen Lab, Germany
Katherine Kurtz has been a member of the DB2 development team since 1997 and is currently an Information Development Manger for DB2 LUW and the IBM Smart Analytics System for the DB2 LUW Development team at the IBM Canada Lab in Markham, Ontario. She holds a Bachelor of Mathematics (Computer Science and Pure Math) from the University of Waterloo and a Bachelor of Education from the University of Western Ontario. Katherine’s work is focused on understanding how customers use our products, and how IBM can make our products more consumable through the sharing of best practices that incorporate insight from IBM technical leaders in the Lab and in the field. Katherine also has deep experience in DB2 System Verification and Test, SAP/DB2 Integration, customer support, performance development and release management.
The DB2Night Show now has a LinkedIn Group - join us to stay up to date on our show and discuss show episodes! The group registration link can be found on www.DB2NightShow.com. We hope you will join us and participate as a studio audience member. One studio audience member will be randomly selected to win an electronic gift certificate! If you can't make the scheduled time, register anyways so that you get information about recorded replays.