Keep on Learning
Today I launched a Certification Checklist on My Developerworks that you can use to track your progress on following the steps required to earn a certification: Getting Started Guide to DB2 Certification. You can use most of the steps in this checklist to track your progress for any IBM software certification, but many of the steps are specific to DB2. I would like to expand the list in the future, but started with the basics.
Please note that you'll need to be logged into My Developerworks in order to access and use the template.
What is a checklist template?
A Checklist template allows you to create a copy of the steps that must be take to achieve a specific goal (in this case to earn a certification). By creating a copy of the checklist, you are able to check off the tasks as you complete them (or if they are not applicable to you) so you can keep track of your progress. You can set specific deadlines for completing each step and use My Developerworks to keep you on top of the schedule.
This is the first checklist that I've created, so I'm sure there are areas for improvement. If you have suggestions for how I can improve this checklist, I'll be happy to hear from you.
Frances Pastuszenski was my mentor for creating this template and I encourage you to follow her checklist for "Getting Started with My DeveloperWorks" and to read her blog entry about her checklist.
svisser1 2700018UK9 Tags:  iod tutorials skills fired certification books 3 Comments 10,707 Views
I subscribe to many newsletters and was reading through them this week..... the one that caught my attention the most was this:
5 surefire ways to get fired by Denise Dubie
I don't want to get fired... and I'm sure most of you don't either! So, reading the article I found that one of the best ways to KEEP your job is by continually growing your skills! I can give plenty advice as to how you can grow your skills... and not all of them require a great deal of time or money!
I've blogged about how to get certified many times. The only thing I want to add at this point is that you can use the path to get certified as a roadmap for building skills. You will learn a lot but will also have validation that your skills are up to par by passing one or more certification exams. For further information on how to start, see my blog entry "Certification 101". To make it even more cost effective for you to get certified, we have Certification Days where exams are offered half price, and a Try it Again offer that allows you to retry your exam if you failed to pass. In my opinion, getting a certification is the FASTEST and most COST-EFFECTIVE way to build skills... bar none!
Travel is expensive, so take a look at the new way to take an IBM class where you choose the time, place, and best of all, no travel involved! Self-paced Virtual Classes are one option, ILO classes are another. Right now, you can take a free SPVC to see how it works.
Another very cost-effective way to build skills. You can buy a printed book, read a book online, borrow from a library... whatever works for you. There is a wide selection of books available... that cover just about every topic imaginable. For the entire list of books that we have available for Information Management topics, see either DB2 in Books or IM Bookstore. The online engines where you can read books are Books 24x7 or Safari Books Online. You can read more about these options in my blog entry.
OK... a conference is very expensive... but is it really? If you factor in all that you get when you attend a conference, you may find that it is very cost-effective. The IOD conference has free certification exams, 400 technical sessions, demos... not to mention networking! See Kate's blog for a series of entries about the IOD conference. Another option is to attend a virtual conference. I don't know of any that are scheduled at this moment...but when I learn about one, I'll blog about it. Sure it is quite different than attending a conference in person in a city away from your home / office, but it still provides some training, demos, and networking, but is usually free to attend.
So, please! Don't get fired because you've let your skills stagnate! Keep up to date with the many options that are available to you!
svisser1 2700018UK9 Tags:  webinar docs bestpractices db2night db2 flashbooks free 2 Comments 12,761 Views
Many of my blog entries had their origins in a question posed to me. Earlier this week someone asked me for some free resources that can be used to stay on the cutting edge of all DB2 changes. I went through recent blog entries and without much effort, I was able to come up with 10 different types of free stuff. Check it out:
and now I get to add 2 more.
11. FREE - Learn from experts via Best Practice articles for DB2 for z/OS: http://ibm.co/eTXbRd
12. FREE – 3 certification exams for attendees of IDUG Tech Conference: http://ibm.co/giLoQA
That’s a lot of FREE! I hope you like.
If you're reading this blog entry, then you're probably knee deep into the social networking that is available. Personally I'm very much into social networking and can't remember what I did before these tools were available.
In this entry I give details on the sites that I am aware of ... and use on a regular basis. I know my list is not complete... so if there is something that you think I should be aware of, please let me know!!
There are so many blogs these days with more being added all the time.... so how can you find the best blogs to read? I suggest that you use aggregator sites where you summaries of many blog entries so you can choose which appeal to you the most. For the IM world the best place to go is PlanetDB2.com. My blog is there as well as blogs from Kate Dawson, Leon Katsnelson, Chris Eaton, Craig Mullins, Grant Hutchison, and many many more! Of course once you begin reading some of these blogs, you can become a fan and can get the entries sent to you directly through RSS feeds.
For a broader range of topics, I suggest looking at the developerWorks blogs. My blog is hosted by developerWorks, so you can find it there as well, but you will find many interesting entries on a wide range of topics.
The difficult thing about Facebook is whether to use it for personal or business reasons. There seems to be quite a few lines being crossed which may cause discomfort for some people. For most of us who write blogs and have Facebook accounts, we automatically pull our entries into our Facebook profile. There are many product fan pages that you can join as well including many from IBM. Some groups you can join are:
I've always had a LinkedIN account for business reasons but only recently have I started to use the groups that are available. I've been very impressed with the amount of interaction taking place in these groups. My only regret is that I don't have enough time to read all the articles that I'm interested in! One of the pros about LinkedIN is that you could separate personal from business by keeping Facebook for personal uses and LinkedIN for business purposes. There are at least two levels available when joining LinkedIN. I have the basic membership and find it incredibly useful. Here are some groups that I like:
This is such a rich site, it is hard to figure out where to start! You can make connections with other devWorks users and create a profile for your personal accomplishments. There are many groups and communities that you can join. I mentioned the wide variety of blogs that are available. The richness of devWorks lies in the content that you can access. Tutorials, Skills Kits, ekits, articles, videos, checklists, downloads, and much more. developerWorks covers a huge variety of topics that covers every software brand and technology that IBM cares about. To find something specific, use the amazing search engine in developerWorks to find what you need. Join developerWorks and then check out these groups:
I call this site a hybrid of many of the sites listed above. It calls in the blog entries from PlanetDB2.com; you can have a network of friends like Facebook; there are groups that you can join to discuss topics with other interested parties like LinkedIN; you'll find a collection of presentations, videos, and links like developerWorks. One thing that is unique about this site is the amount of representation from academic environments. You can find groups for specific countries as well as specific universities. Here are a few of the groups that I follow:
This is the one piece of social networking that I do not use. I understand how powerful it can be, but just don't think that I have the time to get involved with tweeting at this time. Here are a few that I've heard of:
Books on Social Networking
Like all popular topics, you can find a book to read that can teach you how to go deeper in any or all of these topics. Here are a couple of recent titles from IBM Press that you may find interesting:
Reminder: Join me on the DB2Night Show... Friday, Feb 12 at 11:00 EST. The DB2Night Show Episode #12
Yesterday I blogged about the benefits of getting certified.
Today I want to tell you about how to prepare to take and pass an exam.
How to Prepare to Pass a DB2 Certification Exam
1. 1. Read the exam objectives. The website ibm.com/certify lists the objectives for every IBM certification exam. Read these carefully as each question on the exam links directly back to one or more of these objectives! (That’s a huge hint!)
2. 2. Use the recommended study materials to refresh your skills. For each DB2 exam, you can find the recommended study material on this site: ibm.com/software/data/education/certprep.html.
3. 3. Take an assessment exam. These exams cost $10 per take. See ibm.com/software/data/education/cert/assessment.html for the latest information.
4. 4. Take the test. Where? IBM exams are offered worldwide at Prometric Testing Centers. To find a site near you call 1-800-959-EXAM or visit www.prometric.com.
5. 5. If you do NOT pass, use the score report to determine the areas you need to increase your knowledge and start these steps over again.
6. 6. If you PASS, make sure you let your manager know! Your results are confidential to YOU and no one will know you passed unless you tell them!
** DB2 Certification exams are experience-based, so the more practical experience you have using DB2, the easier it will be for you to prepare and pass the exams.
Expected to publish July 17, 2009, order now from amazon.com and save 37% ($18.50)
Authored by two of IBM's leading experts provide the single most comprehensive coverage of DB2's pureXML capabilities. This book explains DB2 pureXML in more than 700 practical examples, including 250+ XQuery and SQL/XML queries, taking the reader from simple introductions all the way to advanced scenarios. The authors have distilled their hands-on experience with many pureXML applications so that you can benefit from best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere. This book is invaluable for database administrators and application developers, beginners and DB2 experts. The topics are organized by typical user tasks throughout the life cycle of XML database projects, from planning, designing, and implementing databases all the way to tuning, problem determination, and application development. It includes code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers. The DB2 pureXML Cookbook provides proven recipes rather than a mere reference of ingredients.
About the Authors
Matthias Nicola is a Senior Software Engineer for DB2 pureXML at IBM's Silicon Valley Lab. His work focuses on all aspects of XML in DB2, including XQuery, SQL/XML, XML storage, indexing and performance. Matthias also works closely with customers and business partners, assisting them in the design, implementation, and optimization of XML solutions. Matthias has published over a dozen articles on various XML topics and is a frequent speaker at DB2 conferences. Prior to joining IBM, Matthias worked on data warehousing performance for Informix Software. He received his doctorate in computer science from the Technical University of Aachen, Germany.
Pav Kumar-Chatterjee has worked with DB2 since 1991 on DB2 for z/OS and since 2000 on DB2 for Linux, UNIX, and Windows. He is currently employed by IBM as a technical sales specialist for Information Management in the United Kingdom. He has helped customers implement the XML Extender product with DB2 V8 and has presented on DB2 and XML in the UK and around Europe.
To tie you over till the book is in your hands, here are some websites for you to check out:
I received my copy of Sam Lightstone's latest book: Making it Big in Software. What chapter should I read first? I think I'll start with Chapter 14: "Zen and the Critical Art of Balance". Why this chapter? I think software developers are notorious for NOT HAVING A LIFE! I must admit that working in the software business (and for IBM for that matter) can be all consuming and never ending... and maybe a bit addictive. Can a balance be achieved? I think it can and I'll let you read what Sam says about the subject.
The only hint I'll give you is the last paragraph that Sam wrote in this chapter:
"Careers do require hard work and enthusiasm, and those are attributes that encourage people to spend more time at the office. Finding your own balance is hard, but if you discover the Philosopher's Stone that helps you get it right, you'll have done the best possible service to your career and your life. No other tactic or vice will serve you better. With only one life to lead, it's definitely worth the effort".
Thanks Sam for helping all these hardworking people achieve a balance in their life while pursuing a very gratifying career in software.
PS... the book is now available for purchase, but it appears that amazon is still saying that it hasn't been released and are offering their standard 34% discount while it is in this state.
I was planning to blog about IBM's Academic Initiatives today, but while doing research I keep being reminded about how important it is to have excellent writing skills.
In the Certification Magazine in the article "Buzzwords your Resume Doesn't Need" I read the following:
Written skills are becoming more and more important for IT professionals to possess, especially as tech workers communicate with others throughout the organization on projects and proposals. But as the old saying goes, show, don’t tell, the hiring manager about your abilities. Demonstrate with your resume and cover letter that you know how to get your ideas across on paper — or on the computer screen — through clear and concise writing and by carefully checking for any typos or grammatical errors before submitting your application materials.
Yesterday I attended a web seminar called "Unwritten Rules: What You Don't Know Can Hurt Your Career" and found that communication is very important in career advancement. Communication in this presentation was largely focused on discussing your expectations with management regarding your career advancement options and expectations, but communication to gain visibility was also a key point. Tell people what you have accomplished and get noticed by writing well.
Then of course Jeff Jonas making the following plea on facebook: "Note to universe: emails over 200 words are very hard to find time to read. Do summarize!"
My favourite was the Macleans article "Do your prof a favour; Write Better!"
A few weeks ago I was invited to be a guest lecturer to a Masters of Computer Science class at York University about how the can improve their writing skills. This is my second time delivering this presentation that was created by Roger Sanders who is also writing a book about the same topic. The presention is entitled "The Art of Technical Writing" and the book will be published this year by MC Press. I don't see a link on the web for this book yet, but will be sure to tell you about it when it is released.
I won't tell you everything that I passed onto the students, but here are a few general guidelines:
1) Go as deep into your TOC or outline as you can... before you begin writing. This will ensure that you have a plan and can help prevent writer's block.
2) Keep your audience in mind when creating the outline and as you write. I guess I should have said "define your audience" first as this is a key step. Don't fall into the trap that what you are writing will appeal to EVERYONE! It won't... and shouldn't.
3) Don't try to impress with a large vocabulary or difficult sentences. Even sophisticated readers like to read concise, well-written sentences rather than complicated words and sentences where they may have to read them twice to get the proper meaning.
4) Vary the size of your sentences. Some long, some short. If you do all the same, it may be boring to read.
5) Avoid the passive voice... stay active. This can be hard to do.
6) Review your own work. Read what you wrote... out loud to yourself, out loud to others, have the computer read it to you... whatever it takes. If you hear the words spoken you can easily spot the parts that are difficult and need revision.
7) I like Roger's recommendation to reveiw your manuscript several times, each time with a specific purpose. For example, read through looking for where you used the passive voice and fix those. Then review again for grammar. Then to make sure lists and headings are parallel. Then to ensure that diagrams and tables are properly labelled. And on and on. It is easier to be consistent if you look for specific problems each time through your manuscript.
8) Be sure that you need to include a diagram or table before including it. I tend to skip diagrams and tables unless it makes it much easier to understand the concepts that are being discussed. I've heard other people admit to skipping them as well. Don't include diagrams and tables as filler.
9) Have someone else (or several other people) review the manuscript for you. When you get feedback... do not take it personally. Your reviewer is NOT critisizing you as a person... but is giving you feedback to improve what you wrote. You don't have to make all the changes that are recommended to you, but do take the feedback seriously. If you don't get feedback at all.. don't assume what you wrote is perfect. It never is! All authors have been shocked to find simple errors in their books even after they were reviewed endlessly by experts.
10) Learn from your mistakes and actively look for ways to improve your writing skill. Writing is a skill and can be learned by paying attention and learning from your mistakes and from others. I strongly encourage you to read Roger's book when it publishes as it will help you in ways that you can't yet imagine.
While I'm on the topic of writing, I should point out that my job is Publishing Program Manager for IBM Information Management. I'm happy to say that I am continuously meeting people who have a desire to write a book. I can help you with that goal if it is one of yours. The first thing you'd want to look at if you are interested in writing a book is this site that gives help on writing a proposal for your book: Proposal Guidelines.
Writing is an important skill for you to have, regardless of your career, so I hope I've helped on some small way to encourage you to continually improve this skill.
Last week my 4 blog entries centered around why and how to get certified in DB2. So, once you've earned your certification, what's next? The latest Certification Magazine answers this very question. I encourage you to read the article: I'm Certified, Now What? by Lynn Lawton.
Share the News
The fact that you passed a certification is NOT broadcast to the world. This is something that you should do yourself. Tell your management, update your profiles on facebook, linkedin, plaxo, etc, add details to your email signature line, add details to your business cards. In short, tell everyone in the biz that you have put the initiative in to study, learn, and pass a certification exam and you should be very proud of your accomplishments.
Put it to Use
You must have learned something during your learning journey... and hopefully what you learned will help you become more efficient or effective at your job. Or perhaps you learned about a new feature or way of doing your job that will have far reaching effects. Practice what you learned. In addition, did the certification that you earned simply a stepping stone to more advanced topics? Check through the roadmaps to see if there are deeper achievements waiting for you. For example, if you've earned a DBA Certification, consider trying for the Advanced DBA Certification. Build on what you have just learned.
Expand your Network
With your added knowledge, are you now qualified to answer questions on forums or in newsgroups? Are you now able to write articles? Join professional groups? I would suggest that you look at PlanetDB2.com, ChannelDB2.com, groups on LinkedIN, Facebook fan pages, etc. Wherever product experts gather, you should see if you are able to join and contribute.
Display the Accomplishment
Print your certificate... give one copy to your boss and frame another to display in your office. Be proud of your accomplishment and brag about it. If you are in a consulting role, perhaps this certification will open up new opportunities for you and the certificate can be presented to your clients.
Consider a Job Search or Raise Request
It won't hurt to ask.... is it time for a raise or a job change? A new certification might be the stepping stone to something better.
Teaching is a great way to strengthen your knowledge about any topic. Now that you are certified, can you encourage and help others achieve the same goal? Can the need for certification become a department or company wide goal and future achievement? Wouldn't you prefer to work with people who at least know what you do? Think of the synergy that can come from working with equally educated team members.
Achieving a certification is a great accomplishment, but in no way does it mean that you know everything that there is to know. You must put what you learned into practice, recommend better ways of doing things, and continue to learn. One mistake that I saw people making a few years ago is that they didn't think that they needed to re certify when a new product level was released. This is an incorrect assumption. If the vendor thought that it was worth updating an exam (usually at significant cost) then it is worth you retaking the exam to be sure that you are aware of the latest features of the latest products.
Do you have any other suggestions for what people should do once they've received their certification? If so, let me know!
In the past 10 years, I’ve met many people who have taken and passed one or more DB2 certification exam. I like to chat with people, so I usually ask them to tell me if they see benefits to passing an exam. I also meet with many people who are reluctant to take an exam and must convince them of the benefits. I’ll put a few of my findings in this post, but I hope that I hear from people if they agree or disagree!
People who are reluctant to take a certification exam are usually reluctant due to fear. Fear of failure, fear of taking a test, fear of having others learn their scores, or fear of being judged or ranked. I totally understand these fears! The first thing I want to stress about certification exams is YOUR SCORE IS CONFIDENTIAL TO YOU. Sure the score is captured by a computer system and is sent to IBM to be stored in a DB2 database, but we are governed by very strict privacy laws that prevent any of this information to be given to anyone except for the candidate who is taking the exam.
This should give you a sense of comfort that you can take the exam without anyone knowing. So if you fail, feel free to try again! Use the score report to help you strengthen your knowledge in the areas where you didn’t do so well. If you do pass the exam, you must tell your managers, customers, clients, etc. Only you can brag about your certification!
Another thing that you should keep in mind is that each exam has a cutscore assigned to it. You can think of a cutscore as the mark you must reach to pass the exam. To come up with a cutscore, we have a team of experts take the exam and then rank each question in terms of difficulty, importance to the job role, and frequency that the task is performed. As an example, the cutscore for Exam 731 is 59%. Since there are 64 questions on the exam, you must answer 38 questions correctly to pass the exam. As a result of passing the exam, you will be sent a certificate stating that you are now IBM Certified. Your certificate will look the same whether you score 59% or 100%!
I also suggest that you don’t play the “score” game. I’ve heard conversations where people are bragging about their score or candidates who are pressuring themselves to score better than one of their co-workers. I can tell you that most of the people bragging about their score are embellishing slightly! It’s best to not discuss your score in the first place.
One of the biggest benefits of passing a certification exam is that it proves that you are very proactive at keeping your skills up to date. Anyone can say that they know about the latest features of a product, but by passing a certification exam, you have validation that you do indeed understand the latest features. Although DB2 certifications are very popular and still growing in numbers, the number of people who actually [i]have[/i] a certification is a fraction of the number of people who [i]could[/i] have a certification. If you are certified, consider yourself as part of a relatively small group! A second benefit is that studying for a certification will expose you to areas of the product that you wouldn’t normally care about. Very few people have hands-on knowledge of EVERY feature in a product, so when studying for, and taking the exam, you will be exposed to more features than you normally use. Perhaps you’ll discover a feature that will really help your application or in the usage of the product.
One of the benefits that I mention to the developer in the Toronto Lab who create the DB2 product is that it will allow them to see the product as our customers use it. Not many of us in the Toronto Lab work as DBAs, so by passing the DBA exam, it exposes us to the tasks that DBAs must perform in their daily jobs. It seems to me that this will help IBM create better products! The same is true for those who are writing about the product, supporting it, testing it, or even selling it.
A team of us are trying to scientifically determine the actual benefits of being certified, but in the mean time, my team ran an informal survey asking what the benefits were. Here are some of the responses:
What do you think? Have you experienced any of these benefits? Are there other benefits that you experienced?
I’m looking forward to hearing from people.
svisser1 2700018UK9 5,076 Views
DB2 9.7 is now available, and you should consider giving it a try. Why?
1) You can download DB2 Express-C for free to see how the latest features work.
2) I've had the pleasure of reviewing the latest edition of the "Getting Started with DB2 Express-C" free book. Raul and his team did an amazing job writing a short book that covers just about everything that you need to know to get started using DB2. The latest edition isn't posted yet, but should be really soon.
3) Compression, WLM, and SQL/PL are the big stories. Did you see the cool video that explains how great these feature is? The video is actually the Technology Update Chat with the Lab.... watch it :)
4) 35% Improvement in DBA Efficiency
5) Lower Server and License Costs
6) Lower Storage Costs
7) Easier XML projects
8) Peace of Mind
9) Free update for customers with DB2 support!
For these and all reasons, check out the IBM Upgrade to DB2 9.7 website.
A couple of years ago, an author who I’ve worked with on a few projects, Dan Wolfson, introduced me to his friend Mandy Chessell who was interested in writing a book. A few months later, Mandy was in Toronto and we met to discuss her book. She told me that it was based on work that she was doing with her clients and that many of her clients were very excited to get their hands on this book.
Mandy showed me the work that she had already completed and I was astounded at the level of completeness and quality that she had already put into the book. I introduced her to the people at IBM Press and the book was accepted and after much more work... the book is complete and will publish next week! I’m looking forward to getting my hands on the book and intend to read it cover to cover.
Here are details about the book, Mandy, and her co-author Harald Smith.
Use Best Practice Patterns to Understand and Architect Manageable, Efficient Information Supply Chains That Help You Leverage All Your Data and Knowledge
In the era of “Big Data,” information pervades every aspect of the organization. Therefore, architecting and managing it is a multi-disciplinary task. Now, two pioneering IBM architects present proven architecture patterns that fully reflect this reality. Using their pattern language, you can accurately characterize the information issues associated with your own systems, and design solutions that succeed over both the short- and long-term.
Building on the analogy of a supply chain, Mandy Chessell and Harald C. Smith explain how information can be transformed, enriched, reconciled, redistributed, and utilized in even the most complex environments. Through a realistic, end-to-end case study, they help you blend overlapping information management, SOA, and BPM technologies that are often viewed as competitive.
Using this book’s patterns, you can integrate all levels of your architecture–from holistic, enterprise, system-level views down to low-level design elements. You can fully address key non-functional requirements such as the amount, quality, and pace of incoming data. Above all, you can create an IT landscape that is coherent, interconnected, efficient, effective, and manageable.
About the authors:
FREng CEng FBCS
Mandy has worked for IBM since 1987. She is an IBM Distinguished Engineer, IBM Master Inventor, and member of the IBM Academy of Technology Leadership Team. As the chief architect for InfoSphere® Solutions in IBM’s Software Group, Mandy designs common information integration patterns for different industries and solutions.
In earlier roles, Mandy’s work has focused on transaction processing, event management, business process management, information management, and model-driven development. This breadth is reflected in her invention portfolio, which to date stands at over 50 issued patents worldwide.
Outside of IBM, Mandy is a fellow of the Royal Academy of Engineering and a visiting professor at the University of Sheffield, UK. In 2001, she was the first woman to be awarded a Silver Medal by the Royal Academy of Engineering, and in 2000, she was one of the “TR100” young innovators identified by MIT’s Technology Review magazine. In 2006, she won a British Female Innovators and Inventors Network (BFIIN) “Building Capability” award for her work developing innovative people and the BlackBerry “2006 Best Woman in Technology - Corporate Sector” award. More recently, she was granted an honorary fellowship of the Institution for Engineering Designers (IED) and she won the “2012 everywoman Innovator of the Year.” For more information on Mandy’s publications, see http://en.wikipedia.org/wiki/Amanda_Chessell.
Harald has worked for IBM since 2005. Harald is a software architect in IBM’s Software Group specializing in information quality, integration, and governance products, and is IBM certified in delivering IBM Information Management solutions. In this role, he develops best practices, methodology, and accelerators for common information integration use cases.
Harald has 30 years of experience working with data quality products and solutions; product and project management; application development and delivery; system auditing; technical services; and business processes across the software, financial services, healthcare, and education sectors. Harald was the product manager at Ascential® Software and IBM responsible for designing and bringing the IBM InfoSphere Information Analyzer product to market as a key component in IBM’s information quality portfolio. He has been issued three patents in the field of information quality and rule discovery and was recently recognized as an IBM developer- Works Contributing Author.
His publications include the IBM developerWorks articles “The information perspective of SOA design” [parts 6, 7, and 8], “Use IBM WebSphere® AuditStage in a federated database environment,” “Using pre-built rule definitions with IBM InfoSphere Information Analyzer,” “Designing an integration landscape with IBM InfoSphere Foundation Tools and Information Server” [part 1], and “Best practices for IBM InfoSphere Blueprint Director” [parts 1 and 2]. For the IBM InfoSphere Information Server documentation, Harald contributed to the “IBM InfoSphere Information Analyzer Methodology and Best Practices Guide” and “IBM InfoSphere Information Server Integration Scenario Guide”; he has also contributed to three IBM Redbooks®.
Remember if you are an IDUG member, you are entitled to 45% off all IBM Press books, including this one. Find the secret code on the IDUG.ORG site after you sign in.
Were you able to join today’s DB2 Night Show webinar? Today was the second show of this year’s very popular competition. If you missed it, I strongly encourage you to watch the replay. Here’s what you’ll get:
Contestant 1 – Kohli
Kohli’s presentation showed how you can backup your database on one filesystem and redirect it to another. He very clearly went through a scenario where he did so and showed the errors that can result and how to solve the issues. Unfortunately Kohli ran out of time during the critical part of the presentation where he was explaining how to resolve the issues that resulted from using the restore redirect command. It was a good presentation, but needed more pictures and more focus on solving the issues rather than defining the process.
Contestant 2 – Elder
Yet Another db2imigr Command Alternative
Elder’s topic showed how to version migration when there is no window for an offline backup and restore. This wasn’t an elegant solution, but is a great trick to use if that’s the only option. It was a good presentation and very clearly delivered. Elder came in on time and admitted that he practiced his timing in order to come in on time.
Contestant 3 – Renu
How to Use Statistical Views to Optimize and Tune SQL
Renu showed us how she tuned a 200 line SQL statement for her client. Her client wanted her to use MQT, but she chose to use Statistical Views instead. She defined both MQT and Statistical Views and explained the pros and cons of using each. As a result of her tuning, she was able to show a 99% improvement in running time. I thought it was a very easy to follow presentation and was well done.
Contestant 4 – Rajesh
Tip for DB2 Instance Check
This happened once last year as well, Rajesh had a good topic, but decided not to create slides to present the topic to us. He showed us source code, but it was hard for me to follow. Rajesh mentioned that he didn’t have PPT installed, so I want to suggest that Google has a free presentation software that he should look into. Another alterative is to increase the fonts in a word document so that it looks like a slide deck. I think it would have been a great presentation if he had used the slides.
Contestant 5 – Sharad
MQT – Friend or Foe? How to turn Foe into Friend
Sharad defined the terms and showed a case study for overcoming MQTs limitations of using too much log space. I found it hard to hear Sharad and therefore found it somewhat hard to follow the presentation. My more technical co-judges found the topic interesting especially when you have Big Data stored in your tables.
Contestant 6 – Srini
Move Table Online Using admin_move_table
Srini’s presentation showed how to use a new DB2 9.7 command to move a table that is growing more than 64 GB. I found it hard to follow the presentation. Maybe the slides were too busy. Maybe Srini didn’t project when speaking. My co-judges really liked the topic and found the presentation very valuable and topical.
The judges, Martin Hubel, Klaas Brant, and myself chose Kohli and Elder to move onto the next round based on the relevance of their topic and the quality of their presentations. We had much trouble choosing who should move on since many of the presentations were superb. If there is still room in the schedule, those who didn’t get chose should see if you can get another contestant slot. Talk to Scott.
Do you agree with our choices? If you watch the replay, you’ll be able to fill in a survey to let us know if there is someone else who should also move on. Listen for the great tips and for your opportunity to advance another excellent contestant.
Join us every Friday in February for contestant presentations. March is reserved for the finals where those who have moved on will present a second time and the listeners can choose the winner rather than the judges. The commitment for March has lessened in that there will only be 3 shows in March rather that the originally planned 5. We still have openings for a couple of contestants, so if you’re interested, sign up to join!
Thanks to host Scott Hayes for this opportunity for me as a judge and for the contestants for helping them build technical presentation skills that are so valuable.
For details on the prizes for this competition… and a summary of last year’s event… see my blog entry: http://ibm.co/AnZxb4
svisser1 2700018UK9 Tags:  cognos analytics db2zos db2night db2 flashbooks ebooks cloud 8,358 Views
This year we published 3 very popular Flashbooks for the IOD conference that took place in 2011. A flashbook is a small, single-purpose printed book that we produce specifically for attendees at conferences and events. We feel that this is a way to summarize some of the key messages that we think you’ll benefit greatly from. With a book such as this, you get a single version of the truth, rather than trying to filter through vast amounts of information on the internet.
If you didn’t attend the conference, or didn’t get a printed copy of the book… no worries. We also create e-book versions of each and have them available to you and everyone, free of charge. The books that were created and distributed in past years are also still available and many are still quite relevant.
Here are your choices:
Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data by Dirk deRoos, Chris Eaton, George Lapis, Paul Zikopoulos, Tom Deutsch
Get your free copy on the IM Bookstore Website
Big Data represents a new era in data exploration and utilization, and IBM is uniquely positioned to help clients navigate this transformation. This NEW Flashbook reveals how IBM is leveraging open source Big Data technology to deliver a robust, secure, highly available, enterprise-class Big Data platform.
The three defining characteristics of Big Data—volume, variety, and velocity—are discussed. You’ll get a primer on Hadoop and how IBM is 'hardening' it for the enterprise, and learn when to leverage IBM InfoSphere BigInsights (Big Data at rest) and IBM InfoSphere Streams (Big Data in motion) technologies. Deployment and scaling strategies plus industry use cases are also included in this practical guide.
Flashbook: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance by Cristian Molaro and John Campbell
Get your free copy on the IM Bookstore Website
Under the current economic climate, businesses are under significant pressure to control costs and increase efficiency in order to improve their bottom line. DB2 for z/OS customers around the world are still trying to gain competitive advantage by doing more with less: more business insight, more performance, more operational efficiency, more functionality, more productivity with less cost, quicker time to market and a lower TCO.
With the support for DB2 Version 8 scheduled to end in April 2012 there has never been a better time to start planning your DB2 10 upgrade - there are many more reasons to upgrade to DB2 10 and users will see significant business benefits. Here are the top 10 reasons why we feel you should start planning your upgrade.
1) Improved performance, reduced software license costs
2) Increase the number of concurrent users by a factor of ten
3) Reduce contention in database administration
4) More administrative capabilities while database is online
5) Improved security and auditing
6) Maintain “snapshots” of changing data – Temporal Data
7) Improved portability via enhanced SQL
8) Enhanced pureXML performance and usability
9) Improved productivity for database/systems administrators and application programmers
10) Better online transaction processing performance – Hash Access
Flashbook: Customer Experience Analytics: Fast, Intelligent and Action-Packed by Arvind Sathi
Get your free copy on the IM Bookstore Website
The book includes four major segments. First segment introduces the concept of Customer Experience Analytics using a series of customer experience scenarios. It also establishes the scope and focus for the book in types of customer experiences covered linking it to the Customer Life Cycle and a variety of communication touch points. The second segment introduces business value for Customer Experience Analytics. It frames the measurement dimensions, sensitivity across geographies, organizational life cycle and industries, and ways to quantify the business value. Customer Experience Analytics is a journey across maturity levels. We establish here the levels of maturity and what an organization can expect at each level of maturity. The third section covers the solution architecture for CEA solution with components offering real-time processing, intelligence and autonomics. It includes components for data collection, storage, modeling, reporting, and integration with action. This section includes choices that must be made to keep the solution simple and easy to implement. The fourth section concludes our findings and discusses some of the changes we see in the architecture as new disruptive technologies evolve.
This book is intended for semi-technical audience. It uses a series of scenarios (real as well as imaginary), case studies and allegories to illustrate the CEA business opportunity, solution and program to senior and mid level business and IT management. The technical terms are defined and indexed for easy reference. Hopefully, sales executives will also use this book to make their audience aware of the opportunities, and get their interest in exploring a solution for CEA.
Some of the books that were given out in previous years that still may interest you can also be found on the IM Bookstore Website, and include the following:
DB2 pureScale: Risk Free Agile Scaling
by Paul Zikopoulos, Matt Huras, Aamer Sachedina, Paul Awad
DB2 10 for z/OS - Cost Savings ..... Out of the Box
by Roger Miller, David Beulke, Julian Stuhler, Surekha Pureka
The IBM Data Governance Unified Process: Driving Business Value with IBM Software and Best Practices
Business Intelligence Strategy: A Framework for Achieving BI Excellence
IBM Cognos Analytics and Cloud Computing: Best Practices for Deploying Cognos Business Intelligence to the IBM Cloud
If you go to the “Books by Product” page on the bookstore, you’ll also find a few other free e-books listed along with excellent titles that you may wish to purchase.
Enjoy all the free learning available to you!
The DB2Night Show Episode #64: Things I Learned at IDUG EMEA with DB2's GOT TALENT Winner Norberto Filho
IDUG EMEA took place in Prague a few weeks ago and like all European conferences, it was fun and educational. In some ways it feels like a DB2 reunion as well since it is much smaller than other conferences that I attend. This makes it easy to connect with people and to catch up since we last got together.
Personally I have a few stories I’d like to share with you, but not now. Now I’d like to tell you about meeting "DB2’s Got Talent” winner Norberto. This was a trip of “firsts” for Norberto: his first time in Europe, first IDUG, and likely a few other firsts as well. If you missed the conference, I strongly encourage you to join Friday’s DB2 Night Show episode where you can hear directly from Norberto about his trip, what he learned, and what he thought of IDUG.
Space is limited, so Register now. Here are the details:
The DB2Night Show Episode #64: Things I Learned at IDUG EMEA with DB2's GOT TALENT Winner Norberto Filho
Date: Friday, December 2, 2011
Time: 11:00 AM - 12:00 EST
After registering you will receive a confirmation email containing information about joining the Webinar.
Summary:During this unique episode of The DB2Night Show, Norberto will share with our audiences many of the most interesting things that he learned while attending IDUG EMEA.
Refresh your memory on the absolutely wonderful series of “DB2’s Got Talent” Shows:
PS. I’ve completely lost my voice due to a bad cold. I’m glad Norberto is presenting and not me. You likely wouldn’t be able to hear my whispers :)