Keep on Learning
The Information on Demand conference is fast approaching. I've been doing some final planning for the conference that includes creating signage for the bookstore and book signing events. I'll share with you what the plans are and hope that you'll be able to join us at the conference and specifically for the book events.
The IOD bookstore is offering books at a 20% discount. Browse the selection of books because I think you'll be able to find several books that interest you and can perhaps help you do your job better. I'll be working at the bookstore and whenever I do, the comment I hear most often is... "I had no idea there were so many books!".
The bookstore will be open Sunday October 25 thru Thursday October 29. There will only be a limited quantity of each book... so browse & buy early to avoid disappointment.
The following authors will be at the conference and will be available to sign your books. You can buy your book at the conference or bring a copy you already own. Remember that a signed copy of a book makes an excellent gift!
What's Up with Your Handshake?
Meet Mark at the IOD bookstore on Monday, October 26 from 11-12 or Tuesday October 27 from 1:30 - 2:30.
Viral Data in SOA: An Enterprise Pandemic
Meet Neil at the IOD bookstore on Monday, October 26 from 1:30 - 2:30
Promoting all three of his best sellers: Outliers; The Tipping Point, Blink
Meet Malcolm at the IOD bookstore on Wednesday, October 28 from 10:15-11:15
DB2 pureXML Cookbook
Meet Matthias at the IOD bookstore on Wednesday, October 28 from 1:30 - 2:30
As in previous years, we also have some free FLASHBOOKS that you can take. These books are very slim and easy to read and typically only available to conference attendees.
Information on Demand for Dummies
Authors: Judith Hurwitz, Fern Halper, Marcia Kaufman, Glenn Hintze, Adam Gartenberg
These books are only available to partners or customers. Exchange your coupon for a book.
Meet the authors on Monday October 26 from 2:30 - 3:30 at the IOD Bookstore
Break free with DB2 9.7: A Tour of Cost-Slashing New Features
Authors: Paul Zikopoulos, Belal Tassi, George Baklarz, Chris Eaton
Get your free book and meet the authors at the Mandalay Bay Registration Desk South on Tuesday, October 27 from 12 - 1
New Intelligence for a Smarter Planet - Driving Business Innovation with IBM Analytic Solutions
Authors: Bill Wong, Rex Wiederanders, Alan Meyer, Pat Bates, Mike Biere
Get your free book and meet the authors at the Mandalay Bay Registration Desk South on Wednesday, October 28 from 3:45 - 4:45
MDM for Customer Data : Optimizing Customer Centric Management of Your Business
Author: Kelvin Looi
Get your free book and meet Kelvin the Mandalay Bay South: Bayside D - Data Management Room
I know you may think it's too geeky to get your book signed... but the authors enjoy meeting people and talking about their books and related topics.
If you want more info about IOD... read Kate's blog. She's been doing an entire series about various aspects of the conference.
I hope to see you / meet you at the conference. If you are going, come and find me at the bookstore and tell me that you read my blog! I like talking to people too!
Congratulations to Tony for the upcoming publication of his first book:
Techniques for a Scalable and Sustainable Architecture
by Anthony Giordano
This is the Rough Cut version of the printed book. Rough Cuts is an interactive publishing service from Safari Books Online that provides you with first access to select pre-published manuscripts.
Data integration accounts for some 70% of the cost and risk of data warehousing and business analytics projects. Now, the leader of IBM's Global Data Integration Practice for Business Intelligence presents a complete reference architecture and best-practice blueprint for higher-quality and lower-cost data integration. Anthony Giordano shows how to build data integration processes that use standardized architectures and processes to support the capture, rationalization, and loading of exceptionally high volumes of data. He introduces data integration patterns for SOA, EAI, and ETL and covers every phase, task, and step required to build mature data integration environments.
This book also:
As data analysis has become increasingly important and more tightly integrated with strategy, the processes required to combine data from different sources into meaningful information has become its own discipline. Data Integration Blueprint and Modeling is the definitive guide to that discipline.
About the Author:
Anthony Giordano leads IBM's Global Data Integration Practice for Business Intelligence (BI). He has been part of both PricewaterhouseCoopers and IBM's Global Business Services BI Senior Leadership Team and is one of the coauthors of IBM's Business Intelligence Reference Architecture and Methodology. Giordano has worked in BI and Data Warehousing for more than 20 years. He has extensive experience in both the financial services and automotive industries and has served in roles ranging from partner and consultant to team leader and programmer. He has also taught information management/data warehousing courses at the MBA level.
Join Berni Schiefer as Scott Hayes' guest on tomorrow's edition of the DB2Night Show!
Topic: DB2 LUW Performance Update & Best Practices
Who: Berni Schiefer
When: Fri April 30
Time: 11 am Eastern Time
Cost: FREE - Register now
Note that this event is nearly full to capacity... likely because Berni will NOT be presenting at this year's IDUG or IOD EMEA conferences! Berni's talks are always popular... is it the topic or the speaker?
Here's more info (from Scott) about the event:
In the DB2 LUW Community, Berni Schiefer is a man that doesn't need an introduction - but, just in case you are newer to DB2 LUW (like one of the many Oracle converts), Berni is "the performance guy". He's a Distinguished Engineer who leads the Information Management Performance and Benchmarks team at the IBM Toronto Lab. Berni has been a frequent speaker at IDUG conferences and other venues, and he gives terrific presentations that share DB2 Performance Benchmark results and performance best practices.
With DB2 pureScale announced last fall, we can only "guess" that IBM will be publishing some new benchmark results very soon. Claim your seat in our virtual studio audience to hear the very latest information on performance results and best practices!
The DB2Night Show has a Twitter account - please follow twitter.com/db2nightshow for the latest news about new episodes and interactive discussion. Use the hash tag #DB2Night in your Tweets.
The DB2Night Show now has a LinkedIn Group - join us to stay up to date on our show and discuss show episodes! The group registration link can be found on www.DB2NightShow.com.
We hope you will join us and participate as a studio audience member. One studio audience member will be randomly selected to win an Amazon.com gift certificate - use this towards a new USB thumb drive, a new book, or anything you like!
If you can't make the scheduled time, register anyways so that you get information about recorded replays. Lastly, please forward this invitation to at least 5 of your friends!
I hope you enjoy the talk!
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.
InformIT.com 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:
I was asked this question this morning and I thought this might be a good one to answer in my blog.
We don't have a book about DB2 pureScale yet, but I have a team of experts putting together a flash book that will be available early next year. In the mean time, I suggest you look at the following sources of information:
IBM DB2 pureScale Unlimited capacity with continuous availability
DB2 pureScale: A Technology Preview
Announcing DB2 pureScale
DB2 pureScale: Scaling Databases without Limits
Transparent Application Scaling with IBM DB2 pureScale
For databases size does matter: introducing DB2 pureScale
IBM unveils DB2 pureScale on IBM Power Systems
IBM readies Exadata killer
IBM pureScale Technology Redefines Transaction Processing Economics
Using DB2 pureScale to Eliminate Over-Provisioning of Database Software
Did I miss anything? Let me know if there are resources that I've missed!
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!
We’ve all heard the expression that practice makes perfect. I can prove that this is the case. Watch the seven episodes that we’ve done so far on the DB2’s Got Talent Competition on the DB2Night Show and you’ll see how each presenter and presentations gets better & better. You know what this show is actually doing? This competition is grooming many people to become future speakers at conferences such as IOD and IDUG.
The theme for today’s show was Personal DB2 Success Stories. Seven people presented. Let me tell you briefly about each:
Norberto – A Handmade ETL Solution
ETL = Extracting, Transforming, Loading. Like the pro he is now, Norberto laid out the problem, the need, and a creative solution using triggers, procedures and functions. Very well done.
Momi – Old School Table Partitioning
Momi used a fair amount of humour in today’s presentation and it worked very well. He clearly described the problem of having a table that continued to have more data coming in. Restrictions included a need to keep the table size constant and no time for maintenance. Momi gave us a few possible solutions and advantages of each.
JB – A Terabyte of Data & Trouble with I/O
This sounds like it could be a very common problem. JB showed us how she used the DB2 V9.7 rebalance feature to improve performance and contention by 90%.
Mary – Using SQL to Write SQL
Mary gave us a very creative way to use scripting. She gave very clear instructions with pointers as to what to watch out for. With a small amount of work, these scripts could be used on the mainframe as well.
Ahmad – Fix Runaway Job & Change Developer’s Mindsets
The SQL examples that Ahmad showed were very complex, but he did a nice job of taking us through the details. The suggestion that DBAs need to work with their developers was a good one.
Thiru – Influencing Optimizer for Success
Although this is a risky thing to do, Thiru did a fine job of taking us through how to create an optimizer profile that can improve performance of a statement that ran 4 hours. He succeed using the DB2CAEM utility (which he said is like a flight simulator) and now the statement takes 4 minutes to run.
Bob – Searching for the Needle in a CLOB Haystack
Last, but not least, Bob showed us how he created a Java application to do string manipulation to improve performance over using the LIKE option. This was a cookbook type of presentation that gave many tips on how to perform the actions.
This episode we had to send two people “home”, unfortunately. And just as it is on American Idol, this gets harder to do each week because the quality of each presentation is amazing and 100% of the audience said they learned something new during this show. The judges, Martin Hubel, Cristian Molaro (sitting in for Klaas Brant this week), and myself were in agreement with the results from the audience poll. We decide to send Thiru to the finals and said good bye & thank you to both Bob and Ahmad.
Now we need your help… now, more than ever. We need you to watch the replays and to decide which presentation you think is best. Vote for the best to decide who will go on and will get a free pass to an IDUG conference of their choice.
To vote, use this URL: https://www.surveymonkey.com/s/DB2TalentFinals3
Thanks to Scott Hayes for putting this show together to Entertain and Educate us. Thanks to all the participants for your dedication to DB2 and for sharing your experiences with all of us. All of you are quite talented and should consider presenting to a live audience at a future IDUG event.
Join us next week for the final show of the competition. There will not be a show on April 1. The winner will be announced on the show on April 8.
If you've considered making the move to DB2, developerWorks has made it easier than ever to find out everything you need to know.
The new DB2 enablement page for DBAs and database developers is loaded with resources -- articles, tutorials, demos, webcasts, and more -- to help you understand the benefits of DB2 for Linux, UNIX, and Windows. Benefits like industry-leading performance, autonomic admin features, and lower costs.
Are you already working with another relational database management system (like, say, Oracle)? Why not find out how easy it is to migrate your applications to DB2 9.7? Plus, new SQL compatibility features in DB2 9.7 (including support for Oracle's SQL and PL/SQL dialects) make it easy to reuse your PL/SQL knowledge.
And for more on all of IBM's data solutions, stop by our Information Management zone here on developerWorks.
And don’t forget the great books that are available for you to make the move to DB2:
Beginning DB2: From Novice to Professional
Understanding DB2®: Learning Visually with Examples, 2nd Edition
svisser1 2700018UK9 Tags:  assessment iod11 exam qualitystage crammer infosphere certificaiton 5,878 Views
This year at the IBM Information on Demand Conference (#IOD11), there is a crammer course for InfoSphere QualityStage 8.5 (Exam 422). If you use this product, you may want to earn an industry-recognized IBM Information Management certification by passing Exam 422. Passing this exam is a great way to validate your skills on the InfoSphere QualityStage 8.5 product. Remember, if you are a registered Information On Demand conference attendee, taking the exam is free. Normally it is $200 per take, so you are saving significantly.
To help you pass this exam, consider taking the Crammer course that is being offered for the first time at this event: (9Q061) InfoSphere QualityStage 8.5 Certification Crammer for Exam 422. This course is being offered the day BEFORE IOD begins: Sunday, October 23. You can register in advance or show up early morning to register at the event.
The instructor for this course is Dale Buckingham. Dale is a learning consultant and technical architect for InfoSphere.
This one day crammer course is designed to introduce you to the concepts a test candidate must know in order to take and pass the InfoSphere QualityStage 8.5 Certification exam 422. The material for this course is aligned with the 422 exam objectives.
To gauge whether you need to take this course or not, consider taking the assessment exam. Normally these exams cost $10, but for conference attendees they are free and will show you how much more you need to know to pass the exam. Beyond this crammer courses, check out the other types of education that are available to learn the material to pass this exam. Of course, you may not have time to take any of this education before going to IOD, so the crammer course may be the best timing and value.
The test contains six sections totaling approximately 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Methodology (5%)
Section 2 - Design Considerations (18%)
Section 3 - Investigation (10%)
Section 4 - Standardization/Addresses/Postal (11%)
Section 5 - Rule Sets (16%)
Section 6 - Matching (21%)
Section 7 - Survive (10%)
Section 8 - Setup and Troubleshooting (10%)
Good luck on this an any other exam you may choose to take at the IOD conference this year.
Design, implement, and monitor a successful Q replication and Event Publishing project
by Pav Kumar-Chatterjee
Buy the book now from packtpub.com.
Available soon from Amazon.
Note… this is Pav’s second book. His first was co-authored with Mattias Nicola:
Packt will publish their 100th Enterprise focused title. The chosen title for this landmark moment: Lotus Notes 8.5 User Guide !
This is it. We’ve done all that we can do and now we get to reap the rewards of our hard work. Show time!
IBM Information on Demand starts this weekend. Many of us are flying to Las Vegas tomorrow already. The weekend will be filled with customer meetings, business partner sessions and the inevitable last minute details.
What can you expect? You’ll walk a lot, meet many people, maybe even eat too much. You’ll learn about many new products and technologies. You’ll be tired by the end of the week, but I hope you’ll end the conference saying that you had fun and that every minute was worth it!
If you want a running commentary on what’s happening at the conference, be sure to check out the Official IOD Blog and Twitter and Facebook. Several of us will be posting to these sites throughout the week.
Here’s a list of the blog entries I’ve published in the past month to support this IOD:
A few of my entries went straight to the Official Blog. Here are mine and a couple of my favourites:
Have fun, learn a lot... and stay safe!
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.
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?
Have you taken IBM certification exams in the past, but don't remember what you've passed? Have you received the certificates that you are entitled to? Check on the Member Site for IBM Certified Professionals to see where you stand.
IBM's Certification Member Site allows you to:
* View your test and certification history, including shipping status of certificates
* Submit requests to merge multiple candidate/testing IDs
* View and update your demographic information
* Request additional copies of your certificates (softcopy via email or hardcopy)
* Download the IBM Certification marks to which you are entitled
Remember, certification results are confidential to you, so if you have earned a certification, the only way for your manager to know is if you tell them. I suggest that you print a copy of the certificate and give it directly to your manager.
Watch The DB2Night Show episode #5
Nov 12 11am EST
"SQL Snapshot Potluck Party"
with special IBM guest Chris Eaton
In this episode of The DB2Night Show, special guest Chris Eaton from IBM will share his TOP 10 Favorite SQL Snapshot commands, host Scott Hayes will throw in a few of his faves, and EVERYONE who contributes at least one of their own favorite SQL Snaps to the show will receive access to a FREE text/zip file containing ALL of the SQL Snaps on the Show! WOW - What a great way to build your toolbox of SQL Snapshots!!!
Click on the registration link for details on how to submit your SQL Snapshot to this potluck party.
Rumor has it that another special guest may make a cameo appearance as well - independent security consultant, published author, and now DB2 LUW Security blogger Rebecca Bond has threatened to share SQL commands with viewers that will help analyze DB2 Security! Have you discovered her new DB2 LUW security blog yet?
ALSO - are you following http://www.twitter.com/db2nightshow yet? YOU SHOULD BE! Set your "follow" to enable mobile messages - The DB2Night Show is now starting to give away Amazon.com gift certificates! Just be the first to directly and correctly answer DB2 trivia, sample certification, or other DB2 related questions, and you could win valuable prizes!
Visit http://www.DB2NightShow.com weekly for updates on upcoming shows and recorded replays. Here is a look at future shows that are currently being planned:
* Nov 20 "Free Application Development Tools - Data Studio vs Quest Toad" (tentative)
* Dec 4 "SQL Server versus DB2 LUW and FREE DB2" with special guests Paul Z and Leon K from IBM (tentative)
* Dec 11 "Managing the DB2 Workload Manager" with special guest Paul Bird from IBM --AND-- A REAL LIVE CUSTOMER that is using WLM! (confirmed)
* Dec 18 "Crunching the Numbers - Snapshot Analysis with Scott Hayes" We'll be looking at real data from real live production databases. (confirmed)
* Jan 8, 2010 "DEAR IBM, ..." Special guests include IBM senior executives and leaders Sal Vella, Tim Vincent, and Drew Bradstock. Send your praise, comments, feedback, questions, and requirements to the show! This is a virtual CAC of sorts with a guest panel of IBM DB2 LUW top shelf leaders! (confirmed)
Congratulations on reading this far! Here is your reward! The first five people to register for Episode #5 and who contribute a SQL Snapshot command will receive a $25 Amazon.com gift certificate in appreciation for your contribution to the Potluck Party.
The International DB2 User Group (IDUG) is a co-sponsor of The DB2Night Show.