Modified on by svisser1
Conferences are ideal for learning and networking This year at IOD, a new tutorial series has been created to help you do both. These are full day tutorial sessions that you can take either Sunday November 3 or Thursday November 7. There are 3 tutorials you can choose from. Each is a full day in length and is taught by an industry expert who is influential in the topic area.
Here are the 3 that are scheduled at this time. There is an additional fee for each and there is only limited space so we expect them to fill to capacity quickly.
Data Governance Fundamentals with IBM InfoSphere
Sunday, November 3
Sunil is the author of numerous books on data governance, including The Data Governance Unified Process, Selling Information Governance to the Business and others.
Evolving your Information Architecture; What? Why? How?
Dr. Peter Aiken
Thursday, November 7
Dr. Peter Aiken is widely acclaimed as one of the top data management authorities worldwide. In addition to examining the data management practices of more than 500 organizations, he has completed multi-year immersions with a range of diverse organizations in multiple industries. His latest book is The Case for the Chief Data Officer: Recasting the C-Suite to Leverage your most Valuable Asset.
Big Data, Hadoop, and Big SQL; A Crash Course
Dr. Vladimir Bacvanski
Thursday, November 7
Dr. Vladimir Bacvanski has more than two decades of engineering experience with software and data technologies in areas such as architecture and design of mission critical enterprise systems, rule-based systems, modeling tools, real-time systems, and database technologies. Vladimir is published worldwide and is a frequent speaker at leading industry events. He was awarded the title of IBM Champion for five consecutive years -- 2009-2013.
For more information on the sessions and the speakers, see bit.ly/iodtutorials
How to register
Visit ibm.co/IODtutorials and click the blue register button. This brings you to the main Information on Demand Conference page where you can register for the conference and also the tutorials. (Please note that if you are an IBMer, you will not see this list.)
To attend these sessions, you must be registered for the Information on Demand Conference. You can select the tutorial options you would like to attend as an add-on to your conference pass as part of the conference registration.. If you are already registered for the conference, then please contact the Registration / Housing line at 770-359-6591 to add one or more of these sessions to your conference registration.
Here is the screen to look for on the registration page:
Watch for coming blog entries that will describe sessions that you can choose to take while at the conference.
Performance Management 101 for DB2 for Linux ,UNIX, and WindowsIT'S ALL ABOUT PERFORMANCE!!
Attend FREE from your own computer
Performance Management 101 for DB2 for Linux ,UNIX, and Windows
Join this IBM developerWorks Live! virtual technical briefing and
learn about Integrated Data Management solutions from IBM.
Better performance translates to greater revenue, greater customer
satisfaction, and greater ability to meet SLAs. Tired of the finger pointing
among staff when performance is an issue? Find out how you can create exception
monitoring metrics, track and measure performance indicators, and quickly
diagnose performance problems when they arise. Use IBM DB2 Performance Expert
and Extended Insight Feature to make the process easier and more efficient.
Performance Management 101 for DB2 for Linux ,UNIX, and Windows
Date: Tuesday, 8 December
Time: 1:00 p.m. (New
Duration: 1 hour
What you will learn:
- The nature of performance issues and most common DB2 for Linux, UNIX and
- A performance approach and how tooling enables quick and accurate ways to
find the issues
- How to create and monitor more effective performance indicators to meet SLAs
and improve client satisfaction
- How to enable end-to-end database performance monitoring for Java
applications to isolate performance issues in minutes
- How to foster collaborative approaches to problem solving among IT staff
See you on Tuesday!!
It isn't due to publish until December, but the excitement for this book is already increasing. Pre-order the book from amazon.com now and get a 37% discount:
IBM DB2 9 New Features (Paperback)by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris EatonList Price: $39.99You Save: $14.80 (37%)
Part of the foreword, written by Dr. Ambuj Goyal:
As you dig into this treatise, you’ll be learning about one of the most innovative deliveries of information management capability in the last 25 years. Innovation like that doesn’t come easily. Including features like pureXML™, and “deep” compression capabilities, DB2 9 is the culmination of over 5 years of research, and comes as a result of more than 750 people and the resources from IBM research facilities collaborating across 8 countries. Our effort builds on IBM’s long string of database innovation, including the invention of relational database over 30 years ago.
You’ll learn the details of DB2 9 in this book. But just as important, each chapter attempts to position the data server innovation of DB2 9 and how that will enable the business innovation your company needs. Enjoy it!***
I've been working with all four authors for many years now and believe that they are the best people to deliver this type of information to you. I expect this book to be a very huge seller. About the authors:*Paul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technologies team. He has more than ten years of experience with DB2 products and has written numerous magazine articles and books about it. Paul has co-authored several top-selling books.*George Baklarz, B Math, M Sc (Comp Science) is a senior manager in the DB2 Worldwide Pre-sales Support Group. He works closely with customers to help them understand new Information Management technology and to gain their feedback for improving DB2 products. He has more than 20 years of experience with DB2 and has co-authored a number of books. In addition, he is a member of the International DB2 Users Group Speaker and Volunteer Hall of Fame. In his spare time, he lectures at the University of Guelph (Database Theory) and presents at a variety of user conferences, including the International DB2 Users Group.*Leon Katsnelson works in the IBM Toronto Lab where he manages a team of product managers responsible for the IBM DB2 UDB products. Leon is a recognized expert in the areas of DB2 application development and DB2 Connect. Leon has 20 years of experience with complex database and network systems. Leon has worked on DB2 Connect from very beginning and worked on this project as the product planner, development manager and product manager. He is often referred to “the father of DB2 Connect”.*Chris Eaton is Senior Product Manager for DB2 Universal Database primarily focused on planning and strategy for DB2 UDB. Chris has been working with DB2 on the Linux, UNIX, Windows platform for over 13 years. From customer support to development manager of the DB2 Control Center team to Externals Architect and now as Product Manager for DB2 UDB, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is also the author of The High Availability Guide for DB2 available from Prentice Hall.*Susan[Read More
My previous entry gave you an IBM view of the new InfoSphere Warehouse 10 and
DB2 10. This entry will give you a perspective from our IBM Champions.
- "We are most intrigued and impressed by the new and improved index and data
techniques. We anticipate that the new Index Jump
Scan technique will help minimize
the number of indexes needed on
any given table, and that this, in turn, will save disk
insert, update and delete performance, reduce lock contention, and
consumption. ETL processes and loads should also benefit. Individual results
and circumstances will vary, but data warehouse users might realize query
time improvements of 20-40% or more."
-- Scott R. Hayes,
President & CEO, DBI
- "With each release of DB2, I experience faster results with
- “The Adaptive Compression feature of DB2 10 offers my
clients an additional 12% disk
- “The DB2 10 Time Travel Query feature is valuable because
it gives business executives
an easy-to-understand history of data changes
over time. And business analytics run
faster, increasing the productivity of
company decision makers.“
-- Martin Hubel, President, Martin Hubel
- “We are excited by the arrival of IBM DB2 10. SAP has worked very closely
with IBM to
optimize DB2 10 for the use with SAP applications. New features
like simplified space
reclamation, enhanced HA capabilities
and Adaptive Compression will help reduce
operations cost even further.”
-- Dr. Torsten Wittkugel, VP DB/OS Platform Development SAP
- "Our customer, Holiday Extras, increased its travel business even in a
because of the high performance and lower
cost of IBM's technology. We're looking
forward to offering this
solution to our small and mid-size customers, who will reap even
business benefits from its improved features."
-- Iqbal Goralwalla,
Head of DB2 Midrange and Managed Services, Triton Consulting
- “With the new adaptive compression feature in DB2 V10.1, we
see up to 15% greater compression
over classic row compression alone.
Additionally, we benefit from not having to perform offline
reorganization when the data changes, as the page-level compression dictionary
and dynamically updated. This is a real improvement for
database administration, storage savings, and
- “The continuous data ingest feature of DB2 V10.1 allows us
to provide near real time data delivery
in our retail environment, something
that has historically been a challenge for us. I’m also impressed by
how easy it was to setup and use.”
-- Joachim Müller, DBA/DWA,
Douglas Informatik & Service GmbH
- "DB2 10.1 brings powerful optimization features to our customers that will
drastically reduce the need for tuning statements while simultaneously improving
performance. The new ZigZag join will reduce statement elapse
time for star schemas. The jump scan technology will allow for better use of
multi-column indexes, therefore eliminating the need for numerous indexes. By
minimizing the memory needed for hashing functions, the resource consumption on
sort heap is also drastically reduced. This makes DB2 10.1 a very
-- Jean-Marc BLAISE, IT solution
architect, DELTA DB
Attend IDUG in Denver the week of
May 13 to learn even more about this “talented” release! IDUG Denver – May 2012
There has been lots to read about DB2 pureScale in the past couple of weeks, but if you're like me... you've been too busy to read much of the press and are therefore missing some key information. I plan to attend the upcoming DB2 Chat webcast on Wednesday, Oct 21
so I can learn what I need to learn. I hope you can join too!
Here are the details:DB2 pureScale: Scaling Databases without LimitsDate
: Wednesday, October 21, 2009Time
: 11:30 - 13:00 Eastern
10:30 AM Central / 8:30 AM Pacific / 16:30 hrs London / 17:30 hrs Frankfurt, Paris / India 9PMPresented By
: Experts from Toronto Lab: Sal Vella
(IBM), Matt Huras
(IBM), Aamer Sachedina
DB2 pureScale is an integrated solution that provides virtually unlimited scalability for all your transaction processing needs while ensuring continuous database availability. It allows you to scale capacity dynamically to meet peak demands, and pay for only the resources you require. In this webcast experts from the IBM labs will share technical details about DB2 pureScale.
- Vice President, Matt Huras
- Distinguished Engineer, Aamer Sachedina
- Senior DB2 Architect,
to learn how you can scale your existing and new database applications transparently with DB2 pureScale.
Register for this webcast by using the following link:http://bit.ly/2BfXG
If clicking the above link does not work, please copy the entire link and paste it into your Web browser.
Modified on by svisser1
DB2 11 for z/OS Generally Available on October 25, 2013
Rather than me telling you about it, I’m sharing content from experts:
Say "Hello" to DB2 11 for z/OS from IBM Champion Craig Mullins
DB2 for z/OS: How Big is Big? from Robert Catterall
Are you looking for some excellent DB2 11 reading materials? from Willie Favero
And last, but not least, the latest Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics
By Cristian Molaro, Surekha Parekh, Terry Purcell & Julian Stuhler
This book is filled with
Business Value of DB2 11 in the new era of Computing;
Deeper insight into new functions and features of DB2 11;
Executive Summary of DB2 Tools & Utilities;
The objective of this book is to give our customers insight into DB2 11, which was announced on October 1, 2013. Everyone is talking about DB2 11. Many of our Early Support Program customers have been testing this product and are seeing some incredible results! Our customers and business partners around the world are very enthusiastic.
So what’s new in DB2 11 that is causing so much excitement? Here is a quick summary of some of the exciting new features and business benefits of DB2 11, about which this book will give you deeper insight:
• Even more out-of-the-box CPU savings
• Enhanced resiliency
Fewer planned outages, fewer REORGs, faster recovery
Cost-effective archiving, access warm/cold data in single query
DB2 Analytics Accelerator performance enhancements
Big data integration
In-transaction real-time scoring
Advanced QMF analytic capabilities with mobile support
• Simpler, faster upgrades for faster ROI
6x faster catalog migration
Protection from incompatible changes
Repeatable testing with real workloads and integrated cloning
The book is segmented into two parts. The first part is all about the business value of DB2 11 for z/OS and explains the unmatched efficiency for big data and analytics. This section also includes short papers on the DB2 11 Optimizer and the business value of IBM tools and utilities. The second section focuses more on DB2 and System z and how DB2 for z/OS can reduce the total cost of ownership for organizations. With the enormous explosion of data, this is more critical now than ever before. We hope you find this book as valuable as our previous versions.
Download your free copy today. Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics
For those attending IOD this year, stop by the IOD bookstore on Monday, Nov 4 to get your free printed copy!
What do you know about IBM InfoSphere BigInsights?
BigInsights brings the power of Apache Hadoop to enterprises. This means that by using InfoSphere BigInsights, you can manage and analyze data in ways that were previously unimaginable. You an extract deep insights that can lead to greater efficiencies, value-add services, and opportunity for transformation.
That’s not much to go on, but what I can tell you is if you’re interested in learning more, take advantage of the special one-day class on Sunday, October 23, 2011 in conjunction with the IBM Information on Demand 2011 Conference in Las Vegas, Nevada. Registration for the IOD Conference is NOT required to attend this Sunday class.
This one-day training course is for system administrators and developers responsible for managing Apache Hadoop. Not only will you learn about this new technology, but after you’ve taken the course, you’ll be prepared to take and the BigInsights Technical mastery test, which you can take for free at the IOD conference.
- Big Data Overview
- Introduction to Hadoop and HDFS
- HDFS Administration
- Introduction to Map / Reduce
- Setup of an Hadoop Cluster
- Managing Job Execution
- Overview of JAQL
- Data Loading
- Overview of workflow engine
More about the Mastery Exam: Test M97: IBM BigInsights Technical Mastery Test v1
This proctored technical mastery test examines IBM BigInsights knowledge regarding the ability to identify, manage and close sales opportunities.
The test is applicable to sales representatives who demonstrate sales and technical knowledge of the IBM BigInsights product and targets the technical sales professional who can deliver a comprehensive business solution to customers through solution identification, product differentiation, and competitive positioning.
This technical mastery test meets one of the technical requirements for SVP (Software Value Plus) and counts as a skill towards Advanced and Premier PartnerWorld Membership levels. It is strongly advised that the candidate complete the recommended education prior to attempting this technical mastery test.
- Number of questions: 39
- Time allowed in minutes: 75
- Required passing score: 76%
- Test languages: English
- Section 1 - BigData Overview (23%)
- Section 2 - Introduction to Hadoop (18%)
- Section 3 - HDFS Administration (15%)
- Section 4 - Setup of a Hadoop Cluster (18%)
- Section 5 - Managing Job Execution (8%)
- Section 6 - Overivew of JAQL (18%)
Other Pre-Conference Education available at IOD this year:
Other blog entries about IOD Events:
Flashbook: IBM DB2: The Past, Present and Future: 30 Years of Superior Innovationby Surekha Parekh, Terry Purcell, John Campbell, Ruiping Li and Don Haderle
About the book:
DB2 experts John Campbell and Terry Purcell have contributed to this
book, but as a special treat, we also managed to have Don Haderle - "The
FATHER of DB2" contribute to the book. This book is not only full of
RICH, TECHNICAL content but is will also be a "keepsake" for DB2 fans
For further information on the 30th Anniversary details, see Surekha’s blog: New Book To be Launched at IBM Information On Demand: IBM DB2: The Past, Present and Future
If you are attending the IBM Information on Demand Conference, get a free printed copy of this book at the Author Signing and Giveaway that is scheduled:
This is a limited edition book and limited copies will be printed so don't miss the book signing.
- Monday October 22, 12:30 – 1:30 at bookstore
the conference is over, a free e-version of the book will be available
for you to download. Follow my blog to ensure that you are one of the
first to know where you can download the book.
Other sessions by these authors:
# 2032A - IBM DB2 for z/OS Migration: Query Performance Considerations
- Islander A; Tue, Oct 23, 2012; 8:15 AM - 9:30 AM
# 1723A - Application Best Practices and Recommendations Specific to
IBM DB2 for z/OS Data Sharing - Islander A; Tue, Oct 23, 2012; 11:15 AM -
# 4012A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 1 - Islander A; Wed, Oct 24, 2012; 10:45 AM - 11:45 AM
# 4013A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 2 - Islander A; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
- Session # 3942B BOF: IBM DB2 for z/OS and Tools: Ask the Experts Panel - South Pacific F; Wed, Oct 24, 2012; 6:15 PM - 7:15 PM
# 1840A - Protecting Your IBM DB2 for z/OS Assets With Effective
Backup and Recovery Strategies - Islander A; Thu, Oct 25, 2012; 8:15 AM -
- Session # 1845A - Runstats Challenges for Optimal Query Performance - Islander B; Mon, Oct 22, 2012; 11:30 AM - 12:30 PM
# 3922B BOF - New SQL Function and Performance in DB2 10 for z/OS -
Bayside Dining IM BoF Tables 5&6; Tue, Oct 23, 2012; 12:45 PM - 1:45
- Session # 2049A - Do These IBM DB2 10 Optimizer Enhancements Apply to Me? - Islander B; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
# 3923B BOF - Query Performance Challenges with DB2 10 for z/OS -
Bayside Dining IM BoF Tables 3&4; Wed, Oct 24, 2012; 1:15 PM - 2:15
# 2054A - The IBM DB2 Analytics Accelerator Hands-On Learning Lab -
Shorelines B Lab Room 1; Thu, Oct 25, 2012; 9:30 AM - 12:30 PM
- Session # 2991A - Social Business for IT Professionals: Career Enhancements - Islander B; Mon, Oct 22, 2012; 3:45 PM - 5:00 PM
# 3921B BOF - IBM DB2 for z/OS e-Communities, Collaboration Groups
-Social Networking World - Bayside Dining IM BoF Tables 3&4; Tue,
Oct 23, 2012; 12:45 PM - 1:45 PM
Free printed IBM Redbooks at IOD
Look at all these great FLASHBOOKS that will be at IOD this year!
Look at all these great books that will be at IOD this year!
Get Certified at the IBM Information on Demand Conference
Bare Naked Ladies – at IOD
Nate Silver – book signing & speaker at IOD
Books published in 2012 – Featured Titles
Top 25 Books Sold at IOD2011
hope you enjoy this new book. Find out why DB2 is still growing after
30 year and how it is helping our customers to reduce costs and grow.
The web is wonderful, but the web is evil! Wonderful because it contains so
much content and evil because it contains so much content! It can be
overwhelming to navigate through the content and if you don’t immediately find
what you’re looking for, it is very easy to get distracted and forget what you
were looking for in the first place.
My intention for this blog entry is to help those who use the DB2 for z/OS
products find skills resources that are specific to you. I hope you find this
IBM Data Management Magazine
The next generation of IBM Data
Management magazine is available for you to read online. It has many great
articles, including regular columns by Bonnie Baker and Robert Catterall.
Version 10 books:
So far, two books have published to support DB2 V10… but there are more
Version 9 books:
Version 9 is still being used by many, so you may find this book useful as
“Flashbooks” are small-sized books that have fewer than 150 pages, and have
easy-to-read messages about products, solutions, or technology. Flashbooks are
published to coincide with conferences such as IBM’s Information on Demand
Conference or IDUG. The huge quantity of messages and content delivered at such
conferences makes it difficult for attendees to retain all the key messages.
Flashbooks are designed to contain the key messages IBM experts want you to take
away with you.
Flashbooks are handed out in print format at conferences and other events,
are available for free in ebook format from this site and can be purchased from
amazon.com or other online bookstores.
The ITSO is always busy creating technical publications to help you deepen
your knowledge and get hands on skills with IBM’s Information Management
products. Here are a few you may wish to look at:
9 for z/OS: Packages Revisited
Redbooks, published 2 Mar 2009,
last updated 3 Feb 2012, Rating:
(based on 7 reviews)
10 for z/OS Technical Overview
Redbooks, published 30 Dec
2010, last updated 6 Dec 2011, Rating:
(based on 3 reviews)
10 for z/OS Performance Topics
Redbooks, published 21 Jun
2011, last updated 6 Dec 2011, Rating:
(based on 3 reviews)
Find many more on the IBM Redbooks Website.
IDUG NA 2012 – taking place May
14-18 in Denver Colorado:
The IDUG conference taking place in Denver Colorado, May 14 – 18. This is
possibly the third time that the conference is in this location. It is an
attendee favourite for many reasons, including micro brew pubs, scenery, great
city – good vibe, restaurants, and ease for many people to get there.
For details, see this link:
Full-Day Educational Seminars at
the IDUG DB2 Tech Conference
The following topics are Select from these topics:
DB2 10 for z/OS DBA Certification Crammer Course: Susan Lawson,
This course is a certification preparation course intended to
help you take DB2 9 Family Fundamentals exam (730) and DB2 10 for z/OS Database
Administration exam (612). Passing of these exams will result in certification
as an IBM Certified Solutions Expert - DB2 10 z/OS Database Administration.
Participants are expected to have fundamental knowledge of relational principles
in addition to applied working knowledge of DB2 9 for z/OS and basic knowledge
of DB2 10 features. Susan’s latest book will also be available, for sure before
the conference and hopefully at the conference.
Recommended Best Practices from Customer DB2 Health Check Studies:
John Campbell, IBM DB2 for z/OS Development
This one day
seminar will introduce and discuss the major lessons to be learned from customer
DB2 Health Check Studies carried out by DB2 for z/OS Development and provide
recommended best practices in each area. The objectives are to: introduce and
discuss the most common issues, share the experience gained from customer health
check studies, share the experience from live customer production incidents,
provide proven recommended best practice, and to encourage proactive behavior.
The following topics will be covered: WLM Policy Setup, Balanced Design across
CICS and DB2 Disaster Recovery, use of Flashcopy, Continuous Availability vs.
Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups.,
Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs.
Restart Light, Storage Tuning. Download John’s Flashbook for free: DB2
for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance (3.36MB)
I Didn't Know DB2 did THAT!: Bonnie Baker, Bonnie Baker
Have you ever wondered what goes on inside DB2 when your SQL is
being executed? This seminar is designed to answer exactly that question and
more by taking a look at DB2 Components and the Optimizer's instructions for
various SQL access paths. While simple paths will be reviewed, this class will
also focus on those difficult to understand access paths. Topics include RIDPOOL
failures, Hybrid Joins and a "Type C" Hybrid Join, coding both a GROUP BY and an
ORDER BY on the same columns to insure that my GROUPs are returned in ORDER,
using a 64-partition DPSI for SORT Avoidance, how does DB2 know if Index-Only
data is "clean" or "dirty", result sets built at OPEN CURSOR, DSNZPARMs affects
on access path selection and operation and much, much more!
Certification for DB2 is the MOST popular certification
program in IBM! Not everyone who uses DB2 is IBM Certified yet, but the version
10 exams are available and is a great place for you to jump on board. Here is
an offer for getting certified for half price as well as some information on how
to started on your path to getting certified:
The DB2 for z/OS community is heavily into blogs. I’ve had the pleasure to
work with Willie Favero and Surekha Parekh on presentations about social media.
Here are some of the bloggers you may wish to follow:
My apologies if I missed your blog! Drop me a line and I’ll make amends
More and more people are getting on twitter. If you’re not yet…
the one thing you should know about twitter is it is great resource for up to
the minute information. You don’t need to tweet anything yourself… you can
simply follow others to hear what they’re saying. In a single location you can
get news about your favourite products, rock stars, world events, and more.
Here are a few twitter handles you may wish to follow.
Suggestion… check out who these people are following. That will give you
suggestions as to who else you may wish to follow.
Communities are a way for you to participate in conversations with other like
minded people. You’ll find lots of resources, news about events, and perhaps
access to experts.
Is there More?
Yes, there is more. Much more. I didn’t even begin to cover the courses
offered by IBM Education. I hope what I have provided is helpful and I’ll
update this page when I have more to add.
and Roger Sanders
are continuing their series of sample questions to help prepare people to pass Exam 730: DB2 9 Family Fundamentals.
Here is the latest in the series:IBM DB2 9 Fundamentals certification (Exam 730): Sample questions No. 5 and No. 6
Just a reminder that publisher MC Press is the first time publisher of DB2 Certification Study Guides and will have 5 in the series. One book was published earlier this year, three more will publish in the next month, and the fifth one will publish early next year. Here are the titles and the links:DB2 9 Fundamentals Certification Study Guide
(MC Press) by Roger Sanders
. On Sale: $37.77DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732
(MC Press) by Susan Lawson and Dan Luksetich
- October - On Sale: $40.92DB2 9 Database Administration Certification Study Guide for Exam 731
(MC Press) by Roger Sanders
- October. On Sale: $38.95DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736
(MC Press) by Roger Sanders
. On Sale: $24.95
The fifth one in the series is a group effort by Roger Sanders
and Dwaine Snow
and will cover the material you need to pass Exam 734: DB2 9 Advanced Database Administration. Roger tells me that he and Dwaine are nearly finished writing and will soon be able to get the book into editing, indexing, and all the other steps that are part of the book publishing process.
Modified on by svisser1
I think many who read my blog know that I work in the Toronto Lab. I can’t imagine a better place to work. Not only because Canada and Toronto are such great places to live, but because the Toronto Lab is filled with people who I really like to work with. Every day I’m able to talk with brilliant, creative people, who you may only know from videos, blogs or conferences. I can’t tell you how lucky I am!
You may have seen some of the videos in this series put together and hosted by Paul Zikopoulos. He created 14 videos in total and it is part of my job to release one video a week. We release the videos on Tuesday mornings, and the very talented Chris Eaton blogs about each video and embeds it into his blog. All the stars of the videos work from the Toronto Lab and are part of the DB2 Development team. Take a look at the videos and Chris’ blog entries to see what I mean about the fun we have working here:
Video # 1
Martin Wildberger, IBM VP of Information Management Development, takes us through the extraordinary innovation behind the creation of BLU Acceleration. He kicks off a new video series that will introduce you to key members of the BLU Acceleration development team and share insider tips on improving performance and increasing speed. Watch video. Read blog from Chris: DB2 10.5 and BLU Acceleration
Video # 2
In this FAQ, IBM Fellow Tim Vincent and IBM VP Paul Zikopoulos discuss the technical genius of DB2 with BLU Acceleration. They discuss how columnar, simplicity, actionable compression, core-friendly parallelism, vector processing or SIMD, cache friendly, and data skipping provide synergy to optimizing performance for all the data you have in your database. Watch video. Read blog from Chris: BLU Acceleration and 7 Big Ideas
Video # 3
Paul Zikopoulos talks with Master Inventor Sam Lightstone in this video called “Actionable Compression in DB2 10.5 with BLU Acceleration”. BLU compression allows you to work on the data while the data is still compressed. This is changes the game! Find out more by watching video. Watch video. Read blog from Chris: Actionable Compression in DB2 10.5 with BLU Acceleration
Video # 4
Paul Zikopoulos and performance expert Jessica Rockwood discuss how DB2 with BLU Acceleration teams with IBM Cognos to deliver blazing fast analytics in this video. Hear how the two integrate seamlessly for "fast on fast" performance. Watch video. Read blog from Chris: How DB2 10.5 with BLU Acceleration Speeds the Analysis for Cognos Users
Video # 5
Chris Eaton and Paul Zikopoulos compare Columnar index on SQL server with BLU Acceleration technology. Find out how using BLU Acceleration can help you get all the benefits of real-time ingest with the ability to do columnar in-memory analytics. Watch video. Read blog from Chris: IBM DB2 10.5 with BLU Acceleration vs Microsoft SQL Server Columnar Index
Video # 6
Paul Zikopoulos and Chris Eaton discuss how IBM DB2 10.5 compares to Oracle Exadata. They discuss 1) Hybrid columnar in Oracle Exadata versus true columnar storage that you’ll find in IBM DB2 10.5 with BLU Acceleration and 2) Actionable Compression in BLU versus the various compression strategies found in Oracle Exadata. Watch video. Read blog from Chris: IBM DB2 10.5 with BLU Acceleration vs. Oracle Exadata
Video # 7
How does DB2 10.5 with BLU Acceleration stack up against niche vendors like Vertica, Actian, and Vectorwise, Amazon RedShift? Listen to this 10 minute conversation between Paul Zikopoulos and Chris Eaton to find out. Watch video. Read blog from Chris: IBM DB2 10.5 with BLU Acceleration vs. Niche Columnar Vendors
If you want more information about how DB2 competes, be sure to attend Chris’ Tech Talk: DB2 BLU Acceleration Competitive Discussion
Video # 8
What is column organized table storage? And why does it do wonders for improving performance and memory efficiency? Find out by watching this video conversation between Paul Zikopoulos and Sam Lightstone. Watch video. Read blog from Chris: Column Organized Table Storage in DB2 10.5 with BLU Acceleration
Video # 9
DB2 provides ease of use, right out of the box. DB2 with BLU Acceleration was designed as a load and go database with little complexity or human cost. Chris Eaton discusses simplicity with Usability Expert Rick Sobiesiak. Watch video. Read blog from Chris: Simplicity in DB2 10.5 with BLU Acceleration
Video # 10
BLU Acceleration was designed with a new page replacement algorithm, the Scan Friendly Victim Selection algorithm, that improves workloads with large table or column scans. Adam Storm and Chris Eaton discuss in detail. Watch video. Read blog from Chris: Scan-Friendly Caching in DB2 10.5 with BLU Acceleration
Video # 11
Paul Zikopoulos and Chris Eaton discuss how the in-memory feature of IBM DB2 10.5 with BLU Acceleration compares to that of Oracle 12c. Listen to Paul and Chris talk about how Compression, Data Persistence and Availability compare to the new option from Oracle. Watch video. Read blog from Chris: IBM DB2 10.5 with BLU Acceleration vs. Oracle 12c In-Memory Option
"When RAM is too slow: How 'Dynamic In-memory Processing' changes the game for data analytics" by Sam Lightstone http://bit.ly/181zJ55tion
Don’t miss a single video by subscribing to our channel:
DB2 10.5 with BLU Acceleration YouTube Channel
Last week’s blog entry Budgeting for IDUG North America conference as viewed by the DB2 Locksmith by guest Rebecca Bond was very popular, so I’ve asked Rebecca back for a second entry. Actually Rebecca did one for me like this last year as well. I figure that DBAs would benefit more if they hear from a DBA saying what sessions she plans to attend rather than me telling you what sessions are available for you to attend. Rebecca is on the LUW platform, so I’ll try to find a willing guest blogger to do something similar for the z/OS platform so that I’m able to satisfy as many people as possible.
I heart IDUG NA. It’s like a geeky vacation where I learn much, smile and laugh a lot with old and new friends and go home armed with a suitcase full of technical material. This year is especially exciting since I’m going to be presenting two sessions and will be one of the featured speakers for the Dine Around!
As I do almost every year, I plan to take advantage of the free certification testing. I place great value in DB2 certifications and can certainly see evidence on job boards that employers prefer certified employees. The fact that I can take these exams for free helps makes the conference registration cost a bargain.
Monday, May 2 offers Full Day Seminars presented by DB2 Rockstars. True, these are not free, but given that they are being delivered by experts, these seminars offer great benefit for the price. If you are also registered for the full conference, you can add on one of these seminars for $425. See this link for a list of Rockstars and Full Day Seminars. I have some personal plans for Monday, so I will not be able to attend a full day seminar this year.
Typically, I approach planning my conference agenda from the standpoint of “what information will best help with my current job?” This year, however, I’m looking at it from “what sessions are going to be most valuable to increase my DB2 knowledge as I look for my next job?” This time, I’m looking for sessions that will help round out my resume.
The keywords for me for this IDUG are:
pureScale, Performance Tuning, XML, Cloud, and, of course, Security.
The good news is that there are plenty of opportunities to attend sessions on these topics. The bad news is that there are plenty of opportunities to attend sessions on these topics. Until I can get a personal DB2 Locksmith clone (no, not a database clone), I am going to have to make some difficult decisions about which sessions to attend in person. All is not lost, however, since I will definitely download the handouts from all the sessions for later review. I believe that recordings of most of the sessions will be available to attendees after the conference wraps up. So, I won’t really miss anything, I’ll just postpone taking advantage of some of the information.
I have to say though, this year is especially tough because I’ve heard most of these speakers before and I know how good they are. There are SEVERAL Best Speaker award winners in the group. I think Scott Hayes said it best, “DB2’s Got Talent”! That is an equally fitting designation for this year’s IDUG speaker list. (By the way, the winner of the first ever DB2’s Got Talent competition will be at IDUG!)
I’m not going to list my full agenda, because I like to keep a few secrets, or at least that’s my cover story. The truth is I simply cannot decide, but here are some sessions that are high on my personal list of “musts” this year.
Tuesday, May 3:
General Session: Jeff Jonas, Chief Scientist, IBM Entity Analytics and IBM Distinguished Engineer
S02: Choose DB2 LUW and Save Your Company Money, 10:15, Tim Vincent
F01: DB2 and Cloud Computing: Why Should I Care? 12:45, Leon Katsnelson
G02: DB2 LUW Security -- What If Your Firewall Catches Fire, 2:00, Rebecca Bond (DB2 Locksmith)
D03: Best Practices in Action -- The IBM Smart Analytics System, 3:15, Eddie Daghelian
C04: Understanding and Tuning Page Cleaning in DB2, 4:30, Matthias Nicola
Wednesday, May 4:
D06: The Latest from the Lab on DB2 pureScale - Part 1, 9:45, Matt Huras
D07: The Latest from the Lab on DB2 pureScale - Part 2, 11:00, Matt Huras
E08: Real-World XML Application Development Patterns for DB2, 2:45, Fred Sobotka
Thursday, May 5:
C10: Improve Performance by Analyzing DB2 LUW Access Strategies, 9:45, Melanie Stopfer
D11: Workload Optimized Systems - Don't Run a Marathon in High Heels, 1:30, Chris Eaton
Friday, May 6:
G14: Security Secrets for DB2 LUW DBAs, 9:15, Rebecca Bond (DB2 Locksmith)
G15: Monitoring and Troubleshooting Distributed Access to DB2 for z/OS, 10:30, Cristian Molaro
Of course, I also have to find time to meet friends, have interesting technical discussions in the hall, visit the expo, perform the “exchange of business cards ritual” and find some time to get in a run or two. It is certainly going to be busy week, but it will also be a highly educational and entertaining one. When you see me, I hope you will say “Hi” and let me know how you approached choosing your agenda.
Thanks Rebecca! I must say I’m feeling quite sad that I won’t be there! I’ll send all my friends to your Dine Around Night.
I’ve been a fan and a contributor of developerWorks since it first began. I’m gaining a whole new
appreciation for this major competitive advantage: I’m a temporary member of
the dW team while one of the brilliant editors is on a leave. I must say, I
have huge shoes to fill, but I’m lucky that the team surrounding me is very
I want to share with you some of what I’ve learned in the past week and
encourage you to “live” on the dW site!
Stay in touch
Are you following developerWorks on twitter? – More than 57,000 are following,
so if you’re not, start following so you can also benefit from the information
Ditto for developerWorks on Facebook: Get information and join the
The developerWorks newsletter has world-wide coverage, plus local
editions in Russia, Korea, Japan, China and Brazil. Subscribe and you’ll find a
list of the articles that were most read in the past week as well as a spotlight
on new content that the dW team thought you’d find valuable.
In this week’s edition you’ll find a link to the 2012 Tech Trends Survey. Take the survey and watch for the
resulting report: what are people most interested in technology-wise, right
Become a member of the developerWorks community
If you have not already done so, register and create a developerWorks profile. It will enable you to connect and
collaborate with other developers and to use any of the applications available
to members of the developerWorks community, including blogs, wikis, groups, file
sharing, activities, and bookmarks. If you’re an author, you can be notified
and when a reader leaves a comment on your article. You can learn more about
these applications and how to use them to become a vital member of the
developerWorks community at http://www.ibm.com/developerworks/xml/community/newto/index.html.
Write an Article
Do you have a deep technical article that you want to publish about an IBM
product, industry trend or another technical topic? A good choice is to publish
on developerWorks so it can be reach a very larger audience. Submit your
proposals here and have the opportunity to work directly with one of our editors
to get it published! developerWorks has an audience of more than 4 million
unique monthly users so this is a great way to get lots of exposure!
Interested? Send in a proposal.
Check out the content wish list to get some ideas on what you could write
You can also receive professional recognition for your developerWorks
publishing achievements. See the IBM developerWorks Author Achievement Recognition Program for
Should you write an article or blog entry?
As you can see, if you are a member of the developerWorks community, you have
many options for sharing information. The obvious choices for sharing content
is either via a blog or an article. My blog is on developerWorks and I’m very
pleased to have the opportunity to share my thoughts on a variety of subjects,
whenever I choose. Which should you choose? I found this information Articles vs Blogs - Are They the Same? that may help you make
- Articles can vary greatly in their length, usually consisting of anywhere
between 500 and 2,000 (or more!) words.
- Articles are often meant to inform and are more formal in their
- Articles are detailed, informative, and fact-based.
- Blogs are shorter and are usually 200 – 500 words in length.
- Blogs are more casual and provide a great way to personally connect with
- Blogs provide a personal, inside point of view.
- Blogs are (expected to be) updated more frequently than articles.
Find valuable content on developerWorks
Whenever I spend time on developerWorks, I’m awed at the sheer volume of
content that is available. Beyond articles and blogs, you can find free
downloads, tutorials for preparing for certification exams, resources for people
new to this area of technology, information about bootcamps, best practices,
migration toolkit, DBA central, technical briefings, skills e-kits, e-books, and
a variety of demos.
All this content is free! Can you think of a better place to go for valuable
I’ve known this for the last week, but haven’t been able to blog about it till today! The authors of Freakonomics and SuperFreakonomics will be special guest speakers at this year’s IBM Information on Demand Conference. They are scheduled to speak at the General Session on Wednesday morning.
We’ve managed to arrange for Stephen Dubnar and Steven Levitt to come to the bookstore for attendees to get their books signed… the unfortunate things is that they only have 20 minutes available for the signing! Add this book signing to your schedule via the Smart Site Agenda Builder. Their session is Anc # 3779.
Have you read the books yet? I have listened to both books in audible versions and can speak endlessly about how much I enjoyed the stories in their books. I will purchase both copies in printed format so I can get these amazing authors to sign them!
About the books:
Which is more dangerous, a gun or a swimming pool? What do schoolteachers and sumo wrestlers have in common? Why do drug dealers still live with their moms? How much do parents really matter? How did the legalization of abortion affect the rate of violent crime?
Four years in the making, SuperFreakonomics asks not only the tough questions, but the unexpected ones: What’s more dangerous, driving drunk or walking drunk? Why is chemotherapy prescribed so often if it’s so ineffective? Can a sex change boost your salary?
I’m very interested in hearing what they have to say to an IBM audience. I presume it will be related to IBM’s Smarter Planet initiative… which really is looking at the world in a different way much as the freak guys did in their books.
find it interesting to see what people buy at a bookstore. Personally I
love bookstores and online book sites. I can spend hours researching
bookstore at the IBM Information on Demand conference was very busy
this year, and I’ve put together this blog to tell you want others were
buying. The biggest seller was Nate Silver’s book The Signal and the Noise: Why So Many Predictions Fail-but Some Don't.
The best selling book at a conference tends to be one from a special
guest. Nate was quite the guest to have given his predictions in the US
election that happened shortly after IOD ended. I listened to the
audible version of the book and quite enjoyed it. The book has a
chapter for each area where predictions are normally made: weather,
earthquakes, stock market, baseball, poker, and elections. Nate fully
describes the reason why predictions either work or don’t work for the
area. You’ll instantly be connected to the story and will learn how
predictions can be made more accurate in this case and how you can
improve predictions that you need to make yourself.The next biggest seller was Sunil Soares’ latest book Big Data Governance: An Emerging Imperative.
The store sold out of Sunil’s book, so clearly Sunil did a great job
putting this book together. I haven’t read it yet, but would like to. Read a sample chapter from the book.
Governance and Big Data are both huge and important topics, so take a
look. Sunil’s first book also made the top 10 list: Selling Information
Governance.Next was the book by Jeff Ma, The House Advantage: Playing the Odds to Win Big In Business.
If you watched the movie “21” with Kevin Spacey, you’ll remember Jeff
Ma as the lead MIT student who counted cards. If you attended Jeff’s
talk at IOD, you learned that Jeff played a dealer in the movie. I
think I need to rewatch the movie!Cognos books sold very well this year! Four different Cognos titles made it in the top 10 list: and since the conference, a few more Cognos books were published:And the top selling IM books this year were:Note, if you’re in Europe, I’ve written a blog to help you figure out what online sites give you the best prices: I’m in Europe: How can I get a copy of that book?Susan