Today I registered for the IOD conference, requested a hotel room and certified that I’ll be presenting this year. Now it is time to start using the SmartSite to schedule my time. The conference takes place in Las Vegas, Nevada at the Mandalay Bay Hotel during the last week of October 2011. I hope you plan to come!
If you are planning to register, remember that you can save $300 by registering by Aug 31!
As you may know, I manage the book signings that take place at the bookstore conference, and as in previous years, we have a very full schedule planned. I’m busy building the schedule right now, so I can get the book signings added to SmartSite as we did last year.
As a teaser, I’ll tell you this:
1) We will be launching 2 new certification guides.
2) We’ll be giving out 3 brand new Flashbooks.
3) Michael Lewis will be signing his many books… some of which have been made into movies.
4) There are 8 new technical books launched at the conference that will appeal to you.
Stay in touch and I’ll reveal details as I can.
There are many reasons to attend! Amazing speakers, deep technical education, free certification exams and more. See the Justification information on the website for more reasons.
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.
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
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.
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!
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!
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.
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
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.
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.
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.
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?
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:
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
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!
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.
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/