Modified on by svisser1
IBM Innovate 2013 is a Technical Summit that provides insights that you need to stay ahead..... and it takes place June 2 - 6 in Orlando Florida.
This Summit offers over 450 outcome-driven sessions, including quite a few that are focused on the ever popular Big Data area. If you are attending the conference, you should consider attending these Big Data sessions:
BD-1962 : Agility in a Relational Database World - Dynamic Schema with JSON and DB2
Speaker: William Bireley, IBM
Today's mobile, social, and analytic applications demand agility, speed, and scalability using a flexible data model. This partly explains the huge interest in NoSQL databases. Modern applications frequently need to add, drop, or modify fields in the data store without administrator involvement. Change management processes associated with relational databases can be an impediment to continuous integration processes. A popular NoSQL approach is the use of a "document database", where documents are stored with a flexible format, such as JSON. Many existing NoSQL solutions offer these advantages, but sacrifice "ACID" characteristics of a traditional database, such as transaction control, recover-ability, and other aspects taken for granted in DB2. Using DB2 as a JSON document store provides the best of both worlds. This session describes a solution that does exactly that. The session also includes a live demo showing the power and flexibility of this JSON over DB2 solution.
BD-2501 : Big Data Predictive Analytics
Speaker: Mike McRoberts, IBM
Learn about the new Big Data feature in IBM SPSS Modeler and how to automate and integrate this capability into your application. You don't have to worry about Map/Reduce programming to take advantage of predictive analytics on Big Data.
SC-2486 : Cloud and DevOps: Big Demands, Big Iron
Speakers: Phil Murphy, Forrester; Hayden Lindsey, IBM
DevOps is changing how software is delivered, but how does it fit into your shop? The demands of delivering applications across mobile, social, big data, and cloud technologies are driving development teams to use many different types of technology. Furthermore, Agile methodologies are enabling development teams to deliver usable application features on quicker schedules. This is now happening for application development on all platforms, in private datacenters and public clouds. Learn how your organization measures up as Phil Murphy, VP and Research Director with Forrester Research, presents fresh research on the impact of these technology trends on IT organizations. Listen as Hayden Lindsey, IBM VP and Distinguished Engineer, discusses how software from IBM Rational brings agility to all of your development environments, from mobile apps to mainframe environments.
CLD-2185 : Developing in the Cloud? Turning Challenges into Opportunities
Speaker: Todd Moore, IBM
Address the increasing challenges of meeting the requirements of your customers. Reduce the pressures on development to deploy new services. Address the challenges by leveraging technologies that can develop once and deploy anywhere. Maximize the power of the cloud, while streamlining your development processes to include Mobile, Social, Big Data, and Business Analytics. Understand how OpenStack is providing flexibility in architecting your cloud. Learn how OSLC and TOSCA are integral to simplifying and accelerating your development processes. Todd Moore of IBM and Jay Snyder of Aetna Insurance will take you through their experiences on how they enabled their developer community to leverage these leading technologies to effectively deliver interoperable solutions. By the end of the session, you will understand how to take your team's development processes to the next level and be more responsive in meeting the needs of your customers.
BD-2498 : InfoSphere BigInsights Programming Overview
Speaker: Anshul Dawra, IBM
Get the most from your Big Data by developing new applications. We'll cover the popular programming styles for Big Data, including Map-Reduce, HBase, SQL and Hive, Jaql, Pig, and Text Analytics. We'll show how to create new applications from spreadsheets and display the results graphically. Learn how developers and end users can leverage big data with simple yet powerful programming styles.
BD-2499 : InfoSphere Streams Programming Overview
Speaker: Pete Nicholls, IBM
Big Data is everywhere we look. In late 2012, IBM conducted an audited benchmark illustrating how IBM Platform Symphony delivered a dramatic 7.3 times performance gain across a range of representative Hadoop MapReduce workloads. While the performance results are compelling, for many organizations the real value lies in associated opportunities for cost savings that arise from greater efficiency and resource sharing on a multi-tenant grid infrastructure. In this session, we will explain the benchmarks and results, detail the technologies that enabled the results, and discuss how organizations can take advantage of low-latency scheduling and new file system technologies to achieve dramatic efficiency improvements in their own Big Data projects. IBM will also unveil a total cost of ownership calculator that can help organizations estimate cost savings opportunities for a variety of distributed computing workloads including Hadoop MapReduce.
BD-2510 : Lightning fast access to Data with IBM Caching
Speaker: Brian Martin, IBM
Traditionally, data is placed in storage and when needed, accessed and acted upon in memory. This results in a natural bottleneck that impacts performance. As data volumes increase, the time required to access and analyze grows and becomes cumbersome. Complex calculation can't be accomplished in real time. With in-memory computing, we can better understand how data is shaped and stored. In this session, we will discuss how in-memory data grids like WXS & XC10 mark an inflection point for enterprise applications, especially with big data. Real-time information provides decision makers with insights not previously available. The session will cover how large data sets can be made available and accessed near-instantaneously.
BD-2511 : Test Data Management in the New Era of Computing
Speaker: Swati Moran, IBM
Big data means high volume, variety, velocity and veracity data. Most development and testing organizations aren't prepared to develop and test applications in this high pressure environment. Clients demand access and high availability. In the rush to meet growing client needs and build applications to support the speed of business, testing becomes even more critical. This session will explore best practices for test data management in the software development lifecycle to satisfy the demands of big data, while protecting sensitive data. In addition, it will explain how to speed delivery of big data applications while reducing cost by enabling testers and developers to access and refresh test data.
BD-2049 : Three Steps for Securing Big Data Environments - Why Big Data Doesn't Have to Mean Big Security Challenges
Speaker: Kimberly Madia, IBM
The ability to harness big data has opened the door for world-wide collaboration in real time. Organizations are able to process data on an extreme scale to derive maximum value. However, as big data environments ingest more data, organizations will face significant risks and threats to the repositories containing this data. Failure to ensure data security reduces confidence in decision making. Ironically, organizations are generating more data now as compared to any other point in history, and yet they don't understand how to protect it. In this session, we will discuss three steps to improve security in big data environments.
I have two upcoming webinars to tell you about today and hope that you can
make one or both of them!
First, the second season of the DB2Night Show starts this
Friday, August 6, 2010. This kickoff episode is special in
that it is 90 minutes in length and Scott will be joined by my two good
friends Serge Rielau and Dwaine Snow.
Together they will give us updates on all the ways that IBM is making it easy
to choose DB2 LUW. If you are a current user of Oracle or Sybase, you really
don’t want to miss this show.
Season 1 ended up with 23 shows and if you missed them, come and listen to
the replays. I was a guest on one of the shows and had much fun with Scott!
View the upcoming shows and register here: DB2Night Show Website.
Second, the DB2 Database professional bloggers are hosting a
free 60-minute virtual session for our the community. The best part is
... YOU GET TO CHOOSE THE TOPIC! Yes, that's right. This virtual
session will be on a topic of your choice. Are you interested in an overview of
the technical advantages of DB2 over Oracle? Want to know more about DB2
pureScale? Maybe you'd like tips on how to migrate an existing Oracle
application to a DB2 application? Whatever your topic(s) of interest, post a
comment and let me know. If you're new to DB2, this is a great opportunity for
you to become familiar with DB2.
Nominate a topic here: DB2 Database
By the way, this is a good blog to “follow”.
Three more days till I fly to Vegas.... for the IOD Conference! I really can't believe how busy I am... and most of it is prep work for IOD! My primary function at the conference will be to introduce you to the many books that are available for you to read to grow your skills on multiple Information Management topics. And guess what? I have much to announce to you on this topic!
First of all, if you are attending the conference, come and visit me at the IOD bookstore: Bayside Foyer, Mandalay Bay Convention Center - South, Level 1
**Books at the IOD Conference bookstore are 20% off the retail price
There are too many books to list here, so come by and browse. Of particular interest are the following books that you can buy and get signed by one or more of the authors:Mark Jeffries
signing copies of What’s Up With Your Handshake?
–Mon 11:00 am - 12:30 pm
–Tue 1:30 pm – 2:30 pm
–Location: At Conference Bookstore Neal Fishman
signing copies of Viral Data in SOA: An Enterprise Pandemic
–Mon 1:30 pm – 2:30 pm
–Location: At Conference Bookstore Malcolm Gladwell
signing copies of his newest book, Outliers
, along with his best-sellers, Blink
and The Tipping Point
–Wed 10:15 am - 11:15 am
–Location: At Conference Bookstore Matthias Nicola
signing copies of DB2 pureXML Cookbook
–Mon & Wed 1:30 pm - 2:30 pm
–Location: At Conference Bookstore
As usual, we also have a collection of books that we are giving out free of charge. I call these "flashbooks" because they are small, easy to read, and introduce you to a new topic. These books are in limited quantity... and you MUST be at the conference to get a copy:Judith Hurwitz
, Fern Halper
, Marcia Kaufman
, Glenn Hintze
, Adam Gartenberg
–Mon 2:30 pm - 3:30 pm
–Authors will be available to sign your copy of Information on Demand for Dummies
–Exchange your coupon for a free book at the Bayside Level Ticket Counter (across from the IOD Main Information Desk)
–Signing location: At Conference Bookstore Bill Wong
, Rex Wiederanders
, Alan Meyer
, Pat Bates
, Mike Biere
–Wed 3:45 pm - 4:45 pm
–Authors will be available to sign your copy of New Intelligence for a Smarter Planet - Driving Business Innovation with IBM Analytic Solutions
–Location: Mandalay Bay Registration Desk South Kelvin Looi
–Mon 3:30 pm – 430 pm; Tue 3:30 pm – 4:30 pm
–Signing copy of book MDM for Customer Data: Optimizing Customer Centric Management of Your Business
–Location: Mandalay Bay South: Bayside D – Data Management Room Paul Zikopoulos
, Belal Tassi
, George Baklarz
& Chris Eaton
–Tue 12:00 pm - 1:00 pm
–Authors will be available to sign your copy of Break free with DB2 9.7: A Tour of Cost-Slashing New Features
–Location: Mandalay Bay Registration Desk South Jason Chan
–Tue 12:00 pm - 1:00 pm
–Author will be available to sign your copy of IBM Redbook: DB2 Virtualization
–Location: Mandalay Bay Registration Desk South Jacques Roy
–Tue 12:00 pm - 1:00 pm
–Author will be available to sign your copy of Informix Dynamic Server Application Development – Getting Started
–Location: Mandalay Bay Registration Desk South
I'd also like to invite you to the new group I created on MyDeveloperWorks
. I will add information about new or existing books as I learn it. If you have questions, this is also a great place to ask it. I'm planning to invite every author who I work with to join me and ask them to answer your questions!
You must join MyDevelopersWork
to join my group. Find information here:https://www.ibm.com/developerworks/mydeveloperworks/
and then join my group: BOOKS! Primarily technical books that cover Information Management products... but a few others too!
As usual it’s been a very productive year for the ITSO who publish IBM Redbooks. Here is a list of 30 titles that were released for the Information Management area in 2010. Notice that the ITSO allows you to give reader feedback and ratings for these books. If you like a book, make sure you leave a comment. Word of mouth feedback is impressively influential.
IBM Scale Out Network Attached Storage Concepts
Published 1 December 2010
IBM Content Collector Integration with IBM Classification Module
Published 11 November 2010
IBM Cognos Business Intelligence V10.1 Handbook
Published 25 October 2010, Rating: (based on 2 reviews)
This one was handed out in printed format at the IOD conference, and it proved to be extremely popular.
IBM Cognos Business Intelligence V10.1: Intelligence Unleashed
Published 25 October 2010, Rating: (based on 1 review)
IBM SPSS predictive analytics: Optimizing decisions at the point of impact
Published 18 October 2010, last updated 12 November 2010
IBM Content Collector Deployment and Performance Tuning
Published 13 October 2010
IBM Informix Developer's Handbook
Published 4 October 2010
IBM Smart Analytics Cloud
Published 1 October 2010, Rating: (based on 1 review)
IBM InfoSphere Streams Harnessing Data in Motion
Published 14 September 2010, Rating: (based on 1 review)
DB2 9 for z/OS and Storage Management
Published 9 September 2010, last updated 17 September 2010, Rating: (based on 1 review)
IBM Content Analytics Version 2.1: Discovering Actionable Insight from Your Content
Published 25 August 2010
IMS 11 Open Database
Published 10 August 2010, last updated 12 August 2010, Rating: (based on 1 review)
InfoSphere DataStage Parallel Framework Standard Practices
Published 30 July 2010, last updated 19 November 2010
Migrating from Microsoft SQL Server to IBM Informix
Published 22 July 2010
IBM Midmarket Software Buying and Selling Guide
Published 12 July 2010, Rating: (based on 2 reviews)
InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence
Published 18 June 2010, last updated 22 June 2010
Disaster Recovery and Backup Solutions for IBM FileNet P8 Version 4.5.1 Systems
Published 16 June 2010, Rating: (based on 1 review)
System z on the Go:
Accessing z/OS from Smartphones
Published 28 May 2010, last updated 10 June 2010, Rating: (based on 3 reviews)
Federated Content Management: Accessing Content from Disparate Repositories with IBM Content Federation Services and IBM Content Integrator
Published 21 April 2010
Best Practices for DB2 on AIX 6.1 for POWER Systems
Published 8 April 2010, last updated 22 April 2010, Rating: (based on 3 reviews)
DB2 9 for z/OS: Using the Utilities Suite
Published 19 February 2010, last updated 28 April 2010, Rating: (based on 6 reviews)
Leveraging IBM Cognos 8 BI for Linux on IBM System z
Published 1 February 2010, Rating: (based on 1 review)
Developing Applications with IBM FileNet P8 APIs
Published 30 December 2009, Rating: (based on 3 reviews)
DB2 9 for z/OS: Resource Serialization and Concurrency Control
Published 22 December 2009, last updated 30 December 2009, Rating: (based on 9 reviews)
DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications
Published 18 December 2009
Data Warehousing with the Informix Dynamic Server
Published 10 December 2009, Rating: (based on 1 review)
MySQL to DB2 Conversion Guide
Published 1 December 2009, Rating: (based on 10 reviews)
Using Integrated Data Management To Meet Service Level Objectives
Published 6 November 2009, last updated 25 November 2009
Oracle to DB2 Conversion Guide: Compatibility Made Easy
Published 6 November 2009, last updated 29 April 2010, Rating: (based on 8 reviews)
IBM Classification Module: Make It Work for You
Published 29 October 2009, last updated 3 November 2009
Looking for more e-books:
DB2 on Campus series of ebooks - 7 titles published, more coming. Free!
Read an e-book, you'll be surprised how much you'll like it!
ebooks are now mainstream... are you in?
Have you seen Leon's
recent blog entry?
Move over Oprah, DB2NightShow.com is moving up in ratings
My last post about the DB2Night Show was in error... I said that Mark Wilding was the special guest this week... but it's actually Mike Winer! I'm sure Mark will be rescheduled for a future show.
So, what's Mike Winer going to talk about? I was a recent guest at his new cottage, but I'm sure that topic won't come up! Instead, he's talking about DB2 Locking. Mike was at the IDUG Tampa conference and at last week's CCDB2UG, so if you missed those talks, you'll be able to catch up in this special 90 minute webinar with Scott Hayes.
Educate - Inform - Entertain ...
Our "mystery" show has turned into a very special feature "The Keys to Mastering DB2 Locking" with guest Mike Winer, IBM STSM and DB2 Kernel Architect.
Mike gave an awesome presentation at IDUG North America in Tampa on DB2 Locking, updates, 9.7 Current Committed, and much more. So that Mike can deliver his full talk on this topic, we are extending the duration of The DB2Night Show to 90 minutes. We should have time for questions from the Studio Audience at the end.
Again, this is a first - a 90 minute show: 10am - 11:30am CENTRAL, 11am - 12:30pm EASTERN.
Remember, all past shows were recorded, so you can listen to previous shows that you may have missed. Also coming this month are:
The DB2Night Show Episode #22
Comparing DB2 LUW and Oracle with Burt Vialpando
The DB2Night Show Episode #23
"DB2 LUW Storage Optimization Best Practices"
with guests Berni Schiefer and Robin Grosman, IBM
Thanks again to the amazing Scott Hayes
for arranging these informative talks with talented speakers!
Modified on by svisser1
Here are the latest Flashbooks that were published this year and are available for you to download in PDF format. As always, these books contain extremely valuable information about the direction IBM is taking in a number of areas for key products... and they are free to download. Be sure to get yours and share this information in your network.
Don’t miss the flashbooks we’ve published in previous years:
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
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
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,
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:
- Monday October 22, 9:45 – 10:45 at bookstore
- Tuesday October 23, 9:30 – 10:30 at bookstore
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!
Modified on by svisser1
This is the third book we’ve showcased at an IBM conference authored by Dr. Arvind Sathi!
Engaging Customers Using Big Data: How Marketing Analytics is Transforming Business
At IBM Insights:
If you are at IBM Insights later this month, you can pick up a free copy of this book and have it signed by Arvind on Tuesday October 28 from 2:30pm – 3:30pm in the Solution EXPO in Booth 525. Arvind will also be at the Conference Bookstore on Tuesday October 28 from 4:00pm – 5:00pm. These books are in limited supply, so be sure to schedule this event so you don’t miss it.
About the book:
Big Data is rapidly transforming a number of business functions across many industries. The biggest transformation is in how we market to our customers. This book shows marketers today how to seek small samples from their customers to observe their behavior, predict changes, and act using a series of unconnected business actions. Big Data has changed the game completely—we can connect with customers, record every click on the web, watch every step in the store, and listen to all public conversations. Unlike today's environment, where marketers broadcast across a set of customer segments, we can now personalize our communications to each customer based on their current predisposition to the products being sold.
The book makes three major propositions:
Big Data brings all the data to the table leading to a lot more detailed analysis and discovery. We can get a lot more understanding about consumer behavior.
Automation and Social Media drives a lot more influence on the decisions. We can converse with the customers as they make decisions and influence their decision-making using a series of sophisticated marketing tools.
The market leaders will integrate their resources and investment to optimize across a number of instruments in ways we have never seen before.
These changes have tremendous impact on our marketing processes and capabilities. In the first half of the book, using a series of examples from big data pioneers, such as PF Chang's, Best Buy, Google, and IBM, Sathi describes how each marketing function is undergoing fundamental changes: how personalized advertising is delivered using online channels where the marketers identify the specific customer and tailor their messaging based on customer behavior, context, and intention; how customer behaviors are collected from a variety of sources across many industries and examined to identify micro segments; and how online and physical stores collaborate to provide a unified shopping experience and deliver product information. The second half of the book examines the tools and techniques for marketing science in support of these capabilities including statistical techniques, qualitative reasoning, and real-time pattern detection, to name a few. Based on these changes, the book prescribes the changes needed to update our skill and tools for Marketing Analytics.
You may have read one of Arvind’s previous books, including:
This 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.
e-Version: register here to download your copy.
Book information on blog
Electronic Version (6.98 MB)
Dr. Arvind Sathi is the World Wide Communication Sector Architect for Big Data at IBM®. Dr. Sathi received his Ph.D. in Business Administration from Carnegie Mellon University and worked under Nobel Prize winner Dr. Herbert A. Simon. Dr. Sathi is a seasoned professional with more than 20 years of leadership in Information Management architecture and delivery. His primary focus has been in creating visions and roadmaps for Advanced Analytics at leading IBM clients in Telecommunications, Media & Entertainment, and Energy & Utilities organizations, worldwide. He has conducted a number of workshops on Big Data assessment and roadmap development.
Over the years, DB2 has become more compatible to Oracle, thus making it much
easier for people skilled on Oracle to move to DB2 jobs as well as much easier
for companies to switch their Oracle databases and applications that rely on
With DB2 10 for Linux, UNIX, and Windows, you’ll find the
PL/SQL Compatibility features and other enhancements make it even easier for you
Learn about why and how to switch by joining this latest DB2 Tech Talk that
takes place on May 31:
DB2 Tech Talk: Oracle
Database and SQL/PL Compatibility
Date: Thursday, May 31, 2012
Time: 11:30 – 1:00 pm EDT
Speaker: Serge Rielau, SQL Architect for DB2 for LUW
This webcast will discuss:
- Native PL/SQL support, plus other compatibility features including
concurrency control, PL/SQL package support, Oracle SQL dialect support, OCI,
SQL * Plus Scripts, and Oracle Forms.
- Enhanced support for triggers, new scalar functions, declared types and
procedures within local scope.
- Tooling that IBM has made available to streamline this move process.
- Case studies drawn from elements of the process with actual customers and
shown at the code level.
If you are serious about switching to DB2 from Oracle, here are some other
resources for you to consider:
Last week I blogged about some of the excellent training resources that you can get for free. Today I’ll tell you about some of the deals you can get to bring down the price of a resource to something closer to free:
- DB2University.com – Some of the courses are free, but not all. The idea behind DB2University is to offer you very low cost training opportunities.
- Membership to IDUG is free. If you are a member, you can get 45% off the retail price of any of the IBM Press books. Go to IDUG’s home page and click on the icon on the bottom right corner. This will give you the instructions needed to get your discount. See a previous blog entry for more information on IDUG: IDUG = International DB2 User Group
- If you’re not a member of IDUG and don’t wish to join, you can take advantage of the following offer: New and Best-Selling Information Management Books at 35% off; Enter coupon code INFOMGMT during checkout to receive discount.
- Looking for an ebook? Get 40% off IBM Press titles. See “eBooks from IBM Press “ for details.
- Buy your DB2 Certification Guides directly from MC Press’ Online bookstore to save as much as 54% on a book.
- Best book about how you can improve and thrive in your career: Making it Big in Software. Still 35% off at amazon.com.
- Save $100 and refresh your skills with Assess and Save – Take a sample test and get $100 off the normal price of an exam.
I’ll keep looking for offers to share with you that are free or nearly free… so keep coming back for more information.
This week’s show took place today… and I missed it! I thought I still had an extra day to promote it. So, if you’re like me and missed the show, you can listen to the replays. Here’s what happened in the past week:
Thursday April 21
The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1
Julian Stuhler from Triton Consulting and Rick Sobiesiak of IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. The study examines the major differences between DB2 9.7 and Oracle 11gR2, and assesses the complexity of each. Very impressive results, which I’ll let you discover by reading the study or watching the replay.
Round 1: Installation
Round 2: Data Compression
Round 3: Index Compression
Round 4: Backup & Recovery
If you want to see the complete study, down load the free Whitepaper: Quantitative Complexity Analysis.
Get the commentary and the replay. In the commentary, you’ll find links to several blog entries that were written in conjunction with this study.
Monday April 25
The DB2Night Show #Z01: The history of DB2 for z/OS
The launch of the DB2 for z/OS version of the DB2Night Show hosted by Klaas Brant. The first show featured special guest Roger Miller who spoke of the history of DB2. Klaas mentions in his wrap up of the show that there were many things mentioned that he wasn’t aware of even though he had been using DB2 since V1.2. Also, this show marks the last visit Roger will make on the DB2Night Show as he will retire in a few weeks. Roger, you’ll be missed!!
Get the commentary and the replay.
Thursday April 28
The DB2Night Show #51: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 2
Julian Stuhler and Rick Sobiesiak continued presented findings from their DB2 LUW versus Oracle Usability study. Make sure you make it known as to which of the tasks covered in either show you’d like to see demonstrated on a future DB2Night Show.
Round 5: Memory Tuning
Round 6: Data Access Control
Interesting comments & questions that came up during the show:
- Scott recommended that audience members also check out The DB2Night Show #14: Crunching the Numbers and DB2 STMM.
- Question from the audience whether IBM is making DB2 so easy to put DBAs out of business or to give DBAs a chance to improve their golf game.
- Question from the audience: why is Oracle so popular if DB2 is so great?
- Many questions on STMM.
There were so many questions today, but they will be answered in the Replay Blog.
Get the commentary and the replay.
Next week: IDUG.
And, the week after IDUG:
Monday May 9
The DB2Night Show z/OS Edition #02: DB2 for z/OS Now and into the Future
Jeff Josten will share the latest news with DB2 z/OS V10 and offer his insights into what may be coming next in DB2 z/OS: The Future of DB2
Friday May 13
The DB2Night Show Episode #52 - : DB2 for LUW Best Practices: Writing and Tuning Queries for Optimal Performance
John Hornibrook from the IBM Toronto Lab will spend 90 minutes to give his query optimization talk. John is also back for another show taking place on Friday May 20. Since that is so long from now, check out a previous show with John that was ranked one of the best of the first season: Episode 11. DB2 9.7 Optimizer Updates with special guest John Hornibrook from IBM.
As always, a great learning and entertainment opportunity via the DB2 Night Show. Thanks Scott! Good luck in Nashville on the marathon.
Yesterday was the day that DB2 10 and InfoSphere Warehouse 10 were
made available to purchase. The products were announced on April 2, so I’m sure
you’ve seen some of the buzz surrounding this outstanding accomplishment.
On a personal side, my desk in the office is in the middle of the Release
Team who managed these releases. It has been an exciting and busy time for all
those involved and a huge congratulations go their way for all their hard work!
We had a brief celebration in the lab as well and I learned many interesting
- The development team spanned 8 lab sites.
- There are many lines of code! I’m not sure if I can say how many, but lots!
- There were 4 betas with lots of customers and resulting feedback.
- Many solutions were built into DB2 10.
So the developers are moving on to their next thing, but the Db2 10 work
doesn’t end here! Now those who create courses, exams, books, webinars,
articles, and events are working towards providing you what you need to move to
this product and to use if effectively.
Here’s my blog entry about what’s in the release and what IBM Champions are
saying about it:
As for education, if you are attending IDUG later this month, you’ll have plenty of learning
- DB2 10
for Linux, Unix, Windows - 6 in 60 minutes (SIGs)
Storage & Multi-Temperature Data Management -- Making DB2 Storage Management
Easier With Each New Release - H05
May 16, 2012 (08:30 AM - 09:30
- DB2 10
for LUW: Time Travel and Compression - H01
May 15, 2012 (12:45 PM -
Dive into DB2 10 Query Performance Optimization: Statistics and Optimization
Profiles - H14
May 18, 2012 (09:15 AM - 10:15 AM)
Dive into Multi-Temperature Data Management: Best Practices for Implementing
MDTM - H02
May 15, 2012 (02:00 PM - 03:00 PM)
Dive into Query Performance Optimization: Complex query optimization +
multi-core parallelism - H12
May 17, 2012 (02:45 PM - 03:45 PM)
Dive into Query Performance Optimization: Zigzag Join , Jump Scan - H13
May 18, 2012 (08:00 AM - 09:00 AM)
Dive into Row and Column Access Control: How to Define and Implement Security
Policies - H11
May 17, 2012 (01:30 PM - 02:30 PM)
Dive into Storage Optimization: When and How to use Adaptive Compression -
May 16, 2012 (09:45 AM - 10:45 AM)
Dive into Time Travel Query: Best Practices for Implementing Temporal Tables
while reusing existing applications - H10
May 17, 2012 (09:45 AM - 10:45
Dive into Time Travel Query: First Steps using Temporal Tables - H09
17, 2012 (08:30 AM - 09:30 AM)
Update: Multiple Stand-by (DB2 10 for Linux, Unix, Windows) - H03
15, 2012 (03:15 PM - 04:15 PM)
Ways to Tame your Database with DB2 Workload Management - H15
2012 (10:30 AM - 11:30 AM)
Compatibility Update for DB2 10 for Linux, Unix, Windows - H08
2012 (02:45 PM - 03:45 PM)
Best Practices for Performance and Monitoring - H04
May 15, 2012 (04:30
PM - 05:30 PM)
Data Warehousing Best Practices: Using Ingest Utility - H07
May 16, 2012
(11:00 AM - 11:55 AM)
PLUS, we're launching DB2 10 Flashbook at IDUG: New Flashbook for DB2 10 – Launching
at IDUG Denver
If you aren’t attending IDUG, don’t worry! Here’s what I can suggest for
- After the conference, I’ll have the PDF version of the Flashbook and will
post it on a website for you to download for free. Follow my blog so you won’t
miss the news.
- Webinars. Some have taken place, but there are many more planned. Again,
follow my blog or twitter and I’ll alert you to the events.
- Articles, blogs, best practices, and more books.
Watch the Replay of these webinars:
Schedule to attend these upcoming webinars:
There are many blog entries already posted and many more coming. I highly
- Follow planetdb2.com which
is a blog aggregator for DB2 bloggers. If you have a blog but are not included,
send a request to have your blog added.
- Find twitter mentions by searching on twitter tag #db2ten. Even if
you don’t have a twitter account, you can enter this tag in google and see what
has been posted.
Chris Eaton of IBM created a great video about “why you should consider migrating from
Oracle to DB2”
and I found this article/slideshow on eweek.com: Database: IBM Databases: Top 10
Innovations of the Past 50 Years by Darryl K. Taft
As usual, developerWorks is publishing new content on a daily basis to
support this release. Here are just a few of the items you’ll be able to find:
Bookmark this developerWorks page to see articles as they are published: ibm.com/developerworks/data/
And last but not least, IBM
Data Management Magazine has a whole series of articles and columns planned
to keep you reading. Make sure you check back frequently for new content.
What do you think? What a great amount of content for you to explore … and
DB2 10 was just released YESTERDAY! Keep learning!
Last November I posted blog entry about a survey to help decide the topics
for upcoming DB2 Symposiums: “DB2
Symposiums – Take a Survey to ensure World Class DB2 Education Comes to
You”. As a result of this survey, Klaas Brant has pulled together an
incredible group of speakers who will be teaching full day sessions over a 3-day
Today on the DB2Night Show, Klaas announced a 20% discount
for those who register by March 1. Simply use the promo code
DBI12A1 when you register. The symposium takes place at the DoubleTree
Fort Lee – New Jersey.
For those of you who are new to the DB2 Symposium: the DB2 Symposium is a
three day training event with one day seminars presented by industry leading
consultants. The DB2 Symposium fills the gap between a conference and a
multi-day training. The DB2 Symposium is unique because you can join us
for 1,2 or 3 days, depending on your needs and budget.
The amazing line up of speakers are all IBM Champions (aka IBM’s Best
and the Full Day Sessions:
Wednesday 28 March
Thursday 29 March
Friday 30 March
Great speakers, great learning opportunities, and now a great discount! Register now!
Lots of votes came in over the past two weeks. Our final four contestants, Ember, Mohan, Eric, & Chris
know how to use their networks! It was a very close call for 2nd, 3rd,
& 4th places. A new record was set for the number of votes
received: 1367 Thanks to all who voted!! I hope you enjoy the show
and will come back to replay many of the other informative shows in the
DB2Night Show collection.
Thanks to the sponsors for offering these excellent prizes!
Prize: One FREE IDUG Conference Registration to any IDUG Conference in
2013 (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
2nd Prize: One FREE DB2 Symposium Registration (3 Days) to any Event in 2013 provided by KBCE, plus up to $1,000 USD travel expense allowance provided by HLS Technologies.
3rd Prize: Apple iPad (approximate value $500) provided by Responsive Systems.
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.
And the winners in order are:
Congratulations to each of you. Your contributions to the community are extraordinary
and I hope to see each of you participate in many upcoming events!
Conferences, webinars, books, blogs, articles... and any other way you
can share your knowledge & your talent!
I send the same message to all the contestants who took part in the competition this year as well as the previous two years.
See my blog entry Summary of DB2's Got Talent Competition 2013
that provides links to all the shows from this year’s competition as
well as how you can reach blogs & twitter accounts for those who
like to give special attention to Mohan, our winner. I mentioned on
today’s show that I recently found out that Mohan was the author of a
great book that was recently published. He sent me the information
about his book and many other ways he’s contributed:
Michael Tiefenbacher returns
as our special guest to share his terrific IDUG EMEA Germany
presentation on "Explain Reality!" If you want to learn about DB2 LUW
Explains, don't miss this show!
DB2 V10 Hint functions for Dynamic SQL
shows how to use SPUFI to explore the Hint setting facilities for
Dynamic SQL in DB2 V10. If you had ever wanted to use hints with dynamic
SQL, be sure to attend this show!
ATTACK of the BLOB!
Sr. DBA, makes his debut on The DB2Night Show by sharing his horror
story with DB2 BLOB performance and how he conquered the monster!
Database Performance Trends!
Forrester analyst Noel Yuhanna
will share with us his perspectives on database performance trends.
Join us to hear his views on performance management challenges, server
consolidations, cost optimization, databases in the cloud, and what he
calls "the newer workload". Take away analyst insight, tips, and
valuable, actionable advice.
Agile Big Data Analytics: Implementing a 22 billion row data warehouse
discusses the design, architecture, meta-data, performance and other
experiences building a big data and analytics DW system. If you need to
build a big data warehouse, be sure to attend this show!
Breaking News from IBM on DB2 LUW!
Special guest George Baklarz, IBM, will share with us the latest news on IBM DB2 for LUW.
14 JUN 201
Extreme Tuning SQL and Performance
Sheryl M. Larsen
covers multiple versions of DB2 and covers the following areas and you
will leave the presentation confident in identifying efficient queries
for DB2 10 & 11!
DB2 LUW 10 Index Jump Scans and Index Design Best Practices
Show host Scott Hayes
wears two hats and doubles as our show guest. Learn about DB2 LUW 10
Index Jump Scans and find out the Updated Rules for Index Design Best
Practices, including DB2 compression results.
DB2 LUW Customer Success Story
DB2's GOT TALENT 2012 1st Place winner "Kohli"
joins us to share his experiences with implementing and tuning a new
DB2 LUW application at his company. His advice is priceless!
Get all previous DB2Night Show episodes in replay: approaching 260,000 downloads.
Summary of DB2's Got Talent Competition 2013
DB2 NightShow - The Grand Finale 2013
Scott’s summary of Episode 7
DB2 NightShow: Episode 6 of the DB2's Got Talent Competition
Scott’s summary of Episode 6
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
IBM's Information on Demand (IOD) Conference took place in Rome: May 19-21.
My purpose at the conference was to sell books to attendees, but I wasn't able to arrange for a bookseller to set up shop. I'm not able to sell books myself so I promoted both electronic books and buying books directly from the publisher.
Safari Books Online joined me as they provide one of the available options for electronic books. Erin and Martin from Safari were giving demonstrations of their system to attendees. We gave out bookmarks that promoted a free trial subscription for people to try Safari. The URL is: http://safaribooksonline.com/requesttrial/ (Feel free to give it a try!) IBM has a corporate license to Books 24x7 which provides a similar service, but there are fewer technical books than are available via Safari Books Online.
I brought my Kindle to the conference to show people technical content on this device. I don't think that it is the best option for technical books. I've downloaded all the readers and find the PC eReaders to be very good. I suspect that iPads will be suitable, but have not been able to use one yet.
The publishers who I work with sent me a sample copy of each book I requested. I likely had 50 books in total. These were merely for display so the attendees could browse through the books and to see the range of titles that were available. There was much interest. If someone wanted to purchase a book, I gave them information on how they could get a discounted printed version by ordering directly from the publisher. Pearson set up a site for EMEA to purchase books at a 35% discount, local currency, free shipping and duty: http://www.pearsoned.co.uk/bookshop/ibmpressbookshop
Magnus Lindkvist, keynote speaker and facilitator
Author of Book: Everything We Know Is Wrong – The Trendspotter’s Handbook
Magnus brought copies of his book to the conference and sold nearly 100 copies for cash.
Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, and Michael Schroeck
Authors of Book: The Art of Enterprise Information Architecture
IBM purchased 300 copies of this book to be given to qualified attendees. Attendees needed to attend a session hosted by one of the authors or to visit the InfoSphere Demo Room. The event was very successful and all the books were claimed in about an hour.
I arranged to have a number of the previously published flashbooks available to hand out. These included:
New Intelligence for a Smarter Planet – Driving Business Innovation with IBM Analytic Solutions
Break free with DB2 9.7: A Tour of Cost-Slashing New Features
Information on Demand for Dummies, 2nd edition
SAP DBA Cockpit - Flight Plans for DB2 LUW Administrator
I had about 50 copies of each title and they were very well received. Some of the books were moved to the Education Zone to attract / reward people who visited.
I was able to meet with many authors and potential authors! This networking has resulted in more books in the pipeline. I'll have more information on the titles in the future.
James Lumsden from Packt Publishing flew into Rome to meet me in person and attended the Thursday night networking session that was part of the conference. I was able to introduce James to 25 authors or potential authors. During these conversations we discussed potential topics that would be good for the future.
I met an IBM university ambassador for Spain and will work with him to find more ambassadors in Europe so I can further promote some of our books.
Since this was the first time showcasing books at a conference rather than selling them, I learned a few things that I'd like to improve for future events:
Since I had books from 5 or 6 different publishers, it was difficult for me to give one URL for people to go to for our books. Our bookstore website needs to be redesigned and updated to include all the relevant books in both electronic and printed format.
I need a piece of collateral that can highlight the messages we can give to the customer about the book strategy. This can be a flyer, postcard, or bookmark.