database expert is in a critical position to become a hero in this big
data era. Why? Because you know data.. you know your database. Now you
need to know how to expand your knowledge to find the secrets lying
dormant in your awesome data.
help you, I'm posting this podcast which is a conversation between
database expert & IBM champion Jean-Marc Blaise and Big Data expert
Leon Katsnelson. Perhaps you have the same question? Listen & find
Beyond this podcast, we have many other resources available to help you with your learning curve.
First I’ll start with some excellent books.
Big Data: A Revolution That Will Transform How We Live, Work, and Think
by Viktor Mayer-Schonberger, Kenneth Cukier
thought the book was very well written and covered the history of data,
the advent of big data, and what we need to do differently to profit in
this new era.
things will be different. As the author hinted and IBM CEO Ginny
stated, big data is like oil was in the industrial age. Lots of things
changed then to cope with the precious resource and it is no different
stories about current big data successes are inspirational and the
authors make it clear that the untapped potential of data is massive.
Don't let this potential slip out of your hands. Learn what you can now
to see what you can harness from this incredible asset you have in your
highly recommend the book. It is a quick read. If you only have time
for 1 chapter, read chapter 10. It does a nice job of summarizing all
the concepts and issues introduced in the book.
by Paul Zikopoulos, David Corrigan, Tom Deutsch, Krishnan Parasuraman, James Giles, Dirk Deroos
an overview of the IBM Information Management Big Data platform. It’s
intended for a broad audience, ranging from those who are brand new to
Big Data, to those on the business and management side, to architects,
and to developers who want a glimpse into the technical details that
underpin this platform.
by Dr. Arvind Sathi
book discusses three perspectives on Big Data Analytics. First, why is
Big Data Analytics becoming so important and what can we do with it.
Second, it lists major components of Big Data Analytics - Unstructured
Data Analytics, Massively Parallel Processing, Adaptive Real-time and
Predictive Modeling, Data Privacy Management, Data Visualization, and
Ontologies. Third, it provides a glimpse at implementation concerns and
how they must be tackled.
written a few blog entries in the past few weeks that summarizes blog
entries and articles that come recommended in your journey to learn
about Big Data:
What are you sacrificing for the promise of big data?
Reading list mined from "Getting Control of Data in Big Data Era" Tweetchat
Recommendations mined from Tweetchat about Mobile Data
Likely the best place for you to keep up to date with all the great things that are happening from a Big Data perspective is the Big Data Hub.
The breadth of content that you’ll find here will keep you busy for
some time. Let me tell you, you’ll be an expert in Big Data very
Upcoming events to mark on your calendar:
Before March 25 - Tell us your most important big data issues in a fun with with IBM’s Smart Sixteen - Big Data Style! See Big Data Bracketology for a description of the “Smart Sixteen” teams in the big data dance by the four regions.
March 27 at 12:00 noon ET - Join
us for our next tweetchat which takes place on Wednesday, March 27 at
12:00 noon ET. Topic is "In-Memory for Big Data Management" with
panelists: James Kobielus, analysts from Wikibon and SiliconANGLE, and
IBM Champions Alex Philp, Cristian Molaro, Craig Mullins, Cuneyt Goksu
April 30 - Big Data at the Speed of Business - Find out more about managing big data, join IBM for a free event.
Are you an expert who would like to share your knowledge with a world-wide
and large audience? If yes, I would suggest that you submit a proposal to speak
at the IBM Information On Demand 2012 Conference to be held
October 21-25, 2012 in Las Vegas, Nevada.
This conference provides in-depth technical education through an agenda that
includes Information Management, Business Analytics and Enterprise Content
Management. The Business Leadership program also addresses strategy issues and
the industry challenges facing today’s business leaders. The call for speakers
is open now http://ibm.co/IODspeaker until Friday, April 13,
2012 at 5:59 pm Eastern time.
Proposals are being accepted for the following programs:
We’re looking for best practices
and case studies to be featured in all of the above tracks. Details and
guidelines can be found on this page: http://ibm.co/IODspeaker
Why this conference?
- The conference attendees come from around the world and it’s expected
that more than 11,000 business and technology leaders will attend to experience
four days of in-depth education.
- The Business Leadership program addresses strategy issues and the industry
challenges facing today's business leaders.
- More than 700 sessions will be offered and we welcome your proposal that
highlights how IBM technologies and solutions help
leverage information to
gain insight and drive business results.
- Technical sessions will cover products, solutions, and implementations
including Hands On Labs. These sessions target IT professionals, DBAs,
architects, developers and programmers.
Why become a speaker?
- To share your expertise.
- To be seen as an an expert in your area.
- If you’re an author, to promote your book.
- To save on the conference fee to attend the conference.
- To network with like-minded professionals.
I’ve worked at every IOD conference that IBM has ever put on and I must say
that I love going to these conferences because of the energy, range of topics,
and the caliber of the speakers.
Recently published: The New Era of Enterprise Business Intelligence
Using Analytics to Achieve a Global Competitive Advantage
By Mike Biere
This year at the IBM Information on Demand Conference, Mike is a speaker at several sessions and will be signing copies of his latest book. Mike’s signing session is scheduled for Wednesday, October 27 from 11 am – noon. Add this book signing to your schedule via the Smart Site Agenda Builder. His session is Anc # 3619B.
About his latest book:
A Complete Blueprint for Maximizing the Value of Business Intelligence in the Enterprise
The typical enterprise recognizes the immense potential of business intelligence (BI) and its impact upon many facets within the organization–but it’s not easy to transform BI’s potential into real business value. In The New Era of Enterprise Business Intelligence, top BI expert Mike Biere presents a complete blueprint for creating winning BI strategies and infrastructure, and systematically maximizing the value of information throughout the enterprise.
This product-independent guide brings together start-to-finish guidance and practical checklists for every senior IT executive, planner, strategist, implementer, and the actual business users themselves. Drawing on thousands of hours working with enterprise customers, Biere helps decision-makers choose from today’s unprecedented spectrum of options, including the latest BI platform suites and appliances. He offers practical, “in-the-trenches” insights on a wide spectrum of planning and implementation issues, from segmenting and supporting users to working with unstructured data.
• Understanding the scope of today’s BI solutions and how they fit into existing infrastructure
• Assessing new options such as SaaS and cloud-based technologies
• Avoiding technology biases and other “project killers”
• Developing effective RFIs/RFPs and proofs of concept
• Setting up competency centers and planning for skills development
• Crafting a better experience for all your business users
• Supporting the requirements of senior executives, including performance management
• Cost-justifying BI solutions and measuring success
• Working with enterprise content management, text analytics, and search
• Planning and constructing portals, mashups, and other user interfaces
• Previewing the future of BI
This is not Mike’s first book. Also from Mike:
2003’s Business Intelligence for the Enterprise
and Flashbook: New Intelligence for a Smarter Planet: Driving Business Innovation with IBM Analytic Solutions
Modified on by svisser1
IBM InfoSphere: A Platform for Big Data Governance and Process Data Governance
by Sunil Soares
ISBN 978-1583473825, MC Press, February 2013
Governance has taken a backseat to the analytics and technologies associated with big data. However, as big data projects become mainstream, we anticipate that privacy, stewardship, data quality, metadata, and information lifecycle management will coalesce into an emerging imperative for big data governance.
Foreword from David Corrigan, Director, Product Marketing, InfoSphere
The importance and the role of a governance strategy are still not well understood. Information Governance is a business strategy that has a series of IT deliverables. Sunil has been one of the pioneers in this area, defining the Unified Information Governance Process several years ago. He defined several key steps, such as identifying a business problem and executive sponsor, setting up cross-functional governance boards, and measuring and communicating success. He has applied this process at hundreds of clients and has helped them achieve successful implementations. His approach can also be applied to governing big data. It has helped many organizations get the business involved in governance and establish trusted information for a key enterprise application.
In short, this process helps you move beyond an IT project toward a true business strategy. It helps by getting business executives and owners involved in the process of governing data. It helps ensure successful outcomes. Sunil, thank you for continuing to contribute to the discipline of Information Governance and move it into the new era of computing—the era of big data.
And to the readers of this book, remember that the competitive advantage you seek from insights garnered from big data has two components: big data analytics and trusted information. Information Governance creates trusted information from very uncertain sources, enabling you to trust and act upon the insights from analytics. I wish you well in your big data strategy.
Sunil’s other books:
The IBM Data Governance Unified Process (MC Press, 2010)
Details the 14 steps and almost 100 sub-steps to implement an information governance program. The book has been used by several organizations as the blueprint for their information governance programs and has been translated into Chinese.
Selling Information Governance to the Business: Best Practices by Industry and Job Function (MC Press, 2011)
Reviews the best practices to approach information governance by industry and function.
Big Data Governance: An Emerging Imperative (MC Press, 2012)
Discusses the governance of different types of big data.
Congratulations to Sunil on this latest book!
I’m aware of three important webinars that are planned for the next few weeks that you should consider attending:
First– DB2Night Show – Friday Sept 24
As usual, join Scott Hayes the host of the DB2Night Show for some very entertaining learning… for free! Next week on the DB2Night Show: DB2 LUW Recovery Planning & Best Practices.
Failing to Plan is Planning to Fail. Watch the DB2Night Show Friday 9/24 to learn about DB2 LUW Recovery Planning & Best Practices. Experts Dale McInnis and Kate Kurtz from IBM Toronto have much information to share that this topic.
Last week’s show with Mike Winer had record attendance. Did you miss it? No worries! Scott keeps recordings of all the shows, so go through and watch all the ones you’ve missed. If you’re new to this series, you might be surprised at the variety of guest speakers that Scott has worked with! Visit http://www.DB2NightShow.com for details and FREE registration links.
Second – Tuesdays with Craig – begins Tuesday Sept 28
SoftwareOnZ is sponsoring a series of DB2 webinars presented by Craig S. Mullins (author of DB2 Developer’s Guide and regular columnist for zJournal Magazine). Each webinar will be focused on a specific DB2 topic so you can pick and choose the ones that are most interesting to you – or attend them all and receive a certificate signed by Craig indicating that you have completed the DB2 Education Webinar Series. The first one is:
September 28, 2010 – DB2 Access Paths: Surviving and Thriving
Third– Chat with the Lab – Wednesday Sept 29
This webcast provides and in-depth overview of High Availability (HA) options for DB2 on Linux, UNIX and Windows.
It covers various HA features and enhancements added to DB2 during the last few releases, including:
- High Availability and Disaster Recovery (HA)
- Integrated High Availability and Automated Failover
- Read capability on Standby Servers
The Chat will also touch on future directions.
To learn more and get your questions answered, join experts from IBM labs - Sal Vella, (VP) and Dale McInnis (HA Architect).
Presentation charts for this Chat will be available for download from ibm.com/db2/labchats 1-2 days prior to the event.
Date: Wednesday, September 29, 2010
Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 9 PM
Speakers: Sal Vella (IBM), Dale McInnis (IBM)
Host: Rav Ahuja (IBM)
To register and receive instructions for attending this webinar, point your browser to:
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
Thanks to all the great people who put together this important education!
Roger is taking part in three highly accessible events that are taking place at IOD this year:
What’s in the book?
- Read this book to prepare to pass Exam 541 – DB2 for Linux, Unix, Windows Database Administration.
- All test objectives for this exam are covered in the same degree as they are covered on the exam.
- Roger was a member of the exam development team, so if fully aware as to what questions are on the exam!
- This book isn't like Roger’s previous books, rather this is a copy of the slides that he uses for his Crammer Courses to teach people at conferences what they need to know to pass the exam. The material has been tested multiple times and updated based on feedback from people after they’ve taken the exam.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives. You can see the details on the website: Exam 541 Objectives
Section 1 - DB2 Server Management (10%)
- Demonstrate the ability to configure/manage DB2 servers, instances, and databases (e.g. scope)
- Demonstrate the ability to schedule jobs
- Demonstrate the ability to use autonomic features
Section 2 - Physical Design (20%)
- Demonstrate the ability to create a database and manipulate various DB2 objects
- Demonstrate knowledge of partitioning capabilities
- Demonstrate knowledge of XML data objects
- Demonstrate knowledge of compression
Section 3 - Business Rules Implementation (5%)
- Demonstrate the ability to create constraints on tables
- Demonstrate the ability to create views WITH CHECK OPTION
Section 4 - Monitoring DB2 Activity (15%)
- Demonstrate the ability to use Admin views and SQL functions for monitoring
- Demonstrate the ability to use Work Load Manager
- Demonstrate the ability to use additional auto-monitoring tools
- Demonstrate the ability to identify the functions of Problem Determination Tools
- Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 - Utilities (15%)
- Demonstrate the ability to use the data movement utilities
- Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
- Demonstrate the ability to use the DB2 Advisor utility
- Describe the purpose of Data Studio Administrator (basic concepts - replacing existing DB2 tools)
Section 6 - High Availability (20%)
- Describe DB2 data integrity actions
- Demonstrate the ability to perform database-level and table space level backup and recovery operations
- Demonstrate the ability to configure and manage HADR
Section 7 - Security (10%)
- Describe DB2 authentication
- Describe DB2 authorizations and privileges
- Describe the ability to set and remove user, group, and role authorities and privileges
- Demonstrate general knowledge of the Audit facility
- Demonstrate knowledge of the DB2 Security Infrastructure
Section 8 - Connectivity and Networking (5%)
- Demonstrate the ability to configure database connectivity
- Demonstrate knowledge of using JDBC/SQLJ connections with DB2
Other blog entries about IOD Events:
More information about Roger & Certification Exams:
Roger Sanders was featured in the latest edition of the DM Magazine - The Man to See About Certification - “The guru of DB2 certification tests talks about how he puts them together—and how they can help your career” by Howard Baldwin
I wrote an entry on my blog some time ago that I still recommend: Certification 101. I do need to update the entry to include the DB2 9.7 exams such as Exam 541, but the content is still accurate in most ways:
Benefits of Earning a Certification
New in Certifications
How to Prepare to Pass a DB2 Certification
Details about DB2 Certification Program
Once you are Certified... What Next?
Study Materials Electronically
Roger Sanders Books, Videos, and Crammer Course
Ready to validate your skills and demonstrate your IBM DB2 9 proficiency with Information Management Professional Certification
? The IBM DB2 9 Application Developer Exam (733)
is now ready for you to take to prove to yourself and others that your skills are current. Here are some crucial details about the exam:
Length: 70 questionsPassing score: 55%Duration: 90 minutesJob Role Description:
An IBM Certified Application Developer is an intermediate or advanced level application developer specializing in creating applications that run on any of the DB2 platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows, z/OS, s/390, and iSeries. This individual has strong skills in all common programming tasks as well as strong skills in one or more of the specialty areas: embedded SQL programming, ODBC/CLI programming, .NET programming or Java programming.Prerequisites:
To attain the IBM Certified Application Developer – DB2 9 certification, candidates must pass two exams (730
and 733) or be certified as an IBM Certified Database Associate - DB2 Universal Database V8.1 (exam 700
) and pass exam 733
* section 1 Database objects and Programming Methods 16% * section 2 Data Manipulation 26% * section 3 XML Data Manipulation 10% * section 4 Embedded SQL Programming 4% * section 5 ODBC/CLI Programming 4% * section 6 .NET Programming 7% * section 7 Java Programming 7% * section 8 Advanced Programming 14% * section 9 User Defined Routines 12%Study Materials:Self Study Preparation TutorialsOn-line Professional Certification Assessment ExamsTake an IBM Exam at Thompson PrometricTake an IBM Exam at Pearson VUE
Suggested Redbooks that can help prepare for specific areas of the exam:
* DB2 9 pureXML Guide
* DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
* DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More
* DB2 for z/OS Stored Procedures: Through the CALL and Beyond
For additional information, see the Information Management Certification
Drum roll, please!!
The winner is: Norberto!
#4 = JB (7.3% of the vote). Shocking!! But considering the competition, #4 is outstanding. We’ll all remember her amazing presentations and value the knowledge we learned from her.
#3 = Momi (16.7% of the vote). Momi will be back in the fall with his great topics.
#2 = Thiru (31.1% of the vote). Thiru had to be saved a few times, but his topics were technical and thorough, and clearly pleased the audience.
#1 = Norberto (46.8% of the vote). Not surprised. He has a lot of knowledge, enthusiasm, and charisma. Very well done! I would very much like to see Norberto presenting at future conferences. He would like to attend the IDUG Anaheim Conference, but he may not have his Visa in time, and may have to choose Melbourne or Prague as backups. What a difficult choice that would be.
Comments from listeners was amazing… 1231 votes: 97.6 % indicated that they learned something that would help them in their job!
Congratulations to all of the contestants who took part in this 8-week series! Through the course of this very entertaining and educational experience, I can say will full confidence that we ALL learned something. Personally, as a judge for the competition, I learned how to critically watch each presentation and to make comments on it. This isn’t nearly as easy as you think it is! I also learned that there are amazingly talented people working on DB2 and a show like this can dramatically improve the presentation skills through practice.
I’ve known Scott Hayes, Martin Hubel, and Klaas Brant for some time now, but working with them on this show only improved my already high view of these people. This is true also for Cristian Molaro, although I only met him about 6 months ago. With all sincerity, I would highly recommend each of these gentlemen for there skills and knowledge. IBM is lucky to have such partners to work with.
And now for the contestants… Some of them created and presented 5 times. And this isn’t simply polishing up the same presentation and presenting it 5 times, this was creating a NEW presentation each time! Sure, they were only to be 5 minutes in length, but still very hard to do. I could see improvements being made by all presenters based on the judge’s comments.
Here are some of the amazing presentations that were delivered. I highly recommend that you watch the replays to get this education.
- DB2 Concurrent I/O - Best Practices
- A Terabyte of Data and Trouble with I/O
- Using HADR to migrate data
- Pressure Makes Diamonds (and Practice makes Perfect)
- A Different Approach to Table Partitioning
- DB2 z/OS report utility
- Managing z/OS DB2 REORGS
- "DATA" and the db2cat command
- Influencing the Optimizer for Success
- Explain from Actuals
- Green Eggs and Ham and the DB2 LOAD Utility
- Using SQL to Write SQL
- Using Sequences
- Fixing a Run Away Job and changing Developer's Mindsets
- High Speed Text Search
- Searching for the "Needle" in a CLOB "Haystack"
- SQL Tuning
Next Friday DB2Night Show returns to regular programming. See the full schedule.
April 15: DB2 LUW Workload Manager Hints, Tips, & How-to's from the IBM Developer
April 21: DB2 LUW vs Oracle Usability Study Part 1
April 25 Kickoff - The History of DB2 for z/OS
April 28: DB2 LUW vs Oracle Usability Study Part 2
Another DB2’s Got Talent Competition is planned for the Fall. I would love to be asked to be a judge again!
Here are my related blog entries:
Tips for DBAs from Guest Blogger Norberto.... DB2's Got Talent contestant
DB2, DB2Night Show and IDUG as viewed by JB
DB2’s Got Talent Finale
DB2's Got Talent - 3rd Episode of the Finals
DB2's Got Talent - March 11 Episode
Fourth Episode of "DB2 has Talent"
Third Episode of “DB2 has Talent”
Second Episode of DB2 has Talent
First Episode of “DB2 has Talent”
Have you seen this exciting news:
DBI is sponsoring a new
virtual TV Show "The DB2Night Show". Your host will be Scott Hayes and
we hope he further develops his sense of humor!
Like many TV and Radio Shows, each segment will include fun stuff,
education, tips, and special guests. The DB2Night Show will reach out
to various industry experts for their participation. We will also be
seeking guests from the DB2 LUW User Community - yes, that's right, you
could be on our show! We want to take questions from viewers and
possibly even help solve DB2 mysteries. Would you like over 100 DB2
LUW professionals to help you solve your toughest DB2 challenges? If
you are interested in being on The DB2Night Show, please send an email
The DB2Night Show has a Twitter account - please follow
twitter.com/db2nightshow for the latest news about new episodes and
interactive discussion. Use the hash tag #DB2Night in your Tweets.
Episode #1 will include two very special guests:
Drew Bradstock with the IBM DB2 Toronto Lab will share with us his "Top 10 Coolest Things about DB2 9.7".
Rebecca Bond, published author of Understanding DB2 9 SecurityUnderstanding DB2 9 Security,
Independent Consultant, Full Time Shoe Collector, and part time comic
will also share with us her "Top 10 DB2 LUW Security Tips"
Scott Hayes promises to share his "Top 10 Ways to Know if your DB2 LUW Database is Toast".
We're going to go to a shopping mall and ask random people what
they think and know about DB2, if they've heard of IBM, and how they
are contributing to a Smarter Planet.
Thursday, September 24, 2009
10:00 AM - 11:00 AM CDT
|Use the form on the right to|
reserve your Webinar seat.
To register: http://bit.ly/db2ontv
We hope you will join us and participate as a guest or via
twitter.com/db2nightshow. The more people we have involved during the
recording of the show, the more fun we'll have.
If you can't make the scheduled time, register anyways so that you
get information about recorded replays. Lastly, please forward this
invitation to at least 5 of your friends! We can keep this FREE with
Good luck Drew, Rebecca and Scott! I hope Episode 1 is a huge hit so we can have many more similar events!!
Check out this new ILO course:Managing IDS Using the SQL Admin API and Scheduler ILO course (3S301)
In this course, learn about the features of the Informix SQL Administration Application Programming Interface (API). Learn how to write SQL statements to perform a variety of system administration tasks, and will see different ways in which the Administration API can be used. Also learn about the Informix Dynamic Server (IDS) Scheduler and how to create tasks to be performed at regular times or intervals. You will also learn how to create sensors to gather system information into tables over time. Examples will be presented on how tasks and sensors can be used.View this course in other countriesNote:
This is an Instructor Led On Line
course. Please do not
make travel arrangements for this course. Your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
This course is eligible for the IBM Education Advantage Program.Audience
This is an intermediate course for Informix Dynamic Server System and Database Administrators.Prerequisites
You should have: IBM Informix Dynamic Server System Administration (IX810) or (IX811), or 6 months experience with IDS system administration.Skills taught
* Distinguish between the task and admin functions * Write SQL commands to perform administration tasks * Create and schedule administrative tasks * Create and schedule sensors to collect system information * Analyze the information collected by sensorsCourse Outline:
I. The sysadmin Database
II. SQL Administration API
* API functions: admin and task * Admin API commands and options * Administration command examples * ONMODE examples * Admin API scenarios
III. Built-in Database Scheduler
* Creating and scheduling a task * Task examples * Creating and scheduling a sensor * Built-in sensors * Sensor examples * Task and sensor scenariosDetails:
Course code: 3S301 Skill level: IntermediateDuration: 0.5 days Delivery type: ClassroomCourse type: Public only Public price: USD $199.00 plus tax
Make sure you check the course catalog regularly for new Instructor Led On Line
courses as they launch.
If you haven't yet upgraded your skills to DB2 V9, here is some incentive for you:
Were you able to join today’s DB2 Night Show webinar? Today was the third
show of this year’s competition. If you missed it, I strongly encourage you to
watch the replay. Here’s what you’ll get:
Contestant 1 – Rodolpho
Tips for End of DB2 Log & Reset RBA Process
The problem Rodolpho discussed in his presentation was about the end of logs…
which is like the end of the world! This shouldn’t happen as quickly as it is,
but data is being added to databases at unprecedented rates, so it is
happening. Rodolpho’s presentation was therefore timely. His slides very
clearly laid out the problem and tips to solving the problem. Very well
Contestant 2 – Kingo
Hybrid Database Environment Introduction – DB2 plus Oracle
This is a huge topic and Kingo’s presentation was meant to be only an
introduction to it. As an introduction it was well done. There was a clear
representation of the problem and how to solve it. The slides were clear and
the graphics were good. We were able to see Kingo’s screen savers before and
after his presentation. They were lovely! Also on his screen was a clock and
thermometer. I’m not sure where Kingo was presenting from, but it was 1:30 am
his time and the temperature was 0C.
Contestant 3 – Saravana
Predicting Production Access Path
Perhaps I shouldn’t mention Saravana. We weren’t able to hear her so clearly
there were microphone problems. We saw the slides with the title and were
looking forward to the presentation. Saravana, I hope you can fix your audio
problems and come back in the future.
Contestant 4 – Fahim
Performance Tuning – Business Process Choreographer
I really liked Fahim’s graphics. They made the slides interesting to look
at. I didn’t find the presentation very clear though. I wasn’t able to fully
understand the problem that he was solving. The solution was a bit more clear,
but still I was lost. Part of the problem was the acronyms that weren’t
defined. Good attempt Fahim.
We were looking for contestants Lloyd, Carlos, and one other person, but we
couldn’t find them. Most of the contestants today were from distance places, so
maybe these people fell asleep or were confused by the time zone differences,
but we’d like to hear from them if they can come to a future show. Scott
mentioned that some people sign in with an alias so their name may not be
recognized when we are looking for you. I hope this didn’t happen to the people
we were looking for today. If this does happen to you, use the chat function
to tell us what name to look for.
The judges, Martin Hubel, Klaas Brant, and myself chose
Rodolphe and Kingo to move onto the next round based on the relevance of their
topic and the quality of their presentations. Congratulations to you both.
We’re looking forward to more quality presentations from each f you.
Do you agree with our choices? If you watch the replay, you’ll be able to
fill in a survey to let us know if there is someone else who should also move
on. Listen for the great tips and for your opportunity to advance another
Join us every Friday in February for contestant
presentations. March is reserved for the finals where those who have
moved on will present a second time and the listeners can choose the winner
rather than the judges. The commitment for March has lessened in that there
will only be 3 shows in March rather that the originally planned 5. Note that
this means there is a show on March 2, 16, and 30 only. If you get reminders
for March 9 and 23, please ignore these reminders.
Thanks to host Scott Hayes for this opportunity for me as a judge and
for the contestants for helping them build technical presentation skills that
are so valuable.
For details on the prizes for this competition… and a summary of last year’s
event… see my blog entry: http://ibm.co/AnZxb4
See also: Session 1 of the
DB2’s Got Talent 2012 Competition
See also: Session 2 of the
DB2’s Got Talent 2012 Competition
PS… If you are in the NY area, make sure you look into attending the DB2
Symposium that is taking place March 28-30 in this area. See DB2 Symposium for details.
Modified on by svisser1
I enjoy working with all the IBM Champions who I’ve had the pleasure of meeting so far. The one champion I’d like to focus on in this blog entry is Scott Hayes.
Once again, Scott has filled his DB2Night Show calendar with educational webinars that you’ll want to take part in. This is the fifth season, so there are already 4 seasons of great episodes that you can watch in replay. He’s also planning on a 4th edition of the “DB2’s Got Talent” Competition. He’s already invited me to return as a judge, so I’ll be there every show!
Scott over-achieved in putting this line up together. Clearly Scott knows “everyone” and knows how to get them to “talk”. Frankly I think you should sign up for every episode in this list. Most, but not all, focus on DB2 BLU. This new product is big & game changing and even if you think you already know everything there is to know about BLU, I’m pretty sure that you’ll learn more in each show. Click the link to find out more and to register.
Sept 6 - DB2Night Show webinar
Performance Experiences and Best Practices with DB2 BLU
Berni Schiefer, Jessica Escott, Michael Kwok
Sept 20 - DB2Night Show webinar
DB2 BLU Experiences at ****
Intimate Details on DB2 BLU
Feelin' BLU - Beyond the Marketing Literature
Taming the Data Tsunami: 17 Laws of building Petabyte Level DB and Big Data Systems
Insights from IBM IOD, Tips from Top Consultants
Fred Sobotka & Ember Crooks
Breaking News from IBM on DB2 LUW!
IBM software certification exams will be available to registered attendees throughout Information On Demand 2010. Attendees may take up to three IM (including SPSS, Cognos and ECM) exams at no charge; a discounted fee of $100 USD for subsequent exams will apply. See the certification site for further details.
Don't miss this opportunity to validate your skills and demonstrate your proficiency in the latest IBM software technology and solutions.
To prepare yourself to pass the exams, I have a few suggestions for you:
1) Read through a previous blog entry that I did called Certification 101.
2) Buy or borrow a Study Guide that you should read before the conference. These books are available electronically through Books 24x7 or Safari Books Online. The suggested books are:
DB2 9 System Administration for z/OS: Certification Study Guide: Exam 737
DB2 9 Database Administration Certification Study Guide for Exam 732
Susan Lawson and Daniel Luksetich
DB2 9 Advanced Database Administration Certification Study Guide for Exam 734
Roger Sanders, Dwaine Snow
DB2 9 Fundamentals Certification Study Guide
DB2 9 Database Administration Certification Study Guide for Exam 731
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736
Note that all of these books were written by members of the exam development team and each chapter contains sample questions along with answers and explanations.
3) Show up to the conference early and attend a full day Sunday class that was specifically created to give you the information you need to pass the exam. This year we have three classes scheduled:
DB2 9.7 for Linux UNIX & Windows DBA Certification Crammer (Exam 541)
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX, and Window certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
DB2 for z/OS DBA Certification Crammer (Exams 730 and 732)
This is a high-level certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 9 for z/OS Database Administration exam (732). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 V9 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 z/OS V8 and basic knowledge of V9 features. This will be a lecture-only class with no labs. This session offers an intense, overall review of those areas that will be on the certification exams (both the 730 – DB2 9 Family Fundamentals and the 732 – DB2 9 for z/OS), providing a comprehensive review for those planning on taking the certification exams to become an IBM Certified Solutions Expert - DB2 9 for z/OS Database Administration.
Exam 737 Crammer
This one-day crammer class reviews topics on the:
IBM Certified System Administrator – DB2 9 for z/OS Certification Exam 000-737 Exam.
Students will be guided in the class through:
- Understanding the objectives of the #737 Exam
- Discovering changes to DB2 9 for z/OS that relate to the testing
- Techniques that are used by System Administrator in the day-to-day work to plan, install, mange, tune and secure DB2 9 for z/OS
- Review questions at the end of each section of the material
Note, as of today, October 12, 2011..... I've been informed that this book has been delayed. I am so sorry for the inconvenience and the trouble this delay is causing for the authors, bookstore and especially the test takers! Susan
Susan Lawson and Dan Luksetich have updated their popular certification guide and it is publishing just in time for the IBM Information on Demand 2011 Conference: DB2 10 for z/OS Database Administration: Certification Study Guide. This book will be sold at the Conference Bookstore for a 20% discount. Remember that Certification exams are free for attendees at IOD.
You can meet Susan and Dan at the Conference Bookstore and have them sign a copy of your book:
Once again, Susan is teaching the Pre-Conference Certification Crammer Course:(9Q001) DB2 10 for z/OS Database Administration Certification Crammer for Exam 730 & 612
Dan is speaking at the following session:
Explaining the IBM DB2 for z/OS Dynamic Statement Cache: Tuesday 11:15 – 12:15.
IBM DB2 for z/OS does a good job of caching dynamic SQL statements to avoid recompiling (also known as binding) the statements on the fly. This can save significant system resources. However, users still must determine what dynamic statements are coming in to DB2 and how they are performing. DB2 for z/OS has the ability to capture and report on the statements in the dynamic statement cache. The session will focus on the use and management of this facility, and how to report, understand and act on the available performance information.
What’s in the book?
- Read this book to prepare to pass Exam 612 – DB2 10 for z/OS Database Administration.
- All test objectives for this exam are covered in the same degree as they are covered on the exam.
- Susan and Dan were members of the exam development team, so are fully aware as to what questions are on the exam!
- Susan and Dan use DB2 every day and have 22 years experience.
While the book does cover all topics on the test, it also covers much more than that. It covers the new features of DB2 10 for both database and application development.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives. You can see the details on the website: Exam 612 Objectives
730 Exam Objectives – Family Fundamentals
Section 1 - Planning (14%)
• Knowledge of restricting data access
• Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed space - i.e., configuration advisor, configuration assistant, command line processor)
• Knowledge database workloads (OLTP vs warehousing)
• Knowledge of non-relational data concepts (extenders)
• Knowledge of XML data implications (non-shreading)
Section 2 - Security (11%)
• Knowledge of DB2 products (client, server, etc.)
• Knowledge of different privileges and authorities
• Knowledge of encryption options (data and network)
• Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)
Section 3 -Databases and Database Objects (17%)
• Ability to identify and connect to DB2 servers and databases
• Ability to identify DB2 objects
• Knowledge of basic characteristics and properties of DB2 objects
• Given a DDL SQL statement, knowledge to identify results (ability to create objects)
Section 4 – Using SQL (23.5%)
• Given a DML SQL statement, knowledge to identify results
• Ability to use SQL to SELECT data from tables
• Ability to use SQL to SORT or GROUP data
• Ability to use SQL to UPDATE, DELETE, or INSERT data
• Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
• Ability to call a procedure or invoke a user defined function
• Given an XQuery statement, knowledge to identify results
Section 5 - Tables, Views and Indexes (23.5%)
• Ability to demonstrate usage of DB2 data types
• Given a situation, ability to create table
• Knowledge to identify when referential integrity should be used
• Knowledge to identify methods of data constraint
• Knowledge to identify characteristics of a table, view or index
• Knowledge to identify when triggers should be used
• Knowledge of schemas
• Knowledge of data type options for storing XML data
Section 6 - Data Concurrency (11%)
• Knowledge to identify factors that influence locking
• Ability to list objects on which locks can be obtained
• Knowledge to identify characteristics of DB2 locks
• Given a situation, knowledge to identify the isolation levels that should be used
612 Exam Objectives
Section 1 - Database Design and Implementation (30.5%)
• Design tables and views
• Explain the different performance implications of
• Design indexes
• Create and alter objects
• Perform table space and index partitioning
• Normalize data and translate data model into physical model
• Implement user-defined integrity rules
• Use the appropriate method to create and alter DB2 objects
• Encoding schemes
Section 2 - Operation and Recovery (29%)
• Issue database-oriented commands for normal operational conditions
• Issue database-oriented commands and utility control statements for use in abnormal conditions
• Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
• Load and unload data into and from the created tables
• Reorganize objects when necessary
• Monitor the object by collecting statistics
• Monitor threads
• Identify and respond to advisory/restrictive statuses on objects
• Establish timely checkpoints
• Identify and perform problem determination
• Perform health checks
• Develop backup scenarios
• Describe the special considerations for availability in a data sharing environment
Section 3 - Security and Auditing (7%)
• Protect DB2 objects
• Protect connection to DB2
Section 4 - Performance (29%)
• Plan for performance monitoring by setting up and running monitoring procedures
• Analyze performance
• Analyze and respond to RUNSTATS statistics analysis
• Determine when and how to run the REORG utility
• Understand and implement Real-Time Statistics & DSNACCOR(X)
• Analyze cache
• Evaluate and set appropriately the performance parameters for different utilities
• Describe the performance concerns for the distributed environment
• Describe DB2 interaction with WLM
• Interpret traces (statistics, accounting, performance) and explain the performance impact of different DB2 traces
• Identify and respond to critical performance thresholds
• Excessive I/O wait times
• Identifying lock-latch waits and CPU waits
• Identifying and resolving deadlocks and timeouts
• Review and tune SQL
• Dynamic SQL Performance
• Performance Features
Section 5 - Installation and Migration/Upgrade(4.5%)
• Run catalog health checks using queries and utilities
• Identify the critical DSNZPARMs
• Identify the migration/upgrade modes
• Identify and explain data sharing components and concepts such as:
For other IOD sessions related to DB2 10 for z/OS, see the Information Management Roadmaps.
Other blog entries about IOD Events: