Keep on Learning
As usual, host & IBM Champion Scott Hayes has some interesting shows lined up on his award winning webinar series: The DB2Night Show.
October 5, 2012; 11:00 AM – 12:00 PM
"You CAN Teach an Old Programmer New Tricks” with Bonnie Baker, IBM DB2 Gold Consultant
October 12, 2012; 11:00 AM – 12:00 PM
BREAKING NEWS from IBM! Special guest, Les King, Director, Information Management Solutions & Warehouse Development at IBM, tells us he'll have some exciting "breaking" news to share!
October 19, 2012; 11:00 AM – 12:00 PM
“The Joys of Big Data” with Dave Beulke
If you’ve missed any of the shows in the past, remember that they have been recorded and are available for you to watch anytime you like. Here are a few that I’ve blogged about in the past:
Harness the Power of Big Data - The IBM Big Data Platform
by Paul Zikopoulos, Dirk deRoos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles
Information about book:
Big Data represents a new era of computing – an inflection point of opportunity where data in any format may be explored and utilized for breakthrough insights - whether that data is in-place, in-motion, or at-rest. IBM is uniquely positioned to help clients navigate this transformation. This book reveals how IBM is leveraging open source Big Data technologies, infused with deep IBM innovation from over 6 billion dollars in analytics acquisitions, that manifest in a platform capable of 'changing the game'.
In this book you will also learn not just about the technologies that make up the IBM Big Data platform, but when to leverage its purpose built engines for analytics on data in-motion and data at-rest. And you’ll gain an understanding of how and when to govern big data, and how IBM’s industry-leading InfoSphere integration and governance portfolio helps you understand, govern, and effectively utilize big data. Industry use cases are also included in this practical guide.
An excerpt of this book is available and can be found: The Big Data Hub. Also see the Big Data Hub for blog entries, videos, and other resources that will help you on your journey in the Big Data world.
If you are attending the IBM Information on Demand Conference, get a free printed copy of this book at the Information Desk at the big data booth #622 in the Expo. Bring your book to get signed by the authors at the IOD bookstore Tuesday October 23, 9:30 – 10:30.
After the conference is over, a free e-version of the book will be available for you to download. Follow my blog to ensure that you are one of the first to know where you can download the book.
Other sessions by these authors:
Co-Author Krishnan Parasuraman created this reading list related to the book: Big Data / Netezza Reading List
Lots of people love IBM Redbooks. As you know, they are FREE and available
for you to download in PDF or EPUB versions at anytime from the IBM Redbooks website.
One of the most popular giveaways at IBM Information on Demand Conference is
printed IBM Redbooks. This year we have 10 different titles to give away.
Please note that the PRINTED copies are in limited quantity.
Make sure you attend one of the sessions planned at the bookstore to make sure
you get the title that you want. While you're getting your free copy, meet the authors who wrote the book and have them sign it for you!
I included links to the eversion of the book if it already exists. Notice that some are not yet published? They’ll be launched specifically for IOD:
Tuesday, October 23, 12:00 – 1:00 at the IOD bookstore
Wednesday, October 24, 12:00 – 1:00 at the IOD bookstore
Thursday, October 25, 12:00 – 1:00 at the IOD bookstore
As you can see, we’ve made it easy for you. Come by the bookstore Tuesday, Wednesday and Thursday at lunchtime to get a printed book!
While you’re at the bookstore, check out the technical books that are available for you to purchase at a 20% discount as well as pick up one of the many free Flashbooks that are scheduled to be handed out at the bookstore on Monday, October 22.
The IBM Information on Demand Conference is a great place to promote books that are published through out the year. In fact, quite often publishers time the release of their books to coincide with this conference. As a result, we are typically able to set up book signings and giveaways to help promote the books.
This year is no different. We have quite a few books that have published already that we’ll promote as well as books launching just for the conference and we’ll have 4 (possibly 6) new Flashbooks that we’ll be giving away!
“Flashbooks” are small-sized books that have fewer than 150 pages, and have easy-to-read messages about products, solutions, or technology. Flashbooks are published to coincide the IBM Information on Demand Conference. The huge quantity of messages and content delivered at the conference makes it difficult for attendees to retain all the key messages. Flashbooks are designed to contain the key messages IBM experts want you to take away with you.
Here is the list of Flashbooks. More details for each will be available in my blog shortly.
Warp Speed, Time Travel, Big Data, and more: DB2 10 for Linux, Unix and Window New Features
by Paul Zikopoulos, Walid Rjaibi, George Baklarz, Matt Huras, Matthias Nicola, Dale McInnis, and Leon Katsnelson
Information about the book: http://ibm.co/db210flashbook
Signing and Giveaway: Monday October 22, 12:30 – 1:30 at bookstore.
5 Steps to Business Analytics Program Success
by Brian Green, BlueCross BlueShield of Tennessee, Kay Van De Vanter, The Boeing Company, Tracy Harris, IBM, Bill Frank, Johnson & Johnson, John Boyer, RCG Global
Signing and Giveaway: Monday October 22, 5:00 p.m.–7:00 p.m. EXPO reception
Business Value of DB2 Optimizer and Analytics Accelerator - DB2 for z/OS
by Surekha Parekh, Terry Purcell, John Campbell, Ruiping Li
Signing and Giveaway: Mon 12:30 – 1:30 at bookstore.
Harness the Power of Big Data - The IBM Big Data Platform
by Paul Zikopoulos, Dirk deRoos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles
Signing and Giveaway:
An excerpt of this book is available and can be found: The Big Data Hub
Note: After the conference, all of these books will be available in electronic format. Follow my blog to find out how to get the softcopy!
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:
Interested? I hope so! Here are all the nitty gritty details: DB2’s Got Talent.
This year there are also great runner up prizes:
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!
Join the “one of the best speaker presentations at IDUG North America” webcast that is taking place tomorrow, Nov 2, free of charge.
Webcast DetailsThis webcast will be kicked off by Jeremy Dodd, the current IDUG President. Jeremy will provide an overview of IDUG and then introduce Suresh Sane. Suresh presented one of the best presentations this year at the IDUG DB2 Tech Conference 2011 in Anaheim – DB2 10 Application Topics—A DB2 10 Customer's Experience. Suresh has updated his presentation since the May conference and has added even more experiences and best practices. He has also recently shared his experiences at IBM Information On Demand Conference in Las Vegas.
Gain valuable insight on the DB2 10 user experience such as:
Jeremy has been an active volunteer with IDUG since 2000 as a conference presenter, moderator, Conference Planning Committee member, and had a two-year run as Conference Chair of IDUG Europe (2005-2006). His assignments on the Conference Planning Committee included leading the presentations, marketing, vendor liaison teams. Professionally, Jeremy is a Consultant within the Database Technologies area within Accenture and has 10 years of DB2 for Linux/UNIX/Windows (LUW) experience.
Suresh Sane is an IDUG Hall of Fame speaker who has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and DB2 Packages). He was recognized as an IBM Information Champion in 2009 and 2010. He is a long-time IDUG volunteer and was the Conference Chair for IDUG NA 2008. He recently served on the IDUG Board of Directors.
Register now: http://bit.ly/IDUG2ndNovIBM
Congratulations to the hardworking team for updating the Streams Redbook "IBM InfoSphere Streams: Assembling Continuous Insight in the Information Revolution" to Version 2. The team contributed vast knowledge, time, and expertise to this new version and will be happy to hand out copies to 250 lucky IOD attendees.
Come to the Conference bookstore on Wednesday, October 26 11:30 am – 1:30 pm to get your copy and to meet the author & project team. Use Smart Site to sign up for this session: Session #4205 IBM InfoSphere Streams and the Streams Processing Language.
Note, if you prefer a softcopy version, simply go to the IBM Redbooks site and download the book… always green & free!
Besides the updates to all materials from Streams version 1.2 to version 2.0, there have been additions of new chapters and appendices and links to a streamtool reference and also examples that you can download.
About the book:
In this IBM® Redbooks® publication, we discuss and describe the positioning, functions, capabilities, and advanced programming techniques for IBM InfoSphere™ Streams, a new paradigm and key component of IBM Big Data platform. Data has traditionally been stored in files or databases, and then analyzed by queries and applications. With stream computing, analysis is performed moment by moment as the data is in motion. In fact, the data might never be stored (perhaps only the analytic results). The ability to analyze data in motion is called real-time analytic processing (RTAP).
IBM InfoSphere Streams takes a fundamentally different approach to Big Data analytics and differentiates itself with its distributed runtime platform, programming model, and tools for developing and debugging analytic applications that have a high volume and variety of data types. Using in-memory techniques and analyzing record by record enables high velocity. Volume, variety and velocity are the key attributes of Big Data. The data streams that are consumable by IBM InfoSphere Streams can originate from sensors, cameras, news feeds, stock tickers, and a variety of other sources, including traditional databases. It provides an execution platform and services for applications that ingest, filter, analyze, and correlate potentially massive volumes of continuous data streams.
This book is intended for professionals that require an understanding of how to process high volumes of streaming data or need information about how to implement systems to satisfy those requirements.
Many thanks to Chuck Ballard, Sandy Tucker, Elizabeth Peterson, Vitali Zoubov, Brian Williams, Warren Pettit, Diego Folatelli, and the team of reviewers who contributed to this new edition.
The Conference bookstore will be a busy place this year. Here are the blog entries that summarize all the events and provide session numbers:
Here are the other signings and giveaways that are taking place at the event:
Coming soon: A podcast series where I’ll interview as many of these authors as I can!
I’ve been creating an individual blog post for each of the flashbooks that we have scheduled for a giveaway and author signing at this year’s IBM Information on Demand conference. I now have session numbers assigned to each of the signings which means that you can add this event to your IOD schedule using SmartSite so that you don’t forget about it. You can find links to SmartSite for web or mobile connections, as well as a tutorial of how to use SmartSite on the Conference website: http://www.ibm.com/software/data/2011-conference/. Use the Session numbers listed below with the book information and register.
We have a limited number of the following “Flashbooks” and “IBM Redbooks” that will be given away at the appointed time. The authors of these books will be available to sign your copy. Note that registering for the session via SmartSite does not guarantee a book for you. You must still show up at the designated time before the limited supply of books have been given away.
Monday 9:45 - 10:45 am
Tuesday 9:30 - 10:30 am
Session #4125 Flashbook: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data by Dirk deRoos, Chris Eaton, George Lapis, Paul Zikopoulos, Tom Deutsch
Monday 10:45 – 12:30 pm
Session #4202 IBM Production Imaging Edition and Datacap Taskmaster
Both by the IBM Redbook Team
Tuesday 3:00 – 4:00 pm
Wednesday 11:30 - 1:30 pm
Session #4206 IBM solidDB: Delivering Data with Extreme Speed
Both by the IBM Redbook Team
Monday 12:30 - 1:30 pm
Session#4126 Flashbook: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance by Cristian Molaro and John Campbell
Monday 5:00 - 6:00 pm
Session #4127 Flashbook: Customer Experience Analytics: Fast, Intelligent and Action-Packed by Arvind Sathi
svisser1 2700018UK9 Tags:  webinar learn hayes free hornibrook db2night db2 statistics education 5,856 Views
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..."
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!
Two more best practices have recently been released for IBM Smart Analytics Systems. Thanks to Serge Boivin for this information!
This document describes IBM Smart Analytics Systems scenarios where DB2 software manages multiple database partitions in a cluster. The scenarios describe optimization methods that can help improve performance in a short time.
The two main tasks for query optimization are:
The key design goals of ingest application design are to balance the required rate of ingest with the availability of processing resources, to ingest data without affecting data availability, and to maintain flexibility in the volumes of data ingested. Identifying service level objectives for the speed and volume of data ingested into the data warehouse will determine the architecture, design, and development of the data ingest application.
See also my previous posts on Best Practices:
svisser1 2700018UK9 Tags:  best_practices db2night education webinar free performance warehouse 5,551 Views
The DB2Night Show first launched in September 2009, and since that time, there have been many requests from the DB2 LUW community for an episode on DB2 LUW Data Warehouse Performance Tuning. It took a while to find the best speakers, but the ideal guests will be on Friday’s episode, which is the Season 2 Finale.
Join Kate Kurtz, Haider Rizvi and Gregor Meyer as they share with IBM recommendations and suggested best practices for optimizing performance of Data Warehouse Databases. If you're trying to make DPF or multi-partition databases run queries as fast as possible, then you should sign up for this show.
Topic: Recommendations and suggested best practices for optimizing performance of Data Warehouse Databases
Speakers: Kate Kurtz, Haider Rizvi, Gregor Meyer. Host: Scott Hayes
Date: Friday, June 24
Time: 11:00 ET
About the speakers:
Haider Rizvi is a Senior Technical Staff Member (STSM) in the Information Management division at the IBM Toronto Lab. He is responsible for the IBM Smart Analytics System architecture and design, a data warehousing solution built using the InfoSphere Warehouse software, IBM servers and storage systems. He is interested in data warehousing performance issues both at the code level as well as systems configuration and tuning.
Haider joined IBM in 1994 in the DB2 Parallel Edition development team. Since then Haider has been working towards improving the DB2 product for data warehousing workloads. He has an M.S. in Computer Engineering from Rice University, Houston and an M.B.A. from the Ivey School of Business, University of Western Ontario.
Gregor Meyer: Data Warehouse Architect, Boeblingen Lab, Germany
Katherine Kurtz has been a member of the DB2 development team since 1997 and is currently an Information Development Manger for DB2 LUW and the IBM Smart Analytics System for the DB2 LUW Development team at the IBM Canada Lab in Markham, Ontario. She holds a Bachelor of Mathematics (Computer Science and Pure Math) from the University of Waterloo and a Bachelor of Education from the University of Western Ontario. Katherine’s work is focused on understanding how customers use our products, and how IBM can make our products more consumable through the sharing of best practices that incorporate insight from IBM technical leaders in the Lab and in the field. Katherine also has deep experience in DB2 System Verification and Test, SAP/DB2 Integration, customer support, performance development and release management.
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 electronic gift certificate! If you can't make the scheduled time, register anyways so that you get information about recorded replays.
Join Sal Vella and Steve Rees for the next Chat with the Lab event: The Latest in Advanced Performance Diagnostics on Tuesday May 31. DB2 Chat with the Lab is a free webinar series from the IBM labs that invites experts to speak to you about DB2-related breakthrough technology, best practices, and to answer your questions.
Recent releases of DB2 for LUW have continued to introduce improved ways to monitor the performance of your system, and uncover & solve performance problems. This presentation will review the gamut of performance tools on offer in DB2, focusing on recent additions such as the new 'time spent' metrics in DB2 9.7, new table functions to access monitor data, and the latest in db2pd options to see what's going on "under the hood" . The emphasis will be on the practical use of these tools to solve typical performance problems.
Presentation charts will be available on ibm.com/db2/labchats just prior to the event.
There have been many episodes in this series. You find them and watch the replays on ChannelDB2.com. To tempt you, here is a list of what you’ll find:
Someone has been very busy! And the best part? They’re all FREE! Learn & Enjoy.
svisser1 2700018UK9 Tags:  oracle tutorials db2night blogs devworks docs db2 meetdb2 free 6,869 Views
OK, I thought I had produced a pretty good list of free resources, but of course, as soon as I post, I realize that I’ve forgotten to mention some really key resources. Let me try again and hope that I don’t miss anything else! (Of course if I do… please tell me!!)
Read through my previous blog entries for more free or almost free resources:
svisser1 2700018UK9 Tags:  contest free db2 webinar education performance db2night_show 6,805 Views
I’ve promoted many, if not all, of the DB2Night Show episodes that took place in 2010. Scott Hayes, the host of these free webinars has produced a list of the most highly attended shows. All of these shows were recorded, so if you missed one or more, you can catch up.
#1 - Episode 21. DB2 LUW Locking with special guest Mike Winer from IBM
#2 - Episode 17 . DB2 LUW Performance Updates with special guest Berni Schiefer from IBM
#3 - Episode 28. DB2 LUW Range Partition Tables with Mike Winer from IBM. Mike congratulations for having two spots in the TOP 3!!
#4 - Episode 11. DB2 9.7 Optimizer Updates with special guest John Hornibrook from IBM
#5 - Episode 18. The Top 10 DB2 LUW Mistakes People Make with special guest Klaas Brant from KBCE.
#6 – Episode 29. DB2 LUW High Availability and Recovery Planning with special guests Kate Kurtz and Dale McInnis from IBM
#7 – Episode 13. DB2 LUW Compression Updates with special guest Paul Zikopoulos from IBM
#8 – Episode 12. DB2 Information Resources with yours truly….Susan Visser. Can’t believe I made the list!!
#9 – Episode 31. Valuable SQL Lessons Learned with special guest Sheryl Larsen from SMLSQL Inc.
#10 – Episode 10. DEAR IBM... Q&A with Senior Executives with special guests Sal Vella and Tim Vincent from IBM
Thanks Scott for pulling together such a valuable and well attended series of educational webinars!
I work in the Toronto Lab, so I’m very lucky to know all of the listed speakers personally. I’m constantly humbled by the high quality people I get to work with! Sheryl and Klaas I also personally know, but from my association with IDUG instead of IBM.
What’s up for 2011?
I’ll be a judge on the DB2 Night Show in February & March: DB2'S GOT TALENT CONTEST.
Join us on the following dates:
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
I’m looking forward to a fun & rewarding new year and wish all the best for you and your families as well!
svisser1 2700018UK9 Tags:  db2night_show webinar db2 sql_server oracle high-availability free 6,218 Views
Join Scott Hayes and Klaas Brant on the last show of this season.
HIGH AVAILABILTY: Comparing DB2 (pureScale), Oracle (RAC), and SQL Server (Cluster)
Friday, December 17, 2010 11:00 – 12:00 EST
DB2 has some great high availability options like HADR and Pure-Scale. But how about the competition? How does DB2 compare to Oracle and SQL Server? In this episode we will look at the architectures that enable high availability and show you why DB2 Pure-Scale is superior to Oracle RAC and SQL Server Cluster.
Personal Tidbit: For those keeping score, my blog views are now over 980,000! Lately I’ve been getting nearly 20,000 new views every week, so there is still a chance that I can get to 1M before the end of the year. Thanks for all your support this year!