During this week’s #bigdatamgmt TweetChat that was focused on Getting Control of Data in Big Data Era",
I noticed that many of the experts recommended articles to emphasize
their points. I’ve gathered all of these recommendations to create this
reading list. I hope you find this valuable.
You must increase control of wasteful data even with Big Data
Management, archive/retire & dispose. Big Data doesn’t change
retention. Keep the data you need, get rid of the rest . You can’t
afford to keep it all. Big
Data is not immune to the laws of information economics. You must
increase control of wasteful data even w Big Datamgmt, archive/retire
& dispose. Infosphere Optim helps you get control of structured
data to feed only the good into Big Datamgmt.
PPB13 How do practitioners overcome emerging skepticism in the marketplace?
Without good data stewardship & Big Datamgmt it will difficult to
unlock the value of big data. To deal with Big Data, speed, and volume:
be proactive by starting Big Data Management across the enterprise
now & maintain. Start now on data quality because if you don’t have it in now Big Data only magnifies data issues.
For more Big Datamgmt resources Data Privacy and Security. Exploring
Big Data still requires trusted data so you must secure and govern even
Big Data refers to datasets whose size, type and speed of creation make
it impractical to process and analyze with traditional tools. That Big
Data definition comes from wikibon; see Big Data Vendor Revenue and Market Forecast 2012-2017. So given that, definitionally then, traditional concepts are at the very least “impractical”… no?
BTRG_MikeMartin You can’t make good business decisions on bad data.
Data governance is critical in the Big Data management era as it makes
small problems bigger. You need data quality to enable Biginsights
searchCIO Metadata practices are gaining momentum as companies tackle Big Data.
searchCIO Data Quality is essential to master Big Data Management
dvellante Perspectives from a former CIO on the importance of data quality
furrier Dirty data equals poor user experience. I wrote about it in 2009 re: twitter facebook & social data
craigmullins Consider non-intrusive data governance; see this article by my friend Bob Seiner
great resources! For our next tweetchat, we’d like to build a reading
list that is sent out prior to the chat. Wednesday, March 15: Topic: Mobile Challenges for the Enterprise. Stay tuned for more information about this event.
To find out more about managing big data, join IBM for a free event on April 30: Big Data at the Speed of Business
What are you sacrificing for the promise of big data?
Recap of Tweetchat: "Getting Control of Data in Big Data Era"
Part 2: Recap of Tweetchat: "Getting Control of Data in Big Data Era"
What is a Tweetchat and why should you join us?
Big Data & Database Technology
The Warehouse team has been busy creating yet another best practice paper.
Best practices: Using High Performance Unload (HPU) as part of a Recovery strategy
IBM InfoSphere Optim High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows V4.2 is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. HPU unloads large volumes of data quickly by reading directly from full, incremental, and delta backup images or table space containers rather than through the DB2 software layer.
The database is not affected by the HPU process and table spaces do not need to be placed in an offline state. HPU can therefore offer advantages over other recovery methods in data availability and processing speed. Incorporating HPU into your recovery strategy for scenarios involving data loss or corruption can help achieve service level objectives for data availability and data recovery.
Incorporate InfoSphere Optim HPU into your recovery strategy to provide:
- Reduced recovery times through targeted data recovery
Use the WHERE clause when selecting data from backup images to target only the data that was lost, compromised, or corrupted, reducing recovery time.
- Increased data availability and reduced resource usage during recovery scenarios
Unload data from a backup image and optionally process this data on a non-production system, maintaining availability of the query workload and reducing the effect on the production system.
- Integration with DB2® and Tivoli® Storage Manager (TSM) software
Query TSM to unload data from full, incremental, and delta backup images archived to TSM by the DB2 BACKUP command, reducing errors and facilitating outside recovery.
This article discusses how to incorporate HPU into a recovery strategy and when to use HPU to meet your recovery objectives. In addition the authors contrast the use of output files and named pipes, discuss introducing parallelism, review the HPU command and control file, and recommend best practices for creating control files. Finally, the article details how to install and configure HPU in an IBM Smart Analytics System.
This paper will be followed in the new year with a second paper on HPU that deals with data migration.
Thanks to the hard working team that includes: Garrett Fitzsimons, Konrad Emanowicz from the VLDB team who created and tested all the scenarios discussed in the paper and to Richard Lubell from the DB LUW ID team who steered the paper through to publication. Thanks also to Alice Ma, Austin Clifford, Bill Minor, Dale McInnis, Jaime Botella Ordinas, and Vincent Arrat whose contributions, feedback and experience were invaluable.
Thanks to Garrett and Serge for providing me with this information.
See also my previous posts on Best Practices:
More on DB2 for z/OS Best Practices
Best Practices: Active Data Warehouse Topology using InfoSphere Warehouse
New DB2 WLM Best Practice Paper
Best Practices: IBM Smart Analytics Systems
How do I handle multi-temperature data in my warehouse?
Updated Best Practices Paper: Database Storage
Best Practice Resources for DB2 z/OS
DB2 Best Practices – New or Updated in 2011
At this time there are 82 Web-Based Training (WBT) Courses available for you to take to sharpen your skills on IBM Information Management (IM) products and technologies. Eighty-two is a LOT of courses! More are being created and being updated, so if this is the way you like to learn, make sure you stay in touch with all the latest as they are released.
IBM’s Education is known for its high quality content and excellent instructors. Although with WBT courses you won’t be in a classroom environment, you’ll get the same quality of content that you expect. WBT courses allow you to learn at your own pace and on your schedule with training that is completely self-contained from your desktop. Most courses provide introductory and overview training that serves as the foundation for more technical and follow-on training. Courses include expert instruction but do not include hands-on labs.
How do you get there?
Access this site to see all course offering types: http://www.ibm.com/software/data/education/elearning.html. Under the Web Based section, click on "Browse the complete Information Management WBT portfolio". I’ve included the 82 courses that I know of right now and have put the newest ones at the top of the list. If you’re an IBM employee, contact me offline as there is a different procedure that must be used to take these classes.
Using IBM Optim Designer and Optim Manager - Web Based – New
Connect Information Server to SAP R/3 ECC (DataStage Pack for SAP) – New
DataStage Essentials - Web Based – Updated
IBM InfoSphere Information Server Metadata in Practice – New
InfoSphere BigInsights Essentials (Web) – New
InfoSphere MDM Server Workbench for MDM Server 9 - Web Based – Updated Programming for InfoSphere Streams V2 - Web Based - New
5 Ways to Apply Data Quality with Information Analyzer WBT
A Blueprint for Implementing MDM Server Using V8.5 - Web Based Training
Advanced DataStage - Web-Based
Advanced DB2 SAP for Administrators - Web-Based
Advanced Programming InfoSphere Streams - Web Based
Basic Programming for InfoSphere Streams - Web Based
Business Glossary Essentials - Web Based
Changing Business with Data Insight (Web Based)
Configure ODBC for IBM DataStage on UNIX - Web Based Training
DB2 9 for z/OS Database Administration Workshop Part 1 (Web Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9.1 (Web-Based)
DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (Web-Based)
DB2 9.7 for Linux, UNIX, and Windows New Features (Web-Based)
DB2 Everyplace V9 Tutorial – Online
DB2 Express V9 - Developer in a Day Workshop – Online
DB2 Family Fundamentals - Web-Based
DB2 for LUW 9.5 Fundamentals – Online
DB2 for LUW pureXML
DB2 LUW Advanced Topics – Online
Exploring IBM solidDB Universal Cache - Web-Based
Exploring Initiate Workbench V8.x - Web Based
Exploring Initiate Workbench V9.x - Web Based
FastTrack Essentials - Web Based
Federation Server Essentials - Web Based
How to Analyze Data (Using InfoSphere Information Analyzer) - Web Based Training
How to Install IBM DataStage on UNIX - Web Based Training
How to Install IBM QualityStage on UNIX - Web Based Training
How to Install Information Server 8.5 - Basic and Advanced Option
IBM Data Studio Basics - Web Based
IBM InfoSphere Change Data Capture Essentials V6.3 - Web Based
Implementing IBM InfoSphere MDM Server for PIM V9 (Web Based)
Information Analysis - Web Based
Informix 11 New Features (Web Based Training)
Informix Version 10 – Online
InfoSphere Information Server Administration - Web Based
InfoSphere Master Data Management Server Overview (MDM Server) - Web Based Training
InfoSphere MDM Server Architecture – WBT
InfoSphere MDM Server Domains for MDM Server 9 - Web Based
InfoSphere MDM Server User Interface Generator - Web Based
InfoSphere Warehouse 9 - Cubing Services - Web Based Training
InfoSphere Warehouse 9 - Data Mining and Unstructured Text Analysis – WBT
InfoSphere Warehouse 9 - SQL Warehousing Tool and Admin Console – WBT
InfoSphere Warehouse 9 Components - Web Based
Initiate Self-Paced Bundle V8.x - Web Based
Initiate Self-Paced Bundle V9.x - Web Based
Install, Configure, and Use DataStage SOA Edition (RTI) - Web Based Training
Installing and Configuring IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM InfoSphere Information Analyzer - Web Based Training
Introduction to IBM Optim Data Privacy Solution - Web-Based
Introduction to IBM QualityStage - Web Based Training
Introduction to InfoSphere Change Data Capture How to Use CDC WBT
Introduction to InfoSphere DataStage Using Version 8 - Web Based Training
Introduction to InfoSphere QualityStage Using Version 8 - Web Based Training
Introduction to Initiate Master Data Service - Web Based
Introduction to New Features in Informix Version 11 – Online
Introduction to TSA in IBM Smart Analytics Systems - Web Based
Managing Workloads for DB2 LUW and InfoSphere Warehouse - Web Based
Metadata Workbench Essentials - Web Based
Overview of (IISD) InfoSphere Information Services Director - Web Based Training
Overview of IBM DataStage Enterprise Edition for ETL Developers - Web Based Training
Overview of IBM Information Server and DataStage QualityStage Version 8.0 - Web Based Training
Production Automation of IBM DataStage- Web Based Training
Programming for InfoSphere Streams - Web Based
Programming with IBM InfoSphere MDM Server for PIM V9 (Web Based)
QualityStage Advanced Concepts - Web Based
QualityStage V8 Essentials - Web Based
SQL Replication: Advanced Topics (Web Based)
Troubleshooting IBM InfoSphere Information Analyzer - Web Based Training
Using InfoSphere MDM Server for PIM V9 (Web Based)
Using Initiate Inspector V8.x - Web Based
Using Initiate Inspector V9.x - Web Based
Using Queue Replication - Web Based
Using SQL Replication (Web Based)
Validating Data with Rules in Information Analyzer 8.1.1 - Web Based Training
XML and DataStage: Convert Relational and XML Data - Web Based Training
I hope you’ve found one or two in this massive list that interest you! Take the course and let me know what you thought of it.
As you’ve noticed, I’m promoting the upcoming IBM Information on Demand Conference via my blog. Many Europeans are unable to afford the time or money to go all the way to Las Vegas for a conference, so the good news is there is an amazing conference planned for Prague in November. I’m hoping that I can attend in order to set up a bookstore for attendees.
IDUG DB2 Tech Conference in Prague, Czech Republic, 13-18 November 2011, at the Clarion Congress Hotel Prague
- Register on or before 17 October 2011 and receive a discount of EUR 275.
- Multiple Delegate Discount: For every three individuals who register from the same organization, a fourth may attend at the discounted rate of EUR 730.
- Mentor Program: If you have attended three previous IDUG DB2 Conferences, you are eligible to bring a first-time colleague to Prague for an 80% discount off the full registration fee.
How you can hone your expert DB2 skills at IDUG EMEA
- Members of IDUG get 45% off IBM Press books. New books include Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture, The New Era of Enterprise Business Intelligence: Using Analytics to Achieve a Global Competitive Advantage, and The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight.
- On 13 November, receive FREE IBM certification training, DB2 migration workshops and sessions for CA customers.
- IBM Certified Database Administrator - DB2 10 DBA for z/OS certification Preparation Seminar - Susan Lawson
- DB2 UDB V9.7 for LUW Advanced Database Administration certification Preparation Seminar - Guy Przytula
- One-Day Educational Seminars - Friday, 18 November 2011
Registration for paid full conference delegates is EUR 450; the cost for just the one-day seminar is EUR 495. Select from the following session topics:
- DB2 10 for z/OS - In Depth, Phil Grainger, Cogito
- DB2 Intermediate and Advanced SQL, Daniel Luksetich, Yevich Lawson & Assoc Inc.
- I Didn't Know DB2 did THAT!, Bonnie Baker, Bonnie Baker Corporation
- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace, John Campbell, IBM Corporation
- Rocket Science: DB2 for LUW Performance Analysis and Tuning Workshop, Scott Hayes, DBI
- Some of the top rated speakers:
For the complete agenda and speaker list, see this site: http://www.idug.org/p/cm/ld/fid=102
Modified on by svisser1
Congratulations to Jacques Roy for the completion of his latest book:
The Power of Now
Real-Time Analytics and IBM InfoSphere Streams
This book will launch at the IBM Insight conference in Las Vegas. You can get a free book and have it signed by Jacques if you are an attendee of the conference. Jacques will be signing the books at the IBM Insight Conference Bookstore on Tuesday October 28 from 9:30 – 10:30 am. There are only a limited number of copies at the conference, so if this is a book you want, you should make sure you put the day and time in your schedule.
What’s the book about? It is about the really great product from IBM called InfoSphere Streams. I attended a few tweetchats in the past year and was happy to see the number of people who mentioned this product and the value it brings to them as they analyze data-in-motion. InfoSphere Streams is the world’s fastest and most flexible platform for streaming data. Sounds interesting, doesn’t it!
I was asked to help write the content for the covers of this book and read several chapters of the book and I find the topic quite interesting. Here is what we put on the cover of the book:
Read this book to:
Understand how the integration of multiple technologies form a big data architecture that can process data, both at rest and in motion
Learn how real-time distributed analytics can provide insights to create a business advantage and currently unseen opportunities
Discover the ways to implement a data-in-motion solution that works for your environment
Explore the characteristics that make a good real-time distributed analytics platform
Learn understand how to apply InfoSphere Streams technology to your business problems to get solutions faster
IBM InfoSphere Streams provides a new approach to processing information by providing an easy-to-program platform for distributed real-time analytics that can answer the need to generate information from the huge amount of data that comes at businesses rapidly.
In “The Power of Now: Real-Time Analytics and IBM InfoSphere Streams”, discover how distributed real-time analytics can uncover opportunities in your enterprise providing more efficiency and a business advantage. Technology is changing rapidly, and there is so much of it to learn. This book gives you a shortcut to becoming proficient with InfoSphere Streams so that you can dive into implementing a solution for your enterprise.
About the author:
If you’re not going to be at the conference, you’ll still have a chance to get a copy of the book, but in electronic format. I’ll write a new blog entry when the PDF version is available so you can download your free copy.
Flashbooks can be downloaded in PDF format for free. Here are the Flashbooks that were featured at events in 2013:
just got easier with an exciting new initiative for mobile learning.
Be one of the first to participate and provide your feedback!
To learn more about the devices that are supported and how to start, see the Mobile Learning Pilot.
There are two new courses designed to be served up on your mobile device. The total end to end running of each course is a few hours but since they are modular in nature, you can run them in sections to better fit into your busy schedule.
The courses that are available for this pilot are FREE and include:
Easy Steps to Developing BigSheets Function Plugins:
uses the familiar spreadsheet interface to do text analytics of
unstructured and semi-structured data. Coupled with this are a large
number of supplied functions to simplify the analytics process. However,
you may find the need to extend BigSheets and add your own functions.
This tutorial walks you through the development and installation process
required to add a new function to BigSheets.
Configuring an InfoSphere CDC to InfoSphere DataStage Subscription:
Change Data Capture is a tool that captures changes from source
databases and replicates those changes in real-time to target systems.
This tutorial walks you through how to use Change Data Capture to setup
replication from a source DB2 database to a DataStage job.
the end of each course, you will be asked to complete a confidential,
brief survey. Your feedback is a critical step helping us understand
how to provide the best learning experiences for you. Please provide
your feedback by March 31, 2013.
To take part in the pilot, go to The IBM Learning Portal.
Note: the date when we need feedback has changed to March 31, 2013.
a treasure chest full of great content from experts. Articles,
tutorials, best practices, downloads, spotlights, podcasts, videos... so
much is available to help you deepen your skills... all for FREE. 2012
was a busy year and I’m pleased to tell you the top 10 articles that
were published. Were you one of the readers who helped make these
articles to the top? Check it out. Read the ones you missed. Share
the ones you liked.
- Comparing the Informix Version 11 Editions by Carlton Doe
about the various editions of IBM® Informix®? In this article, get an
introduction to each edition, then you can compare features, benefits,
and licensing considerations in a side-by-side table. Regardless of
which edition you choose, Informix brings you legendary ease of use,
reliability, stability, and access to extensibility features.
- Run Oracle applications on DB2 10 for Linux, UNIX, and Windows by Serge Rielau
DB2® 10 for Linux®, UNIX®, and Windows® has out-of-the-box support for
Oracle's SQL and PL/SQL dialects. This allows many applications written
against Oracle to execute against DB2 virtually unchanged. In this
article, get a high-level overview of what Oracle compatibility means in
DB2. Whether you want to switch your custom application to DB2 or
extend your DBMS vendor support to DB2, now is your time. [2012 15 May: This article has been updated to include new resources.]
- Hadoop Tutorial: Hello World with Java, Pig, Hive, Flume, Fuse, Oozie, and Sqoop with Informix, DB2, and MySQL by Martin Lurie
article is focused on explaining Big Data and then providing simple
worked examples in Hadoop, the major open-source player in the Big Data
space. You'll be happy to hear that Hadoop is NOT a replacement for
Informix® or DB2®, but in fact plays nicely with the existing
infrastructure. There are multiple components in the Hadoop family and
this article will drill down to specific code samples that show the
capabilities. No Elephants will stampede if you try these examples on
your own PC.
- Migrating from the DB2 Control Center to IBM Data Studio by Antonio Maranhao, Kevin Jiang
the IBM® DB2® Control Center tools have been deprecated in DB2 9.7,
users have been encouraged to adopt IBM Data Studio and IBM InfoSphere®
Optim™ tools for managing DB2 databases. IBM Data Studio 3.1 was
released in October 2011 with several enhancements over previous
versions, making it an excellent replacement for Control Center. This
article aims to help DB2 users who are familiar with Control Center
tools to quickly transition to IBM Data Studio.
- Designing a database for multi-tenancy on the cloud by Raul Chong
some considerations that new software as a service (SaaS) vendors need
to take into account when developing applications or modifying existing
ones to enable them for multi-tenancy on the cloud. The article
discusses the considerations only from a database perspective —
specifically, from an IBM® DB2® perspective. Six cases or methods are
- Physical database design for OLTP environments by Amyris Rada and others
article focuses on physical database attributes that are affected by
the specifics of DB2 database servers in online transaction processing
- IBM federated database technology by Eileen Lin, Laura Haas
a large modern enterprise, information is almost inevitably distributed
among several database management systems. Despite considerable
attention from the research community, relatively few commercial systems
have attempted to address this issue. This article describes the
technology that enables clients of IBM's federated database engine to
access and integrate the data and specialized computational capabilities
of a wide range of relational and nonrelational data sources.
- A flexible data integration architecture using InfoSphere DataStage and InfoSphere Federation Server by Wendy Tam and others
InfoSphere® DataStage® and InfoSphere Federation Server to provide an
efficient and flexible architecture for moving and transforming data.
This article promotes the use of InfoSphere Federation Server as a "data
pre-processor" for InfoSphere DataStage, and demonstrates situations in
which the combination reduces both the elapsed runtime (by as much as
91 percent) and overall resource consumption of the job. The article
does not promote the combination of InfoSphere Federation Server and
InfoSphere DataStage for all data consolidation scenarios, rather it
attempts to characterize the situations in which the combination is most
- Starting your education in big data: free courses with hands-on labs you can run on the cloud by Raul Chong
about current free, online courses that are available at
BigDataUniversity.com. Follow the suggested path to get started and grow
your knowledge on big data, and get ready to implement it to meet your
own business needs.
- Analyzing social media and structured data with InfoSphere BigInsights by Cynthia Saracco, Anshul Dawra
you want to work with "big data" without writing code or scripts,
you'll want to look into BigSheets. BigSheets is a spreadsheet-style
tool for business analysts provided with IBM® InfoSphere® BigInsights, a
platform based on the open source Apache Hadoop project. This article
teaches you the basics of using BigSheets to analyze social media and
structured data collected through sample applications provided with
BigInsights. You'll learn how to model this data in BigSheets,
manipulate this data using built-in macros and functions, create charts
to visualize your work, and export the results of your analysis in one
of several popular output formats.Congratulations
to all these authors for a job very well done! I hope you plan to
write more this year because we’d like more great content from you!Susan
One of the IBM Redbooks that will be featured at the IBM Information on Demand Conference this year is:
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition, SG24-8031-00
by Jon Lind, Pat Bates, Whei-Jen Chen, Timothy Donovan, Garrett Fitzsimons, Rogerio Silva
you’re attending the conference, you have the chance to pick up a
printed copy of this IBM Redbook and to have it signed by two of the
authors: Jon Lind and Pat Bates. There are only a limited number of
printed copies to hand out, so you must ensure that you are at the IOD
Bookstore at the scheduled time to get your copy.
The date and time scheduled for this book is Tuesday, October 23, 12:00 - 1:00 pm.
If aren’t able to get a printed copy, you can download your free copy in PDF or EPUB versions.
If this is your area of interest, I’d like to recommend a few other books for you to consider as well:
Sessions by Jon and Pat:
2873A Pervasive Business Analytics: Enabling Faster, More Accurate Business Decisions; Wed, Oct 24, 2012; 2:30 PM - 3:30 PM - South Pacific D
3033A End-to-End Data Warehouse Modeling for Performance and Data Governance; Thu, Oct 25, 2012; 10:00 AM - 11:00 AM - South Pacific D
are many sessions being offered in this area, so be sure to check
through SmartSite thoroughly to ensure you don’t miss an important
DB2 10 Redbook, "Unleashing DB2 10 for Linux, UNIX, and Windows”
Free printed IBM Redbooks at IOD
Check out the guest blog entries that are coming fast & furious on the Official IOD Blog:
Stay tuned for more guest blogs from IBM’s Best Friends: IBM Champions. Susan
- Dave Beulke has a trio of great new posts on his blog:
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
Customizing and Extending IBM Content Navigator
Wednesday, October 24, 12:00 – 1:00 at the IOD bookstore
Thursday, October 25, 12:00 – 1:00 at the IOD
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.
Tech Talk Details:
Best Practices in DB2 for Linux, Unix and Windows Application
Thursday August 30, 12:30 PM ET
Speakers: Holly Hayes and Cliff Leung
Join host Serge Rielau with guests Holly Hayes and Cliff
Leung for a deep dive into IBM InfoSphere Optim
solutions that offer the state of art performance monitoring
and optimization technology for DB2 for LUW.
Rigorous performance monitoring and management are crucial for business
critical applications. Even with premier in-engine query optimization,
application performance for DB2 is dependent on factors like available
resources, good database design and data access best practices.
Using these performance management solutions for DB2, Holly and Cliff will
show you how to:
- identify emergent performance related problems
- diagnose where the problem resides
- resolve issues in the application or database design
- proactively prevent performance problems from re-occurring.
The featured offerings include:
- IBM InfoSphere Optim Performance Manager
- InfoSphere Optim Query Workload Tuner
- InfoSphere Optim Configuration Manager
- InfoSphere Optim pureQuery Runtime
which are also part of DB2 Advanced Enterprise Edition and
InfoSphere Warehouse Advanced Enterprise Edition.
Have you missed any of the previous TechTalks? No worries, they were
recorded and are available whenever you are:
PS: Thanks Serge Rielau and Cindy Russell
for your dedication to this program.
I hope you’re taking part in some of the learning opportunities available now
that DB2 10 & InfoSphere Warehouse 10 have released. Check out my blog from
yesterday about all kinds of options: April 30, 2012: GA of Version 10 products: DB2 for LUW and
Today I want to expand on a couple of webinars that I mention in that post.
First off, the DB2 Night Show. Last Friday, May 4, host
Scott Hayes invited IBMers Danny Arnold and Glen Sheffeld
to talk about the latest release: DB2 LUW
10.1! STOGROUPS, WLM, RCAC, and More. If you missed it, be sure to watch
the replay. Replays available in WMV and M4V formats.
There is so much to talk about that this was just part 1, and was a deep dive
into What's New in DB2 LUW V10. Storage Groups, Workload Manager
Enhancements, and Row and Column Access Controls were covered, and many example
SQL commands were shared to illustrate the concepts.
According to Scott’s website, 100% of the audience learned something
new! “Danny and Glen were terrific guests. I appreciated all of the SQL and
command examples that they shared while discussing STOGROUPS, WLM Enhancements,
and RCAC. Their presentations offered significant technical depth - this wasn't
just a DB2 10 marketing pitch. I am delighted that 100% of our studio audience
indicated that they learned something.”
Register now for Part 2: Episode #81 will discuss DB2 10 compression
enhancements, HADR, time travel queries, index jump scans, zigzag joins, and
more. Special guests from IBM share breaking news about vNext. Part 2 of 2.
This will be a 90 minute show. Yes, there is A LOT to talk about.
Secondly, The DB2 Tech Talk Series, hosted by Serge
Rielau. The next show, DB2
Tech Talk: Optimizing Storage Utilization for DB2 10 , takes place May 11, 12:30 EST to 2PM
Learn about the new storage optimization features in the newly available DB2
We will cover three areas including:
- Adaptive Compression which allows you to reach higher compression
ratios with DB2 10 than ever before.
- Multi-Temperature Data Management which configures your database so
that your most frequently accessed data resides on fastest storage
- Workload Management, which provides the ability to treat work
differently based on the data touched.
This technical tour is the second DB2 Tech Talk on the DB2
10 and InfoSphere Warehouse 10 product releases.
Additional webcasts will be
offered throughout 2012 to provide an in-depth discussion on the features in
The first of the series was DB2 Tech Talk: Technical Tour of New DB2 10 and InfoSphere Warehouse 10,
which took place April 26. Watch the replay. Serge Rielau, Conor O’Mahony, and
Cindy Fung took you on a tour of DB2 10 & InfoSphere Warehouse 10.
Mark your calendar for the 3rd in the series, DB2 Tech Talk: Oracle Database and
SQL/PL Compatibility, which takes place on May 31.
See also my other blog entries about DB2 10 and InfoSphere Warehouse 10:
New Flashbook for DB2 10 – Launching at IDUG
DB2 10 – From IBM Champion’s Perspective
DB2’s Next Major Release
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!
IBM Press Earth Day Sale
Save 50% on eBooks with Coupon EDIBM
You don't necessarily need paper products to learn—step into electronic
learning with digital products from IBMPressbooks.com. From eBooks to
online-only content, we have a wide range of environmentally-friendly options
that provide the answers you are looking for, without the paper. And now you can
save when you stock up—buy any 2 eligible eBooks, and save 50% with coupon
EDIBM. Offer valid through 04/24/2012. Start
Need some suggestions? Here’s what I’d recommend: