There are two DB2 Symposiums coming up in March. Book before Feb 17 to qualify for a 10% Early Bird discount.
DB2 Symposium is a three day training event with one day seminars
presented by IBM Champions & industry leading consultants like
Bonnie Baker, Susan Lawson, Craig Mullins, Dan Luksetich, Cristian
Molaro and Klaas Brant.
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 two locations in March 2013 are:
- March 13-15 - Dallas / Arlington, TX
- March 18-20 - Boston / Marlborough, MA
More about the world-class speakers:
Thousands of programmers and DBAs have enjoyed Bonnie's clear and entertaining style of teaching. This year Bonnie talks about:
- Things I Wish I'd Never Told You
- Matching Indexes to SQL
Susan is well known for her DB2 books and comprehensive certification sessions. Her seminars always receive excellent ratings! Susan's topics are:
- DB2 10 for z/OS Transition: Performance, Usage and Availability
- DB2 z/OS High Performance Design and Tuning: Classic Techniques and DB2 10 Considerations
Craig is the author of the DB2 Developer's Guide.
His latest edition contains more than 1500 pages of in-depth technical
information on DB2 for z/OS updated through DB2 Version 10 in 2012 (6th
edition). He presents:
- DB2 Developer's Guide Comes Alive! (only in Boston)
Dan is the co-author of many DB2 books
and hosts a podcast called the “The DB2 Cocktail Hour”. His new
advanced SQL class has the latest DB2 10 enhancements and focusses on
- DB2 Advanced SQL and Performance
a co-author of more than five redbooks Cristian can be called an
authority on DB2 for z/OS, always praised for his in-depth knowledge. He
- Understanding and fixing common DB2 for z/OS performance problems
- Distributed access to DB2 for z/OS in 2012
has been organizing the DB2 Symposium since 1999. Klaas is known for
his practical approach and useful tips. This time his sessions are all
- DB2 for z/OS XML In-depth (only in Dallas)
- DBA Update
Location for Dallas DB2 Symposium March 13-15, 2013
2401 East Lamar Boulevard, Arlington, TX 76006-7503
hotel is located between Dallas and Fort Worth. The hotel offers free
parking, a free shuttle to DFW Airport and is conveniently accessible
for all companies in the greater Dallas area.
Location for Boston DB2 Symposium March 18-20, 2013
123 Boston Post Road West, Marlborough, MA 01752
hotel is located in Marlborough, just outside Boston. The hotel offers
free parking and is conveniently accessible via highway 90 and 495.
I hope you can attend one or more of these very valuable learning events.
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.
The IDUG DB2 Tech Conference in Orlando
is a MUST attend event for database experts and those aspiring to be an
expert! And this year is special beyond special! Why? DB2 is 30
years old and IDUG is 25 years old. Come and celebrate these amazing
accomplishments while you’re learning.
There are many things to learn about... here are a few for you to consider:
1. Robust Technical Session Schedule
are designed to fit your needs. You will have no problem filling your
agenda with the right education for your job role and organization's
2. Celebrations for IDUG's 25th Anniversary
mentioned above, IDUG is 25 this year! Join us to look back at where we
have come from and see where IDUG is headed in the future.
3. IBM DB2's 30th Anniversary
DB2 will also celebrate a significant milestone in 2013. Stay tuned for
more information about celebrations for IBM DB2's 30th anniversary.
4. One Day Seminars
The perfect opportunity to learn more about specific aspects of DB2 that you deal with on a day-to-day basis.
5. Certification Exams
advantage of this opportunity to gain IBM professional certifications
at no additional cost. All IDUG DB2 Tech Conference attendees are
eligible to take two complimentary certification exams.
6. Save on Registration, Be an IDUG Mentor
offers an incomparable loyalty reward program for those who have
attended three or more IDUG conferences, are an IBM Champion or are a
member of a Regional User Group.
7. Complimentary Wi-Fi
Throughout the meeting space and in each hotel guest room at the Caribe Royale All-Suite Hotel and Convention Center.
8. Easy-to-Navigate Meeting Space
The Caribe Royale All-Suite Hotel and Convention Center is compact and easy to navigate.
in Orlando, gain access to old and Stay Connected new connections.
Trade business cards with industry leading vendors, your DB2 peers and
speakers at the Exhibit Hall and networking events sponsored by some of
IDUG's top vendors
10. Hot Industry Topics
Hear from experts regarding their opinions on important topics. Key sessions include:
Explaining Tuning Results to the C-level
Thomas Baumann, Swiss Mobiliar:
DB2 10 LUW Securely Hiding Behind the Mask
Rebecca Bond, SAP DBA Contractor
The 10 Commandments of Supporting E-commerce Databases
Ember Crooks, Rosetta
The Top Ten Things You Need to Know: For DBAs, Developers and Managers
Craig Mullins, Mullins Consulting, Inc.
Register before March 22 and save on registration!
I have much more to say on this topic, so be sure to follow my blog to avoid missing any updates.
does “big data” mean to you? It is a term that is widely used and can
convey all sorts of concepts, including: huge quantities of data, social
media analytics, next generation data management capabilities,
real-time data, and much more. Once you’ve figured out what “big data”
actually means to you, you must then figure out how to manage and store
it. Are your current systems able to handle this type of data? How
can you be sure?
Several recent articles and blog entries discuss this theme.
The Commoditization of Commercial Database Management Systems?
by Craig Mullins
are so popular these days that they are being taken for granted. This
article argues that databases are intricate, multi-faceted and useful
tools that are necessary to get the most out of the data that is being
collected and should not be considered a commodity as no two offerings
The Continuing Role of the Database in the New Era of Big Data
by Bernie Spang
amounts of complex big data must be stored in databases in order for it
to be analyzed and made of use to businesses. What features in a
database are necessary to take on this challenge?
Big Data: IBM’s Mainframe Customers Base Grows
by Dave Beulke
Big Data solutions are being embraced by companies worldwide. This
discussion shows that IBM Information Management solutions are well
positioned to fill the needs to handle all your big data.
The Maturing of Big Data: From Herding Cats to Taming Tigers
by James Kobielus
all the recent innovation in the big data market, has big data matured?
Have we figured out how to make big data tigers jump through hoops, or
are we still just herding cats?
Infographic: Taming Big Data
Lots of detail here. Take a look, share the graphic and tell us what you think of it.
Taming Big Data: 12 Best Practices for Analysts - Maria Deutscher Are
you ready to “sink your teeth” into Big Data Technology? Learn how to
start using IBM’s technology correctly in order to get the most out of
your efforts by learning these 12 best practices.
In addition to these articles, I highly suggest that you read the report Analytics: The Real-World Use of Big Data.
It is based on the Big Data @ Work Survey conducted by IBM in mid-2012
with 1144 professionals from 95 countries across 26 industries.
“Across industries and geographies, our study found that
organizations are taking a pragmatic approach to big data.
The most effective big data solutions identify business
requirements first, and then tailor the infrastructure, data
sources and analytics to support the business opportunity.
These organizations extract new insights from existing and
newly available internal sources of information, define a big
data technology strategy and then incrementally upgrade their
infrastructures accordingly over time.”
you attend The DB2Night Show on Friday? We had the second show in this
year’s DB2’s Got Talent Competition. I was on vacation during the
first show, so IBM Champion Cristian Molaro was kind enough to fill in
as a judge for me. I’ve listened to the replay, so here is my summary
of both the first and second shows in this series.
Feb 1 - Show 1 of the DB2’s Got Talent Competition - watch the replay.
were supposed to be a few other contestants on this show, but they were
no-shows. We were still able to hear from Ember Mohankumar and Eric.
All three gave great presentations.
Ember - tips for running db2haicu. Ember is moving on to the finals.
Mohankumar - DB2 LUW data movement utilities. Mohankumar is moving on to the finals.
Eric - the best ways to build an audit table using the partitioning feature of DB2 LUW. Eric was chosen as an alternate.
Feb 8 - Show 2 of the DB2’s Got Talent Competition - watch the replay.
We had 5 contestants on this show: Adam, Chris, Renu, Juliano and Sanjay.
Adam - The Real Benefit of Solid State Disks (SSD) Hardware Upgrade.
story was about doing a hardware upgrade that greatly benefited a DB2
9, SAP, and WebSphere Commerce system. Adam’s presentation provided the
basics, but didn’t give enough information to see why an upgrade of
this kind was necessary. Adam was chosen as an alternate.
Chris - Making Life Easier - Letting DB2 Manage your Backup and Archived Transaction Logs.
provided great times that are very easy to follow. They have 2 DBAs in
their office and many databases, tables, and data to manage. Great
story about how they were able to handle such a workload. Chris has
been chosen as a finalist.
Renu - Small Changes, Big Results - Load Performance
Another presentation with great tips. Renu is moving on as a finalist.
Juliano - Efficient Aspects of Deleting Data in DB2 LUW
So many ways to delete data! Juliano will be a finalist.
Sanjay - Plan Management
This was a DB2 for z/OS topic... and a huge topic it is. Sanjay was chosen as an alternate.
Coming up on the show:
Feb 15 - Episode 3 of the DB2’s Got Talent Competition. There may still be room for one additional contestant.
22 - OK... now the judges are being put to work on this show. Martin
Hubel, Klaas Brant and myself have been asked to put together
presentations to share with you!
Thanks again to our amazing host for putting this show together: IBM Champion Scott Hayes!
Schiefer is the guest on this week’s DB2Night Show. Berni is a DB2
performance legend and you’ll greatly benefit from hearing his talk.
Berni will share the latest news, tips and advice about DB2 LUW 10.Thanks to IBM Champions and hosts of this fabulous show: Scott Hayes and Martin Hubel
Remember, all shows are recorded, so if you miss it, you can still catch up at a later time.
Also remember that Feb 1 begins the 3rd "DB2's Got Talent Competition. For information, see my blog entry: Become a DB2 evangelist by being speaker!
bet you do! If you follow my blog, you know that I often promote the
fabulous work that our champions do to support IBM’s products. I like
to call the champions IBM’s Best Friends!
Just announced today, the nominations for the 2013 IBM Champion for Information Management program are now open (worldwide) and are being accepted through February 28, 2013.
Candidates may be nominated by another individual or they may
self-nominate at https://www.surveymonkey.com/s/Nomination2013 .
The official call for nominations information:
applications will be reviewed and approved solely on the efforts of
one’s community contributions, we are especially interested in
applicants outside the United States.
are looking for individuals - customers, business partners,
consultants, professors/students - who demonstrate a strong impact
within the community in some of the following ways....
Information Management offerings in the community with competence and
credibility (content, blogs, presentations, customer references,
analyst/press, videos/podcasts, etc.)
knowledge with and provide support to the community (books, articles,
blogs, forums, IBM Redbooks, presentations, education etc.).
- Nurture Information Management communities (online communities, social groups, user groups, regional user groups, etc.)
A list of current 2012 IBM Champions
To get an idea of some of the work that Champions are appreciated for, take a look at some of my previous blog entries:
Attend IDUG DB2 Tech Conference 2013 - Apr 29 - May 3, 2013 in Orlando, Florida
- Many of the speakers at this conference are IBM Champions, including
Craig Mullins, Bonnie Baker, Martin Hubel, Scott Hayes, Roger Sanders,
Judy Nall, Susan Lawson, Fred Sobotka, and many more!
DB2 Symposiums 2013
- Many of the champions who take part at large IDUG events, also take
part in more regional events like the DB2 Symposiums. Klaas Brant is
the leader in these education sessions.
Check out these Rising Stars in the DB2 Community!
- I’m not sure how many of these “rising stars” are currently
champions, but I think each and everyone of them should be nominated!
What's Happening in Your DB2 World?
- In December, I was having much fun reaching out to many of the
champions who I interact with via twitter and asking them about the DB2
activities they were involved with.
Best Selling Books, 2012 and Many IBM Champions are Authors -
Many of our champions have written books, which I’m very happy about!
I have more writing opportunities as well, so if you’re interested, you
know where to find me!
Become a DB2 evangelist by being speaker!
- IBM Champion Scott Hayes takes part in the DB2 community in many
important ways, but I think that his grooming of future speakers /
experts is outstanding. Perhaps taking part in this competition is a
first step in becoming a champion!
Three DB210 for LUW Certification Exams are now available
- Have you ever considered who creates the questions on these exams?
Would you be surprised if I said IBM Champions did? People like
Rebecca Bond, Roger Sanders, Dan Luksetich, Judy Nall, Susan Lawson, and
others are critical to the success of the certification program.
IBM Champions at IOD: A perfect match and More IBM Champions - I’ve said it before and I’ll say it again... without champions, would there even be an IBM Information on Demand Conference?
haven’t mentioned every champion, but be sure, they are very
appreciated. If you think you contribute in ways such as these, be sure
to nominate yourself or ask someone to nominate you.
you have worked with me and I’ve promoted the work that you’ve done,
feel free to use me as a reference, but give me a heads up. I look
forward to working with all the IBM Champions who I can in the coming
Opting In: Lessons in Social Business from a Fortune 500 Product ManagerDoes social business work, or is it just the latest marketing buzzword?I
think I know a product manager or two who I’d recommend this book to!
Do you? I’ve only been able to read the foreword and preface of this
book so far, but I can see the value the readers will gain in using a
more social way of performing their jobs.Take a look at the content from the back cover of the book: "Social
business isn't some hot new fad that will be over in an Internet
minute." So says IBM executive Ed Brill, in his new book Opting In.
Whether you are a product or brand manager, marketer, customer
satisfaction expert, strategist, HR executive, IT manager, or CFO, this
book will help you understand how you -- and your organization -- can be
more successful through becoming a social business.In Opting In,
you will learn how to be successful in social business, based on the
strategy and lessons learned as IBM adopted a culture of transformation
and engagement. Brill candidly shares the best practices, challenges,
and results of IBM's social business transformation. Opting In
outlines the process of becoming a social business, through
organizational commitment, cultural change, the right tools, and a
strategy for engagement. Brill helps readers develop individual
strategies and a roadmap for using social business tools, from time and
place considerations, volume and amplification, offense and defense
considerations, through building an army of advocates.Opting In will
help you learn how to use social business tools to grow your business
through customer intimacy, global reach, and product lifecycle
acceleration. You will improve your individual and organizational
effectiveness through influence and reach. You will learn when and how
to engage with customers as individuals and the marketplace through
unique voice. Brill also shows how social business helped him enhance
his personal brand through leadership, influence, balance, and inclusion
-- and how it can do the same for you.
From the Inside FlapUsing
today's social business tools and approaches, product and brand
managers can bring new products and services to market faster, identify
new opportunities for innovation, and anticipate changing market
conditions before competitors do. In Opting In,
IBM's Ed Brill demonstrates how product managers can fully embrace
social business and leverage the powerful opportunities it offers.Brill explains why social business is not a fad, not "just people wasting time on Facebook, Twitter, and YouTube," and not
just for marketers. He shows how to drive real value from
crowdsourcing, interactivity, and immediacy, and from relational links
across your organization's full set of content and networks.Drawing
on his extensive experience at IBM, Brill explores powerful new ways to
apply social business throughout product, service, and brand
management. Using actual IBM examples, he offers candid advice for
optimizing products by infusing them with the three core characteristics
of social business: engagement, transparency, and agility.Also see the Amazon page for a large and growing list of reviews of this book.Get your book:IBM PressAmazonIf you want the audio version, make sure you make the request on Amazon.com.At the IBM Connect Conference.
Buy the book at a 20% discount and have your book signed by author Ed
Brill on Monday, January 28 from 6:00 pm – 7:00 pm at the Conference
Bookstore.See also:Information Management Sessions at IBM Connect 2013Ed’s BlogI’m looking forward to reading the entire book as I see many ways I can improve my day-to-day job with the advice in this book.Susan
IDUG DB2 Tech Conference 2013 is scheduled for April 29 - May 3, 2013
in Orlando, Florida. Make your plans to attend now. The IDUG.org website has been updated with detailed information about the conference, including:
year’s conference will be special for a number of reasons. First of
all, this year is the 25th anniversary of IDUG. That’s right, 25 years
of great technical education for users, by users. This is also the 30th
anniversary of DB2. You can be sure that attendees and organizers will
be in celebratory moods throughout the event! Why not come out and
join the celebrations?
any IDUG conference that takes place in Orlando tends to be special?
Why? Many people like to attend conferences in Orlando so that they
can bring their families for part of the week to combine the business
travel with a bit of vacation. Orlando has plenty to offer, so while
you’re learning, enjoy the weather and the attractions.
Full Day SeminarsIDUG
One Day Seminars allow you to take a deep dive into specific aspects of
DB2 with some of the most renowned speakers in our industry. Listen to
these speakers and ask them your specific questions as well. This year
the seminars will be held on Monday, April 29 2013
and the full day experience includes lunch as well as hard copies of
the course materials. There is an additional registration fee for these
seminars. For details and to register, see: Full Day Seminars at IDUG.
Here are the topics and speakers you can choose from:
these are free, but be sure to register quickly since they tend to fill
up very fast! There are two to choose from and they take place after
the official conference is over, on Friday, May 3; from 8 - 2.
- DB2 10.5 for LUW Immersion Workshop - with new BLU Acceleration
- Data Warehousing with DB2 for z/OS: IBM DB2 Analytics Accelerator Deep Dive Workshop
For details and to register, see Complementary Workshops.
Technical SessionsThere are hundreds to choose from over 6 different tracks. The list can be found on Agenda, but follow my blog to get highlights and details of many of the sessions.
first step is for you to get funding from your boss to come to the
conference. If you need help with your justifications, see:
- Need help justifying expense of your 2013 IDUG conference? We have resources to help. http://ow.ly/gpfn6
- Great blog entry about tech conferences: "Technical Conference – It’s a skill builder, not a trip to Vegas" http://bit.ly/WRRkan
Stay tuned for more highlights and details!
Are you planning to go to the IBM Connect event this year? It’s coming up soon: Jan 27 - 31 in Orlando, Florida. For more information and to register: click here.
you are going, check out the Information Management sessions that you
can participate in that address the pain associated with an
overabundance of information. Learn how to start building an
information strategy for smarter analytics, especially around social
media and sentiment analysis.
Title: IBM Big Data, Information Integration and Governance: Turn Information into Insight for Smarter Analytics
Location: Ped number 31 - IBM Platform for Social Business Zone
us at an IBM Big Data, Integration and Governance demonstration to
learn how to turn your ever-growing supply of data into an enterprise
source of knowledge. The demonstration—which addresses both strategies
and technologies—will identify the pains associated with the
overabundance of information and spur thinking around building an
information strategy for smarter analytics especially around social
media and sentiment analysis.
The Foundation for Big Data: Information Integration and Governance
Day/Date: Monday Jan 28th
Speaker: Rick Clements, Program Director, MDM Product Marketing, IBM
Time/Location: 2:15-3:15PM, Dolphin Southern Hemisphere I
customer satisfaction with the right mix of personalization,
self-service, and commerce capabilities requires a high performing
business analytics platform. Organizations are turning to big data
technologies to deliver this solution. The potential of big data rests
in finding the value in the volume, velocity and variety of data. Those
companies that capture meaning through the analysis of the torrent of
data will be in advantageous positions over their competitors. During
this session, we will explain how Information Integration and Governance
best practices can assure trusted information, make business operations
more efficient and mitigate risk. Establishing Information Integration
and Governance will optimize your investment in big data and streamline
operations. Join this session to learn how Information Integration and
Governance provides trusted information on a secure platform to serve as
the basis for in-context, effective interactions.
How to build data security into big data environments
Day/Date: Wednesday Jan 31st
Speaker: Kimberly Madia, WW Product Marketing Manager, InfoSphere Guardium & InfoSphere Optim, IBM
Time/Location: 3pm-4pm Swan, Swan 1-2
be competitive, organizations are taking advantage of today's data
explosion to grow business while controlling costs and reducing risks.
At the same time, organizations must come to terms with the security
challenges they introduce. Big data environments allow organizations to
aggregate and share more and more data — much of which is financial,
personal, intellectual property or other types of sensitive data. The
good news: You don’t have to feel overwhelmed when it comes to securing
big data environments. Find out how you can apply the same fundamentals
of securing databases, data warehouses and file share systems for
securing Hadoop-based environments to prevent data leaks, ensure the
integrity of information and automate compliance controls. You will
- Unique challenges of big data environments
- How to prioritize data security for Hadoop environments
- Three tips to improve security in big data environments
- IBM InfoSphere® Guardium® data security and privacy solutions for big data
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
are three DB2 Symposiums planned for the first half of 2013. Hopefully
you’ll be able to attend one of these as they are a great way to hear
from industry leading experts on topics that most concern you. You may
join for 3, 2 or just 1 day(s), depending on your needs and budget. Symposiums are different than a conference as they are full day learning sessions that will provide you with the depth you need on a particular topic.
The locations planned for this year are:
Dallas, TX - March, 13-15 2013
Boston, MA - March, 18-20 2013
Veldhoven, Netherlands - May, 28-30 2013
I enjoy Dallas and Boston, I highly recommend you combine education and
vacation together to enjoy the tulips that will be in bloom in the
Netherlands during last week of May! My family is Dutch, as I’m sure
you can tell by my surname, and I’ve been lucky to visit this lovely
country several times. It is quickly becoming one of my favourite parts
of the world.
For detailed information on the locations and the sessions that will be offered, see the DB2 Symposium website.
Welcome to January 2013! I hope you had an excellent break from work to have some fun, food & time with family & friends! I did and am now ready for a fast start into the year.
I can see that it will be a very busy year for me, and I'm sure for many others. Here are a few things that are already on my radar:
- Key anniversaries: DB2 for z/OS = 30 years; IDUG = 25 years; and DB2 for LUW = 20 years.
- New releases. I can't say more, but apparently there may be something new on the horizon!
- New books: yes... there are several on the horizon. Follow my blog and I'll let you know first :)
- Interesting events: Orlando, Barcelona, Las Vegas for the big events and Toronto, Boston, Dallas, and the Netherlands for smaller events.
- Free webinars: Lots of topics are being planned for both the DB2Night Show and DB2 Tech Talk webinars.
- Articles, tutorials, and best practices. So much is already in the pipeline for developerWorks!
- Articles and columns - also planned for IBM Data Management Magazine.
- Social media! Find us on twitter, facebook, blogs, YouTube videos, podcasts, slideshare, communities, linkedIN... just about everywhere!
- IBM Redbooks, product docs, and training courses: stay in touch to find the best of the best to keep your skills sharp.
- DB2 Evangelists? Our partners, customers, IBM champions, gold consultants, and of course our very own IBM employees are working together to ensure that there will be no end of fun this year!
Happy New Year!
PS: I found the image on the DB2 Symposium
page and liked it very much that I used it here as well!
been a great year for blogging this year... at least for me! This is
the 139th entry I’ve written this year, and that doesn’t count the ones
that I wrote for the IBMIOD Official Blog. That brings my total up to
963 entries since my blog was initiated on developerWorks! I now have
263 followers and 3,320,000 unique views since my blog landed on
developerWorks!I thank each and every one of you who read an entry I wrote and hope that you like what you read and come back for more!In terms of number of unique views, here are the top ten entries that I posted this year:
Thanks for following!Yours, Susan
Redbooks are cherished by many, since they provide excellent technical
content in electronic format, all at a price that is hard to resist:
FREE! This year IBM Redbooks are also available in ePub format,
allowing tablet owners a new way to read these books.You can find the most popular downloads for Information Management on the IBM Redbooks site: IBM Information Management Redbooks.Rather
than give you this list, I’ve compiled my own list that includes the
top downloads of the most recent DB2 or InfoSphere titles: 1. High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and WindowsThis
IBM Redbooks publication describes the DB2 high availability functions
and features, focusing on High Availability Disaster Recovery (HADR) in
the OLTP environment. The book provides a detailed description of HADR,
including setup, configuration, administration, monitoring, and
preferred practices. 2. Oracle to DB2 Conversion Guide: Compatibility Made EasyThis
Oracle to DB2 migration guide describes new technology, preferred
practices for moving to DB2, and common scenarios that can help you as
you move from Oracle to DB2.3. InfoSphere DataStage for Enterprise XML Data IntegrationXML
is one of the most common standards for the exchange of information.
However, organizations find challenges in how to address the
complexities of dealing with hierarchical data types, particularly as
they scale to gigabytes and beyond. In this IBM Redbooks publication, we
discuss and describe the new capabilities in IBM InfoSphere DataStage
8.5. These capabilities enable developers to more easily manage the
design and processing requirements presented by the most challenging XML
sources. Developers can use these capabilities to create powerful
hierarchical transformations and to parse and compose XML data with high
performance and scalability. Spanning both batch and real-time run
times, these capabilities can be used to solve a broad range of business
requirements.4. Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OSThis
IBM Redbooks publication provides technical decision-makers with a
broad understanding of the IBM DB2 Analytics Accelerator architecture
and its exploitation by documenting the steps for the installation of
this solution in an existing DB2 10 for z/OS environment.5. Unleashing DB2 10 for Linux, UNIX, and WindowsThis
IBM Redbooks publication provides a broad understanding of the key
features in IBM DB2 10 and how to use these features to get more value
from business applications.6. Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDCIn
this IBM Redbooks publication, we show you examples of how InfoSphere
CDC can be used to implement integrated systems, to keep those systems
updated immediately as changes occur, and to use your existing
infrastructure and scale up as your workload grows. InfoSphere CDC can
also enhance your investment in other software, such as IBM DataStage®
and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere
Master Data Management Server, enabling real-time and event-driven
processes. Enable the integration of your critical data and make it
immediately available as your business needs it.7. Smarter Modeling of IBM InfoSphere Master Data Management SolutionsThis
IBM Redbooks publication presents a development approach for master
data management projects, and in particular, those projects based on IBM
InfoSphere MDM Server.8. DB2 10 for z/OS Performance TopicsThis
IBM Redbooks publication provides an overview of the performance impact
of DB2 10 for z/OS discussing the overall performance and possible
impacts when moving from version to version. We include performance
measurements that were made in the laboratory and provide some
estimates.9. IBM InfoSphere Streams V3.0: Addressing volume, velocity, and varietyStill
in draft format, learn how IBM InfoSphere Streams provides a
development platform and runtime environment where you can develop
applications that ingest, filter, analyze, and correlate potentially
massive volumes of continuous data streams based on defined, proven, and
analytical rules that alert you to take appropriate action, all within
an appropriate time frame for your organization. 10. Managing IBM DB2 10 for z/OS Using the IBM DB2 Administration Tool for z/OS Version 10This
IBM Redbooks publication highlights the data administration
enhancements introduced by DB2 Administration Tool for z/OS Version 10
by providing scenarios of their use with the new functions provided by
DB2 10 for z/OS.Stay tuned for next year for more great content from the IBM Redbooks team!Susan
DB2 Tech Talks Now in ReplayWere
you able to watch any of the DB2 Tech Talk webinars this year? There
have been many excellent topics covered in the past year with a variety
of experts sharing their knowledge with you.If
you missed any of these, you can watch them at your convenience. To
help you filter through all the shows, I’ve come up with a list of the
top 10 most popular talks:1. Technical Tour of DB2 10 for LUW and InfoSphere Warehouse 10Get
the details behind these new product releases as announced on April 3.
Learn about powerful new features such as: Adaptive Compression,
Multi-Temperature Data Storage, SQL Compatibility with Oracle, Time
Travel Query, Real-time operational data warehousing, and NoSQL
capabilities.2. Technical Tour of PureData Systems for transactions and operational warehousingJames Cho
goes through the technical features of PureData for Transactions and
PureData for Operational Analytics, showing you how these systems ease
deployment, management and development.3. Part One Certification Prep for DB2 10 Fundamentals ExamTogether, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.4. Part Two Certification Prep for DB2 10 Fundamentals ExamTogether, the two parts will cover everything you need to pass Exam 610 - DB2 10.1 Fundamentals.5. Compression Comparison: DB2 vs. Oracle Database and The restChris
Eaton compares DB2 10 for LUW to Oracle Database and other industry
databases, explaining the features and advantages that help to maximize
valuable storage resources. 6. Temporal Data Management Features of DB2 10Matthias
Nicola of IBM labs covers the bi-temporal data management features
which let you manage data at past or future points in time, consistently
and cost-effectively.7. Optimize Storage Utilization and Minimize Administration with DB2 10Learn about new storage optimization features: Adaptive Compression, Multi-Temperature Data Management, and Workload Management.8. Oracle Database and PL/SQL Compatibility Features of DB2 10With DB2 10 for Linux, UNIX, and Windows,
you’ll find the PL/SQL Compatibility features and other enhancements
make it even easier for you to switch. Learn about why and how to
switch.9. Inside Row and Column Access Control in DB2 10 and InfoSphere Warehouse 10This
talk will help you learn more at the technical level about the new Row
and Column Access Control (RCAC) features in DB2 10 for Linux, UNIX and
Windows and InfoSphere Warehouse 10.
10. Database Application Performance Management Best Practices
Be sure to follow my blog to learn about all the Tech Talks that will take place throughout the coming year.
In this episode of the DB2 Tech Talk Series Cliff Leung
and Holly Hayes discuss how you can use Optim Query Workload Tuner and
Optim Performance Manager to easily get to the bottom of common database
problems. For those who have not looked at OPM and OQWT in a while,
prepare to be amazed.
have former contestants of “DB2’s Got Talent” competition been able to
achieve since they improved their presentation skills as a result?Some
of the former contestants have been telling me about their published
articles and IDUG presentation. If you haven’t contacted me already and
you were a contestant, tell me about what you’ve been up to.Before
you read the list, I first want to say that I’m very proud of each and
everyone one of these people as becoming presenters and writers isn’t
always easy. I’m also very glad that I took a small part in encouraging
these people to try something new.Rajasekhar @raja_iafwas
one of the finalists in the 1st year of the contest and had to withdraw
due to a work project that involved travel. He says that his
appearance on the DB2Night Show enabled him to connect with the Database
community, build confidence & networking. Clearly he thoroughly
enjoyed being part of this contest. In the second year Raja didn’t take
part, but he mentored 5 people from his organization to participate.
He’s been teaching DB2 for 8 years.Jeyabarathi Chakrapani @JBChakra's presentation was accepted for IDUG 2013: "Evolution of the DB2 HADR Tool". JB has also had an article published on developerWorks: Use concurrent I/O to improve DB2 database performance And she wrote a guest blog entry for me: DB2, DB2Night Show and IDUG as viewed by JB . has a blog Xtivia. His latest entry: "DB2 Update Anywhere Replication for Dummies". http://bit.ly/Y4OSnt. Brian will also be presenting at IDUG Orlando in May 2013: “A DB2 LUW Fitness Plan”.Norberto Gasparotto Filho @norbertogfpublished a tutorial on developerWorks: "DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning" and keeps a blog Insights on DB2 LUW database admin, programming and more.Ember Crooks on her first developerWorks article: "Mining your package cache for problem SQL in DB2 for Linux, UNIX, and Windows" and maintains a blog: DB2 for WebSphere Commerce: Expert
tips on building and administering DB2 LUW databases for WebSphere
Commerce. She will be presenting at IDUG in Orlando: "The 10
Commandments of Supporting E-Commerce Databases” . AND she is appearing
on tomorrow’s DB2Night Show: "Do what I mean, not what I say! Back-Out Strategies for DB2 Database Changes"
. (Note, if you miss the show on Dec 14, remember that you can watch
all DB2Night Show episodes in replay... whenever you want.Kohli Kshitij @kohli83 had
a great year! He won the “DB2’s Got Talent Competition” from the
DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says
that his favourite sessions were:and... he thinks he’d like to volunteer for IDUG!https://www.ibm.com/developerworks/mydeveloperworks/blogs/KohlisDB2_Adventures/?lang=en_usHe’s reviewing a book that will be published next year by IBM PressAndres Gomez Casanov (@angoca) has a DB2 blog in Spanish, where he puts opinions, tricks & tips.Would
you like to be involved more in the community and achieve some of the
successes that these people have? You can! Become a contestant on next
year’s “DB2’s Got Talent” competition and build your skills, network,
and possibly win a prize!See my recent blog for details: Become a DB2 evangelist by being speaker!Susan
Join DB2 expert Kelly Schlamb and panelists Ben Ream and Debbie Hauss as they discuss The New Rules Of Always-On Retailing in a free webinar.Date: Tuesday, December 18th, 2012Time: 1:00 pm ETRetailers
have specific database needs, especially this time of year. Any outages
to a retailer's computer systems, quickly means loss of revenue. To
help retailers ensure that their systems can handle unexpected
transaction spikes and to adjust to new demands quickly, retailers must
deploy and manage a continuously available environment. A continuously
available environment means transactional data can be accessed in real
best data management systems evaluate the performance of each specific
task, offering new levels of availability and scalability on distributed
platforms and enabling extreme workload capacity while cutting costs
across the enterprise. Learn how DB2 pureScale can minimize outages and
keep systems up and running.Register for this webinar
to hear how retailers can leverage advanced data management in order to
maximize their capacity to fill orders and process transactions.
Attendees also will learn how to respond to demand spikes easily, meet
SLA demands with proper workload management, and address performance
concerns in order to ‘keep the lights on’ at all times.Panelists• Kelly Schlamb, WW IM Technical Sales Acceleration, IBM• Ben Ream, Principal Retail Analyst, Ream Consulting Services• Debbie Hauss, Editor-in-Chief, Retail TouchPoints
Related content:Ember Crooks writes a blog called DB2 Commerce and she focuses on issues related to the retail industry.Two recent articles in the IBM Data Management Magazine were about retailing and were written by IBM Champion Scott Hayes:
time for the annual IBM Press book sale, which is on from now until
Friday December 28, 2012. This is a perfect time to stock up on great
books that will help you become more effective at your job. Here’s a
list I put together along with reasons why you’d want to read this book.40% off from IBM Press: —save
40% on print books, eBooks, and videos during our this Sale. Also, as a
special reward for purchasing, you will automatically receive one free
month's access to Safari Books Online via email confirmation. Use
discount code HS2012 and start shopping now!
- "DB2 Developer's Guide"
book by IBM Champion Craig Mullins is in its 6th edition. Clearly that
means the book is a favourite to many people. This book was fully
revised to cover all the latest features in DB2 V10 and is the perfect
book for anyone using DB2 for z/OS. This comment from amazon.com sums
up the book’s value: “5.0 out of 5 stars -
The best book for DB2 developers. It is not a manual; it teaches
"philosophy" of the relational database and gives a lot of good tips.”
- "DB2 SQL Tuning Tips for z/OS Developers"
is a very short book and focuses on the most valuable tuning tips for
writing SQL for DB2 for z/OS. Written by IBM Champion Tony Andrews.
book fully reflects the latest SQL programming best practices for DB2
V9 and DB2 V10 on z/OS: techniques that are taught in no other book and
are rarely covered in general DB2 SQL courses. Drawing on his extensive
consulting experience and highly praised training with Themis Inc., Tony
also presents practical checklists and an invaluable 15-step
methodology for optimizing virtually any DB2 application.
- "An Introduction to IMS, 2nd Edition"
is the original BIG DATA database and even though some applications
were written 50 years ago, they are still working and critical to many
business transactions. Someone once told me, if you use a bank machine,
then you use IMS! Written by a team of IBM IMS experts.
you’re a DBA, database developer, or system programmer, it brings
together all the knowledge you’ll need to succeed with IMS in today’s
mission critical environments.
this book, a team of IBM’s leading information management experts guide
you on a journey that will take you from where you are today toward
becoming an “Intelligent Enterprise.”
- FREE eSampler PDF is available.
- Enterprise Master Data Management: An SOA Approach to Managing Core Information
very interesting story about this book! I spoke with several of the
authors at the IBM IOD conference this fall and learned that when they
visit customers to help them implement complex MDM solutions, they find
that their clients are using this book as the ultimate guide.
read the book cover to cover and can see why it is so valuable. The
authors have put great care into creating “patterns” for specific
industries that cover every conceivable detail about the data and the
world around it. I think this is a must read for anyone with a complex
Reminder: If you’re in Europe, find these books are featured on the www.pearson-books.com/ibmpressbookshop website
that offers 35% off and free shipping within the UK. Shipping fees to
the rest of Europe are not free, but very small. Be sure to bookmark
this page and share with others who buy technical books in Europe.Susan
What’s happening in your DB2 world? I
asked this question to many of the people I’m connected with on twitter
and I got many responses that I’d like to share with you.
Rebecca Bond@DB2locksmith hasn’t had time to update her blog (http://www.securedb2.com)
lately, but is thinking of topics she could write about. Is there
something you want Rebecca’s opinion on? I’m sure she’d love to have
some suggestions to help her write something.
Kohli Kshitij @kohli83 had
a great year! He won the “DB2’s Got Talent Competition” from the
DB2Night Show, he attended IDUG in Denver and IDUG in Berlin, he says
that his favourite sessions were: and... he thinks he’d like to volunteer for IDUG!
Sanjeev Datta @1dsanjeev is very pleased with the publication of his new book: IBM Cognos Insight (http://www.packtpub.com/ibm-cognos-insight/book). He
recommends Chapters 1 for anyone who is new to IBM Cognos and IBM
business vision and strategy. Chapters 4 & 5 will help finance,
sales, & marketing departments in usingCognos Insights to develop their own workspaces. If you find the book sold out on amazon, contact Sanjeev through twitter and ask him for other buying options & discounts.
Michael Schulz @mikeondb2 says DB2
is rockin' and rollin' and PureData for Transactions is taking it to a
new level. Don’t forget to read this article that Mike recently wrote
for IBM Data Management Magazine: "Achieving High Availability and Disaster Recovery with IBM DB2" .
Sunil Soares @SunilSoares1
just finished the Data Governance Winter Conference. He’ll be speaking
at IDMA conference in April 2013 on best practices for insurance data
governance. He’s very happy with the publication of his latest books
and the sales of all three of his books:
- The IBM Data Governance Unified Process
- Selling Information Governance to the Business: Best Practices by Industry and Job Function
- Big Data Governance
Philip Gunning @db2luw
is finishing off his latest book that will publish in 2012 as well as
performed a DB2 upgrade with TSAMP, HADR & wrote an article on
Temporal Tables that will published on
you have an answer to my question “what’s happening in your DB2 world”
and would like to share with me and others, either send me a tweet
@susvis or post on the DB2 Facebook page.