database expert is in a critical position to become a hero in this big
data era. Why? Because you know data.. you know your database. Now you
need to know how to expand your knowledge to find the secrets lying
dormant in your awesome data.
help you, I'm posting this podcast which is a conversation between
database expert & IBM champion Jean-Marc Blaise and Big Data expert
Leon Katsnelson. Perhaps you have the same question? Listen & find
Beyond this podcast, we have many other resources available to help you with your learning curve.
First I’ll start with some excellent books.
Big Data: A Revolution That Will Transform How We Live, Work, and Think
by Viktor Mayer-Schonberger, Kenneth Cukier
thought the book was very well written and covered the history of data,
the advent of big data, and what we need to do differently to profit in
this new era.
things will be different. As the author hinted and IBM CEO Ginny
stated, big data is like oil was in the industrial age. Lots of things
changed then to cope with the precious resource and it is no different
stories about current big data successes are inspirational and the
authors make it clear that the untapped potential of data is massive.
Don't let this potential slip out of your hands. Learn what you can now
to see what you can harness from this incredible asset you have in your
highly recommend the book. It is a quick read. If you only have time
for 1 chapter, read chapter 10. It does a nice job of summarizing all
the concepts and issues introduced in the book.
by Paul Zikopoulos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles, Dirk Deroos
an overview of the IBM Information Management Big Data platform. It’s
intended for a broad audience, ranging from those who are brand new to
Big Data, to those on the business and management side, to architects,
and to developers who want a glimpse into the technical details that
underpin this platform.
by Dr. Arvind Sathi
book discusses three perspectives on Big Data Analytics. First, why is
Big Data Analytics becoming so important and what can we do with it.
Second, it lists major components of Big Data Analytics - Unstructured
Data Analytics, Massively Parallel Processing, Adaptive Real-time and
Predictive Modeling, Data Privacy Management, Data Visualization, and
Ontologies. Third, it provides a glimpse at implementation concerns and
how they must be tackled.
written a few blog entries in the past few weeks that summarizes blog
entries and articles that come recommended in your journey to learn
about Big Data:
What are you sacrificing for the promise of big data?
Reading list mined from "Getting Control of Data in Big Data Era" Tweetchat
Recommendations mined from Tweetchat about Mobile Data
Likely the best place for you to keep up to date with all the great things that are happening from a Big Data perspective is the Big Data Hub.
The breadth of content that you’ll find here will keep you busy for
some time. Let me tell you, you’ll be an expert in Big Data very
Upcoming events to mark on your calendar:
Before March 25 - Tell us your most important big data issues in a fun with with IBM’s Smart Sixteen - Big Data Style! See Big Data Bracketology for a description of the “Smart Sixteen” teams in the big data dance by the four regions.
March 27 at 12:00 noon ET - Join
us for our next tweetchat which takes place on Wednesday, March 27 at
12:00 noon ET. Topic is "In-Memory for Big Data Management" with
panelists: James Kobielus, analysts from Wikibon and SiliconANGLE, and
IBM Champions Alex Philp, Cristian Molaro, Craig Mullins, Cuneyt Goksu
April 30 - Big Data at the Speed of Business - Find out more about managing big data, join IBM for a free event.
During this week’s #bigdatamgmt TweetChat that was focused on Getting Control of Data in Big Data Era",
I noticed that many of the experts recommended articles to emphasize
their points. I’ve gathered all of these recommendations to create this
reading list. I hope you find this valuable.
You must increase control of wasteful data even with Big Data
Management, archive/retire & dispose. Big Data doesn’t change
retention. Keep the data you need, get rid of the rest . You can’t
afford to keep it all. Big
Data is not immune to the laws of information economics. You must
increase control of wasteful data even w Big Datamgmt, archive/retire
& dispose. Infosphere Optim helps you get control of structured
data to feed only the good into Big Datamgmt.
PPB13 How do practitioners overcome emerging skepticism in the marketplace?
Without good data stewardship & Big Datamgmt it will difficult to
unlock the value of big data. To deal with Big Data, speed, and volume:
be proactive by starting Big Data Management across the enterprise
now & maintain. Start now on data quality because if you don’t have it in now Big Data only magnifies data issues.
For more Big Datamgmt resources Data Privacy and Security. Exploring
Big Data still requires trusted data so you must secure and govern even
Big Data refers to datasets whose size, type and speed of creation make
it impractical to process and analyze with traditional tools. That Big
Data definition comes from wikibon; see Big Data Vendor Revenue and Market Forecast 2012-2017. So given that, definitionally then, traditional concepts are at the very least “impractical”… no?
BTRG_MikeMartin You can’t make good business decisions on bad data.
Data governance is critical in the Big Data management era as it makes
small problems bigger. You need data quality to enable Biginsights
searchCIO Metadata practices are gaining momentum as companies tackle Big Data.
searchCIO Data Quality is essential to master Big Data Management
dvellante Perspectives from a former CIO on the importance of data quality
furrier Dirty data equals poor user experience. I wrote about it in 2009 re: twitter facebook & social data
craigmullins Consider non-intrusive data governance; see this article by my friend Bob Seiner
great resources! For our next tweetchat, we’d like to build a reading
list that is sent out prior to the chat. Wednesday, March 15: Topic: Mobile Challenges for the Enterprise. Stay tuned for more information about this event.
To find out more about managing big data, join IBM for a free event on April 30: Big Data at the Speed of Business
What are you sacrificing for the promise of big data?
Recap of Tweetchat: "Getting Control of Data in Big Data Era"
Part 2: Recap of Tweetchat: "Getting Control of Data in Big Data Era"
What is a Tweetchat and why should you join us?
Big Data & Database Technology
you attend The DB2Night Show on Friday? We had the second show in this
year’s DB2’s Got Talent Competition. I was on vacation during the
first show, so IBM Champion Cristian Molaro was kind enough to fill in
as a judge for me. I’ve listened to the replay, so here is my summary
of both the first and second shows in this series.
Feb 1 - Show 1 of the DB2’s Got Talent Competition - watch the replay.
were supposed to be a few other contestants on this show, but they were
no-shows. We were still able to hear from Ember Mohankumar and Eric.
All three gave great presentations.
Ember - tips for running db2haicu. Ember is moving on to the finals.
Mohankumar - DB2 LUW data movement utilities. Mohankumar is moving on to the finals.
Eric - the best ways to build an audit table using the partitioning feature of DB2 LUW. Eric was chosen as an alternate.
Feb 8 - Show 2 of the DB2’s Got Talent Competition - watch the replay.
We had 5 contestants on this show: Adam, Chris, Renu, Juliano and Sanjay.
Adam - The Real Benefit of Solid State Disks (SSD) Hardware Upgrade.
story was about doing a hardware upgrade that greatly benefited a DB2
9, SAP, and WebSphere Commerce system. Adam’s presentation provided the
basics, but didn’t give enough information to see why an upgrade of
this kind was necessary. Adam was chosen as an alternate.
Chris - Making Life Easier - Letting DB2 Manage your Backup and Archived Transaction Logs.
provided great times that are very easy to follow. They have 2 DBAs in
their office and many databases, tables, and data to manage. Great
story about how they were able to handle such a workload. Chris has
been chosen as a finalist.
Renu - Small Changes, Big Results - Load Performance
Another presentation with great tips. Renu is moving on as a finalist.
Juliano - Efficient Aspects of Deleting Data in DB2 LUW
So many ways to delete data! Juliano will be a finalist.
Sanjay - Plan Management
This was a DB2 for z/OS topic... and a huge topic it is. Sanjay was chosen as an alternate.
Coming up on the show:
Feb 15 - Episode 3 of the DB2’s Got Talent Competition. There may still be room for one additional contestant.
22 - OK... now the judges are being put to work on this show. Martin
Hubel, Klaas Brant and myself have been asked to put together
presentations to share with you!
Thanks again to our amazing host for putting this show together: IBM Champion Scott Hayes!
DB2 Tech Talks Now in ReplayWere
you able to watch any of the DB2 Tech Talk webinars this year? There
have been many excellent topics covered in the past year with a variety
of experts sharing their knowledge with you.If
you missed any of these, you can watch them at your convenience. To
help you filter through all the shows, I’ve come up with a list of the
top 10 most popular talks:1. Technical Tour of DB2 10 for LUW and InfoSphere Warehouse 10Get
the details behind these new product releases as announced on April 3.
Learn about powerful new features such as: Adaptive Compression,
Multi-Temperature Data Storage, SQL Compatibility with Oracle, Time
Travel Query, Real-time operational data warehousing, and NoSQL
capabilities.2. Technical Tour of PureData Systems for transactions and operational warehousingJames Cho
goes through the technical features of PureData for Transactions and
PureData for Operational Analytics, showing you how these systems ease
deployment, management and development.3. Part One Certification Prep for DB2 10 Fundamentals ExamTogether, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.4. Part Two Certification Prep for DB2 10 Fundamentals ExamTogether, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.5. Compression Comparison: DB2 vs. Oracle Database and The restChris
Eaton compares DB2 10 for LUW to Oracle Database and other industry
databases, explaining the features and advantages that help to maximize
valuable storage resources. 6. Temporal Data Management Features of DB2 10Matthias
Nicola of IBM labs covers the bi-temporal data management features
which let you manage data at past or future points in time, consistently
and cost-effectively.7. Optimize Storage Utilization and Minimize Administration with DB2 10Learn about new storage optimization features: Adaptive Compression, Multi-Temperature Data Management, and Workload Management.8. Oracle Database and PL/SQL Compatibility Features of DB2 10With DB2 10 for Linux, UNIX, and Windows,
you’ll find the PL/SQL Compatibility features and other enhancements
make it even easier for you to switch. Learn about why and how to
switch.9. Inside Row and Column Access Control in DB2 10 and InfoSphere Warehouse 10This
talk will help you learn more at the technical level about the new Row
and Column Access Control (RCAC) features in DB2 10 for Linux, UNIX and
Windows and InfoSphere Warehouse 10.
10. Database Application Performance Management Best Practices
Be sure to follow my blog to learn about all the Tech Talks that will take place throughout the coming year.
In this episode of the DB2 Tech Talk Series Cliff Leung
and Holly Hayes discuss how you can use Optim Query Workload Tuner and
Optim Performance Manager to easily get to the bottom of common database
problems. For those who have not looked at OPM and OQWT in a while,
prepare to be amazed.
If you were at the IBM Information on Demand Conference last week, perhaps you picked up a printed copy of one of the 5 new Flashbooks that were published this year? As promised, this blog entry provides additional details including where you can get a free e-version of the book, additional details on the book, and when available, how to purchase a printed copy. Please share with others who will benefit from the content in these books.
Paul Zikopoulos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles, Dirk Deroos
Provides an overview of the IBM Information Management Big Data platform. It’s intended for a broad audience, ranging from those who are brand new to Big Data, to those on the business and management side, to architects, and to developers who want a glimpse into the technical details that underpin this platform.
Surekha Parekh, Terry Purcell, John Campbell, Don Haderle (aka “Father of DB2”)
DB2 experts John Campbell and Terry Purcell have contributed to this
book, but as a special treat, we also managed to have Don Haderle - "The
FATHER of DB2" contribute to the book. This book is not only full of
RICH, TECHNICAL content but is will also be a "keepsake" for DB2 fans
This book was previewed at IOD and was extremely popular. It will be relaunched next year during the 30th Anniversary celebrations. Check The World of DB2
Paul Zikopoulos, Walid Rjaibi, George Baklarz, Matt Huras, Matthias Nicola, Dale McInnis, and Leon Katsnelson
How would you like to compress data, store it in a cloud, and analyze your
data as though you are traveling through time? Do all this, plus experience
lower costs and faster performance. Sound good? Read this book to understand the
power of DB2 10 and get started immediately!
This book provides you with the comprehensive knowledge you need to get
started with the latest DB2 release. Try the new features by downloading DB2
Express-C - it is free to develop, deploy, and distribute (with no user and
database size limitations) and features Big Data and Cloud technology. Go to ibm.com/db2/express.
- e-Version- clicking this will take you to a blog entry with book details and a link to download.
- Order Online
Dr. Arvind Sathi
book discusses three perspectives on Big Data Analytics. First, why is
Big Data Analytics becoming so important and what can we do with it.
it lists major components of Big Data Analytics - Unstructured Data
Analytics, Massively Parallel Processing, Adaptive Real-time and
Predictive Modeling, Data Privacy Management, Data Visualization, and
Ontologies. Third, it provides a glimpse at implementation concerns and how they
must be tackled.
Brian Green, BlueCross BlueShield of Tennessee, Kay Van De Vanter, The Boeing Company, Tracy Harris, IBM, Bill Frank, Johnson & Johnson, John Boyer, RCG Global
5 Keys to Business Analytics Program Success is a work based on the combined
experience of 10 organizations that display excellence and expertise in business
analytics. They share best practices, discuss the management aspects and
sociology that drive success in Business Analytics Programs and uncover 5 key
aspects behind the success of some of the top business analytics programs in the
Write because you have knowledge that you want to share with others, and by
doing so, you may benefit from getting recognized for your talents through a
higher profile within your company, or a promotion. If you’ve spent your
education and career focused on developing strong and deep technical skills,
learning how to write well can make you stand above your peers.
If you think about all the famous scientists throughout time, they all
published. I’m currently listening to “The Origin of Species”
by Charles Darwin and find it enjoyable and very easy to follow even
though this is not my area of expertise. To me that is the sign of a great
writer: to write so that people outside of the field can understand the topic.
I found this website, 25 Great Books By Legendary Scientists, that lists a few more
books in the same genre that may lead to the conclusion that these scientists
became famous as a result of their writing! If they had never written, would we
have heard of them?
OK, you may not become famous (or rich) as a result of writing an article or
book about your field, but it might bring you some satisfaction and others a
deeper level of understanding in your area of expertise.
Two prolific authors in the IM – DB2 area who I think have raised their
profiles via writing are Roger Sanders and Paul Zikopoulos. Both are very talented, but with their
writing, they are seen as being leaders in their fields.
In my current assignment for developerWorks
I’m working as the acquisitions editor for IM content. I’m receiving many
proposals for articles. Believe me, there are many people who want to write
about DB2 and other IM products, and for that I am very happy. I do, however,
see varying levels of quality. My attempt with this post is to give some
guidance to anyone who is interested as to how to improve their skill as a
writer. It is a skill that can be learned, so don’t fool yourself into thinking
that if you don’t have an English degree that you are incapable of improving
this skill. And also, don’t let the fact that English is your second language
stop you from trying to improve your skills. I work with many authors who are
not native to English and would like to single out Martin Oberhofer and Matthias Nicola as two such people who are excellent writers
despite being native German speakers. How did they do it? I bet they’d both
say that it was hard work!
So, here’s what I think you should consider as you plan, write, and edit:
1. Schedule time to write. If you wait until you’re “in
the mood to write”, you’ll never get anything done! Set goals for how much you
want to accomplish and move to another section if one is causing you grief.
Reward yourself as targets are reached.
2. Have a strong outline before you start to write. I know it sounds
cliché, but the more up front planning you do, the easier the writing will be.
Even for technical documents, you should “tell a story”. Have a
beginning, say a problem that needs to be solved; a middle, the search for a
solution; and an end, a strong conclusion. Choose an interesting topic
that is not routine, found in the manuals, or elsewhere in developerWorks.
3. Let some personality show through in the writing. There are some cases
where dry, factual writing is required, but where it’s not, let the writing be
conversational or slightly casual to be of interest to the reader.
Always think of your reader. Even if the writing is just for a
school paper, the last thing you want to do is to bore the reader so that the
ending is never reached.
4. Diagrams and tables are useful, but ONLY if they are tied tightly
with the text. Don’t put them there just for filler because they’ll
never be looked at. The best idea is to add reference numbers to the diagrams
and have text to lead the reader from one point to the next. If that sounds
like too much work, maybe the diagram isn’t really needed.
5. No one’s writing is perfect… every author needs to review and
revise their work many times. Most authors get quite tired of reading
what they’ve written by the time it is “finished”.
To make revision as easy as possible, I suggest that each time you go
through your draft, look for one specific thing at a time. For
instance, the first time through, check that you are using the active voice
instead of passive. Next, go through and look to make sure headings and lists
use parallel wording. Next, look for words that are commonly spelled
incorrectly that will not be caught by a spell checker. And so on.
6. For everyone, but especially if you are English-second language,
consider reading the text out loud or have the computer read it
to you. You may be able to hear problems in the wording easier than you can
read them. Also, look at past comments you’ve received on writing
assignments. Likely you often make the same errors every time you write, so pay
close attention to how your previous errors were corrected, and go through your
document to specifically focus on improving these problem areas. Learn
from your mistakes!
7. There are a lot more details that will help you, so I encourage you to
get a copy of Roger Sanders'
book, From Idea to Print: How to Write a Technical Book or
Article and Get It Published.
8. If you’re writing a technical document, your goal is not to make it
“beautiful”… your goal is clarity. You want to ensure that
anyone who reads what you’ve written understands your technical messages.
9. Get others to review your draft, but don’t take feedback about your
writing as an insult about you personally. If you do, you’ll never be able to
write. Not many people can write a first draft that is perfect… but with
many revisions and attention to feedback you can get as close
to perfection as possible.
10. Size matters. There are different ways to present your
content. Is it an article (average 10 pages or fewer when printed), a tutorial
(average 20 to 30 pages when printed), a white paper, a series of articles with
a constant theme, or a book? For developerWork’s definitions of articles,
tutorials and knowledge paths see: A
step-by-step guide for authors to create articles, tutorials, and knowledge
paths for publication on developerWorks. White papers are typically
for research purposes and books are typically 250 pages.
Many of my tips were adapted from tips found in Roger Sanders’ book
“From Idea to Print: How to Write a Technical Book or Article and
Get It Published”. This book covers everything that you need
to know & do in order to get an article or book published. Becoming
a writer isn’t nearly as difficult as you think, but it does take
Other resources to consider:
- If you want to get ahead and achieve the most from your technical talents,
learn from Sam Lightstone’s book “Making it Big in Software”, that one of the best ways to get a
promotion is to do something that makes you stand out from your peers. Publish,
file patents, join groups, present about your topics, etc. Do what you like to
do and what makes you feel appreciated. Writing and presenting will make you an
instant expert in a topic and will make you stand out.
There was lots of advice in Sam’s book 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.
- Developing Quality Technical Information: A Handbook for Writers
and Editors, 2nd Edition
- By Gretchen
Kilty Hernandez, Polly
- Direct from IBM's own documentation experts, this is the definitive guide to
developing outstanding technical documentation--for the Web and for print. Using
extensive before-and-after examples, illustrations, and checklists, the authors
show exactly how to create documentation that's easy to find, understand, and
use. This edition includes extensive new coverage of topic-based information,
simplifying search and retrievability, internationalization, visual
effectiveness, and much more.
- IBM Style Guide, The: Conventions for Writers and
- By Francis
- The IBM Style Guide distills IBM wisdom for developing superior
content: information that is consistent, clear, concise, and easy to translate.
The IBM Style Guide can help any organization improve and standardize
content across authors, delivery mechanisms, and geographic locations. This
expert guide contains practical guidance on topic-based writing, writing content
for different media types, and writing for global audiences.
If you have a subscription to Books 24x7 or Safari Books Online, you should
be able to access all four of these books in electronic format. If you choose
to purchase a copy, purchase the IBM Press books directly from the publisher and
get 35% off by using this code at the FINAL CHECKOUT:
IBMEXPERIENCE. There is also an ebundle and video enhanced to get all three books at a special price.
Keep your technical skills up to par, but go the extra step and learn
how to wow the world with your knowledge through writing!
I just got this note from Dean and thought I’d share it with you. I’m quite
impressed by the content that Dean has created and want to make sure you are
aware that this content exists. Thanks Dean!
New db2Dean.com Article - DB2 10.1 New Features
became available on 30 April 2012 and has TON of new features and improvements,
some of which you can begin taking advantage of without doing anything other
than upgrading your database. As with the past “features” articles, this is a
summary of the new features in v10.1 that I see as the most important. My hope
is to provide a summary that you can browse to quickly find the items that are
the most valuable to you and to provide links you can click to do more in depth
reading on them. A number of features have been discontinued in v10.1, most
notably Control Center and many of the GUI tools that you access from it like
Command Center. I summarize these discontinued and deprecated functions in this
article. See http://www.db2Dean.com for
the rest of the article.
Want some Compression with that database, honey?
wondered what features are included with which edition of DB2 and which need to
be ordered separately? For example, did you know that pureScale is included in
DB2 Workgroup edition, but must be purchased separately with DB2 ESE and
Advanced editions? Well, now there is a page on the web where you can view a
chart showing which features are in which editions. It can be found at: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.licensing.doc/doc/r0053238.html
DB2 10.1 Favorite Links
I have updated my "Favorite
Links" page with links to the DB2 10.1 manuals, information center and other
good v10.1 stuff. http://www.db2dean.com/Previous/DeanLinks.html
DB2 v9.1 now OUT of SUPPORT
DB2 v9.1 went out of support
on April 30 of this year. If you are still running any DB2 servers or clients
on that version you should upgrade them ASAP. See the Upgrade Portal for logs
of help with this task: http://www.ibm.com/support/docview.wss?rs=71&context=SSEPGG&uid=swg21200005
The Falcons are Back
The Peregrine Falcons are back in
their nest in Salt Lake City this year and the web cam is still on them. See
the parents and chicks live at: http://wildlife.utah.gov/dwr/learn-more/peregrine-cam.html
Generally "Camera 2" has a better angle .
New DB2 Fix Packs Available
- - Fix Pack 6 for DB2 v9.7
was released on May 30 . See entry called "Recommended group:
- Fix Pack download links can be found
- DB2 v10.1 Proof of Technology July 18-19 in Salt
Lake City. Get your hands on the latest features at this great event. For more
information and registration, see https://events.webdialogs.com/portal/wippages/register.php?id=c92b63969e&l=en-US
Keep up with regularly scheduled, technically oriented conference calls by
checking the "Technical Conference Calls" link on my home page under "Online
Events". You can also see my events on Facebook at http://www.facebook.com/db2Dean#!/db2Dean?sk=events
As I get new contacts I add them to my broadcast
list. If you do not wish to receive further SPAM from me, please reply and ask
to be removed from my list. On the other hand if you find this really useful,
please pass it on to your friends and colleagues.
Please note that I keep all previous articles on my website for your
reference. You can find them by going to my home page and clicking "Previous
Articles" or by following this link: http://www.db2dean.com/Previous/Prev.html
Thank your for liking me on Facebook! I now have my own db2Dean page at
Facebook.com/db2Dean! On this page I hope to create a
community where you can add your thoughts to help others and to help me improve
my website. I'll post events that may interest you and abstracts of all new
db2Dean articles. I'll also make frequent posts about what I'm talking to my
customers about and thoughts about why those topics may interest you. Like I so
frequently do, I made an irreversible mistake when I created this page, so
you'll need to like me there again to follow posts.
I've created a developerWorks Group that you can join.
These on line groups are for sharing information, so please join. You can read
additional information and add comments and blog posts that you think will help
other DB2 professionals. You can add script files and other files that you
think might help others. I've added each of my articles as a link in the
"Bookmarks" section of the page. You can click the "view all" link at the
bottom of the section and then it opens up a "details" link for you to see
abstracts. Please note that I call my group "db2Dean and Friends" and just
like Barney and Friends, there should only be family friendly content posted
Can’t get enough of db2Dean? Do you want to get notified
when I add new technical conference calls, Favorite Links, or Googlegangers?
Then follow me, db2Dean on Twitter. When you do you will get
text messages sent to your cell phone when I update any page on this site.
Because of my personal spam reduction efforts, I only send you an email when I
publish my monthly news article. By following me, you will only get at most a
few “tweets” a month. Follow me by clicking this link http://twitter.com/db2Dean
For a little levity (ok VERY little) please watch my DB2
infomercial at http://www.channeldb2.com/video/db2-infomercial
or just click the clip at the top of my home page. It includes a guest
appearance by renowned pitch man, Chris Williams! If you have a moment, please
click on the stars after the word "rating" and rate my video after you watch it.
Was it really 5 years ago that DB2 9 was released? The DB2 Fundamentals Guide by Roger Sanders was released in
the spring 2007, so it is likely that the product was released the same year.
We’ve had many changes and releases since then…DB2 9.2 and the “Understanding DB2” book by Raul Chong and others, then
DB2 9.5, DB2 9.7 and DB2 pureScale. And now, in the past week, DB2 10 for Linux,
UNIX, and Windows was announced.
There is so much to this release, that for my first post about it, I’m going
to give you sound bites from my colleagues and point to where you can read more
about what they are saying are the key features that you’ll care about.
Announcing InfoSphere Warehouse v 10.1 – Jon Lind looks at how the new
release can overcome bottlenecks in capturing and loading operational data. By
handling heavy workloads, InfoSphere Warehouse v 10.1 can help identify – and
capitalize on – trends, offering competitive advantages. Find out what sets
InfoSphere Warehouse v 10.1 apart. http://ibm.co/HOEWQs
The new InfoSphere Warehouse 10 and DB2 10 include a major update to
multi-core parallelism that helps you better divide work among subagents. This
means better use of CPU resources and shorter query times. Michael Kwok
explains how this works and what the new operator, REBAL, can do. http://ibm.co/HeJP6o
DB2 v 10 includes a stellar ingest utility that lets you load DB2 LUW tables
from files or pipes. Walter Alvey explains how to load your data
continuously and take advantage of a variety of data formats and more flexible
SQL to achieve the performance you need. He also walks through some sample
The InfoSphere and DB2 for LUW team have been driving down the cost of
enabling users to break free of Oracle. Larry Heathcote details the new
features that make the move even easier than ever. http://ibm.co/H6SZTq
Just announced: IBM InfoSphere Warehouse 10 accelerates time-to-insight,
helping give decision makers the information they need to make faster – and
better – business decisions. Larry Heathcote details the new features and
how they can help your organization strategically use your data. http://bit.ly/HcanZx
For a product segment that was supposed to be a boring commodity, there sure
is a lot of excitement about new data systems this year. IBM’s Bernie
Spang details why DB2 10 and InfoSphere Warehouse 10 will meet the needs of
a new generation of data management. http://bit.ly/HQavJK
Security and compliance are top-of-mind for most companies, especially when
there’s sensitive data in your database. DB2 10 takes data security to the next
level, with new row permission and column mask features that can protect your
data while reducing the cost of developing and maintaining security policies.
Read more from Walid Rjaibi: http://ibm.co/HeJX5O
Faster queries mean faster results. Michael Kwok explains how new
InfoSphere Warehouse 10 and DB2 10 are making queries even faster, including
improvements in hash joins, aggregation and partitioning. http://ibm.co/HQlB6V
DB2 10 and InfoSphere Warehouse 10 include significant improvements in
compression capabilities. Find out from Thomas Fanghaenel how these new
releases reduce data storage costs by compressing data better. http://ibm.co/HPLlPA
As the volume of data grows, so does the cost of enterprise storage. Find out
from James Seeger how new InfoSphere Warehouse 10 and DB2 10 help you
optimize your storage investment to make sure you can access the data you need.
Time traveling isn’t just for sci-fi movies any more. Find out from
Matthias Nicola how InfoSphere Warehouse 10 and DB2 10 let you “time
travel” through your data with temporal data management. http://ibm.co/HhurrO
Thanks to Crysta Anderson and David Pittman for providing me
with this information. There is more to come… way more…. so stay tuned!
Just published by McGraw Hill: IBM Cognos TM1: The Official Guide, by TM1 experts Karsten
Oehler, Jochen Gruenes, and Christopher Ilacqua.
What’s in the book:
Deliver timely, accurate, and actionable performance management solutions to
users across your enterprise. Filled with expert advice from a team of IBM
professionals, IBM Cognos TM1: The Official Guide shows you how to deploy
and maintain a dynamic planning, forecasting, and scenario analytic solution.
Learn the latest Cognos TM1 10.1 best practices on how to model Cognos TM1
cubes, develop highly agile performance management solutions, generate
feature-rich reports, and employ dashboards and scorecards. Securing, sizing,
and performance tuning are also covered in this IBM-authorized resource. This
book can also be used with former TM1 versions.
- Build Cognos TM1 models with cubes, dimensions, rules, and TurboIntegrator
- Load data and establish workflow using the TurboIntegrator
- Model and analyze multidimensional business processes
- Develop applications using Excel and Cognos TM1 Web
- Manage high user volumes with scaling and concurrency
- Assign and enforce roles, privileges, and permissions
- Deliver custom reports to end users through dashboards
- Use KPIs and balanced scorecards to monitor performance
About the Authors
Dr. Karsten Oehler is head of the performance management client
technical professionals (CTP) with IBM Deutschland GmbH, Frankfurt. He has
published four books and more than 130 articles on IT systems for financial
management. Dr. Oehler is a visiting lecturer at several universities in
Jochen Gruenes managed the German competence center for Cognos TM1
within the technical sales organization for IBM Deutschland GmbH and has led
several projects and workshops on the enhanced uses of TM1.
Dr. Christopher Ilacqua is an experienced Cognos TM1 practitioner with
over 20 years spent working with TM1 as a customer, OEM Manager, and Director of
Product Management & Marketing, helping customers globally seeking to
improve their planning, forecasting, and analysis solutions.
Get your copy now! At the time of writing this entry, amazon’s price for
this book is at a 39% discount!
Winning a free trip to an IDUG conference of your choice is the first prize in this year’s “DB2’s Got Talent” Competition. The IDUG locations that you’d choose from are Denver, Berlin or Sydney. It would be pretty difficult to choose from such wonderful places, but that’d be a tough problem to have!
What do you have to do to win?
You will need to create short technical presentations about DB2 and present them to attendees on the DB2 Night Show’s webinar. If the judges choose you, you’ll get yet another chance to create a presentation. In the finals, your peers vote to select the ultimate winner.
Sound easy? If you know DB2 well, it should be easy. Beyond winning a trip to IDUG, you’ll be improving your technical and presentation skills, building a very strong network, and making a name for yourself as an expert.
Learn from past presenters. Those who take part in this year’s competition have it much easier than last year’s contestants. Those who participate this year can review all the great presentations (especially those from the top 5: Mary, JB, Thiru, Momi, and Norberto)that were delivered last year and can learn from them. Here are my blog entries with links to the replays:
First Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
Third Episode of “DB2 has Talent”
Fourth Episode of "DB2 has Talent"
DB2's Got Talent - March 11 Episode
DB2's Got Talent - 3rd Episode of the Finals
DB2’s Got Talent Finale
DB2, DB2Night Show and IDUG as viewed by JB
Tips for DBAs from Guest Blogger Norberto.... DB2's Got Talent contestant
And the winner of the DB2's Got Talent Competition is….
Interested? I hope so! Here are all the nitty gritty details: DB2’s Got Talent.
This year there are also great runner up prizes:
- 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2012 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
- Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by Triton Consulting.
Once again I’ve been asked to be a judge for this competition. I’m thrilled to be invited and am looking forward to meeting the many talented people who will take part in the show.
Good luck to all!
The Warehouse team has been busy creating yet another best practice paper.
Best practices: Using High Performance Unload (HPU) as part of a Recovery strategy
IBM InfoSphere Optim High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows V4.2 is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. HPU unloads large volumes of data quickly by reading directly from full, incremental, and delta backup images or table space containers rather than through the DB2 software layer.
The database is not affected by the HPU process and table spaces do not need to be placed in an offline state. HPU can therefore offer advantages over other recovery methods in data availability and processing speed. Incorporating HPU into your recovery strategy for scenarios involving data loss or corruption can help achieve service level objectives for data availability and data recovery.
Incorporate InfoSphere Optim HPU into your recovery strategy to provide:
- Reduced recovery times through targeted data recovery
Use the WHERE clause when selecting data from backup images to target only the data that was lost, compromised, or corrupted, reducing recovery time.
- Increased data availability and reduced resource usage during recovery scenarios
Unload data from a backup image and optionally process this data on a non-production system, maintaining availability of the query workload and reducing the effect on the production system.
- Integration with DB2® and Tivoli® Storage Manager (TSM) software
Query TSM to unload data from full, incremental, and delta backup images archived to TSM by the DB2 BACKUP command, reducing errors and facilitating outside recovery.
This article discusses how to incorporate HPU into a recovery strategy and when to use HPU to meet your recovery objectives. In addition the authors contrast the use of output files and named pipes, discuss introducing parallelism, review the HPU command and control file, and recommend best practices for creating control files. Finally, the article details how to install and configure HPU in an IBM Smart Analytics System.
This paper will be followed in the new year with a second paper on HPU that deals with data migration.
Thanks to the hard working team that includes: Garrett Fitzsimons, Konrad Emanowicz from the VLDB team who created and tested all the scenarios discussed in the paper and to Richard Lubell from the DB LUW ID team who steered the paper through to publication. Thanks also to Alice Ma, Austin Clifford, Bill Minor, Dale McInnis, Jaime Botella Ordinas, and Vincent Arrat whose contributions, feedback and experience were invaluable.
Thanks to Garrett and Serge for providing me with this information.
See also my previous posts on Best Practices:
More on DB2 for z/OS Best Practices
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
New DB2 WLM Best Practice Paper
Best Practices: IBM Smart Analytics Systems
How do I handle multi-temperature data in my warehouse?
Updated Best Practices Paper: Database Storage
Best Practice Resources for DB2 z/OS
DB2 Best Practices – New or Updated in 2011
I have so much that I want to tell you about last week’s IOD11 conference, but I keep running out of time! I wasn’t able to connect last week while at the conference, so I had much mail to respond to today. So, here are the highlights, but look for more entries in the next few weeks.
1) People. Wow… were there a lot of people at the conference! I spoke to many people and made so many new friends. I’m already looking forward to IOD 2012 to see them again. Last year was amazingly well attended, and this year had more attendance. Thanks to all of you who attended! And… sorry for not spending time with the many people who have emailed me saying that they came to the bookstore to see me, but I wasn’t around!
2) Books. We sold more books this year than we did last year… and last year was a record for us. Shortly I’ll have all the details and will be able to tell you which books were best sellers. I can tell you from what I witnessed at the signings that the most popular books were Moneyball, Cognos 10, and Bold… followed closely by Netezza, Data Warehouse, and Data Integration. More on these books later.
3) Michael Lewis and Billy Beane. One of the highlights for me was meeting Michael and Billy. I’ve read two of Michael’s books and fully intend to read others. I really like his style of writing and encourage you to pick one up if you haven’t. Billy is amazing… friendly, good looking, athletic… I found it hard to believe he has a temper! The talk that the two of the had in the opening session on Wednesday was a lot of fun and for those who missed it, I can only guess that it will be edited before it is releases as a video, if it is released at all. The signing was truly amazing… never have I seen such excitement for a book. For those who missed the fact that there was a signing…. make sure you keep reading my blog as I’ll know in advance who the speaker will be and if it is an author, will read their books before the conference.
4) Jeff Jonas. He opened the conference with a short but amazing talk on Monday morning. In my opinion, he was the highlight of the day.
5) Train. The event on Tuesday featured the band Train. They were great. The lead singer knows how to work a crowd. The food was lacking, but everything else rocked! Sal Vella and I hung out and made the best of the opportunity to meet & greet as many people as we could.
6) Women. The WIT event on Wednesday night was the best attended WIT event I’ve ever attended! Is it because it was just announced that Ginny was taking over from Sam as CEO? Or was it better promoted? In any case, we have more reason than ever to celebrate women at the event. Inhi took a photo of the 300 attendees and sent it to Ginny who was touched by the gesture. The one shadow over the event was the tribute we had for one of our female colleagues who had just passed away due to breast cancer. Many of us at the event knew her well and were deeply saddened by her suffering and our loss. RIP Linda!
7) Champions. We have new champions this year and more coming. I am very lucky to know many of them… but there are many more who I’d like to meet. I had breakfast with Susan and Terry, who I nominated to be champions.
8) Flashbooks. We produced 3 new flashbooks for this conference and were blown away at the response. Let’s start with the Big Data book. We gave out 3000 copies after the Monday opening session. I couldn’t believe that we went through all the books, so spent the rest of Monday looking for the rest of my shipment. It was proved beyond a shadow of a doubt that I did in fact receive all the books and yet, it is possible to give away that many books in half an hour! I then ordered 1000 additional copies to give out to the many disappointed people who were unable to get a copy on Monday. The other two Flashbooks also generated a huge amount of excitement and I was very pleased to see us “sell out” of every single copy. If you missed your copy, watch for another entry from me about how you can get an e-version of any of these books free of charge.
9) Walking. Last year I wore a pedometer and walked 99 miles. I inspired my team who were running the “Services, Support & Education Zone” to have solar-powered pedometers as their giveaway. I’m sure that there are several people who were able to beat my distance from last year! Let me know if you did. I didn’t wear a pedometer this year, but know that I walked many a mile. I still say “ouch” with nearly every step!
10) Social Media. I gave two presentation about social media and received positive feedback from these sessions. I have more to tell you about this topic, but wait for another entry. Before the conference, I created 25 blog entries to help promote the many events that were planned. I’m happy to say that I have had the more views this month than any other month since I began blogging. I hope that means you find my entries helpful. I wasn’t able to tweet while at the conference, so I thank those who tweeted about my entries. Long live blogging!
More to come!
At this time there are 82 Web-Based Training (WBT) Courses available for you to take to sharpen your skills on IBM Information Management (IM) products and technologies. Eighty-two is a LOT of courses! More are being created and being updated, so if this is the way you like to learn, make sure you stay in touch with all the latest as they are released.
IBM’s Education is known for its high quality content and excellent instructors. Although with WBT courses you won’t be in a classroom environment, you’ll get the same quality of content that you expect. WBT courses allow you to learn at your own pace and on your schedule with training that is completely self-contained from your desktop. Most courses provide introductory and overview training that serves as the foundation for more technical and follow-on training. Courses include expert instruction but do not include hands-on labs.
How do you get there?
Access this site to see all course offering types: http://www.ibm.com/software/data/education/elearning.html. Under the Web Based section, click on "Browse the complete Information Management WBT portfolio". I’ve included the 82 courses that I know of right now and have put the newest ones at the top of the list. If you’re an IBM employee, contact me offline as there is a different procedure that must be used to take these classes.
Using IBM Optim Designer and Optim Manager - Web Based – New
Connect Information Server to SAP R/3 ECC (DataStage Pack for SAP) – New
DataStage Essentials - Web Based – Updated
IBM InfoSphere Information Server Metadata in Practice – New
InfoSphere BigInsights Essentials (Web) – New
InfoSphere MDM Server Workbench for MDM Server 9 - Web Based – Updated Programming for InfoSphere Streams V2 - Web Based - New
5 Ways to Apply Data Quality with Information Analyzer WBT
A Blueprint for Implementing MDM Server Using V8.5 - Web Based Training
Advanced DataStage - Web-Based
Advanced DB2 SAP for Administrators - Web-Based
Advanced Programming InfoSphere Streams - Web Based
Basic Programming for InfoSphere Streams - Web Based
Business Glossary Essentials - Web Based
Changing Business with Data Insight (Web Based)
Configure ODBC for IBM DataStage on UNIX - Web Based Training
DB2 9 for z/OS Database Administration Workshop Part 1 (Web Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9.1 (Web-Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (Web-Based)
DB2 9.7 for Linux, UNIX, and Windows New Features (Web-Based)
DB2 Everyplace V9 Tutorial – Online
DB2 Express V9 - Developer in a Day Workshop – Online
DB2 Family Fundamentals - Web-Based
DB2 for LUW 9.5 Fundamentals – Online
DB2 for LUW pureXML
DB2 LUW Advanced Topics – Online
Exploring IBM solidDB Universal Cache - Web-Based
Exploring Initiate Workbench V8.x - Web Based
Exploring Initiate Workbench V9.x - Web Based
FastTrack Essentials - Web Based
Federation Server Essentials - Web Based
How to Analyze Data (Using InfoSphere Information Analyzer) - Web Based Training
How to Install IBM DataStage on UNIX - Web Based Training
How to Install IBM QualityStage on UNIX - Web Based Training
How to Install Information Server 8.5 - Basic and Advanced Option
IBM Data Studio Basics - Web Based
IBM InfoSphere Change Data Capture Essentials V6.3 - Web Based
Implementing IBM InfoSphere MDM Server for PIM V9 (Web Based)
Information Analysis - Web Based
Informix 11 New Features (Web Based Training)
Informix Version 10 – Online
InfoSphere Information Server Administration - Web Based
InfoSphere Master Data Management Server Overview (MDM Server) - Web Based Training
InfoSphere MDM Server Architecture – WBT
InfoSphere MDM Server Domains for MDM Server 9 - Web Based
InfoSphere MDM Server User Interface Generator - Web Based
InfoSphere Warehouse 9 - Cubing Services - Web Based Training
InfoSphere Warehouse 9 - Data Mining and Unstructured Text Analysis – WBT
InfoSphere Warehouse 9 - SQL Warehousing Tool and Admin Console – WBT
InfoSphere Warehouse 9 Components - Web Based
Initiate Self-Paced Bundle V8.x - Web Based
Initiate Self-Paced Bundle V9.x - Web Based
Install, Configure, and Use DataStage SOA Edition (RTI) - Web Based Training
Installing and Configuring IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM InfoSphere Information Analyzer - Web Based Training
Introduction to IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM QualityStage - Web Based Training
Introduction to InfoSphere Change Data Capture How to Use CDC WBT
Introduction to InfoSphere DataStage Using Version 8 - Web Based Training
Introduction to InfoSphere QualityStage Using Version 8 - Web Based Training
Introduction to Initiate Master Data Service - Web Based
Introduction to New Features in Informix Version 11 – Online
Introduction to TSA in IBM Smart Analytics Systems - Web Based
Managing Workloads for DB2 LUW and InfoSphere Warehouse - Web Based
Metadata Workbench Essentials - Web Based
Overview of (IISD) InfoSphere Information Services Director - Web Based Training
Overview of IBM DataStage Enterprise Edition for ETL Developers - Web Based Training
Overview of IBM Information Server and DataStage QualityStage Version 8.0 - Web Based Training
Production Automation of IBM DataStage- Web Based Training
Programming for InfoSphere Streams - Web Based
Programming with IBM InfoSphere MDM Server for PIM V9 (Web Based)
QualityStage Advanced Concepts - Web Based
QualityStage V8 Essentials - Web Based
SQL Replication: Advanced Topics (Web Based)
Troubleshooting IBM InfoSphere Information Analyzer - Web Based Training
Using InfoSphere MDM Server for PIM V9 (Web Based)
Using Initiate Inspector V8.x - Web Based
Using Initiate Inspector V9.x - Web Based
Using Queue Replication - Web Based
Using SQL Replication (Web Based)
Validating Data with Rules in Information Analyzer 8.1.1 - Web Based Training
XML and DataStage: Convert Relational and XML Data - Web Based Training
I hope you’ve found one or two in this massive list that interest you! Take the course and let me know what you thought of it.
Sadly I missed John Hornibrook’s fourth appearance on the DB2Night Show that took place on Friday, Sept 9th. Did you miss it as well? There is a replay available (Thanks Scott!). You can find it here:
To download a recorded replay of Episode #57, right click on the link below and choose "Save As..."
Episode 57, 9 September 2011, DB2 LUW Vital Statistics with John Hornibrook
What was John talking about? DB2 LUW Vital Statistics. 94% of the audience said that they learned something new during the talk… so you can expect it to be very informative. John’s previous visits:
This show, #57 in the DB2 for LUW series, marks the kickoff of Season #3. Since the show's inception, there have been over 90,000 downloads of replays to date. The library of FREE DB2 LUW Education is enormous and growing! Check out these valuable educational resources by watching REPLAYS whenever and as often as you can.
Also, never miss another show. They take place pretty much every Friday from 11:00 – 12:00 ET, so block your calendar to make time for a weekly learning opportunity. Take a look at the schedule of upcoming shows. As always, a very impressive line up.
Thanks to host Scott Hayes for Engaging, Entertaining and Educating us!
Another book that will publish just in time to be launched at the IBM Information on Demand 2011 Conference is
By Roger Sanders
Roger will be at IBM’s Information on Demand Conference this year and will be available for two book signings at the Conference bookstore:
Monday October 24 from 3:00 – 4:00 pm
Tuesday October 25 from 2:00 – 3:00 pm
Soon you’ll be able to add this signing to your Smart Site Schedule. This book and another of Roger’s books (DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes)that will also launch at the conference will be sold at the Conference Bookstore for a 20% discount.
About the book:
I’ve already read the book and highly recommend it. It covers everything that you need to know & do in order to get an article or book published. What makes this book so different than others of the same sort is first of all Roger’s extensive experience in writing technical books and articles and second his explanation of an author contract. I personally find legal contracts to be very difficult to understand and I have little interest in putting in the effort to understand all the terms that appear in an author contract. Roger put the effort in, and it shows. He goes through each clause and term that you’ll encounter and explains it in a very understandable way. In addition, Roger gives examples of what he’s encountered throughout his career and how the various clauses in the contract affected the situation.
Getting the skills to write well isn’t nearly as hard as you think. Here are the basics that Roger covers in his book:
1. Schedule time to write. If you wait until you’re “in the mood to write”, you’ll never get anything done! Set goals for how much you want to accomplish and move to another section if one is causing you grief. Reward yourself as targets are reached.
2. Have a strong outline before you start to write. I know it sounds cliché, but the more up front planning you do, the easier the writing will be. Even for technical documents, you should “tell a story”. Have a beginning, say a problem that needs to be solved; a middle, the search for a solution; and an end, a strong conclusion.
3. Let some personality show through in the writing. There are some cases where dry, factual writing is required, but where it’s not, let the writing be conversational or slightly casual to be of interest to the reader. Always think of your reader. Even if the writing is just for a school paper, the last thing you want to do is to bore the reader so that the ending is never reached.
4. Diagrams and tables are useful, but ONLY if they are tied tightly with the text. Don’t put them there just for filler because they’ll never be looked at. The best idea is to add reference numbers to the diagrams and have text to lead the reader from one point to the next. If that sounds like too much work, maybe the diagram isn’t really needed.
5. No one’s writing is perfect… every author needs to review and revise their work many times. Most authors get quite tired of reading what they’ve written by the time it is “finished”.
To make revision as easy as possible, Roger suggests that each time you go through your draft, look for one specific thing at a time. For instance, the first time through, check that you are using the active voice instead of passive. Next, go through and look to make sure headings and lists use parallel wording. Next, look for words that are commonly spelled incorrectly that will not be caught by a spell checker. And so on.
6. For everyone, but especially if you are English-second language, consider reading the text out loud or have the computer read it to you. You may be able to hear problems in the wording easier than you can read them. Also, look at past comments you’ve received on writing assignments. Likely you often make the same errors every time you write, so pay close attention to how your previous errors were corrected, and go through your document to specifically focus on improving these problem areas.
8. One last piece of advice. If you’re writing a technical document, your goal is not to make it “beautiful”… your goal is clarity. You want to ensure that anyone who reads what you’ve written understands your technical messages.
There are a lot more details that will help you, so I encourage you to get a copy of Roger’s book.
Roger is also attending the IOD conference to share his expertise on DB2 Certification. He was an exam developer of many DB2 exams and is the instructor at a highly rated Pre-Conference Certification Crammer Course: (9Q020) DB2 9.7 for Linux, UNIX and Windows DBA Certification Crammer for Exam 541 . His other book, DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes will help you pass one of the free exams that are being offered to attendees.
Other blog entries about IOD Events:
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
I quite often talk to people who have achieved some sort of benefit from taking advantage of the many training resources that IBM provides in the Information Management area. My team is trying to pull together some testimonials from people who have used and liked one or more of the resources that are available. We’d love to talk to you if you have a story. Simply send me an email and we’ll go from there!
One thing about IBM is that there is NO shortage of options for you to choose to increase your skills and learn about IBM products and technologies! You can find options that are free and easily accessible to custom designed courses to suit the specific learning needs of your employees.
Why are there so many options? Learning is one of the most important things you will do in your lifetime and is something that you do from the day you are born until you die. We don't all learn the same way though, so having a choice of options is very important so that you can find the learning method that is best for you.
Here is a list of the learning options that are available for the Information Management products and technologies.
e-books - Many choices are available ... many are free, but you can also read books on electronic reading devices such as Kindle. See my blog entry "The Year of the e-Book".
IBM Redbooks - The PDF versions can be downloaded for free and books are available for a very wide range of topics. See the IBM Redbooks web page and my blog entry with a few IBM Redbook recommendations.
developerWorks - Tutorials, Demos, Skills Kits, Best Practices for DB2 for z/OS or DB2 LUW, e-kits - These are free and very popular.
Gaming - 3 games are available to help you learn SQL in a fun way.
White papers - A white paper is an authoritative report or guide that often addresses problems and how to solve them. White papers are used to educate readers and help people make decisions. For a list of whitepapers, google search "db2 whitepapers".
Podcasts - Chat with the Lab; DB2Night Show, DB2 for z/OS Webcasts On Demand
Online Communities - PlanetDB2; ChannelDB2; LinkedIN groups; developerWorks groups, Facebook
Virtual Conferences - Last year there were several virtual conferences that were run by IBM that allowed you to "attend" a conference via your computer. I don’t know of any that are active right now, but will post a future blog entry when one is available.
Retail books -IBM Press, MC Press, McGraw-Hill, Apress, O'Reilly, Packt are the publishers who have invested in publishing about IBM products and technologies. For a listing of books by topic, see our bookstore website . For a list of books that were recently published, see my previous blog entries.
Conferences - IDUG holds amazing user-based conferences in various regions each year; IBM holds many conferences including the popular Information on Demand Conferences.
Instructor-Led Training (ITL) classes are traditional classroom courses where students are in the same room as the instructor who guides the students through classroom material and hands-on lab exercises. Students are able to interact with fellow students and the instructor and are provided with printed course material.
Instructor-Led Online (ILO) classes are equivalent to ILT classes in terms of classroom material, labs, instructor and fellow students, only you won't need to leave your home or office as you will connect to the classroom via your computer. See my blog entry about ILO classes.
Self-Paced Virtual Classes (SPVC) are for students who don't need the instructor or don't want to be tied to a class schedule. These classes are typically lower priced than ILO or ILT classes meaning that you save on travel and tuition costs. Content, labs and instructors are the same as ILO and ILT classes, but it is recorded so the class can be taken at your pace, where and when you want it. See my blog entry about SPVC.
Web-Based Training (WBT) are standalone courses on the web that provide 6-8 hours of instruction. These are typically voice over power-point format.
Custom Classes are available for companies that want training to take place on their premises with course material that is taken from multiple existing courses and changed to suit specific needs.
We REALLY want to hear from you…. so if you’ve used any of the above resources and have a story to tell, let me know! Emal: email@example.com
Read through my previous blog entries for more free or almost free resources:
More Free Resources
Not quite free….
DB2Night Show - DB2 for z/OS
Here are articles and white papers that I've read that emphasize the importance of continued learning:
Whitepaper The Value of Training shows that by cutting skills development and training budgets in the hopes of improving gross margins will cause higher attrition, higher support costs, and the risk of falling behind in technological advances.
Article 5 surefire ways to get fired by Denise Dubie shows that the best way to KEEP your job is by continually growing your skills.
Whitepaper DBA Certification: Is It Worth It? by Howard Fosdick compares the costs to the benefits of earning a DBA certification. This white paper is a few years old, but the message is still valid.
Article "Is certification valuable, or not? We have the definitive answer" by Linda Musthaleris says that companies need high-functioning teams that are able to transform and grow the business like never before. These teams consist of highly skilled professionals who have current and relevant knowledge. Certifications are designed to encourage people to keep learning and then to validate their skills.
The results of the IDC study in the November 2009 report by Cushing Anderson called "Impact of Training on Network Administration: Certification Leads to Operational Productivity" shows "a direct relationship between higher levels of certification and improved performance -- when team skills improve, organizational performance increases proportionally."
If you’ve spent your education and career focused on developing strong and deep technical skills, is there a need to learn how to write and present as well?
If you want to get ahead and achieve to most from your technical talents… yes! As we learned from Sam Lightstone’s book “Making it Big in Software”, one of the best ways to get a promotion 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. Writing and presenting will make you an instant expert in a topic and will make you stand out.
Getting skills to write and present aren’t nearly as hard as you think. Let’s cover writing first. In a few months you’ll be able to read Roger Sander’s latest book “From Idea to Print”. I’ve already read the book and highly recommend it. It covers everything that you need to know & do in order to get an article or book published. I blogged about the book and about teaching writing skills to a class in York University: Campus Visit. Many people think presenting is worth than death, so if you think like that, you may try your hand at writing first. One major tip though… don’t take feedback about your writing personally. If you do, you’ll never be able to write. Not many people can write a first draft that is perfect… but with many revisions and attention to feedback can help you get as close to perfection as possible.
One of the people I follow on twitter is a regular technical speaker and she wrote a wonderful blog entry on tips on speaking: “Speaker Lessons Learned” by Karen Lopez. I don’t speak to audiences very often, but must say that I find speaking on webinars or podcasts to be much easier than in front of a live audience. Comfort would come with practices, so there is an opportunity for anyone to get comfortable if they choose.
Another suggestion I have to help you improve both your writing and presentation skills is to take part in an event like “DB2’s Got Talent” that was featured earlier this year on the DB2Night Show. Contestants speak to a “live” audience but over a mic from their home or office. This might be the best way to begin getting comfortable speaking to an audience. The show took place over 8 weeks and some of the contestants presented up to 5 times. The presentations were short but still not easy. Judges gave constructive feedback to the contestants to help them hone their writing and presenting tips and the contestants were able to use this feedback the next time they presented. I was very impressed with the improvements each contestant was able to make. Listen to the replays to see what you can learn from the competition. The DB2Night Show plans to do this event again in the fall, so jump in and join!
Keep your technical skills up to par, but go the extra step and learn how to wow the world with your knowledge through writing & presenting.
Congratulations to Author Bob Laberge for publishing his first book:
by Robert Laberge
I’ve promoted this book since it was available as a pre-order and am very pleased with the interest in this book. I’ve had many views on my blog entry and many people when to amazon to order the book. I’ve been requesting reader feedback, so if you do read the book, we’d love to see your comments in a blog or on amazon. By the way, as of today, amazon’s pre-order price of 38% off the regular price is still active.
What’s in the Book?
In The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, business intelligence and data warehousing expert Robert Laberge explains the components and different alternatives in building a data warehouse and describes pros and cons for choosing one path over another. Building a data warehouse is unique for each organization but can be guided by the author’s years of knowledge obtained from working on many differing data warehouse and business intelligence environments in organizations around the world.
The book covers practical and technical aspects of current data warehouse and business intelligence issues with views on realistic solutions within the management and technical arenas. Data warehousing topics are first presented from a high-level overview to ensure the terminology and context is understood, and are then covered in deeper detail to clarify the specifics. These topics all pertain to data warehousing, business intelligence, and performance management.
The Data Warehouse Mentor
- Explains the proper implementation of the many available technologies and practices
- Shares the author’s nearly 30 years of data warehouse and business intelligence experience in more than 20 countries worldwide
- Mentors you to success in determining and deploying the most effective data warehouse and business intelligence solutions for your business
- Helps you anticipate future data requirements and usage to ensure the design and build environment for your solution is flexible and open to change
Data Warehouse and Business Intelligence Overview; Data in the Organization; Reasons for Building; Business Intelligence and Data Warehouse Strategy - The Plan; Project Resources – Roles and Insights; Write it Up – Overview; Business Intelligence: Data Marts & Usage; Enterprise Data Models; Data Warehouse Architecture; ETL and Data Quality; Project Planning; Working Scenarios - Hands On; Data Governance; Post Project Review
About the Author
Robert Laberge is a lead principle consultant for the IBM Industry Models and Assets Lab in Dublin which focuses on data warehousing and business intelligence solutions. He has helped more than 50 large organizations in 20 countries by mentoring, training, and demonstrating data warehouse and business intelligence solutions, including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group. Robert has a Masters of Business Administration from the University of Durham (UK) and has nearly 30 years of experience in IT.
Proven strategies for implementing the right data warehouse and business intelligence solutions for current and future business needs: order the book now!
I am! For those who don’t know what IOD is, it is the IBM Information on Demand Conference which will take place in Las Vegas (Mandalay Bay) during the last week of October. Last year we had 10,000 attendees and it was an awesome conference in so many ways. See my blog entry about the top-selling books at the conference last year.
Why am I thinking of IOD now, when the conference is months away? I’m planning the books that will be published specifically for the attendees of this year’s conference, and working with publishers who have books that will be published before the conference so I can arrange book sales and signings.
Last year I arranged to have 5 new Flashbooks launched at the conference and a total of 16 books signings which included famous authors such as Dr. Atul Gawande (The Checklist Manifesto), Steven Levitt & Stephen Dubnar (Freakonomics), and Mark Jefferies (The Art of Business Seduction). I don’t know who the speakers will be this year, but I hope that they are authors so I can arrange a book signing, and selfishly, meet them in person!
I recommended Dan Ariely as a motivational guest speaker because I loved his book Predictably Irrational. Other IBM conferences this year have included speakers who were involved in IBM Watson and of course this being IBM’s Centennial, so you can be sure that there will be buzz around the two related books:
By Stephan Baker
By Kevin Maney, Steve Hamm, Jeffrey O'Brien
As for Flashbooks, I have a few tentative plans… An update to the DB2 z/OS Migration book, an update to the Cognos Strategy book, and maybe the Cloud book. We might have a new DB2 LUW book and maybe a Big Data book. I think a Netezza Flashbook might be useful… maybe a Data Warehouse one as well? We’ll see what I can arrange. Do you remember what a Flashbook is? It is the free, small, published books that are handed out at the conferences to introduce you to key ideas that we want you to take home with you. Here’s where you can find the titles we did last year including links to the e-version, printed version that you can purchase and a blog entry about the book: Information Management Bookstore.
As for published book, I already have several on my list that I’m looking forward to:
By Roger Sanders
By Roger Sanders
DB2 10 for z/OS Database Administration: Certification Study Guide
By Susan Lawson and Dan Luksetich
By Robert Laberge
By Sunil Soares
Karsten Oehler, Jochen Gruenes, Christopher Ilacqua
By Anthony Giordano
By Bill Carpenter
Have you registered for the conference yet? I haven’t but will soon. Here is where you can find all the registration information: http://bit.ly/attendIOD