Keep on Learning
svisser1 2700018UK9 Tags:  books webinars games courses expert career certification 8,722 Views
On Monday and Tuesday this week, the CCDB2UG conference was held in Markham, ON. I was very happy to be invited to take part in a very small way to speak to attendees during the reception and to network with people following the reception.
I handed out my business card to everyone who I met in the hopes that they will become readers of my blog. I hope one or two of you are people I met in person on Monday!
The message that I delivered to the attendees was that our Education and Skills team are dedicated to provide resources to people who want to gain skills on DB2 and other IM products. We have self study courses, books, ebooks, redbooks, conferences, webinars, traditional courses, ILO courses, certification programs, games, and more! I have blogged about these resources in the past and will continue to do so in the future, so keep coming back!
During the event I spoke to many of the excecutives of this user group: Yvonne, Joe, Tim, Dawn, Murray... and others! While talking to them I realized that each and every one of them are using a piece of advice that is prominent in Sam Lightstone's book: Making it Big in Software. That advice is to become a domain expert which will allow you to build your own skills but to help others build their skills and to build your network of like minded people. Can you imagine the benefits of knowing people throughout the industry who have the same passion and skills as you have?
Tim told me that he has attended just about every user group meeting for the past 25 years! I think the dedication that he and others put into user groups is amazing and hope that there are people early in their career who are willing to contribute to keep such an amazing community viable well into the future.
I hope you enjoy my blog entries!
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
IOD EMEA which took place in Rome last week was a huge success. I'm working on my trip report and will post some of it here.
Monday and Tuesday next week, I'll be at the Toronto conference CCDB2UG where the Central Canada DB2 Users Group is celebrating their 25th anniversary! I'm quite looking forward to my annual visit with some of the most amazing people I've ever met. For more information, see this blog entry I did recently: Local Conference - Central Canada User Group.
I've already began planning for our huge IOD event that will take place in Vegas the last week of October. I'm looking forward to see the sessions and speakers who have been chosen for the event. The bookstore is arranged already, so just the signings are left to plan. I'm hoping this year that we have the book signing events included in the agenda builder so you won't miss what the signings that you want to attend. More on this conference coming up.
I've talked to a few people about the IDUG conference that is taking place in Vienna the second week of November. I'm not sure what my involvement will be at this point, but it would be a nice one to attend, don't you think?
There are many free webinars that are coming up soon... I hope you are able to take advantage of the amazing content that is available to you for free! I know time is always a factor, but most of the webinars are recorded so you can benefit from the content after the fact.
My favourite ones are:
1) DB2Night Show - tomorrow is Sam Lightstone, and there are several more speakers planned for the coming weeks.
2) Chat with the Lab - there was an event today, but you can keep on top of the scheduled and recorded events by joining this group: Channel DB2 Chat with the Lab
3) Surekha Parekh does a fine job of informing the world of the events surrounding DB2 for z/OS. I strongly suggest that you join one of the groups that she posts to in order to stay on top of what's happening. The World of DB2 for z/OS is one of the places she updates regularly.
svisser1 2700018UK9 Tags:  lightstone hayes live career db2night_show software making_it_big 6,467 Views
Don't miss Sam's appearance on the
Get your copy of book:
•This book is designed to reach out to a wide client audience on a global basis leveraging IBM‘s vision and products in the Information Management area.
If you are at the IOD2010 conference taking place in Rome, come by the Bookstore at 1:15 pm to get your free copy of this book. The author team will be signing copies and look forward to meeting you to discuss your Information needs. . Get your coupon at the InfoSphere booth in the expo to get your free book.
Magnus is a trendspotter and futurologist based in Stockholm, Sweden, his mission is to help companies make sense (and money) out of future possibilities and inspire people into action. He founded his company Pattern Recognition AB in 2005 and have a mix of large conglomerates and nimble upstarts within finance, energy, media and IT on the client list. Furthermore, he was elected Sweden’s Business Speaker of the Year in 2009.
Leveraging Spatial Capabilities in your Database
Date: 5/27/2010 (Thursday May 27, 2010)
Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
10:30 AM Central / 8:30 AM Pacific / 16:30 hrs London / 17:30 hrs Frankfurt, Paris / India 9PM
Presented By: Sal Vella (IBM), David Adler (IBM)
This chat introduces the spatial capabilities of IBM relational databases, focusing on the DB2 LUW Spatial Extender. Much of the business data that we work with has a spatial characteristic, such as customer or office locations, sales regions, hazard polygons or facilities such as utility lines and highways. By representing this spatial information in a relational table as spatial datatypes, SQL queries can incorporate spatial functions to perform spatial analysis in the database. Business value is derived by being able to answer questions like:
- where are customers who may be interested in buying flood insurnce?
- what are the patterns of high crime activity
- should a new service center be constructed to support new customers
- where are preferred service providers along a route I plan to take
DB2 with the Spatial Extender is being used to answer these questions.
To learn more join experts from IBM labs - Sal Vella and David Adler.
Presentation charts for this Chat will be downloadable from ibm.com/db2/labchats
To register for this event and receive instructions for attending goto:
If clicking the above link does not work, please copy the entire link and paste tinyurl.com/spatialdb into your Web browser.
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
How and why do companies use XML? In which cases do they decide to store, index, and query XML in a databases? What are some of the common patterns for such XML usage?
Join XML expert Matthias Nicola to hear the answers to these questions in a Webcast on May 18, at 11am US Eastern Time (15:00 GMT).
He will describe XML use cases that are applicable to a variety of industries, such as finance, insurance, healthcare, and government, and discuss the benefits that XML brings to these application scenarios.
The webcast will be of interest to users who are new to managing XML in a database as well as to experienced XML practitioners. It will also benefit IT architects who have an interest in XML strategies. Basic understanding of databases and of XML will be useful for this webcast.
If you work in the Toronto Lab... Toastmasters Leadership Series Presents: The 12 secrets of successful innovation by Sam Lightstone : 8200 Amphitheatre; Wednesday, May 12, 12-1 pm.
For those who are NOT in the lab... you can hear Sam's presentation live on May 28, 11-12 pm... for free from your desk thanks to Scott Hayes of the DB2Night Show. Register now! http://bit.ly/7am8ED
Safari Books Online is joining me as they provide one of the available options for electronic books.
If you are an employee with IBM, you automatically have access to all the books available on Books 24x7. If you are a student at a University, you may also have access to Books 24x7. Check with your administrator.
The publishers who I work with are presenting e-book strategies to me for future publications. The idea is that the books will be available immediatly in an online format of some kind, but the books are only printed when they are requested / purchased by a reader. This means that the book can be more easily updated when necessary and the publisher will not have a warehouse full of printed books.
I digress... back to the conference: Safaria Books Online and I will set up in a central location and have plans to showcase many of the books that have been recently published. For an idea of the books that you'll see there, see my previous blog entries:
Besides the books, you'll also be able to buy IBM-logo merchandise. A wide range of items are being made available for you to purchase.
Once I finish this blog entry about the book Making it Big in Software by Sam Lightstone, I plan to post part of it to amazon.com as my reader feedback for the book. I hope you post your comments on amazon once you've read the book... as feedback of this sort is what helps make a book sucessful!
This book, written by
I would say that the thing most surprising about Sam's book so far is the number of audiences that it appeals to.
I had the absolute pleasure to attend an hour long session by
Speaking of career killers, I'd be surprised if you've managed to avoid all the problems that are mentioned.... I know I have witnessed most of them in my career. The advice in this chapter is dead on... and in times when many jobs are disappearing, it might be a good idea to read this chapter to make sure that you are on the right side of a layoff.
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.
PS... you can hear Sam speak. He's been invited as the guest speaker on the
svisser1 2700018UK9 Tags:  book information infosphere architecture smarter_planet 5,419 Views
The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight
Architecture for the Intelligent Enterprise: Powerful New Ways to Maximize the Real-time Value of Information
Tomorrow’s winning “Intelligent Enterprises” will bring together far more diverse sources of data, analyze it in more powerful ways, and deliver immediate insight to decision-makers throughout the organization. Today, however, most companies fail to apply the information they already have, while struggling with the complexity and costs of their existing information environments.
In this book, a team of IBM’s leading information management experts guide you on a journey that will take you from where you are today toward becoming an “Intelligent Enterprise.”
Drawing on their extensive experience working with enterprise clients, the authors present a new, information-centric approach to architecture and powerful new models that will benefit any organization. Using these strategies and models, companies can systematically unlock the business value of information by delivering actionable, real-time information in context to enable better decision-making throughout the enterprise–from the “shop floor” to the “top floor.”
Amazon - currently 22% discount, but this could change at any time.
IBM Press - Save 35% on this title, plus get FREE ground shipping in the US when you use Coupon Code IBM5717 at ibmpressbooks.com.
Are you attending the IOD EMEA Conference in Rome the week of May 17? If you are, you will have a chance to receive a free copy. What do you need to do? Besides being at the conference, you must attend sessions that are hosted by one of the authors.
If you tweet & blog, you KNOW the importance of word of mouth feedback! Spread the word about a favorite topic. The world wants to hear you!
Check out this amazing contents that is sponsored by IDUG:
Tell us your best DB2 stories and win big prizes – yes, it’s as simple as that. In your own words, tell us your experience with DB2, and if our judging panel finds your story interesting you could be taking home a Wifi enabled Vizio HD TV or an Apple iPad.
“Do You DB2?” is open to anyone in North America – DBA’s, developers, testers, students, professors, or even managers, CIO’s and CEO’s. All we want to hear is your DB2 stories, whether technical or business oriented. (Make sure you check out the official website and rules. )
Speaking of IDUG, have you registered for the annual conference that is taking place in Tampa Florida from May 10 - 14? That's next week, so rush if you haven't yet registered. Check out my previous posts about this conference:
1) What sessions would a DBA like Rebecca Bond choose to attend? http://bit.ly/do7EjC
2) What sessions are being presented by IBMers? http://bit.ly/do7EjC
3) IDUG is all about the users! Don't miss a single presentation! http://bit.ly/a53P7k
4) InfoSphere is a hot topic. Check out all the sessions that are available. http://bit.ly/dwqDg3
5) At the end of each day, do some networking. http://bit.ly/ckk3xd
6) Take this opportunity to get certified... and do it for free! http://bit.ly/daNvdN
7) If you have registered, you are eligible to take an assessment exam for free. Those who are registered will get an email with the special promo code: http://bit.ly/dftRin
8) As usual, there will also be a bookstore on site. Check out the books that you should be able to purchase while at the conference: http://bit.ly/c2CdMy
So... DO DB2 (and Win)
and LEARN DB2 at IDUG :)
Don't you love it when there is a conference that is local to your home or office? Well, at least this one is local to me... maybe not for you, but I hope you can come and enjoy our lovely city!
The Central Canada DB2 User Group presents two exciting days of DB2 for LUW and z/OS education! Come see and listen to renown speakers such as John Campbell, Susan Lawson, Bonnie Baker, Sheryl Larsen, Willie Favero, and many other IDUG Hall of Fame speakers present on many diverse areas of DB2.
The event will be held at the Institute for Learning in Markham, Ontario.
Full details and registration available at the CC DB2 User Group web site.
This is the 25th Anniversary of this event and takes place at the end of the month: May 31 - June 1.
I'll be there and hope to see you!
Join Berni Schiefer as Scott Hayes' guest on tomorrow's edition of the DB2Night Show!
Topic: DB2 LUW Performance Update & Best Practices
Who: Berni Schiefer
When: Fri April 30
Time: 11 am Eastern Time
Cost: FREE - Register now
Note that this event is nearly full to capacity... likely because Berni will NOT be presenting at this year's IDUG or IOD EMEA conferences! Berni's talks are always popular... is it the topic or the speaker?
Here's more info (from Scott) about the event:
In the DB2 LUW Community, Berni Schiefer is a man that doesn't need an introduction - but, just in case you are newer to DB2 LUW (like one of the many Oracle converts), Berni is "the performance guy". He's a Distinguished Engineer who leads the Information Management Performance and Benchmarks team at the IBM Toronto Lab. Berni has been a frequent speaker at IDUG conferences and other venues, and he gives terrific presentations that share DB2 Performance Benchmark results and performance best practices.
With DB2 pureScale announced last fall, we can only "guess" that IBM will be publishing some new benchmark results very soon. Claim your seat in our virtual studio audience to hear the very latest information on performance results and best practices!
The DB2Night Show has a Twitter account - please follow twitter.com/db2nightshow for the latest news about new episodes and interactive discussion. Use the hash tag #DB2Night in your Tweets.
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 Amazon.com gift certificate - use this towards a new USB thumb drive, a new book, or anything you like!
If you can't make the scheduled time, register anyways so that you get information about recorded replays. Lastly, please forward this invitation to at least 5 of your friends!
I hope you enjoy the talk!
svisser1 2700018UK9 Tags:  recruiters tips software career lightstone managers 1 Comment 8,007 Views
I've been reading the book "Making it Big in Software" by Sam Lightstone and as a result, I've been thinking quite a bit about careers and all the skills that go into making a satisfying career. On top of Sam's book, I've been reading his blog and have noticed a few articles that I'd like to share with you.
First the articles.
Last year I read an article called "5 sure ways to get fired" and I wrote a blog entry about the article. This blog entry that I wrote has turned out to be one of my most viewed entries... "Trying to Get Fired?"
A few weeks ago I came across another article that sounds similar: "10 Ways to Make Yourself Layoff Proof". This is a slideshow, with not much information, but you'll find that Sam covers most of these topics in his book.
Today while waiting in line for coffee, I noticed an article posted on the bulletin board called "Soft Skills are Sexy". Clearly I don't go to coffee very often... the article was published last June! Luckily it can still be found online. Again, you won't be surprised by anything in this article, but note that these skills are also mentioned in Sam's book as being important.
Now about Sam's book. If you read my blog, you'll already know that I'm both a fan of Sam's and of his book. I'm doing what I can to promote Sam's book as it fits in well with my job as publishing program manager, but also with the team I'm on... education.
I would say that the thing most surprising about Sam's book so far is the number of audiences that it appeals to.
1) Obviously this book would appeal to anyone in university about to embark on a full time job. As Sam mentions in his book, school is much different than a job as a software developer in a big company... and to be successful, you need to learn the differences and adjust your behaviour for maximum impact. I really wish that this book was available when I graduated! I was really new to a corporate environment since I came from a family that was into farming and construction. I have noticed throughout my career that collegues that had professional parents were able to work the system much better than I could. This book will help bridge that kind of gap.
2) Similar to those in university are those in the first couple of years on the job. Once you've figured out what you like and dislike about your job / career, you can use the advice in this book to make a real difference as to whether you are put on the fast track or not. The two things that stand out to me at this moment are: 1) become a domain expert; and 2) follow through on your inspirational ideas! These sound so easy to me...yet apparently they are rarely done!
3) People in their mid career can benefit from this book as they can figure out why they may have stalled, if they have, or how to rise a few steps higher, if they so choose. The advice in this book is suitable for any stage of your career.
4) Recruiters. Sam tells stories about when he was recruiting new employees and the types of people he favoured. Over time he realized that he wasn't looking for the right qualities! This goes hand in hand with the fact that school success and career success are quite different. You might be surprised by Sam's findings.
5) Someone I spoke to yesterday gave me this tip. He is a manager and wants to read the book so that he can help his employees reach their potential. What a great manager! I think he should win an award of some kind! But what a great idea. Managers who read this book will become better mentors and coaches from their employees. A successful team reflects very well on the leader of the team!
I strongly encourage you to read the book for yourself and to recommend it to others. Here are a few of the websites that I suggest you read for further encouragement:
Facebook Fan Page - more than 400 members at the time of this writing. This has been a fairly active page so far, so even if you haven't read the book yet, become a fan and learn more about the author and events surrounding the book.
LinkedIn Group - Career based articles and events about the book will be posted here.
Sam's Blog: The Making it Big Blog. Sam has been summarizing some of the points he makes in his book and blogging about them. Active blog and interesting entries.
Valerie's Blog: yesterday Valerie Skinner posted a lengthy interview that she did with Sam on her blog. It is a very interesting read and you'll learn about Sam's up bringing and passions.
Quite a few people have been posting their reviews of Sam's book. Here are a bunch of them:
eweek: The Golden Age of Software - "What makes the book particularly attractive was Sam’s willingness to go out and interview other software stars, including Google’s Marissa Mayer, Java inventor James Gosling and Apple founder Steve Wozniak. The interviews alone are worth the price of admission."
utahcon: Review- Making it Big in Software - "Making it Big in Software is a great read, it is something I think that every software developer would have loved to have had when they were breaking into the software world. I know I would have loved to have had it.
Sam Lightstone has put together what could easily be called the blueprint to a successful career in software. He covers college, post-college pre-career, interviewing, resumes, fitting into the work environment, salary discussions, and more, much more."
Dr. Dobbs - Review of Making it Big in Software - The author accurately concludes that the road to software development career success is attained by following mythologist Joseph Campbell's advice to "Follow your bliss".
Java Ranch - Review - "Making it Big in Software" is a career book that manages to apply to people at many levels. It is good for students, new hires, mid level software professionals and those interested in starting their own company.
iProgrammer - Review - "Software is an amazing place to build a career". If you agree with this sentiment that opens Sam Lightstone's book you are likely to enjoy reading it and find it motivating.
I hope that you take my advice and pick up this book! You can purchase it in many places right now for about $20... which is very inexpensive! You can get a cheaper copy in electronic format. Once you read the book... I'm sure you'll become as passionate about it as I am!
I enjoy all the DB2Night Show events that Scott Hayes arranges, but these three up coming events are truly ones that you shouldn't miss!
The DB2Night Show Episode #17 In the DB2 LUW Community, Berni Schiefer is a man that doesn't need an introduction - but, just in case you are newer to DB2 LUW (like one of the many Oracle converts), Berni is "the performance guy". He's a Distinguished Engineer who leads the Information Management Performance and Benchmarks team at the IBM Toronto Lab. Berni has been a frequent speaker at IDUG conferences and other venues, and he gives terrific presentations that share DB2 Performance Benchmark results and performance best practices.
I had the absolute pleasure to attend an hour long session by Sam Lightstone today. Sam has taken a few topics in his book and created a 10 point agenda that provides a few highlights from his best selling book "Making it Big in Software: Get the Job. Work the Org. Become Great.".
Let me share a few of the tips that Sam shared today... but if you get the opportunity to hear Sam yourself, take it! Sam is a very fun speaker to listen to. Also, you won't be disappointed with the book!
1) Dress for Success
What does a successful software developer wear? The same as a CEO? NO! CEOs are typically polished wearing fancy suits. Software developers? Running shoes, jeans, t-shirts... don't believe me? Find a photo of the Google founders Larry Page and Sergey Brin and you'll see that they dress like ROCK STARS!
Senior Software Architects make much more money than junior employees. Check it out on payscale.com. But... what you don't see on sites like this is the other money superstars make. They often get large bonuses and stock options beyond their base salary.
A superstar developer has much freedom in their job in terms of where they want to work and customers they want to visit.
4) Getting Ahead
There was lots of advice about getting a promotion and rising in your field, but the one thing that stood out for me is that you should become the expert in YOUR DOMAIN. Whatever that domain is... become an expert. It doesn't take long, but unfortunately it is rarely done. So, it would be fairly easy to stand above your peers if you just invested a bit of time each month to learn something new about your domain.
5) Pros and Cons of Climbing the Ladder
There are cons to anything you do in life... but the pros of climbing can be worth the cons, if that's what you want to do.
What is more important than inspiration? Would believe that it is following through on your plans? It is! And apparently following through is rare. Surprising!
7) Time Management
Did you know that goofing off can actually be important to your career? Really! Your brain needs a break from time to time, so give in. But make sure you don't abuse this advice!
There are lots of considerations regarding getting promoted.. and the most important is to do something that makes you stand out from your peers. Publish, files patents, join groups, present about your topics, etc. Do what you like to do and what makes you feel appreciated.
9) Social Dynamics
One of the key messages here is DON'T GOSSIP! 9/10 times you gossip, it may not get around... but even 1 out of 10 times could be a career killer! I've worked with Sam for a number of years and let me tell you! He practices what he preaches.
The last hint that I'll give you today is.... you can hear Sam speak. He's been invited as the guest speaker on the DB2 Night Show. There is a 200 person limit to this webinar, so register today to reserve your spot!
PS... find out more about Sam and what makes his clock tick via this interview: http://bit.ly/cDeeJq
svisser1 2700018UK9 Tags:  security tampa sessions books idug rebecca_bond dba conference 6,154 Views
I asked my wonderful friend Rebecca Bond to give me her
I had to make some REALLY difficult decisions. There are some EXCELLENT speakers and sessions this year.
These are the ones I finally decided to attend. I seriously hope that the ones I am going to miss will be presented at IOD so I can try to attend them then. IDUG has outdone themselves with this line up.
I may look at taking one of the classes on Monday. Just depends on how my writing projects are going and if they have any available spaces left when I make the determination.
I can't decide on which restaurant to sign up for on the Dine Around evening. Several good choices and I want to have dinner with everyone so I think I'll just have to put a blindfold on and throw darts at the sign up board....you might want to warn your readers to steer clear of the sign up board if they see a crazy lady in great shoes start to put on her blindfold.
May 11, 2010
8:00 K01: DB2 INNOVATION: POWERING INFORMATION WORKLOADS FOR SMARTER IT
10:00 S02: DB2 FOR LINUX, UNIX AND WINDOWS - TRENDS AND DIRECTIONS
12:30 D01: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation
1:45 D02: Varsity SQL for the Busy DBA
3:00 C03: Enabling Oracle Applications on DB2 - an Early User Experience
4:15 D04: A VISUAL TOUR OF DB2 9.7 SQL AND PL SQL ENHANCEMENTS
May 12, 2010
8:30 C05: An Indepth Technical Look at DB2 pureScale
9:45 D06: DB2 SECURITY – AMMO FROM THE TRENCHES -- Presenting
11:00 D07: UPGRADING DB2 9.7 – BEST PRACTICES AND LESSONS LEARNED
1:30 V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!
2:45 D08: STUFFED WITH GREAT ENHANCEMENTS - DB2 9.7 FIX PACK 1 NEW FEATURES
4:00 I01: Data Privacy, Security and Audit Compliance -- Panel Participant
May 13, 2010
8:30 C09: pureScale - Why It's So Much Better than Oracle RAC
9:45 D10: LOCKING - WHAT LOCKING? CURRENTLY COMMITTED AND OTHER LOCK AVOIDANCE ENHANCEMENTS TO INCREASE PERFORMANCE AND THROUGHPUT
11:00 V10: END-TO-END MONITORING & PROBLEM DETERMINATION WITH OPTIM PERFORMANCE SOLUTION
1:30 D11: ENABLING FROM ORACLE TO DB2 COBRA THE EASY WAY.
2:45 F12: DB2 Back and Recovery - What Do I Really Need to Know?
4:00 I05: DB2 FOR LUW - HIGH AVAILABILITY & DISASTER RECOVERY
May 14, 2010
8:30 E13: All the FREE Things you can Do with Data Studio
9:45 E14: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks
11:00 B15: Auditing options on DB2 for z./OS (Moderator)
Thanks Rebecca! I wish I was going so I could attend all these amazing sessions with you!
If you missed my posts in the past week, here's the rest of the IDUG coverage that you can find:
A list of all the IBMers who are presenting sessions.
A list of all the
The educational seminars
Don't forget about the
Check out the bookstore that will be onsite where you can purchase the book that Rebecca wrote:
Yesterday I listed all the IDUG sessions that are presented by a user. Today I'll post all the sessions that are being presented by IBMers. I'm sure you'll recognize all the names! The IDUG Conference is taking place this year from May 10-14 in Tampa Florida.
K01: DB2 Innovation: Powering Information Workloads for Smarter IT
Martin Wildberger; Vice President, IBM Data Management Development
S01: Spotlight Session: DB2 10 for z/OS Overview
S02: Spotlight Session: DB2 for Linux, UNIX and Windows - Trends and Directions
S03: Spotlight Session: The Vision of Integrated Data Management - Past, Present and Future of Tooling
476: DB2 10 for z/OS DBA Improvements, Roger Miller
407: CAPITALIZING On DB2 LUW V9.7 Capabilities - A Data Management Feature Presentation, Bill Minor
730: Data Studio and Optim Administration Tooling for DB2 for z/OS DBAs, Bryan Smith
748: Making Your CIO Successful with Analytics, Greg Lotko
438: What's new from the optimizer in DB2 10 for z/OS?, Terry Purcell
419: Defend your Turf – DB2 Technical Advantages over Oracle, Chris Eaton
785: Introduction to Smart Analytics for DB2 & Power Systems, IBM, IBM, Eddie Daghelian
394: DB2 10 for z/OS Performance Preview, Akiko Hosihkawa
718: Diagnosing and Improving Query Performance through EXPLAIN plan analysis, Calisto Zuzarte
786: Infosphere Warehouse Deep Dive, Bill O'Connell
379: A VIsual Tour of DB2 9.7 SQL and PL SQL Enhancements, George Baklarz
793: Maximizing the Value of DB2 for z/OS in Data Warehousing, Beth Hamel
783: An Indepth Technical Look at pureScale, Matt Huras
738: Partitioned Tables: Significant Enhancements in DB2 9.7 (and beyond), Mike Winer
478: Extract the most value from .NET and ODBC Applications, Brent Gross
446| DB2 and System z Synergy, Chris Crone
316: DB2 for z/OS Optimizing Insert Performance - (Two Parts), Frances Villafuerte, John Campbell
791: An Insider's Look at the DB2 V9.7, Matt Huras
339: DB2 in the Cloud: The Hottest Topic for 2010, Leon Katsnelson
663: Stuffed with Great Enhancements - DB2 9.7 Fix Pack 1 New Features, Melanie Stopfer
403: DB2 10 for z/OS Availability Enhancement, Haakon Roberts
253: Upgrading DB2 9.7 – Best Practices and Lessons Learned, Melanie Stopfer
54: DB2 9.7 LUW Newest Online Schema Change Capabilities, Burt Vialpando
V01: Optimizing Data Storage Efficiency with Multi-Temperature Warehouse Principles, Enzo Cialini
V02: Cloning & Backup/Recovery on DB2 for z/OS: The Cutting Edge, Jay Bruce
V03: Understanding Information Governance, Tom Howell
V04: DB2 Has Always Been the Next Generation Database Software, Conor O'Mahony, Irshad Raihan
333: pureScale - Why It's So Much Better than Oracle RAC, Paul Zikopoulos
481: Best Practices for Query Performance In a Data Warehouse, Calisto Zuzarte
477: Enterprise Client Connectivity with DB2, Brent Gross
571: DB2 for z/OS Optimizer - What have you done for me lately?, Terry Purcell
739: Locking - What Locking? Currently Committed and other Lock Avoidance enhancements to Increase Performance and Throughput, Mike Winer
421: DB2 LUW for a z/OS DBA, Chris Eaton
330: A Day in the life of a DB2 for z/OS Page, Randy Ebersole
670: Enabling from Oracle to DB2 Cobra the Easy Way., Serge Rielau
225: DB2 DBM1 Virtual Storage: How to use MEMU2, Judy Ruby-Brown
277: Data Studio and Optim Administration Tooling for DB2 for LUW DBAs, Bryan Smith
657: DB2 Back and Recovery - What Do I Really Need to Know?, Dale McInnis
534: IBM Smart Analytics Optimizer -- Not Your Father's Database System!, Guy Lohman
V08: Going Active - Taking DB2 DR from Standby to Continuous Availability, Serge Bourbonnais
V09: Keeping Your Business Resilient in an Uncertain World, Tom Ramey
V10: End-to-End Monitoring & Problem Determination with Optim Performance Solution, Tom Howell
455: WLM Best Practices, Kevin Beck
334: All the FREE Things you can Do with Data Studio, Paul Zikopoulos
391: Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution, Namik Hrle
717: DB2 LUW LOBs - Past, Present and Future, Bill Minor
487: Auditing Options on DB2 for z/OS, DB2 for z/OS, Ernest Mancill
656: DB2 High Availability Features and Directions , Dale McInnis
53: DB2 9.7: The Latest And Greatest in Database Security, Walid Rjaibi
Check out the bookstore that will be onsite where you can purchase books from
1) Making it Big in Software, by Sam Lightstone
2) The Art of Enterprise Information Architecture by Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, and Michael Schroeck
3) DB2 pureXML Cookbook by Matthias Nicola and Pav Kumar-Chatterjee
Don't forget about the
Check out my previous blog entries for a list of all the
svisser1 2700018UK9 Tags:  sessions users presenters books idug conference 1 Comment 8,053 Views
IDUG = International DB2 User's Group, so you'd expect there to be many presentations at the annual conference that are done by users. And you're right. And what a great bunch of users who are part of the IDUG team! Here are some who I haven't mentioned on my previous blog entries:
756: Hell’s Kitchen; DB2 9, A DBA’s Recipe for Success , Rob Crane II, FedEx
360: Crossing Over - A Mainframers Guide to DB2 LUW, Jim Wankowski, Quest Software
533: Varsity SQL for the Busy DBA, Fred Sobotka, FRS Consulting, Inc.
434: DB2 Z/OS V8 Data Warehouse Conversion to DB2 LUW 9.5, William Gannon, Palm Beach County School District
547: Spatial Data Management on DB2 for z/OS; Customer Experiences at John Deere, Sooraj Ali, John Deere
397: Auditor's Guide to DB2, Thomas Baumann, Swiss Mobiliar
735: De-mystifing JDBC Universal Drivers - for the z/OS DBA, Billy Sundarrajan Fifth Third Bank
613: DB2 9 for z/OS: What's New Since GA?, Phil Grainger, Independent consultant
572: Enabling Oracle Applications on DB2 - an Early User Experience, Bernie O'Connor, Anixter Inc.
450: Squeeze the Most Out of your Indexes in DB2 9!, Jim Dee, BMC Software Inc.
590: DB2 for z/OS SQL Performance Choices, Daniel Luksetich YL&A
782: Table and Index Design Strategies: Looking Forward to DB2 9, Susan M Lawson, YL&A
784: Mainframe DB2 Data Warehousing 2010, Robert Catterall, Catterall Consulting
294: Where my requests spend time? --- First taste DB2 9.7 Time Spent metrics, Pak Kwan Fifth Third Bank
495: DB2 for the Oracle DBA, Jim Wankowski Quest Software
447: Understanding Your DBA?? It Can Be Done!!, Brad Price, Werner Enterprises
351: Solving Warehouse Source Data Issues Using DB2 on z/OS , Robert Goodman, Florida Hospital
91: An A to Z of DB2 for z/OS Backup and Recovery, Phil Grainger, Independent consultant
574: Static SQL and Access Path Review - Tips and Tricks , Paul Walters, Sallie Mae
576: Major Locking Issues with New SQL (2 Parts), Bonnie Baker, Bonnie Baker Corporation
558: DB2 Security – Ammo From the Trenches, Rebecca Bond
321: DB2 9 tricks for COBOL programs, David Churn DST Systems, Inc.
343: A Few Things to Know Before Migrating to DB2 9 for z/OS, David Simpson Themis Inc.
550: Unlocking the Mysteries of the DB2 Log, Paul Turpin, S1 Corporation
408: Scaling Enterprise Data in the Cloud, Albert Lee xkoto, Inc.
448: Rev up your SQL Applications with Enhanced Statistics!, Jim Dee BMC Software
288: DB2 9 Package Stability: Migration, System and Daily Database Maintenance, Ulf Heinrich SEGUS Inc.
736: DB2 z/OS – Hands free approach to maintenance of multi terabyte tables, Billy Sundarrajan, Fifth Third Bank
402: DB2 LUW Index Design and Best Practices, Scott Hayes, DBI
347: Java DB2 Developer Performance Best Practices, David Beulke, Dave Beulke & Associates
345: Exploiting DB2 9.7 Monitoring and WLM Functionality, Philip Nelson ScotDB Limited
V05: You Killed the ELEPHANTS but MOSQUITOES are Killing YOU!, Scott Hayes - DGI, Phil Grainger - Grainger Consulting
V07: Reveal Your Inner Genius with BMC Software, Rick Weaver - BMC
312: Do you really want NOT to LOG ?, Steen Rasmussen CA
570: John Deere's User Experience with DB2 9 New Features, Bryan Paulsen, John Deere
297: Wake Up to Hibernate, John Mallonee, Highmark Inc.
491: Optimize DB2 Buffer Pool performance with the new Performance Wizard and Buffer Pool Tool® for DB2, Joel Goldstein, Responsive Systems
467: Package Versioning for High Availability, John Maenpaa, Health Care Service Corporation
346: Moving to DB2 9.7 : User Experiences, Philip Nelson, ScotDB Limited
311: RTS is your friend – Optimize DB2 housekeeping., Steen Rasmussen, CA
631: A 411 on the DB2 Directory, William Arledge, BMC Software
628: Ask not what the Optimizer can do for you ? ask what you can do for the Optimizer!, Suresh Sane DST Systems Inc
445: The Caveman Chronicles: How We Took our DB Performance from Ice Age to New Age!!, Brad Price, Werner Enterprises
639: IFI you don't know, ask!, Jeff Gross, CA
624: Best Solution in DB2 for z/OS , Frank Petersen Bankdata
566: DB2 Compression and performance impact, Robert Donaldson LSSiData
466: DB2 Attachment Facilities, John Maenpaa Health Care Service Corporation
298: DB2 LUW and Oracle Environment Standardisation (CA-IDUG Award 2009), Peter Suhner, AXA Technology Services Switzerland AG
151: Solving the DB2 Database Administration Dilemma, Randy Goering, DST Systems Inc.
V11: Improving the Performance of the Enterprise, Raymond Meza - Eccox Software Group
V12: Tune Mainframe SQL Like a Genius , Bill Arledge - BMC Software
563: Generic Attach on Z/OS (or attachment demistifyed), Jack Bailey, BlueCross BlueShield of South Carolina
59: The Return of the DB2 Top Ten Lists, Craig Mullins
620: DB2 LUW Design Advisor - db2advis ? Miracle-Worker or Monster-In-Law, Alexander Kopac, Home Depot
485: How a Performance Database Can Help Save the Day! , Mark Wilkinson, AMICA Mutual Insurance Company
484: A practical guide to storage tiering with DB2 for z/OS, Paul Pendle EMC
EU2009 Best Speaker: 623: How to Cope with Soap? WebServices on DB2 for z/OS, Frank Petersen Bankdata
565: High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7, Robert Donaldson, LSSiData
618: Diagnosing & Curing? Lock, Wait and Performance Bottlenecks, Alexander Kopac Home Depot
526: Lessons Learned from SQL Performance Reviews , Sheryl Larsen, Sheryl M. Larsen, Inc.
794: DB2 9 for z/OS Migration Planning Survival Guide, Linda Claussen, Themis
627: Real-world strategies for managing undesirable access paths, Suresh Sane, DST Systems Inc
743: My Memorable Moments with DB2 LUW, Debra Wong, Marriott International
210: The Power SQL PL, Herb Vogel, JB HUNT Transportation
436: DB2 Administration for Better Performance and Low Cost, Sigen Chen, Lockheed Martin
I recognize a few new names here, which is wonderful! Thanks to all speakers and good luck at your session! I hope you are filled to capacity :)
Check out the bookstore that will be onsite where you can purchase books from Rebecca Bond, Susan Lawson, Daniel Luksetich, Craig Mullins and others.
Monday isn't listed above, as the educational seminars are taking place that day. Be sure to check out the offerings. Don't forget about the free certification exams you can take!
Check out my previous blog entries for a list of all the InfoSphere sessions as well as details about the fun events that are planned.
DB2 Health Advisor Service (HAS) is a proactive/reactive SaaS (support as a software service) technology that is non-intrusive and utilizes up to date analytics from subject matter experts across DB2. The main goal of the service is to leverage the expertise and knowledge back at IBM to productively avoid problems, reduce the bar of adoption, lower total cost of ownership and return on investment when using DB2. It is based on best practices and customer knowledge database.
The service collects information about the customer’s DB2 operating environment and sends it back to IBM where it is automatically processed by analysis engine. DB2 HAS analytics are based on DB2 best practices gleaned over many years as well as knowledge of 1000’s of similar configurations. A report is then generated based on the comparison that indicates what system parameters are healthy and which should have a second look. Recommendations are also provided. The report is then sent back to the customers via the email they provided at the command line when they requested the health check.
If you are on DB2 v9.7 FP1, the db2has tool is already available as a part of DB2 installation. If you are on an earlier DB2 release/fixpack, the db2has tool is available from an official IBM download website: https://www.ibm.com/services/forms/preLogin.do?source=swg-beta-db2hasvc .
(You will need to login using your IBM ID and follow the appropriate instructions to download the data collector. )
Here's some information about db2has:
DB2 Health Advisor Service data collector (db2has) gathers information about a DB2 instance, its databases, and its operating environment. The db2has tool will generate a zip file (under ~/sqllib/db2hasdir) that contains an XML file which is the contents of the scan.
- There is no installation required for the tool. For a download version, on DPF systems only it is recommended to copy the db2has executable to the sqllib/adm directory to make sure that the executable can be run from all partitions.
- Have your company's IBM Customer Number (ICN) ready, as this is a required parameter entry when using the db2has tool. If you do not currently have an ICN, contact IBM Software Support.
- Using the -send option will FTP the compressed file to IBM. Otherwise, send the compressed file here ftp://firstname.lastname@example.org:21/toibm/im using your FTP client. If using FTP is not an option (e.g., due to a firewall restrictions) please send compressed file as an attachment to email@example.com.
- For detailed information about the db2has tool, use the "db2has -help all" command or "db2has -help examples" to see other examples.
For convenience, here is a sample command with a recommended set of options (simply replace the fake information as appropriate):
Please review the DB2 HAS report that you receive and evaluate the effect of the report's recommendations by first implementing them in your test environment. If you have any questions, comments, feature requests or if would like to influence the DB2 HAS direction please send an email to firstname.lastname@example.org.
If you have any questions, comments, feature requests or if would like to influence the DB2 HAS direction please send an email to email@example.com.
What books should you choose? Here are some that are offered:
The Greening of IT
Survival Guide for Lotus Notes and Domino Administrators
SOA Governance: Achieving and Sustaining Business and IT Agility
IBM WebSphere DataPower SOA Appliance Handbook
WebSphere Engineering: A Practical Guide for WebSphere Support Managers and Senior Consultants
Implementing ITIL Change and Release Management
New Language of Marketing 2.0
Application Architecture for WebSphere
Rapid Portlet Development with WebSphere Portlet Factory
Executing SOA: A Practical Guide for Service-Oriented Architect
Eating the IT Elephant
Persistence in the Enterprise: A Guide to Persistence Technologies
Understanding DB2: Learning Visually with Examples
A Practical Guide to Trusted Computing
WebSphere Business Integration Primer: Process Server, BPEL, SCA, and SOA
Implementing ITIL Configuration Management, Second Edition
Irresistible! Markets, Models, and Meta-Value in Consumer Electronics
The New Language of Business: SOA & Web 2.0
Let Go To Grow: Escaping the Commodity Trap
That's a lot of e-books that are available at a 40% discount! I hope find one that you like and give it a try.
Not only do IDUG attendees get FREE certification tests at the conference taking place May 10 - 14 in Tampa Florida, but in the weeks before the conference, you can take the assessment test FREE of CHARGE!
Check your email as once you register for the conference, you'll receive the promotion code and instructions by email.
Good luck on the exams! Have fun at the conference!
Check out my previous entries about the IDUG last week:
My second favourite thing to do when at a conference is to network with the other attendees. First is taking advantage of all the learning opporuntiies, of course!
IDUG is my favourite conference to go to as well because the organizers and attendees are so friendly and easy to meet. In the true sense of the word, IDUG is a community... and sometimes feels like a family. I'm sure if you've been to a conference, you know what I mean. If you haven't, I hope you get a chance to go. It might change the direction of your career. For instance, perhaps you will be encouraged to follow in the footstep of the IDUG board members and get more involved, or put together a presentation for future years! I hope you do!
The IDUG committee has arranged a fun way for you to meet others while at the conference. They call it Dine Around with DB2 Experts. Here is what's on the agenda so far:
Phil Grainger and Judy Ruby-Brown at Thai Thani;
Phil Nelson, Dave Beulke and Fred Sobotka at Stumps;
Bill Minor and Mike Winer at Tampa Bay Brewing Company;
Bonnie Baker and Sheryl Larsen at the Spaghetti Warehouse;
Chris Eaton and Scott Hayes at the Laughing Cat.
What a tough decision! My suggestion is that you choose a location based on the food that you like. Or, how about you choose to hang out with the people you know the least? Since I know all the people who are hosting, I wouldn't be able to select based on who I liked... because I like them all and would be very happy to hang out with them for hours!
This event is taking place on Thursday evening at May 13. Have you joined the LinkedIN IDUG group? Join to get more information about this event from those taking place.
Become a fan of IDUG on Facebook to keep up to date with what is going on.
One more thing that I'd like to mention.... If you aren't very comfortable traveling alone, consider this new program offered by IDUG that can help you bring someone new to the event: IDUG Mentor. Bottom line? You can bring a newbie to the conference for an 80% disount. See the website for details.
Check out my previous entries this week: Get Certified, Learn about InfoSphere, and Take a Education Seminar before the conference begins.
Learn plenty, but have fun by meeting people and getting involved!
Yesterday I mentioned the InfoSphere sessions that are taking place at the IDUG Tampa conference (May 10 - 14)and Monday I blogged about the free certification exams that are available.
Today I'll tell you about the 7 education seminars that are taking place on Monday May 10. Note that all these sessions take place the same day and same time, so the hard part will be to choose which one you want to participate in!
Z01: DB2 9 for z/OS Cert Exam, Susan Lawson, YL&A
Z02: Save CPU Costs by Tuning your SQL, Bonnie Baker, Bonnie Baker Corporation
Z03: SQL: What To Use When You Can and Cannot Touch It, Sheryl Larsen, Sheryl M. Larsen, Inc
Z04: DB2 9.7 for Linux, UNIX and Windows DBA Certification Exam Preparation (Exam 541), Roger Sanders, EMC
Z05: Deep dive into DB2 LUW Problem Determination and Troubleshooting, Pavel Sustr, Samir Kapoor, IBM Toronto Lab
Z06: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
Z07: DB2 9 for z/OS In-depth, Phil Grainger, Independent Consultant
Z08: Optimizing System Performance Using DB2 Statistics Trace
You can view session details and build your curriculum with the on-line conference scheduler.
At the conference bookstore, you'll find books by Roger Sanders and Susan Lawson to accompany the course material that they are delivering.
Stay tuned for more information... coming up soon!
Yesterday I blogged about getting certified for free at the upcoming IDUG conference in Tampa Florida. Today I'd like to tell you about the number of InfoSphere Warehouse sessions that will be available so you can leave the conference a step closer to being an InfoSphere expert.
Here are the InfoSphere sessions that you can attend while at the conference (user submissions in this colour):
748: Making Your CIO Successful with Analytics, Greg Lotko, IBM, IBM, Cross Platform
434: DB2 Z/OS V8 Data Warehouse Conversion to DB2 LUW 9.5, William Gannon, Palm Beach County School District, Company/Organization That Uses DB2, Cross Platfor
785: Introduction to Smart Analytics for DB2 & Power Systems, IBM, IBM, Eddie Daghelian, DB2 for Linux, UNIX, Windows
786: Infosphere Warehouse Deep Dive, Bill O'Connell, IBM, IBM, DB2 for Linux, UNIX, Windows
793: Maximizing the Value of DB2 for z/OS in Data Warehousing, Beth Hamel, IBM, IBM, DB2 for z/OS
784: Mainframe DB2 Data Warehousing 2010, Robert Catterall, Catterall Consulting, Consultant, DB2 for z/OS
351: Solving Warehouse Source Data Issues Using DB2 on z/OS , Robert Goodman, Florida Hospital, Company/Organization That Uses DB2, DB2 for z/OS
339: DB2 in the Cloud: The Hottest Topic for 2010, IBM, IBM, Leon Katsnelson, Cross Platform
534: IBM Smart Analytics Optimizer -- Not Your Father's Database System!, Guy Lohman, IBM, IBM, DB2 for z/OS
481: Best Practices for Query Performance In a Data Warehouse, Calisto Zuzarte IBM, IBM, DB2 for Linux, UNIX, Windows
391: Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution, Namik Hrle, IBM, IBM, DB2 for z/OS
You can view session details and build your curriculum with the on-line conference scheduler.
While you're at the conference, stop by the conference bookstore and consider picking up a copy of:
This is the only book with a large amount of InfoSphere content, including coverage for the following products:
* InfoSphere MDM Server
Are you going to IDUG in Tampa, Florida this year? The conference takes place May 10 - May 14 and if you are going, you have 4 weeks to prepare to pass the free exams that you can take while attending the conference.
Why get certified? It's getting harder to keep your skills up to date these days with everything changing so quickly and the huge volume of information that you are bombarded with every day. Certification exams are focused on a specific topics and cover a limited number of objectives that are related to the tasks performed in that job role. So when you are studying for the exam, you are studying only a subset of the content that is available for the product. This targeted studying can be a more achievable way to increase your skills as you'll do a piece of learning and then testing at a time.
To help you target your studying, we have a set of study guides that you can use to prepare to pass the exam.
Here are the books:
DB2 9 Fundamentals Exam 730
Roger Sanders' book: DB2 9 Fundamentals Certification Study Guide
DB2 9 DBA for Linux, UNIX, and Windows Exam 731
Roger Sanders' book: DB2 9 Database Administration Certification Study Guide
DB2 9.7 DBA for Linux, UNIX, and Windows Exam 541
This exam was updated to the V9.7 level, while the book is at the V9 level. This might cause you a slight problem on some of the questions but overall, you should still be able to pass the exam with this book. If you're concerned, you should examine the exam objectives to see what was added. You could also take the Exam Prep for Exam 541 course that will be taught by Roger Sanders on May 10 at the Conference.
DB2 9 Advanced DBA for UNIX, and Windows Exam 734
DB2 9 Advanced DBA Certification Study Guide by Roger Sanders and Dwaine Snow
DB2 9 for z/OS Database Administration Exam 732
DB2 9 for z/OS Database Administration Certification Study Guide by Susan Lawson and Dan Luksetich
These books will be for sale at the conference, but if you can, purchase the books before the conference so that you have time to read them and study to the degree that you need to.
If you aren't able to purchase the books outright, check amazon or other sites for used copies of the books. Also, libraries might have copies of the books. I know our skill's center library has many copies of these books... and they are VERY well used!
Check to see if your company has a subscription with Safari Books Online or Books 24x7. Both of these electronic book engines carry these books which will allow you to read the entire book or to search and read parts of the book as needed.
The publisher of the Certification Study Guides, MC Press, is working on getting the books available in Kindle format, so that could be an option for you as well.
If you are working with DB2 in your daily job, you may be ready to pass the exam with minimal studying. I suggest that you try an assessment exam to guage your readiness. You may also wish to answer the sample questions that are in the Certification Study Guides. If you are able to pass these questions correctly and easily, you may be ready to pass the exam.
If you want a little more help, consider taking the Exam Prep courses that take place on May 10 at the conference. You can prepare for Exam 541 or Exam 732.
For more information about getting certified, see my previous blog entry: Certification 101.
Have fun in Tampa! Get certified :)
TV, or in this case, YouTube can be an excellent way to learn about many things. I really like that IBM is taking an active role at getting valuable content out on YouTube. What's even better is that many of the videos become viral and end up getting many views.
The videos are extemely well done and worthy of going viral. Take these two videos: Servers for Truth #1 and Servers for Truth #2. The videos are in answer to several claims made recently by Oracle. You'll enjoy... and get the REAL story!
Another set of videos that you may wish to watch on YouTube are the "Let's Build a Smarter Planet" series. Again this is a set of amazing videos that explain how and why the world needs to be smarter. My favourite is the one where Jeff Jonas is the star... which one is it? Watch them all to find out.... you won't be disappointed!