We’re coming to the end of a very popular season on the DB2 Night Show. This
is the third season and much has happened, but take a look at what host Scott
Hayes has in store for you to end the season:
15, the guest was Sanjay Kumar, author of new book IBM DB2 9.7 Advanced Application
Developer Cookbook. Sanjay gave many tips about using OLAP, Stored
Procedures, Optimization Profiles, PL/SQL, SQL and more with DB2 for LUW.
This is one of the books I gave away earlier this week at the Central Canada DB2 User’s Group
and the recipient was very pleased to get the book. Have you taken a look yet?
It might be exactly what you’re looking for.
Next Friday, June 22, 11ET, Paul Bird and Serge Boivin join
Scott to discuss the “Best Practices for Implementing DB2 Workload Management in a Data
Warehouse”. both Paul and Serge are long time employees of the Toronto Lab
and know this area extremely well. In fact, they have so much to share with the
audience, that this is a 90-min show.
OK… 90 minutes is a good sized webinar, but Pat Bates breaks the
record. He has so much to talk about that Scott has scheduled 4 back to back
shows for Pat!
Pat is from the IBM Technical Sales Team and will share his expertise in the
InfoSphere Warehouse and Netezza area:
Monday, June 25 at 11:00 am ET
“Temporal Queries and Analytics in an IBM InfoSphere Warehouse
Tuesday, June 26, 3:00 pm ET
Data Warehousing with InfoSphere Warehouse V10.1”
Wednesday, June 27, 11:00 am ET
Warehouse V10.1 Performance Enhancements”
Thursday, June 28, 11:00 am ET
Performance Analytical Data Warehouse using IBM Netezza Appliance 1000 - Best
Click on the links for the show title to register. Join all the shows to
build your expertise in this important area.
Thanks Scott for another great season. Looking forward to Season 4!
New IBM Redbook: DB2 Virtualization
technologies are becoming more popular to help efficiently utilize
resources by consolidating servers. IBM, the first company that
developed and made available the virtual technology in 1966, offers
advanced, powerful, reliable, and cost-saving virtualization
technologies in various hardware and software products including DB2®
for Linux, UNIX, and Windows. This IBM Redbooks publication describes
using IBM DB2 9 with server virtualization.
The book starts with a
general overview of virtualization and describes specific server
virtualization technologies to highlight how the server virtualization
technologies have been implemented. With this introduction anyone new
to virtualization will have a better understanding of server
virtualization and the industry server virtualization technologies
available in the market.
Following the virtualization concept, the book describes in detail the setup, configuration, and managing of DB2 with
three leading server virtualization technologies:
- IBM Power Systems™ with PowerVM™
The virtual machine setup is done with DB2 in mind to help IT support
understand the effective ways of setting up a virtual environment
specific for DB2. The architecture and components of these
three server virtualization technologies are explained to allow DBAs to understand
how a database environment using DB2 can benefit from using the server
In addition, the DB2
features and functions that can take advantage of using server
virtualization are discussed. These features are put into practice when describing
how to set up DB2 with the three virtualization technologies discussed
in this book. This book also includes a list of best practices from the
various tests performed while using these virtualization technologies.
These best practices can be used as a guideline or a reference when
setting up DB2 using these virtualization technologies.
For those of you attending the IBM Information on Demand Conference later this month, you'll be given a chance to get a free printed copy of this book and meet author Jason Chan.
Enjoy all the coverage that DB2 is getting because of theIBM DB2 pureScale announcement last week! From what I've seen... very positive reactions!
I’m currently reviewing a chapter from an upcoming book by Roger Sanders,
The chapter I’m reading now is about promoting your book after it is published. Coincidentally I also found an article on LinkedIn about the same topic: Do authors really need to promote their own books?
The answer is yes! Authors need to promote their books in as many ways as possible. Today I want to tell you about some of the videos that promote books:
1) My video that was filmed at IBM’s Information on Demand Conference this past October. My video is to encourage people to come to the bookstore but also to promote some of the books that were available and of course to promote the 16 book signings that I had set up. I’m happy with how it turned out… and I was correct on some of the top selling books at the conference.
2) I was filmed a second time while at the conference as well. This team filmed many people on a variety of topics. Thanks to Conor and Irshad for putting these videos together!
3) Ellice Uffer from IBM Press filmed several authors while at the conference and intends to continue adding short videos to promote the books. Currently there are three videos:
- Author Matt Ganis talks about his book, A Practical Guide To Distributed Scrum
- Author Martin Oberhofer discusses The Art of Information Architecture
- Mike Biere discusses his book - The New Era of Enterprise Business Intelligence - which teaches how to compete with analytics.
4) My personal friend from University, Eden Watt, recently published her first novel: Vision Speak. See her video that was done via Hay House Movers & Shakers.
Are you an author and are looking for ways to promote your book? Consider filming yourself and putting your video on YouTube.
I was interviewed for a TV show shortly after my second book published. I think it helped sales and back then (2005) the videos weren’t as easy to share as they are now.
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.
Over the past week, I've written several entries to help you get certified. This posting lists all of those entries and makes it easy for you to navigate through some of the material. I'll repost or update this entry as I go. I hope you find this useful.
I was pretty surprised when I heard the top selling books at the IBM Insight conference that started October 26, 2014 in Las Vegas. Why? Well, I had blogged about each and every one of them. So either I had a premonition as to what would be popular or my blog entries helped them sell? Cause and effect??
Anyway, the books that most people took home were the books that we were giving away for free. This includes the three latest Flashbooks, plus these retail books that were purchased by IBM to give away:
Beyond Big Data: Using Social MDM to Drive Deep Customer Insight
Author team: Martin Oberhofer, Eberhard Hechler, Ivan Milman, Scott Schumacher, Dan Wolfson
Enterprises have long relied on Master Data Management (MDM) to improve customer-related processes. But MDM was designed primarily for structured data. Today, crucial information is increasingly captured in unstructured, transactional, and social formats: from tweets and Facebook posts to call center transcripts. Even with tools like Hadoop, extracting usable insight is difficult—often, because it’s so difficult to integrate new and legacy data sources.
In Beyond Big Data, five of IBM’s leading data management experts introduce powerful new ways to integrate social, mobile, location, and traditional data. Drawing on pioneering experience with IBM’s enterprise customers, they show how Social MDM can help you deepen relationships, improve prospect targeting, and fully engage customers through mobile channels.
Business leaders and practitioners will discover powerful new ways to combine social and master data to improve performance and uncover new opportunities. Architects and other technical leaders will find a complete reference architecture, in-depth coverage of relevant technologies and use cases, and domain-specific best practices for their own projects.
Engaging Customers Using Big Data: How Marketing Analytics is Transforming Business
By Dr. Arvind Sathi
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 top selling books that were purchased are:
A Captain’s Duty: Somali Pirates, Navy SEALs, and Dangerous Days at Sea
By Richard Phillips
A Captain's Duty tells the life-and-death drama of the Vermont native who was held captive on a tiny lifeboat off Somalia's anarchic, gun-plagued shores. A story of adventure and courage, it provides the intimate details of this high-seas hostage-taking--the unbearable heat, the death threats, the mock executions, and the escape attempt. When the pirates boarded his ship, Captain Phillips put his experience into action, doing everything he could to safeguard his crew. And when he was held captive by the pirates, he marshaled all his resources to ensure his own survival, withstanding intense physical hardship and an escalating battle of wills with the pirates. This was it: the moment where training meets instinct and where character is everything. Richard Phillips was ready.
Analytics Across the Enterprise: How IBM Realizes Business Value from Big Data and Analytics
By Brenda L. Dietrich, Emily C. Plachy, Maureen F. Norton
Analytics is not just a technology: It is a better way to do business. Using analytics, you can systematically inform human judgment with data-driven insight. This doesn’t just improve decision-making: It also enables greater innovation and creativity in support of strategy. Your transformation won’t happen overnight; however, it is absolutely achievable, and the rewards are immense.
This book demystifies your analytics journey by showing you how IBM has successfully leveraged analytics across the enterprise, worldwide. Three of IBM’s pioneering analytics practitioners share invaluable real-world perspectives on what does and doesn’t work and how you can start or accelerate your own transformation. This book provides an essential framework for becoming a smarter enterprise and shows through 31 case studies how IBM has derived value from analytics throughout its business.
Hadoop for Dummies
By Paul Zikopoulos, Dirk deRoos, Bruce Brown, Rafael Coss
With most of the world’s data created in only the past two years, Hadoop has emerged as the definitive computing paradigm to handle big data. This comprehensive guide from IBM big data experts provides a hands-on resource for those who want to dig into the details of HDFS and MapReduce to take data storage and processing to the next level.
Get started with Hadoop — discover the origins of Hadoop, the realities of worldwide data growth, and practical use cases for this revolutionary platform
Under the Hadoop hood — dig into Hadoop’s distributed framework, including HDFS and MapReduce and the best tools for working with data in Hadoop
Hadoop and structured data — modernize data warehouses with Hadoop and discover data utilities like HBase, Hive, and Sqoop
Hands on with Hadoop — get your hands dirty with details on configuring Hadoop clusters and an overview of day-to-day Hadoop administration
Take your Hadoop knowledge to the next level — use additional Hadoop resources to understand the technology at a deeper level
IBM SPSS Modeler Cookbook
By Keith McCormick, Scott Mutchler, Dean Abbott, Meta Brown, and Tom Khabaza
IBM SPSS Modeler is a data mining workbench that enables you to explore data, identify important relationships that you can leverage, and build predictive models quickly allowing your organization to base its decisions on hard data not hunches or guesswork.
IBM SPSS Modeler Cookbook takes you beyond the basics and shares the tips, the timesavers, and the workarounds that experts use to increase productivity and extract maximum value from data. The authors of this book are among the very best of these exponents, gurus who, in their brilliant and imaginative use of the tool, have pushed back the boundaries of applied analytics. By reading this book, you are learning from practitioners who have helped define the state of the art.
Performing Information Governance: A Step-by-step Guide to Making Information Governance Work
By Anthony David Giordano
Most enterprises recognize the crucial importance of effective information governance. However, few are satisfied with the value of their efforts to date. Information governance is difficult because it is a pervasive function, touching multiple processes, systems, and stakeholders. Fortunately, there are best practices that work. Now, a leading expert in the field offers a complete, step-by-step guide to successfully governing information in your organization.
Using case studies and hands-on activities, Anthony Giordano fully illuminates the “who, what, how, and when” of information governance. He explains how core governance components link with other enterprise information management disciplines, and provides workable “job descriptions” for each project participant.
Tony helps you successfully integrate key data stewardship processes as you develop large-scale applications and Master Data Management (MDM) environments. Then, once you’ve deployed an information asset, he shows how to consistently get reliable regulatory and financial information from it.
Performing Information Governance will be indispensable to CIOs and Chief Data Officers…data quality, metadata, and MDM specialists…anyone responsible for making information governance work.
For the IBM Press books in the list, I suggest you check out the website http://www.ibmpressbooks.com/ to see if there are special offers. This is the 10th anniversary of the partnership between Pearson Education and IBM and there are monthly promotions to celebrate.
For the next month, Packt Publishing is offering a special on their books. If you purchase the print version of any of their books, you’ll also get the e-version of that book plus access to the PacktLib version of that book. One price, three formats.
This is a limited period offer lasting until June 10thso grab your copies now!
Packt’s collection of IBM titles: http://www.packtpub.com/books/ibm
May I suggest a few titles:
IBM InfoSphere Replication Server and Data Event Publisher
Published: August 2010
Our price: $59.99
IBM Rational ClearCase 7.0: Master the Tools That Monitor, Analyze, and Manage Software Configurations
Published: April 2011
Our price: $54.99
WebSphere Application Server 7.0 Administration Guide
Published: August 2009
Our price: $49.99
IBM Cognos 8 Report Studio Cookbook
Published: June 2010
Our price: $59.99
IBM Lotus Notes 8.5 User Guide
Published: August 2010
Our price: $49.99
IBM Rational Team Concert 2 Essentials
Published: February 2011
Our price: $54.99
IBM Lotus Quickr 8.5 for Domino Administration
Published: February 2011
Our price: $44.99
Application Development for IBM WebSphere Process Server 7 and Enterprise Service Bus 7
Published: July 2010
Our price: $59.99
Getting Started with IBM FileNet P8 Content Manager
Published: February 2011
Our price: $64.99
IBM Lotus Notes and Domino 8.5.1
Published: January 2010
Our price: $49.99
Lotus Notes Domino 8: Upgrader's Guide
Published: December 2007
Our price: $49.99
IBM Lotus Sametime 8 Essentials: A User's Guide
Published: September 2010
Our price: $44.99
IBM Cognos 8 Planning
Published: July 2009
Our price: $59.99
IBM WebSphere eXtreme Scale 6
Published: November 2009
Our price: $59.99
Funny story: The Bare Naked Ladies are from Toronto and they are a rock
band… in case you didn’t know. Before they became famous, they were booked to
play in Toronto at our City Hall for some event. The mayor of Toronto at that
time didn’t realize they were a band and made a huge stink about having nudity
at a public event. They say that no publicity is bad publicity and I think this
proves it. They became known to all in Toronto regardless if people were fans
of their music!
I am a fan and was the minute I heard the song “If I had a Million Dollars”.
Of course there were many other hits on that first album and I remember being at
a party around the time I started working for IBM and dancing with friends to
this album. A huge hit!
I love the humour in their songs and like some of the references to local
sites in Toronto.
If you are attending the IBM Information on Demand Conference this year,
you’ll get a chance to see the band perform live. Despite the fact that I see
many concerts, this will be my first time seeing them live as well! I’m looking
forward to it, very much.
about the Bare Naked Ladies:
They have sold over 15 million albums. Some of their award winning songs
"Lovers In A Dangerous Time"
They are playing at the Tuesday October 23
at The Networking Session from 7:30 – 10:30, along with One
PS… Last year we were lucky to see the band Train. I didn’t know who they
were at the time, but went anyway. I did know many of their songs and am still
smiling at memories of the great performance they did!
Join us for the 4th Annual Women In Technology Networking Event at the 2010 IOD Conference in Las Vegas.
Hosted by Debbie Landers, VP Information Management Client Support and Education, and Karla Norsworthy, VP Warehouse Solutions, this 'wine and cheese' reception provides an opportunity to build connections with fellow IBM colleagues as well as women clients and partners.
This year, we'll also have the opportunity to hear Sam Lightsone discuss key findings from his book entitled "Making it Big in Software: Get the Job. Work the Org. Become Great".
It is preferable that attendees register for the event via the IOD website. (Note: You must be registered for the conference to attend this event.)
Women in Technology: Leveraging Our Unique Abilities to Build Success
Wednesday, October 27th @ 6pm
Session Reference: 3613A
Room: South Seas A/B
If you have a copy of Sam's book, bring it to the Wednesday reception for Sam to sign it. If not, attend Sam's official signing session at the IBM Information on Demand Conference, on Thursday, October 28 from 12:30 – 1:30 pm. Add this book signing to your schedule via the Smart Site Agenda Builder. His session is Anc # 3618.
Sam's passion is software development and recruiting and mentoring software engineers. He recently published Making it Big in Software which encompasses everything he learned in a 20+ year career at IBM as a technical leader in management, software architecture and programming. Come hear tips from Sam on jumpstarting your career, moving up, blazing your way to the top, working the organization, successfully managing your time, projects and life and more!
PS... Join one of the groups so you never miss a date:
Facebook Fan Page - more than 400 members at the time of this writing. This has been a fairly active page so far, so even if you haven't read the book yet, become a fan and learn more about the author and events surrounding the book.
LinkedIn Group - Career based articles and events about the book will be posted here.
Sam's Blog: The Making it Big Blog. Sam has been summarizing some of the points he makes in his book and blogging about them. Active blog and interesting entries.
Read one chapter for free online: http://bit.ly/d1KrQZ
Although an amazon link is provide for each book, they are also available through most other book channels and directly from the publisher for bulk orders. See Information Management Bookstore
for an ongoing update of all the books that are available for Information Management. PUBLISHED in 2007Understanding DB2 9 Security (IBM Press)
by Rebecca Bond
, Kevin Yeung-Kuen See
(IBM), Carmen Ka Man Wong
(IBM), Yuk-Kuen Henry Chan
Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security. IBM DB2 9 New Features (McGraw-Hill)
by Paul Zikopoulos
, George Baklarz
, Leon Katsnelson
, Chris Eaton
Enhance productivity, profitability, and efficiency using IBM DB2 9 and the detailed information in this comprehensive resource. Written by experienced IBM data server professionals, IBM DB2 9 New Features covers the technical details of the major new aspects of DB2 9 alongside real-world business uses, syntax examples, and insider tips. Learn how to manipulate and manage XML data using pureXML, automate maintenance tasks, and seamlessly integrate Java, PHP, and Perl scripts. Plus, you'll get vital coverage of the brand-new DB2 Developer Workbench, enhanced .NET developer support, Ruby on Rails, and database security. DB2 9 Fundamentals Certification Study Guide (MC Press)
by Roger Sanders
Starting with the certification process itself and ending with the concept of isolation levels and locking, this guide covers everything needed to know to pass the DB2 9 Fundamentals Certification Exam (Exam 730). The prerequisite for all intermediate and follow-on DB2 certifications, XML usage, basic table creation, a rich set of sample questions, and detailed answers are all included, forming the foundation for understanding the newest version of IBM’s flagship database product. Regardless of what future certification path the reader is planning on pursuing, this study guide will chart a course for proficiency in DB2 9. IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology (MC Press)
by Carlton Doe
Also known as “IDS Flash Book”Published 4000 copies, June 13, 2007; paid for by IBM, distributed by IBMLearn what's new in the latest Informix IDS release.Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (Morgan Kaufmann)
by Sam Lightstone
(IBM), Toby J. Teorey
, Tom Nadeau
Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. Mining the Talk: Unlocking the Business Value in Unstructured Information (IBM Press)
by Scott Spangler
, Jeffrey Kreulen
Written by IBM researchers, and describes, techniques used in research assets used internally at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler, as an adjunct to this book: alphaworks.ibm.com/tech/uimodeler.DB2 Viper Strikes Again - New Features In DB2 9.5 (McGraw-Hill)
by Belal Tassi
, Paul Zikopoulos
, Dwaine Snow
, Aamer Sachedina
Also known as "Viper Flash Book".Not currently available for purchase.... but I'm working on it!Published 8000 copies, October 15, 2007; paid for by IBM, distributed by IBMLearn what is new in DB2 9.5.DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep (IBM Press)
by George Baklarz
and Paul Zikopoulos
Everything a DBA needs to know about DB2 9... from installation to XML to security.DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press)
by Susan Lawson
(IBM Gold Consultant) and Dan Luksetich
Written by two members of the team who participated in the actual writing of the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732, including database design and implementation, operation and recovery, security and auditing, performance, as well as installation and migration/upgrade. But that is only the beginning. It also covers the new features of DB2 9 for both database and application development. Building an Intelligent Web: Theory and Practice (Jones & Bartlett Publishers)
by Rajendra Akerkar
Includes DB2 Express; book is a university text book. DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press)
by Roger Sanders
This comprehensive study guide steps you through all of the topics that are covered on the test, including server management, data placement, database access, analyzing DB2 activity, DB2 utilities, high availability, security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers. DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press)
by Roger Sanders
In DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the short—but notoriously challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736). Getting started with DB2 EXPRESS-C 9: A book by the community for the community
by Rav Ahuja
, Don Chamberlin
, Akmal Chaudhri
, Raul Chong
, Ian Hakes
, Clara Liu
, Matthias Nicola
, Cindy Saracco
, Ted Wasserman
, Paul Yip
- (all IBM)Online book.Understanding DB2 V9.5 (IBM Press)
by Raul F. Chong
, Xiaomei Wang
, Michael Dang
, Dwaine R. Snow
IBM DB2 V9.5 and V9 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2®: Learning Visually with Examples, Second Edition is the easiest way to master current versions of DB2 and apply their full power to your business challenges. ABOUT TO PUBLISHDB2 for Developers (MC Press)
by Phil Gunning
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database. Coming first half of 2008Administering Informix Dynamic Server, Building the Foundation (MC Press)
by Carlton Doe
(IBM)Enterprise Master Data Management: An SOA Approach to Managing Core Information (IBM Press)
by M. Oberhofer
, D. Wolfson
, P. van Run
, I. Milman
, E. Hechler
, A. Dreibelbis
- all IBMAdvanced DBA Study Guide for Exam 734
, by Roger Sanders
, Dwaine Snow
What an amazing year! Congratulations to all authors for all their very hard work in pulling these books together.... and also to all the people behind the scenes who are needed to support the authors.
The ITSO has been busy creating technical publications to help you deep your knowledge and hands on skills with IBM’s Information Management products. Here is a list of the Redbooks and Redpapers that have published in first three months of 2011:
Advanced Case Management with IBM Case Manager
Published 22 March 2011, last updated 26 March 2011, Rating: (based on 1 review)
This publication introduces IT architects and IT specialists to the case management concept, its benefits, and how it is different from traditional business process management or content management. In addition, this book introduces the IBM Case Manager product, designing a case management solution, setting up the appropriate environment, and building and deploying the solution. In addition, it serves as a practical guide for IT professionals who are responsible for designing, building, and deploying case management solutions.
Data Studio and DB2 for z/OS Stored Procedures
Published 15 March 2011
This IBM® Redpaper™ publication is devoted to tools that can be used for accelerating the development and debugging process, in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio.
Information Server: Installation and Configuration Guide
Published 8 March 2011, Rating: (based on 1 review)
In this IBM® Redpaper™ publication we provide suggestions, hints and tips, directions, installation steps, checklists of prerequisites, and configuration information collected from a number of Information Server experts. It is intended to minimize the time required to successfully install and configure IBM Information Server.
IBM Smart Analytics System
Published 23 February 2011
This IBM Redbooks® publication introduces the architecture and components of the IBM Smart Analytics System family. We describe the installation and configuration of the IBM Smart Analytics System and show how to manage the systems effectively to deliver an enterprise class service.
Embedding IBM Informix
Published 17 February 2011
In this IBM® Redbooks® publication, we discuss and describe the capabilities for embedding Informix® into applications and software. We introduce the technological architecture and describe several of the functions and features that support Informix as a robust and powerful embeddable DBMS. Many of these features are unique in the industry today, enabling clients to create a business advantage.
IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
Published 13 February 2011, last updated 17 February 2011
This IBM Redbooks® publication describes the architecture and components of Optim Performance Manager Extended Edition. We provide information for planning the deployment of Optim Performance Manager and detail steps for successful installation, activation, and configuration of Optim Performance Manager and the Extended Insight client.
Extremely pureXML in DB2 10 for z/OS
Published 28 January 2011, Rating: (based on 2 reviews)
In this IBM® Redbooks® publication, we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and Java™ language. The purpose is to provide an easy path to follow to integrate the XML data type for the traditional DB2 for z/OS® user.
IBM Enterprise Content Management and IBM Information Archive: Providing the Complete Solution
Published 19 January 2011
This IBM Redpaper™ publication focuses on the benefit and technical details of the integration of ECM products and offering with the Information Archive device. We explain the need and concept behind the IBM Smart Archive strategy, provide an overview of the Information Archive device and ECM products and offerings, and discuss how integrating them can benefit an organization. The technical details that we provide include integrating the Information Archive device with the following ECM products and offerings:
-- IBM FileNet® P8
-- IBM Content Manager
-- IBM Content Manager OnDemand
IBM Scale Out Network Attached Storage: Architecture, Planning, and Implementation Basics
Published 1 January 2011, Rating: (based on 2 reviews)
In this IBM Redbooks® publication, we give you details of the hardware and software architecture that make up the SONAS appliance, along with configuration, sizing, and performance considerations. We provide information about the integration of the SONAS appliance into an existing network. We demonstrate the administration of the SONAS appliance through the GUI and CLI, as well as showing backup and availability scenarios. Using a quick start scenario, we take you through common SONAS administration tasks to familiarize you with the SONAS system.
DB2 10 for z/OS Technical Overview
Published 30 December 2010, last updated 10 March 2011, Rating: (based on 3 reviews)
This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.
Many people were able to purchase the featured books at the IOD conference, but if you were not able to attend the conference, perhaps you'll be interested in knowing the titles of the top 10 books that were sold at the conference
.DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide
by Roger E. Sanders, Dwaine R Snow Competing on Analytics: The New Science of Winning
by Thomas H. Davenport, Jeanne G. Harris The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich
by Timothy Ferriss DB2 9 for z/OS Database Administration: Certification Study Guide
by Susan Lawson, Daniel Luksetich IBM Cognos 8 Business Intelligence: The Official Guide
by Dan Volitich DB2 9 Fundamentals Certification Study Guide
by Roger E. Sanders Administering Informix Dynamic Server: Building the Foundation
by Carlton Doe DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide
by Roger E. Sanders Enterprise Master Data Management: An SOA Approach to Managing Core Information
by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul van Run, Dan Wolfson DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
by George Baklarz, Paul C. Zikopoulos
These books can be purchased from online booksellers such as amazon.com and may be available on Books 24x7 for IBMers (w3.ibm.com/learning)).[Read More
The next DB2 Tech Talk
is in two parts and is about one of my favourite topics: DB2
Certification Prep for new DB2 10 Exam 610: DB2 10.1
Validate your DB2 skills by earning a Professional Certification from IBM. A Certification will
- Stand out with your employer
- Meet your annual skills objectives
- Gain an edge in the employment market
Attendees of this fall’s IOD
conference will once again be able to take DB2 certifications for free and
in November the “Take it Again” promotion will be active. In either case,
you’ll want to be prepared to pass the exam. Attend this TechTalk to help you
get prepared for Exam 610.
Part one is scheduled
for Thursday, July 26 from 12:30 – 2:00 pm ET. Part two is scheduled for
Thursday Aug 2 from 12:30 – 2:00 pm ET.
Together, the two parts will cover everything you need to pass Exam 610
- DB2 10.1 Fundamentals, including the following:
- Basics of the DB2 products and tools, DB2 pureScale feature, plus data
warehousing and OLAP concepts.
- Security, including authentication, authorization and privileges, and the
new Row and Column Access Control (RCAC) feature.
- Work with databases and database objects including use of DDL statements to
- Access data using SQL to query data using XML data with XQuery and use of
Time Travel Query with temporal tables.
- Work with tables, views, and indexes including XML and Oracle compatibility
data types and the new temporal tables.
- Data concurrency mechanisms.
This talk is hosted by Serge Rielau with DB2 instructor Andre
More resources about Certification that may help you:
It seems to me, given what I’m being sent in newsletters, that this is the time of year to give some thought to improving personal habits. The end of the year brings time for reflection on the year we just lived through and January is the perfect time to put in place new goals or plans for the coming year.
I like to discuss the articles I read with those who are closest to me at work and in my personal life, but in going through the list, I can’t see why these wouldn’t be of interest to a much larger audience. Here’s my list:
Five Things You Should Stop Doing in 2012 by Dorie Clark
I was drawn to this article by the title. Usually we think about what we’ll do better in the coming year, but doesn’t it make sense that you’ll need to drop something that you’re currently doing to fit in something you want to start doing. Face it, we only have so many hours in a day, so adding more to an already impossibly booked calendar makes no sense at all.
For me, email is becoming less relevant, so checking every 90 minutes makes sense to me and will allow me to focus on things that need full attention. I regularly unsubscribe to newsletters that are no longer interesting to me. I used to mail cards, but stopped a few years ago. There are still a few traditions that I take part in that could be dropped.
Dorie’s article points to another article that I liked:
Two Lists You Should Look at Every Morning by Peter Bregman
The lists Peter is talking about are 1) Focus list and 2) Ignore list. Doesn’t that make a lot of sense? I’m more of a social person than a gadget person, so Peter’s first story would never have happened to me. I’m more likely to make eye contact with everyone around me rather than giving my attention to my Blackberry. Figure out where you want to spend your time and consciously decide what you’ll ignore in order to focus on what you want to be focusing on.
Improve my Blogging Skills.
This one will only relate to those who are interested in blogging, but might actually coincide with the points above. Do you find that you repeat yourself over the course of a day or week, answering the same question, or giving the same advice to multiple people? If so, perhaps this content belongs in a blog where it can be shared among multiple people at once. If someone again asks the question, you can simply say.. read my blog!
Serge Rielau recently did this with his SQL Tips blog. Serge will benefit from writing this blog since he can put his effort into creating a well-written and thought out article about a topic that will benefit everyone who finds his blog and reads his tips. This is a much better use of his time than answering questions via email on a one on one basis.
If you are interested in blogging and want to learn how to do it the right way, the first time, I highly recommend this new book by Antonio Cangiano: Technical Blogging: Turn Your Expertise into a Remarkable Online Presence. I’ve been blogging for easily 6 years now and read this book as an official reviewer. I can tell you in all seriousness… that I learned a LOT. I haven’t put all the tips into practice yet, but I’m sure you’ll see my improvements over the coming year. Antonio has just created a blog about his book that you’ll want to subscribe to in order to get tips as he is able to share them: Technical Blogging.
I’m not sure if I’ve ever mentioned it in my blog or not, but I’m a huge fan of TedTalks.com. If you haven’t run across these videos yet, you’re in for a huge treat. TED is an acronym for Technology, Education, and Design. Three of my favourite topics in one. There are many recorded TED talks for you to find and watch that cover a huge range of topics. Here are a few of my all time favourites:
1) TEDxHampshireCollege - Jim Ferrell - Resolving the Heart of Conflict
Jim points out a bad habit that most of us have: treating people as objects. He explains why this is not the way you should treat people and gives examples to make the point clear. I would suggest that this is a video we need to re-watch many times over the course of a year to keep ourselves on track.
2) Salman Khan: Let's use video to reinvent education
The main thing I like about this video is the message that we need to master basic skills before we can try more complex ones. How many times do people try to jump ahead? Salman’s example about learning how to ride a unicycle after only a week on a 2-wheel bike shows the difficulty in not mastering lower level skills first. I also like how he’s developed something that is appealing to young children everywhere and makes learning seem like a game. I hope as a result, we’ll have a highly educated future population!
There are many TED videos for you to watch and enjoy. Warning: once you start, you may want to watch these videos all day long!
20 Things Life Is Too Short To Tolerate
These tips are pretty basic and we all know them very well. Unfortunately, we tend to forget or ignore them. Do yourself a favour. Take these tips seriously and see if they make you happier.
There are two other books that I regularly mention that are related to professional development.
1) Sam Lightstone’s Making it Big in Software. I found this book to be a good read and very helpful in thinking about the direction your career is taking. Here are a few of the blog entries I’ve written since the book was published:
Campus visit - how to improve technical writing skills
Wine and Cheese and Sam Lightstone at IOD
Meet author Sam Lightstone “Making it Big in Sofware”
Making it Big .... Live on the DB2Night Show!
Two live sessions coming up with author Sam Lightstone...
Making it Big in Software
2) Roger Sanders’ From Idea to Print: How to Write a Technical Book or Article and Get It Published. Writing, presenting, and communication are the soft skills that are required for all of us to succeed. I remember writing a blog entry about these at one point, but can’t find it now. I’m hoping to work with a colleague in the coming year to pull together a comprehensive list of how to improve communication skills for technical professionals.
I hope you’ve enjoyed this list and are able to have a productive and healthy new year!
Thanks to Data Warehouse experts Aruna De Silva and Enzo Cialini for putting together this latest Best Practice article. This paper is called "Active-Active Data Warehouse Topology using InfoSphere Warehouse" and explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.
As data warehouses are now continually growing in supporting Tier 1 applications, you need fully integrated disaster recovery architecture. Traditional disaster recovery (DR) strategies involve a passive DR site that is not accessible for processing. However, companies are looking to leverage the additional hardware and software investments made in creating this DR site.
The purpose of this paper is to provide an active-active environment for IBM InfoSphere Warehouse by using IBM DB2 Version 9.7 for Linux, UNIX, and Windows database servers to meet the increasing availability and performance requirements demanded in today's business environment. An active-active warehouse architecture addresses two distinct problem domains: continuous availability and disaster recovery.
WebSphere Edge Components, part of IBM WebSphere Application Server Network Deployment (ND) offering, are typically used to control client access to Web servers. In this paper, we demonstrate how Edge Components can be used to load balance DB2 clients among multiple DB2 coordinators based on performance metrics or access control rules.
In addition, we describe how Q-replication is used to maintain two identical copies of DB2 V9.7 data servers in an active-active DB2 data warehouse topology. Finally, we examine some of the challenges associated with operating an active-active DB2 data warehouse and strategies to mitigate those issues.
About the Authors:
Aruna De Silva is on the QA-DB2 Data Warehouse and IM Solutions team with IBM
Enzo Cialini is Senior Technical Staff Member, IBM
If this is your area of concern or expertise, read the full Best Practice Paper: Active-Active Data Warehouse Topology using InfoSphere Warehouse.
See also my previous posts on Best Practices:
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