If you've considered making the move to DB2, developerWorks has made it easier than ever to find out everything you need to know.
The new DB2 enablement page for DBAs and database developers is loaded with resources -- articles, tutorials, demos, webcasts, and more -- to help you understand the benefits of DB2 for Linux, UNIX, and Windows. Benefits like industry-leading performance, autonomic admin features, and lower costs.
Are you already working with another relational database management system (like, say, Oracle)? Why not find out how easy it is to migrate your applications to DB2 9.7? Plus, new SQL compatibility features in DB2 9.7 (including support for Oracle's SQL and PL/SQL dialects) make it easy to reuse your PL/SQL knowledge.
And for more on all of IBM's data solutions, stop by our Information Management zone here on developerWorks.
And don’t forget the great books that are available for you to make the move to DB2:
Beginning DB2: From Novice to Professional
by Grant Allen
Understanding DB2®: Learning Visually with Examples, 2nd Edition
by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Last Friday Dan Dubriwny from the Big Data Tiger Team, IBM USA, was the guest speaker on episode 62 of the DB2 Night Show, hosted by Klaas Brant. The topic was BIG DATA Overview - What is it? Who cares? If you missed it, be sure to catch the replay.
According to Klaas:
If you have been to IOD 2011 in Las Vegas then the words Big Data will probably still resonate in your mind. The theme of IOD was "Turn Insight into action" and IBM is the only company that can do this for all sort of big data. Most people think that big data is all about Hadoop. And although Hadoop is one of the components in IBM's solutions it is not what big data is all about. Dan Dubriwny gives in this episode an excellent introduction into big data. It is all about Variety, Velocity and Volume. IBM can handle all of this for both data streams and data at rest. Probably by now you are curious how this all works, so go ahead and enjoy Dan's presentation with numerous examples.
Scott Hayes informs me that there is more… much more! Episode #63 on 18 Nov will be a deep dive into IBM solutions around BIG DATA.
Join special guests Paul Zikopoulos and Robert Thomas, both from IBM, to get a look at why IBM is the right partner for Big Data. You'll find that many vendors offer Big Data products whereas IBM is offering a Big Data PLATFORM. Most of this session will be technical--- show casing, for example, the file system (GPFS SNC) that's used with the IBM Big Data platform as opposed to the open source defacto standard HDFS because it provides better performance, management (it's POSIX compliant), security, and availability; with GPFS SNC, IBM hardens Hadoop for enterprise deployments. Of course, no one quite understands the enterprise like IBM so you can bet we are solving other enterprise challenges such as security, integration, governance, and more.
The DB2Night Show Episode #63: BIG DATA Technologies, Solutions, and Details
Speakers: Paul Zikopoulos and Robert Thomas
Friday, November 18, 2011
11:00 AM - 12:00 PM EST
As Scott always says, join to be educated, informed, and entertained.
Want more on Big Data? Check out this entry: Do you feel the excitement of Big Data?
How do you keep up to date with the massive amounts of technology when your life is already filled to the max? Have you tried listening to a podcast? The advantages of podcasts is that they’re short, concise and portable. I think these three qualities are critical to making a podcast useful. Using a portable device for this learning content will allow you to listen in your car, on transit, while walking, or doing chores around the house.
Here are a few you might want to check out:
IBM Press Podcast series
Hear directly from an author about their book and the topic of the book. For example:
Technical Tips for Enterprise Business Intelligence by Mike Biere
Top Business Intelligence expert and author Mike Biere provides a blueprint for creating winning BI strategies and infrastructure, and maximizing the value of information throughout the enterprise. Two parts
developerWorks Podcast Series
Scott Laningham, editor of developerWorks podcasts, talks with thought leaders
in many fields, paying extra attention to the computing and software element with each
focus. This feed also features other developer-related podcasts from IBM. For example,
Steven Adler: The path to smarter data governance with collaborative structures
Steven Adler, Program Director for IBM Data Governance Solutions, talks about what companies face in the data governance space and some key elements in a successful program.
There are many other podcasts available. In my research I found it a bit overwhelming! On IBM’s home page, I did a search on podcast and come up 1.5m hits. You can get podcasts on Audible.com, itunes.com, and Books 24x7. So much choice!
I hope you have the desire to give it a try.
Just published: Cognos 8 Business Intelligence: The Official Guide
by Dan Volitich
This is the only authorized guide to IBM Cognos 8 Business Intelligence.
Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide
shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips
, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users.
* Measure and monitor performance using dashboards and scorecards * Assign user roles and privileges * Provide complete and consistent access to a broad range of data sources via Cognos Connection* Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines* Enable business users to create reports with Query Studio* Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio* Build Dimensional Reports with Report Studio* Use Event Studio to identify and deliver mission-critical information * Create, modify, organize, and publish a model from Cognos Framework Manager * Implement sound security measures * Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability
When at the IOD EMEA Conference last month, I had many requests for this book, but unfortunately it had not yet been released in Europe. Here are some options for buying the book:
1. For Canada/Canadians – mcgrawhill.ca
2. All other, USA & Intl etc – mhprofessional.commhprofessional.com
3. For Cognos employee purchases
, contact me directly for information.
As you’ve noticed, I’m promoting the upcoming IBM Information on Demand Conference via my blog. Many Europeans are unable to afford the time or money to go all the way to Las Vegas for a conference, so the good news is there is an amazing conference planned for Prague in November. I’m hoping that I can attend in order to set up a bookstore for attendees.
IDUG DB2 Tech Conference in Prague, Czech Republic, 13-18 November 2011, at the Clarion Congress Hotel Prague
- Register on or before 17 October 2011 and receive a discount of EUR 275.
- Multiple Delegate Discount: For every three individuals who register from the same organization, a fourth may attend at the discounted rate of EUR 730.
- Mentor Program: If you have attended three previous IDUG DB2 Conferences, you are eligible to bring a first-time colleague to Prague for an 80% discount off the full registration fee.
How you can hone your expert DB2 skills at IDUG EMEA
- Members of IDUG get 45% off IBM Press books. New books include Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture, The New Era of Enterprise Business Intelligence: Using Analytics to Achieve a Global Competitive Advantage, and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight.
- On 13 November, receive FREE IBM certification training, DB2 migration workshops and sessions for CA customers.
- IBM Certified Database Administrator - DB2 10 DBA for z/OS certification Preparation Seminar - Susan Lawson
- DB2 UDB V9.7 for LUW Advanced Database Administration certification Preparation Seminar - Guy Przytula
- One-Day Educational Seminars - Friday, 18 November 2011
Registration for paid full conference delegates is EUR 450; the cost for just the one-day seminar is EUR 495. Select from the following session topics:
- DB2 10 for z/OS - In Depth, Phil Grainger, Cogito
- DB2 Intermediate and Advanced SQL, Daniel Luksetich, Yevich Lawson & Assoc Inc.
- I Didn't Know DB2 did THAT!, Bonnie Baker, Bonnie Baker Corporation
- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace, John Campbell, IBM Corporation
- Rocket Science: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
- Some of the top rated speakers:
For the complete agenda and speaker list, see this site: http://www.idug.org/p/cm/ld/fid=102
For anyone who was at the IOD Conference last year in Las Vegas' Mandalay Bay, you'll remember how **tired** you were after walking the large distances! Do you want an interesting strategy to deal with the strain your poor legs and back will be under?GET CERTIFIED
If you get certified at the conference or were previously certified, you are welcome to join the Certification Lounge
. The Lounge will once again be featuring tables, chairs, food, beverages, and best of all.... free massages. We want to ensure that you are specially rewarded for earning your certification.
Prepare in advance to make sure that you can begin using the certification lounge from day 1:
Each exam has a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it. How do I prepare to pass an exam?
Here is the recommended path I suggest you take to prepare for a DB2 exam:
1) Choose the exam you want to take based on your job role. The DBA and AppDev certifications first require that you are certified as a Database Associate. To help you decide where to start, see the certification roadmaps
2) Read through the exam objectives. Every question on the exam relates directly to one or more of the exam objectives. For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
Here are the exams that cover the DB2 9 product: * Exam 730
- DB2 9 Fundamentals
* Exam 731
- DB2 9 DBA for Linux, Unix, and Windows
* Exam 732
- DB2 9 DBA for z/OS
* Exam 733
- DB2 9 Application Developer
* Exam 734
- DB2 9 Advanced DBA for Linux UNIX and Windows
* Exam 735
- DB2 9.5 Developer. Although not specifically written for this exam, the book DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
might help you prepare for this exam.
* Exam 736
- DB2 9 Database Administrator for Linux UNIX and Windows Upgrade. See also Kate's blog entry about the upgrade exam!
3) If you are experienced with DB2 and feel that you are prepared to pass the exam based on what you saw in the exam objectives, take an assessment exam
: ibm.com/software/data/education/cert/assessment.html. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses. Assessment exams cost $10 per take, so if you really think you are ready, come and take the exam to see.
4) If you are NOT experienced with DB2, download a free version of DB2 Express-C
and give it a try!
5) Decide on how you want to increase your skills: a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore
For exam prep, the best books are these:DB2 9 Fundamentals Certification Study Guide
by Roger SandersDB2 9 Database Administration Certification Study Guide for Exam 731
by Roger Sanders DB2 9 Database Administration Certification Study Guide for Exam 732
by Susan Lawson
and Daniel Luksetich DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736
by Roger SandersDB2 9 Advanced Database Administration Certification Study Guide for Exam 734
by Roger Sanders
and Dwaine Snow
All five of these certification prep guides were written by members of the exam development team. That is, they created the questions for the certification exam that you are about to take! Also, each chapter of the book corresponds directly to a section on the exam. So, if you take the assessment exam and find out that you are week on a single topic, you simply need to read the chapter that corresponds to the topic where you need improvement. Lastly, the authors created a set of sample questions for the book that provides you with the correct answer to the question as well as an explanation as to why the correct answer is correct and the incorrect ones are not.
For reference and guidance beyond the exam, I suggest the following: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
by George Baklarz
and Paul Zikopoulos
b) For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If you have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials
that are available, see ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners. These classes typically have a fee, even for employees, so check with management to see if you can take one of these classes. Classroom education is an excellent way to learn, but may be difficult to justify due to costs. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps
d) Take a pre-conference class at the ILO Conference:DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
6) If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
.Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:Planet DB2
- a blog aggregator that combines DB2 blogs from around the world.IBM developerWorks
- DB2 PortalIDUG
– International DB2 User’s GroupMy blog
: ibm.com/developerworks/blogs/page/susanvisserKate's blog
Enjoy the lounge!
For Episode #28, TheDB2Night Show is bringing back special guest Mike Winer, IBM STSM and DB2 Kernel Architect.
Mike gave an awesome presentation at IDUG North America in Tampa on DB2 Table Partitioning - during this episode, Mike will share excerpts and highlights of this talk, or "all of the important stuff" in his words.
Are Partitioned Tables right for you? Watch are best practices? How have partitioned tables been improved recently? Watch this Episode and find out!
One studio audience member will be randomly selected to win an electronic gift certificate!
If you can't make the scheduled time, register anyways so that you get information about recorded replays.
We’ve just added a new book signing to our already busy schedule:
The Conversation Manager
by Steven Van Belleghem
Wednesday 1:30 – 2:15
About the book
Over the past years, the internet has evolved from a static to a social platform. This evolution has an impact on the way consumers communicate and take purchasing decisions. Unfortunately, most advertisers have failed to evolve along.
Traditional advertising no longer works. Advertisers need to change their day-to-day working methods. The gap between the contemporary consumer and the traditional advertiser is growing on a daily basis.
This era is not the end of the advertising market, though it is the end of the advertiser!
This book offers a solution to this challenge: a change trajectory from advertiser to Conversation Manager. The Conversation Manager has a fresh perspective on how brands operate successfully in cooperation with today's consumer. Conversing with consumers is the key. Listening to and conversing with consumers is a necessary talent to retrain as a Conversation Manager. Using clear examples and clear concepts, the book describes how an advertiser can retrain to become a Conversation Manager.
The book also goes beyond theory alone. It also offers practical tools to start your change process within 48 hours. You will find concrete tips to move your business strategy into the direction of conversation management. You will find numerous practical online tools to help you in your new role: the Conversation Manager.
About the author
Steven Van Belleghem is Managing Partner of innovative research agency InSites Consulting. His passion is helping clients in taking strategic marketing decisions. Steven is specialized in branding, advertising and word-of-mouth strategies. Together with his team, he’s helping companies get a grip on the current consumers through branding, advertising and conversations.
Before Steven joined InSites Consulting, he was a researcher at the Vlerick Leuven Gent Management School. Today, Steven is still a speaker at the school in a large number of executive teaching programs (e.g. brand management, marketing planning, young management program, …). Steven is also a frequent speaker on marketing conferences and business schools.
Steven is married with Evi Seymortier and has one son, Siebe. He’s a fan of good food & wine, FC Bruges and Disney.
We’ll have this session added to the SmartSite for you to add to your schedule, but in the mean time, keep this time in mind to pick up an early copy of Steven’s book. Note that according to amazon.com, this book doesn’t publish until October 30, so you’ll be getting a copy fresh from the printer!
The following eBooks about key IBM Products are available at a 50% discount for the next two weeks, ending April 17. For all the details, click here. Note that the discount is automatic on these selected eBooks:
Manage and administer your WebSphere application server to create a reliable, secure, and scalable environment for running your applications
Build SOA-based flexible, economical, and efficient applications
Engineer a clear-cut strategy for achieving best-in-class results
Upgrade your system and embrace the exciting new features of the Lotus Notes and Domino 8.5.1 platform
Build scalable, high-performance software with IBM's data grid
Design, implement, and monitor a successful Q replication and Event Publishing project
During November, Packt is celebrating the recent success of its IBM book range with an array of special offers including:
20% off all Packt IBM print books
25% off if you purchase 3 or more books
30% off all Packt IBM eBooks
Here are some you may like to choose:
IBM Lotus Notes 8.5 User Guide
By Karen Hooper
A practical hands-on user guide with time saving tips and comprehensive instructions for using Lotus Notes effectively and efficiently.
IBM Rational Team Concert 2 Essentials
By Suresh Krishna, TC Fenstermaker
Improve your team productivity with Integrated Process, Planning, and Collaboration using Team Concert Enterprise Edition
WS-BPEL 2.0 for SOA Composite Applications with IBM WebSphere 7
By Matjaz B. Juric
Define, model, implement, and monitor real-world BPEL 2.0 business processes with SOA- powered BPM
Getting Started with IBM FileNet P8 Content Manager
By William J. Carpenter
Install, customize, and administer the powerful FileNet enterprise content management platform
(Congratulations Bill! I’m glad it worked out well for you!!)
To see the full range of Pack IBM Books available click here.
eBook Offer of the Week:
IBM Cognos 8 Report Studio Cookbook
Get 40% off the eBook | Get 30% off any other IBM eBook
Offer expires on Mon, November 15, 2010 | Download a free chapter
I’m writing this blog entry from the airport in Montreal. I’m waiting for my flight to Zurich which leaves in the next hour. This will be a vacation for me and I plan to tour the city, the nearby alps, see the Scorpions concert and visit CERN.
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.
Apparently this is Read an E-Book Week. Have your read an e-book this week? I'm reading one that hasn't published yet, but am interested in adding a few more books to my collection.
is offering a 40% discount on the list price eBooks. Visit their store
for a complete list of eBooks and enter the coupon code EBOOK
during checkout to get your discount. This offer is valid through March 15, 2010.
PS... The new book by Sam Lightstone is available as an ebook:
Thanks to Leon
for providing me with this amazing data about the amazing success of the DB2 Express-C On-Campus series of books
IBM DB2 Express-C is the community edition of the DB2 data server that you can download and deploy for FREE. The target audience is small businesses or developers and business partners who serve these customers.
Not only is DB2 Express-C
easy to install and use, but it contains the core functions of the more scalable editions of DB2 such as pureXML and self-managing capabilities. You can find out more about the requirements to use DB2 Express-C on the "About DB2 Express-C
To support DB2 Express-C a series of On-Campus books have been created to support this community. Since the DB2 Express-C product can be downloaded for free, we needed to make sure that we could help people develop their skills for free. Thanks to Leon, Raul, Rav and many others, we have many books available for people to learn for free:
Getting Started with DB2 Express-C
has been downloaded just shy of 83,000 times and distributed to more than 100,000 people world-wide. Just think of that! That's a lot of people learning and using DB2... and creating applications that run on any edition of DB2, regardless of the platform. This book is available in 9 languages, so the coverage is world-wide.
The team who created these books are planning to provide even more! There are 26 new books planned for 2010.
Now the success story behind the success of these books - there were 107 authors involved in the writing and translation of these books. 80 people from IBM and 27 outside of IBM. I hope each and everyone of these people benefit greatly from this career development stepping stone. Writing about anything makes you a better expert in that topic, and we all know that writing is one of the most valuable skills for a person to have.
Do you have your copy of DB2 Express-C and the supporting books yet?
Last week I blogged about the importance and benefit of word of mouth feedback via online reviews
. Today I want to remind you of the series of Best Practices documents
that are available for you.
Each Best Practice paper is designed to provide you with practical guidance for the most common DB2 product configurations. These papers were written by leading experts in IBM's development and consulting teams, and have been extensively tested.
Why learn via trial & error when you can be effective immediately by following the advice in these papers?
Here are some of the topics that you can find:
Don't forget to share your feedback on anything IM related. I'd suggest that you put feedback on the ChannelDB2.com site
, at the very least. You can also share your own insights and comments with other users of IBM DB2 Linux, UNIX, and Windows via the IBM Database Wiki
What are you sacrificing for the promise of big data?
of today's companies are making trade-offs in areas of security and
governance to leverage the promise of big data. Can you have both?
have been several responses to this question. First off, I’d like to
point you to the tweetchat that took place on Wednesday, February 27.
Several experts, including Jeff Kelly of Wikibon discussed the topic:
Garbage In/Garbage Out and data governance’s role in the big data era.
This was a very exciting event and all who participated said they had
fun and are looking forward to the next tweetchat. I had to split the
recap into two blog entries:
plan to write a third blog entry from the information gathered by
pulling out the list of related articles that were mentioned during the
Articles and blog entries related to this theme.
Managing Database Change
by Craig Mullins
looked at the many aspects of managing change, including 9 requirements
for successful change. He also shared his DBA perspective as the
“custodian of database changes.”
3 Big Data Issues: Security, Governance and Archiving
by Dave Beulke
notes, “While the new kid database Hadoop may be getting a lot of
press, it needs more capabilities to keep up with the mature platforms
and databases for data security, governance, archiving and temporal
Productionizing your Big Data: A Checklist of Key Considerations
by James Kobielus
your big data investment production ready? James shares five key
considerations to help ensure your big data investment can function as a
reliable business asset.
Must You Sacrifice Privacy for Big Data?
by Larry Dubov
organizations move towards big data, privacy concerns become very real.
Larry traces the history of privacy and explains why good governance
can help reduce the need to compromise on privacy.
IBM InfoSphere: A Platform for Big Data Governance and Process Data Governance
by Sunil Soares
new flashbook provides an in-depth look at several aspects of governing
your big data, with several case studies to offer guidance and best
practices. Download your free copy.
Controlled Explosion: Keeping Big Data Contained with Security, Governance and Information Lifecycle Management
by James Kobielus
Can you control the big data explosion? James argues that you can, with careful attention to three vital types of controls.
Your Information is a Product
by Steven Adler
is the Chairman of IBM Data Governance Council. His view is that
companies who still treat their data as a raw resource rather than an
essential product that they produce, should prepare to be obsolete.
Steve has an ongoing blog related to the topic. You can find his blog
behind a registration page. Here is an entry to look for: The Data Governance Report Card.
Information Governance and Big Data
by Mike Martin
wrote this blog entry a year ago, but it is still as accurate today as
it was then: “I believe we should include Big Data in Information
Governance, after all one of the major issues we try to solve with
Information Governance is data volume and I consider Big Data solutions
to be yet another tool in the arsenal of Information Governance.”
Data Scientist: Exploration in the Age of the Unstructured
by James Kobielus
unstructured data (however defined) enters the enterprise big-data
picture, data management professionals begin to quake in their boots.
Governance of structured data is an established body of practices and
tools, focusing on enforcing controls on schemas and contents of data
deemed to constitute an official system of records in some subject area,
such as customers and finances.”
Infographic: Valentines: 4 database features we'd love to have in big data era.
Availability, Analytics, Governance, Security, Speed, and Compression. How do these values transfer to the Big Data era?
See also Database technology: Remember me? Big data will remind you!
summary of the conversations focused on how and why big data challenges
are posing a bit of a renaissance for databases. Some people see
databases as a commodity, something that gets taken for granted. But as
big data becomes a reality, databases are again taking center stage.
Follow us on twitter using the tag #bigdatamgmt and join in on the conversation.
whopping 730 votes were cast for our finalists before Friday’s show!
As a result, we have our top 6 and bottom 3 contestants. The task for
the judges is to save one of the bottom 3 and then to hand off the
voting to you the listeners again. Let’s try to beat the number of
votes from last week!
Two of our bottom three:
How I successfully, designed, implemented and monitored IBM InfoSphere Event Publisher.... My Experience.
Publisher is a Subset of Q Replication. Rene provided a good
definition of this tool with very detailed slides. This is a big topic,
but Renu covered it quite well, despite running out of time. The
judges chose to save Renu... so she’ll be back next week!
Hash Access to DB2 Data: Faster, Better & Cheaper
informative presentation with good & detailed slides. He provided
the benefits of using hash organization along with how to convert to
this. This is another big topic. If you’re interested, check out the DB2Night Show presentation starring Phil Grainger who did a 1 hour presentation on this topic previously. (see replays)
Our topic six:
How DB2 10.1 Changed the Data Warehouse Terminology ETL to ETi
covered the Ingest feature of DB2 10. He covered this feature in
detail along with a comparison study. He finished on time. Interesting
topic. Well done.
Save me in, locks you out.
Finished early. Nice presentation. Simplicity. Well done.
Counting your Carbs: Watching for the little things that add up
Keeping watchings on tables and indexes that are growing.
Seems like this technique could be a huge time saver!
Great presentation... very good topic that many people struggle with.
Nice solution provided!
Mon_Get_Pkg_Cache_Stmt: Tips for Finding Problem SQL
These functions were introduced in 9.7 and are strategic.
Good guidance on setting the parameters for optimal use.
Related blog entry available.
Ember is a pro. Awesome job. More people should be using these monitoring tools!
our hosting service had technical difficulties, so there were many
people who could not join today... including two of our top 6
contestants. Host Scott Hayes was able to get links to where you can
preview their presentations:
- Eric, How to Analyze and Improve SQL execution time (with db2batch). Eric was unable to connect to GoToWebinar. CLICK HERE to get a PDF of Eric's presentation.
- Mikko, Performance Management with Primary Key Design. Mikko was unable to connect to GoToWebinar. CLICK HERE to get Mikko's presentation (PDF format).
- Armando, Dare to be different, SQL Performance Tuning Part 3 - using utilities. Armando was unable to connect to GoToWebinar. CLICK HERE to get Armando's presentation (PPT format).
When casting your votes, please give these finalists earnest consideration.
Time to VoteLive
studio audience and replay viewers can access the show’s survey to vote
and for a chance to win our $25 Amazon.com gift certificate drawing.
The survey is embedded at the bottom of the replay blog. After you
complete the survey, it will close automatically. Only one entry per computer is allowed. Also, to minimize the "I'll just vote for my friend effect", we are now requiring that you must vote for TWO or more finalists. You can still vote for your friend, but be sure to cast a vote for at least one other good presentation!
Coming Next: We
have two more shows in the “DB2’s Got Talent Competiton”. March 15 and
22. Join us to learn, to support up-and-coming presenters, and to have
Scott’s summary of the show and to access the replay.
DB2 NightShow: Episode 5 of the DB2's Got Talent Competition
Judges present on the DB2Night Show "DB2's Got Talent" Competition
DB2 NightShow: Episode 3 of the DB2's Got Talent Competition
DB2 NightShow's 2013 DB2's Talent Competition
Promote yourself and DB2 with the help of my slides in SlideShare. Here’s where you can get them: Db2 night social_promoting_susan.
Have you been holding off buying books? Don’t wait any longer. For the next
6 days, you can save on Books and eBooks with this Presidents' Day offer from
IBM Press. Now through February 21, buy any two eligible titles and save 40%
with coupon PDIBM. Start
Need some suggestions? I have a few for you!
by James Taylor
by Sandy Carter
by Kevin Maney, Steve Hamm, Jeffrey O'Brien
by Roger Johnson and Filip Draskovic
by Anthony Giordano
by Craig Mullins
by Barbara Klein, Diane Goff, John Butterweck, Kenny Blackman, Margaret
Wilson, Moira McFadden Lanyi, Rick Long, Sandy Sherrill, Steve Nathan
by Michael Biere
by Allen Dreibelbis, Eberhard Hechler, Ivan Milman,
Martin Oberhofer, Paul van Run, and Dan
by Eberhard Hechler, Martin Oberhofer, Steve Lockwood,
Michael Schroek, Mario Godinez, Klaus
by Matthias Nicola, Pav Kumar-Chatterjee.
Keep your skills sharp by reading books!
Get your copy of book: The
Art of Enterprise Information Architecture: A Systems-Based Approach for
Unlocking Business Insight
written by the following author team:
Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, Michael
•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.
Mario Godinez is Executive IT
Architect and IBM Senior Certified IT Architect within IBM's Worldwide
Information On Demand Architecture team. He co-founded IBM Software Group's
Information Management Technical Enablement team, and has spent 15+ years
helping IBM financial and industrial customers architect and implement complex
Eberhard Hechler is
Chief Architect of the European IBM Information On Demand Technical Center of
Excellence. As Senior Certified IT Architect (SCITA) and Executive IT Architect,
he is a technical leader of the Information Management organization at the IBM
Germany Research and Development Lab. He co-authored Enterprise Master Data
Klaus Koenig is an IBM
Distinguished Engineer and has been involved in IT for 20 years. He is an
internationally recognized expert in the field of IT architecture management and
IT infrastructure design. As key innovator and chief technology executive he is
currently leading several development and transformation initiatives, the major
ones in the area of Cloud Computing, Green IT, Service Lifecycle Management and
IT Process Automation.
Steve Lockwood works
in IBM Software Group as a Lead Architect and within IBM's Business Intelligence
practice (a part of Global Business Services). He has been involved in all
aspects of the development of information related projects, covering Data
Warehousing, analytics, Information Integration for CRM solutions and
development of Master Data Management solutions.
Martin Oberhofer is a Senior Technical
Consultant at IBM and a member of the World-Wide IBM Software Group Master Data
Management Center of Excellence. His areas of expertise are Master Data
Management, database technologies, Java development and IT system integration.
Michael Schroeck is a Partner and the Global
Business Intelligence (BI) and Information on Demand (IOD) Leader for IBM,
Global Business Services. Mike has a proven track record in having guided
project teams in the design and successful implementation of large, complex
BI/IOD Solutions (e.g., decision support, integrated analytics, data
warehousing, data mining, etc.) for a wide range of clients.
A new exam was recently added to the large collection of Information Management Certification Exams. This one leads you to become an IBM Certified Specialist - IBM InfoSphere Optim for Distributed Systems - V7.3.1.
This intermediate level certification is intended for application developers, database administrators, and technical personnel who perform the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of InfoSphere Optim environment.
- product installation and configuration
- configuration of security
- archive and extract maintenance
- archiving and Optim Connect
- creation and maintenance of test data
- privatizing data
- accessing extended data sources using Optim Connect and InfoSphere Federation Server
- implementing a test data management environment
- performance and tuning
The person performing these functions is generally self-sufficient and is able to perform most of the tasks involved in the role with limited assistance from peers, product documentation and vendor support services.
To earn this certification, you need to take one exam: Test 000-552 - IBM InfoSphere Optim for Distributed Systems - V7.3.1
There are four sections on the exam. See the full set of exam objectives.
Section 1 - Installation and Configuration (25%)
Section 2 - Optim Core Functionality (35%)
Section 3 - Advanced Topics (34%)
Section 4 - Performance and Troubleshooting (6%)
To prepare to pass, here are the recommended courses that you could take:
As always, you can keep up to date with the latest exams and education offering updates from this site: ibm.com/software/data/education/
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
DB2 LUW Performance Update & Best Practices with special guest Berni Schiefer, Distinguished Engineer, IBM Toronto Lab
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.
RESERVE YOUR Studio Audience FREE SEAT: Friday, April 30, 2010 at 10am CENTRAL.
We will be broadcasting at your favorite screen resolution. For audio, VoIP and local country telephone numbers will be available for US, Canada, European countries, Australia, and New Zealand. You are responsible for your transportation to our "Studio", popping your own popcorn, and your favorite beverage.
The DB2Night Show Episode #18
The TOP TEN DB2 LUW Mistakes with special guest Klaas Brant, IBM DB2 Gold Consultant & Founder, KBCE
Scott and Klaas were SKYPE chatting recently and were lamenting the long list of frequent mistakes that DB2 LUW professionals make. Klaas came up with the idea of doing a Top 10 List of common mistakes as a DB2Night Show theme.
Klaas Brant is the founder of KBCE, a company that specializes in DB2. He specializes in administration, tuning and backup/recovery strategies. Klaas has been working with DB2 for more than 20 years and has published many DB2 articles. He has been the organizer of the DB2 Symposium for more than 10 years and is the chairman of the Dutch DB2 User Group (DDUG). He is an IBM certified DB2 Database Administrator and a member of IBM's DB2 Gold Consultants Team.
During this episode, we'll cover Klass Brant's Top 10 Common Mistakes made with DB2 LUW. You host, Scott Hayes, will add a couple of his own too. What mistakes do you commonly find? Send us an email or contribute to a discussion in our show's LinkedIn group.
RESERVE YOUR Studio Audience FREE SEAT: Friday, 7 May, 2010 at 11am CENTRAL.
We're going to set aside technical DB2 skills in this episode, and instead we're going to have a nice chat with Sam Lightstone, author of the new book "Making It Big in Software
". We're going to try to find out "What does it take to be successful?" Certainly technical skills are part of the equation, but how can one accelerate their career?
In his book, Sam covers these topics and more:
- Get your next job in software development
- Master the nontechnical skills crucial to your success
- Work the organization to move up rapidly
- Successfully manage your time, projects, and life
- Minimize software project overruns
- Successfully manage your time, projects, and life
- Avoid killer mistakes that could destroy your career
- Move up to "medium-shot", "big-shot", and finally, "visionary"
- Launch your own winning software company
You might also be interested to know that Sam Lightstone was a significant contributor "brain" behind the development of the IBM DB2 Design Advisor (db2advis).
RESERVE YOUR Studio Audience FREE SEAT: Friday, May 28, 2010 at 10am CENTRAL.
I’ve been reading IBM Data Management magazine
since it was launched 15 years ago. I’m sure you’ve read an issue or two as
well! The next generation is about to launch and it will capitalize on digital
The world looked very different when the IBM Data Management
magazine was first launched. Digital technology allows a whole new world
of opportunities and the new online format gives us more flexibility to cover
the latest information management developments and IBM advances as they happen.
IBM Data Management
magazine will deliver new kinds of interactive, highly dynamic content,
such as webinars and video. And it gives us a platform on which to create a
strong community of the world’s top information management professionals. This
inflection point also represents a unique opportunity for us to feature a
broader range of voices from across the industry. We're always looking for great
stories and now because we can update content almost immediately, it will be
easier for us to highlight important topics that are timed to a specific day and
Another benefit of going digital is it will make it much easier for you to
find previously published content. A little known fact is that we have 4 years
of articles available for you to search & read. I’m sure you’ll find a
treasure in this vast collection.
Bookmark the URL for the magazine and check back often to find out about the
latest hot topics!
PS: If you’d like to contribute to this magazine, reach out to me and I’ll
connect you with the editor. If you need help writing an article, I highly
recommend that you read Roger Sanders’ book: “From Idea to Print: How to Write a Technical Book
or Article and Get It Published”.
Q5 Once you decide what data to keep, how do you make sure it goes to the right systems and people?
jeffreyfkelly From a developer perspective, Big Data app dev tools need to improve, make it easier to deliver insight to business users.
BTRG_MikeMartin You must increase control of wasteful data even with Big Data Management, archive/retire & dispose http://t.co/Ta361ASBkP http://t.co/904FjTm2yA
Again it's a matter of information liability and asset management.
Which is more critical to your organization? Cutting risk or mining
BTRG_MikeMartin Big Data doesn’t change retention. Keep the data you need, get rid of the rest . You can’t afford to keep it all. http://t.co/Ta361ASBkP
dvellante This is a metadata problem / opportunity
craigmullins Policies, procedures, automation and education are needed to ensure that Big Data makes its way to the right systems + people?
Big Data approach needs to include improved business outcomes which
requires people process & technology working in harmony.
BTRG_MikeMartin You need to instrument processes to not only govern but make the best use of valuable data.
Data is code in the new paradigm of new apps & services - lots of
issues so developer create & data can learn & be smart.
furrier The integration of data create new datasets - future is smart data and learning data - data is code.
jeffreyfkelly Exactly, and new data sets could be highly sensitive - need governance RT @furrier: the integration of data create new data sets
Betharonoff Data as a commodity already exists, so economy is only a few steps down the road.
furrier Meta data practices will be impacted in this data quality and data-as-code concept.
furrier One aspect of this chat is business competitiveness in integrating data as code into business lifecycle and processes.
BigDataAlex Metadata tags are aligned to role based systems - automated systems.
If you don’t improve processes with Big Data management and create
better business outcomes your Big Data initiative isn’t a success.
Kari_Agrawal When and how do we decide to discard the extremely old data? Or do we retain it as in Data Warehouse?
craigmullins You need policies and automated procedures based on retention requirements.
PPB13 How do practitioners overcome emerging skepticism in the marketplace? http://t.co/x0pHJCDcfN
@BTRG_MikeMartin: You need to instrument processes to not only govern but make the best use of valuable data
BigDataAlex Moving "beyond search"
TheSocialPitt ALWAYS start Big Data project by thinking+planning. More data does not fix bad process.
BTRG_MikeMartin What processes to improve: ediscovery, ECM, Data Governance, Data Security, data retention, and data quality.
IBMbigdata Who decides "best"? RT @BTRG_MikeMartin: You need to instrument processes to not only govern but make best use of valuable data
joycetompsett Data quality has to take on the idea it will be moving around different sys/APIs Big Data management > critical for security #RSAC
BTRG_MikeMartin - Without the right tools data retention with Big Data could be a nightmare
skenniston RT @furrier: We all want data retention but who owns it after it's retained..will a data marketplace economy develop?
BTRG_MikeMartin That's where determining business value, legal and regulations come in typically only 30% of data.
Kari_Agrawal How exactly do we begin to classify data in case of Big Data?
craigmullins MT @PPB13: How do practitioners overcome skepticism... <-- by continuing to do work that adds value to your company
dvellante @BigDataAlex yes re: search - it's sometimes used as a 'blunt instrument'
Aarti_Borkar Deciding what data to retain needs to start with business policies defined upfront - its not an "on the fly" decision.
praxsozi RT @jeffreyfkelly: Q5 Big Data requires rethink of business processes - this is NOT a trivial exercise
Natasha_D_G Culture also plays role RT @jeffreyfkelly: Q5 Big Data requires rethink of business processes - this is NOT a trivial exercise
TheSocialPitt Data antique dealers RT @furrier: We all want data retention but who owns it after it's retained.will data marketplace develop?
tomjkunkel @BTRG_MikeMartin Integrated effort with Legal, Finance, Sales, Marketing with IT serving through best architecture.
BTRG_TomNestor The process must lead to better data which should drive better business opportunities.
BTRG_MikeMartin Big Data is not immune to the laws of information economics: http://t.co/Ta361ASBkP #CGOC
Q6 How does Big Data affect data lifecycle management? Does big data introduce new stages to the info lifecycle?
Summary of top answers:
BigDataAlex Yes, new stages - stages we haven't even imagined yet. Data needs to update itself into authoritative sources.
craigmullins One issue that arises is "How can you create realistic test data for testing Big Data systems and applications?"
jeffreyfkelly Yes, but we are just starting to understand Big Data lifecycle mgt - need to build out best practices.
BTRG_MikeMartin Big Data might not create new stages in life cycle management, but certainly with new domains we have to extend the data lifecycle to new platforms.
I disagree - I think new stage of LCM includes emergence of new data
sets created from integration of other data sets and then yet new data
sets created from integrating new new data sets, and on and on and on.
Aarti_Borkar Big Data makes handing the lifecycle of data a far more complex problem than before.
Natasha_D_G Can u say more? RT @Aarti_Borkar: Big Data makes handing the lifecycle of data a far more complex problem than before
Aarti_Borkar Big Data does not create new stages - just new ways to apply the existing stages to different use cases.
Dmattcarter What are some of those new use cases?
Aarti_Borkar Test Data and Privacy for Big Data is critical - as we bring in more data potentially creating a bigger security threat.
BigDataAlex Is there a new data management paradigm emerging?
craigmullins A new paradigm may indeed be emerging.
BTRG_MikeMartin RT perhaps a refined one
TheSocialPitt One new stage = 'ephemeral'.
craigmullins Let's not burden Big Data with things little data has not yet mastered.
craigmullins Sometimes we forget that - in practice - many orgs do not follow a lifecycle, practice data governance, ensure quality, etc.
craigmullins So yes, Big Data should do these things, but it is not failing if it does not.
Big Data Management requires identification & deletion of
ROT-redundant, obsolete & trivial data, which reduces storage &
StevenDickens3 What role does the community see for the original Big Data system of record the mainframe?
BTRG_MikeMartin Consider impacts of eDiscovery, governance, security and #ILM on Big Data stores how do we move traditional methods to Big Data management.
BigDataAlex Many organizations can only afford to store 20 copies of the same data - they are looking for authoritative against process.
jeffreyfkelly definitely, data sprawl becomes an issue
Kari_Agrawal How do we deal with redundancy in case of Big Data?
StevenDickens3 What is the collective view of centralised data vs multiple federated copies ?
Could some Big Data mgmt stages be the elimination of stages? Using
data/ data analysis without constraint and eliminating steps.
Aarti_Borkar Masking test data is essential to Big Data development: what the enterprise considers private needs to always be privatized.
craigmullins My next two Tweets mentioned some of them. Not saying Big Data shouldn't just that our stds should not be too high
craigmullins @BigDataAlex Yes #littledata concepts apply to Big Data... but many orgs still struggle with managing little data
tomjkunkel @Kari_Agrawal Destroy it! I can provide insight on best practices
Dmattcarter Pretty intense data quality and Big Data conversation going on around Big Datamgmt chat!
is already a data problem with #smalldata carrying it over to Big
Datamgmt. Too costly to delete all data that has no value.
BTRG_MikeMartin You must increase control of wasteful data even w Big Datamgmt, archive/retire & dispose: http://t.co/Ta361ASBkP http://t.co/904FjTm2yA
Q7 Are new tools and platforms required to manage Big Data and the new dimensions of the data lifecycle?
Summary of top answers.
craigmullins Tools for performing advanced analytics on Big Data – though not new to the industry – will be new to many organizations.
BigDataAlex Yes. We need new tools, platforms, and systems....it is happening. Calling for massive innovation - love #DataAsCode.
BTRG_MikeMartin @craigmullins It's called defensible disposal http://t.co/Ta361ASBkP
craigmullins Hadoop-based products will need to be augmented with mission-critical DBMS capabilities to become de rigueur.
craigmullins But I think DB2 (and other RDBMS products) could be extended with Big Data capabilities before that happens.
BTRG_MikeMartin Flexibility & scalability of Big Data platforms will themselves assist in helping Big Datamgmt security & controls...
BigDataAlex We need DigitalDNA - anticipating the Internet of Things - World Wired Web.
Aarti_Borkar It’s a mix of new tools and enhancing existing tools. The core solution does not change it morphs
StevenDickens3 All depends where data resides today and whether the current platform/tools are fit for purpose, if yes why move or retool?
tomjkunkel Legacy storage assets can't handle the high availability,low latency applications and need to be displaced.
jeffreyfkelly Yes, a major topic at #strataconf is making Big Data enterprise ready -need better mgt, data gov, DQ capabilities.
Aarti_Borkar Key innovation is required to ensure that both traditional and#big data are uniformly governed.
BTRG_MikeMartin Infosphere Optim helps you get control of structured data to feed only the good into Big Datamgmt: http://t.co/Y5Jniunn6N
jeffreyfkelly And don't forget security - #RSAC - must keep Big Data secure
craigmullins Which brings up regulatory compliance... another big issue
Aarti_Borkar Big Data gov starts with a uniform set of data classification and policies that cover ALL data. Metadata is the magic here.
craigmullins If the Big Data contains PII then all the regulations that apply to PII still apply - doesn't matter how big the data set is.
BigDataAlex Does this spill over into machine learning? Can we reduce dimensionality of data through associative memory?
BTRG_MikeMartin Yes innovation & big ideas as well as change our paradigms.
Betharonoff Interesting query RT @BigDataAlex A7: Can we reduce dimensionality of data through associative memory?
Q8 How does Big Data impact data stewardship? Who “owns” particular data in a big data environment?
BigDataAlex Great question - ownership is beginning to blur - standard licensing models for data are being challenged.
craigmullins All data is owned by the company, whether it is Big Data or not…
jeffreyfkelly Ah, but is it? social data, market data etc.
Internal ownership of Big Data while beyond traditional areas should
still be based on business value, compliance or legal hold.
craigmullins Of course proper data governance policies need to be enacted by the corp to confer #datastewardship and ensure proper treatment
BTRG_MikeMartin Without good data stewardship & Big Datamgmt it will difficult to unlock the value of big data: http://t.co/hGJ3QkTiJf
Aarti_Borkar Ownership of replicated data is the original biz owner- governance of that data is still their problem.
jeffreyfkelly This is a really hard one, again new biz processes informed by Big Data will impact who owns the data.
Aarti_Borkar Stewardship does not change just because a new copy of the data was created.
craigmullins True, but some Big Data is all new.
craigmullins The word "own" is always so troublesome, isn't it?
BTRG_MikeMartin Yes it needs to be well defined .
Aarti_Borkar @craigmullins - Oh so right! .. think "Responsible for".. is better than "own"...
BigDataAlex If DataAsCode, then if DataAsCode is viral, can it be controlled? Do we want it to be controlled? What does ownership mean?
BigDataAlex How does OpenSource apply to our Data?
BTRG_MikeMartin For more Big Datamgmt resources Data Privacy and Security: http://t.co/UL0VNCiivP
is a lot of information! I hope you can follow the discussions. I
tried to clean up a little bit and hope that I didn’t change any content
from the participants.
Besides the massive world events that are taking place and creating history,
there are many other events taking place in the month of March in the
Information Management area that you may wish to know about.
First of all, you likely know that today is Pi Day. OK, now
you know I’m a geek :)
Second, IBM’s Centennial. SVP Robert LeBlanc came and spoke to the employees of the Toronto
Lab this morning. He’s on an executive campus tour to tell people about the
innovation that IBM has been part of in the past 100 years and encouraged us
with his prediction that the next 100 years will also entail incredible
innovation. If you haven’t seen the centennial videos yet, I suggest you do. They are well done
and very motivating.
Next, there are two chats with the lab this month. One for Informix and
another for DB2:
Chat with the Lab: March 31: DB2
and Oracle - An Architectural Comparison
Chat with the Lab, March 17:
"Upgrading to Informix 11.7"
For DB2 for z/OS, there is also a webinar that sounds interesting:
Improve your ROI with DB2 for
z/OS and WebSphere, March 29
There are two final episodes
remaining in the “DB2’s Got Talent” Competition. Last Friday we had the
second of the 4 finalist episodes and there are still 7 contestants. During the
finalist episodes, it is you, the audience, who will “vote” for the winners.
Make sure you watch the replays and cast your vote. The talent and tips we’ve
seen over the past 6 weeks have been incredible.
On a personal note, it is March Break this week, so kids are out of school,
Saint Patty’s Day is this week and I’ll be visiting NYC to celebrate, and I have
a birthday coming. Is it this busy every March??
Have fun :)
Modified on by svisser1
August first is my anniversary as a full-time employee with IBM. I started straight out of university in 1989 and also worked 4 months as a co-op student in 1988.
Time flies! And what an adventure it has been. I’ve changed jobs several times, worked for many managers, and met many extremely intelligent people both in and outside of IBM. I must say it has been an awesome career in many ways. I still feel “fresh” and hope that I have many more years as an IBM employee!
In addition to this milestone of 24 years with IBM, my blog has surpassed 4 million views! It passed this mark on July 26... but I thought it would be good to mention on the same day as my anniversary. As of right now, here are the details:
Apr 28 2009 | 1,046 Entries | 655 Comments | 4,027,735 Visits
I’m proud of this great accomplishment and grateful to all my readers. I’m also grateful to those who helped me through the years on this blog in many important ways: encouragement, setting it up, working through problems, recommending posts, sharing, etc.
Here are a few of my favourite or most popular blog entries.
Trying to get fired?
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! Certification I've blogged about how to get certified many times. The... [More]
New White Paper: IBM DB2 and Canonical Ubuntu
IBM DB2 and Canonical Ubuntu: Your Database Software and OS platform Solution for Enterprise Computing by Andre Albuquerque , IBM Canada Lab Boris Devouge , Canonical Ltd. Hua Lu , IBM Canada Lab You can find this white paper on the DB2 Wiki , which if you don’t visit very often, you’ll be very happy with the outstanding amount of technical information you’ll find on the site. If you want to get the IBM DB2 and Canonical Ubuntu white paper directly, click the title to go directly to the PDF. This paper will help you to get started with... [More]
New Flashbook: DB2 10.5 with BLU Acceleration
Just in time for IDUG, Paul Zikopoulos and his team of co-authors have created a new ebook for you to deepen your skills in regards to the latest release. Here are some details about the flashbook: Title: DB2 10.5 with BLU Acceleration - New Dynamic In-Memory Analytics for the Era of Big Data http:// bit.ly/DB2BLUFlashbook Authors: Paul Zikopoulos, Matthew Huras, George Baklarz, Sam Lightstone, Aamer Sachedina Technical editor: Roman B. Melnyk ... [More]
Making it Big in Software
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 successful! This book, written by Sam Lightstone shines light on the differences between the skills acquired in university versus those needed to succeed in the business world. It also shares what recruiters look for in a candidate and what preferred skills... [More]
Welcome to my Blog
It seems funny to write a “welcome to my blog” entry after blogging for so many years! I’m sure I did such an entry when I first started my blog in 2005. I know that I’ve written welcome-type entries after inviting many people at a conference to read my blog. My motivation is twofold. 1) I’ve been reading Antonio Cangiano’s book about Blogging: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence and 2) I’ve changed my blog template and following the instructions in Bob Leah’s blog: Design @... [More]
Again, thanks to all of you!
As you know, the only constant in life is change.... so there are constantly changes being made to the certification programs. Here are two recent pieces of news that you should be aware of:
1. Assess and Save Promotion is back!
By popular demand, the Assess and Save special offer returned July 1. Purchase and pass any Information Management Online Assessment Exam through Prometric Testing July 1 - Sept. 30 and receive a 50% off voucher towards purchase of the corresponding exam. That's $100 back in your pocket. Candidates from the first phase of this offer experienced significantly improved pass rates on the actual exam.
2. Two new exams:Exam 419 - IBM InfoSphere QualityStage v8
Exam 555 - IDS 11.50 Fundamentals
Major topics covered by the test include
- Design Considerations
- Rule Sets
- Setup and Troubleshooting
The successful candidate for
the IBM Certified Database Associate - Informix Dynamic Server 11.50
Fundamentals has important knowledge, skills, and abilities necessary
to provide entry level administration of IDS 11.50, including basic SQL
(Structured Query Language), how IDS 11.50 is installed, how to create
databases and database objects, security, transaction isolation, backup
and recovery procedures, and describe replication technologies and
This certification targets:
- Entry level technical professionals - programming, system design, architect
- University students - application of information technology
- Entry level DBAs - database administration
3. Stay in TouchDB2 training and certification on Facebook
Become a fan to get updates on changes as they happen!
That's it for this week! I hope you've found this 4-part series helpful.
Part 1) Benefits of Getting Certified
Part 2) How to Prepare to Pass
Part 3) Details of the Db2 Certification Program
Part 4) This post
I am looking forward to going to Denver this weekend in preparation of IDUG NA which starts on Monday, May
14. I’m hoping to blog and tweet from there, so regardless if you are at the
conference or not, you can follow what’s going on. Here are some key links:
- #idugna for conference level tweets
- #idug for IDUG in general
- @IDUGConference will be used for announcing room changes and formal
IDUG’s Facebook page will also be pretty busy during the conference too: www.facebook.com/IDUGDB2
Scott Hayes has set up an aggregator site
that includes all of the tweet related to IDUG: http://bit.ly/idugna12
Mike Krafick is the social media guru for IDUG. He tweets from IDUGDB2 and is looking
for more followers. He’s trying to get more followers than my twitter account
susvis. Let the
More information about this year’s IDUG Conference:
On Tuesday in the Exhibit Hall, we'll be handing out a limited supply of
signed copies of the New Flashbook
for DB2 10. For those of you not at the conference, follow my blog for
information on how you can download a copy for free.
Two other books will be launching at IDUG this year. We don’t have a
bookstore, but be sure to speak to the authors for information on ordering a
copy for yourself at a discount offered to IDUG attendees:
The winner of this year’s DB2’s Got Talent competition was Kohli (We HAVE a winner! DB2’s Got Talent
Competition) and he chose to attend IDUG Denver as his prize. I’m looking
forward to meeting Kohli. If you were also a competitor, please find me at the
show and introduce yourself.
If you’re interested in writing articles or books, or reviewing any of the
upcoming books… also find me and let me know. I may have some interesting
opportunities for you!
Have you been taking advantage of the rich content available from IDUG? IDUG is the Worldwide DB2 User Community and if you don’t yet know about them, but work with DB2, you should take a look at what they offer:
1) A very rich website filled with resources that you can access to deepen your skills. Resources include CDs filled with conference presentations, webcasts, videos, blogs, articles, Solutions Journal e-Magazine and more.
2) Three full conferences each year: one in North American, one in Europe, and one in Asia. In 2011, the conferences will be:
IDUG North America 2011, May 2-6, 2011, Anaheim, California, USA
EMEA - 14-18 November 2011 in Prague, Czech Republic
ASIA – To be announced.
3) Regional symposiums and events throughout the year and the world.
4) If your educational budget is limited, please remember IDUG's Mentor Program where you may qualify for a special low rate if you bring a first time attendee to an IDUG conference.
5) Volunteer opportunities. You can speak, teach, organize, plan, or get into leadership positions. More about this:
IDUG is a volunteer run organization. In order to appropriately recognize excellent work from our many IDUG volunteers, the Volunteer Management Committee of the Board of Directors is now accepting nominations for IDUG Volunteer of the Year. If you have seen exceptional effort, exemplary work, or outstanding performance from an IDUG Volunteer, please send the specifics to firstname.lastname@example.org.
Have you ever thought of serving on the IDUG Board of Directors? Do you know someone who might?
The IDUG Board of Directors is responsible for setting the overall strategy for our organization, and coordinating the activities of our various volunteer teams around the world. We are beginning the process of putting together the 2011/2012 slate, and would like to invite nominations for a role on next year’s Board of Directors. This is a great opportunity to help shape the organization and grow the worldwide DB2 community.
If you have a clear vision for IDUG’s future, can think strategically as well as tactically and are passionate about IDUG’s mission, we want to hear from you! If you know of someone else who fits these criteria and would like to nominate them, that’s fine too!
Please complete the form by clicking here and return it to email@example.com no later than Monday, 27 December 2010.
Join IDUG for free and get connected to a fabulous community of people who will quickly and easily become a second family to you.
Did I ever tell you that I love my job? Part of why I do is because I’m surrounded by some of the most creative people in the world! Yes, all these developers in the Toronto are very creative, but right now I want to mention authors.
I’ve met famous authors: Malcolm Gladwell and Steven Covey, famous people who became authors: Devon Harris (bobsled olympian) and Michael Eisner (Mr. Disney) and just plain interesting people who have written books: Mark Jeffries, Chris Anderson, Magnus Lindkvist, and Chad Fowler. Meeting these people is the icing on the cake, but I’ve noticed that they have the same enthusiasm and drive as the lesser known authors who I work with to get books about DB2 and other IBM products produced.
Let’s start with some of the most prolific authors who I know. Enthusiasm is number one, but one of the things that sets these people apart from others is their desire and willingness to teach other people the tricks of the trade:
Then there are the gold consultants. These are people who don’t work for IBM, but may as well. They are essentially IBM’s cheerleaders. I should say that Roger, Craig, and Rebecca listed above are not gold consultants, but they are definitely passionate about IBM’s DB2 products!
Rick Van Der Lans
And then there are the IBMers who are already so busy in their day jobs but still manage to find time to write a book! Paul, George, and Bill also fall into this category:
I should also make a note here to congratulate those authors who are writing in English even though English is their second language!
Finally, there are the people who want to be authors who find the time to create a proposal and send it to me. I hope that these people one day find the right topic to become their book. These people tend to review many of the books that I work on and are amazing reviewers.
What makes a good author? Writing a book is very hard work, so the two primary things that are necessary for success are willingness to work hard and a very strong passion for writing about the chosen topic. Roger Sanders is writing his 21st book and this one is about how to become an author of technical articles and books. If you are interested in writing, I high recommend that you start with Roger’s book: From Idea to Print.
I wasn’t able to list all the authors who I admire in this post, because believe me, there are many more. I appreciate all the experience, passion and hard work that you pour into your projects. I hope you all have many more books in you and that you encourage others to follow your paths.
If you will be at the IBM Information on Demand Conference this October, please stop by the many book signing sessions that I have planned to congratulate an author on a job well done. To find the book signings that are scheduled, search on “signing” when logged into the Smart Site. You should find 15 entries.
Another author we featured at the IOD conference was Maria Villar
. Maria and Theresa Kushner
recently published the book Managing Your Business Data: From Chaos to Confidence
I didn't attend Maria's sessions, but had the pleasure of sitting with Maria while she did a book signing! I very much enjoyed my time with Maria and could tell by the comments from the people who did attend the session and came to buy a book, they they were captivated by Maria's ideas.
I now have a copy of the book and intend to read it. Take a look for it. It should be on amazon.com very soon, but you can also get it direct from the publisher racombooks.com
What's in the book? Here is the information from the publisher:
As a business person, you probably have more data and more kinds of data available than ever before. But has it helped? Sometimes, maybe. But, for many executives more data has just added more fuel to feed the fire of their love/hate relationship with it. You love it when it gives you good information about which markets to pursue or how to compete more effectively. But you hate it when you can’t get sales figures in time or worse still, when they don’t reflect "reality."This book was written for the executive who wants to understand the lifeblood of his/her company, wants to be able to make better decisions, and knows that managing information is the best way to protect and grow a business.
This book is designed to help you as a business leader think about the use of data and its impact on your daily operation. In 2 sections and 12 chapters it provides practical guidance to balance the use of hard facts and your professional instincts; how to identify and focus on the numbers that matter for your organization; how to overcome the obstacles to getting a complete view of your customer; how to meet risk and security standards; 12 steps to effective business performance management; and how to grow a data culture and make it work for you.
Newly minted MBAs are known for saying, “Just give me your number.” Savvy managers know that it’s not that simple. They also know that it’s not that difficult. Managing Your Business Data provides the wise counsel that every executive can use to manage his or her organization’s data more productively.
Enjoy! susan[Read More