This book, written by
Keep on Learning
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,354 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!
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:  tampa security sessions idug books rebecca_bond conference dba 6,000 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 presenters users books idug conference 1 Comment 7,832 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