Don't you love all the low prices that you can find these days? If you
look around, you can find great deals on just about everything. For
instance....amazon.com has lowered their prices on IBM Press books that
are available for pre-order. There is no way of knowing how long these
prices will be offered, so if you want one of these books, please act
- DB2 pureXML Cookbook -- 37% off regular price... so you only pay $31.49
- Dynamic SOA and PBM – 34% off regular price... so you only pay $26.39
- Viral Data in the SOA – 34% off regular price... so you only pay $26.39
- Author Neal Fishman
is leader of IBM Software Group's integration
forensics program, has spoken at conferences around the world, and is a
Practicing Member of the World Wide Institute of Software Architects.
This is one of the manuscripts that I had the pleasure of reading
Enjoy the savings!
If you have deals to share, send me a note.
The IDUG DB2 Tech Conference in Orlando
is a MUST attend event for database experts and those aspiring to be an
expert! And this year is special beyond special! Why? DB2 is 30
years old and IDUG is 25 years old. Come and celebrate these amazing
accomplishments while you’re learning.
There are many things to learn about... here are a few for you to consider:
1. Robust Technical Session Schedule
are designed to fit your needs. You will have no problem filling your
agenda with the right education for your job role and organization's
2. Celebrations for IDUG's 25th Anniversary
mentioned above, IDUG is 25 this year! Join us to look back at where we
have come from and see where IDUG is headed in the future.
3. IBM DB2's 30th Anniversary
DB2 will also celebrate a significant milestone in 2013. Stay tuned for
more information about celebrations for IBM DB2's 30th anniversary.
4. One Day Seminars
The perfect opportunity to learn more about specific aspects of DB2 that you deal with on a day-to-day basis.
5. Certification Exams
advantage of this opportunity to gain IBM professional certifications
at no additional cost. All IDUG DB2 Tech Conference attendees are
eligible to take two complimentary certification exams.
6. Save on Registration, Be an IDUG Mentor
offers an incomparable loyalty reward program for those who have
attended three or more IDUG conferences, are an IBM Champion or are a
member of a Regional User Group.
7. Complimentary Wi-Fi
Throughout the meeting space and in each hotel guest room at the Caribe Royale All-Suite Hotel and Convention Center.
8. Easy-to-Navigate Meeting Space
The Caribe Royale All-Suite Hotel and Convention Center is compact and easy to navigate.
in Orlando, gain access to old and Stay Connected new connections.
Trade business cards with industry leading vendors, your DB2 peers and
speakers at the Exhibit Hall and networking events sponsored by some of
IDUG's top vendors
10. Hot Industry Topics
Hear from experts regarding their opinions on important topics. Key sessions include:
Explaining Tuning Results to the C-level
Thomas Baumann, Swiss Mobiliar:
DB2 10 LUW Securely Hiding Behind the Mask
Rebecca Bond, SAP DBA Contractor
The 10 Commandments of Supporting E-commerce Databases
Ember Crooks, Rosetta
The Top Ten Things You Need to Know: For DBAs, Developers and Managers
Craig Mullins, Mullins Consulting, Inc.
Register before March 22 and save on registration!
I have much more to say on this topic, so be sure to follow my blog to avoid missing any updates.
I received my copy of Sam Lightstone's latest book: Making it Big in Software
. What chapter should I read first? I think I'll start with Chapter 14: "Zen and the Critical Art of Balance
". Why this chapter? I think software developers are notorious for NOT HAVING A LIFE! I must admit that working in the software business (and for IBM for that matter) can be all consuming and never ending... and maybe a bit addictive. Can a balance be achieved? I think it can and I'll let you read what Sam says about the subject.
The only hint I'll give you is the last paragraph that Sam wrote in this chapter:
"Careers do require hard work and enthusiasm, and those are attributes that encourage people to spend more time at the office. Finding your own balance is hard, but if you discover the Philosopher's Stone that helps you get it right, you'll have done the best possible service to your career and your life. No other tactic or vice will serve you better. With only one life to lead, it's definitely worth the effort".
Thanks Sam for helping all these hardworking people achieve a balance in their life while pursuing a very gratifying career in software.
PS... the book is now available for purchase, but it appears that amazon is still saying that it hasn't been released and are offering their standard 34% discount while it is in this state.
Join Paul Rockwood and
other PureData Experts as they help you understand the capabilities of
the PureData System for Transactions. This FREE session will cover
hardware, software and integration.
Date: 19 April 2013
Time: 9:00 a.m. – 4:30 p.m.
Location: Room D108, IBM Markham TEC, 3600 Steeles Ave., Markham, ON L3R 9Z7
Why take part in this session?
developing, and deploying resilient enterprise database systems often
requires substantial time and expertise to manually architect, install,
configure, integrate, optimize, and scale the components of a
multi-server deployment. The IBM PureData System for Transactions
arrives fully integrated from the IBM factory, architected by IBM experts, and ready to deploy cluster topologies and database workloads in just few hours. Come and learn about the expertise built into the integrated system and have a simplified experience.
how IBM PureData System for Transactions simplifies the delivery and
management of highly available database OLTP clusters by:
your critical systems available all the time, with uninterrupted access
to the data through planned and unplanned outages
Providing near linear scalability; Allowing you to modify, maintain or tune your cluster transparently to users and applications
Automating and consolidating administration, management, monitoring, and maintenance through a single pane of glass.
System Architecture and Setup
about hardware and software architecture of the system and how to
seamlessly integrate the PureData System for Transactions into your
System Console Overview
familiar for how to manage and monitor system elements such as
topology, PureSystems Management Nodes, Compute nodes, Storage,
Patterns and Deployments
the pattern-based technology at the heart of PureData System, which
dramatically simplifies the management and deployment process for large,
complex enterprise database environments, saving significant IT labor
and maintenance costs. Based on patterns of expertise, the hands-on lab
demonstrates a new simplified way of designing and deploying cluster
topologies and OLTP workloads.
Database Console Overview
familiar with the consolidated PureData Console – a single pane of
glass for development, administration, management, and maintenance of
PureData Systems databases.
Learn how to take advantages of applications to do seamless Work Load Balancing, Automatic Client Reroute and Client Affinity.
the integrated monitoring capabilities of PureData System for
Transactions – they save time and money as the instrumentation comes
pre-configured, and provide faster ability to perform problem
determination and root cause analysis.
how PureData System provides a large, shared pool of resources, yet
still provides secure, fine-grained isolation, both physically and
virtually, which can support multiple lines of business and/or multiple
phases of the database and application life cycles.
session is offered free of charge. Complimentary refreshments and lunch
will be provided. However, participants are responsible for their own
business travel expenses.
your convenience, registration and continental breakfast will begin at
8:30AM. The session will start at 9:00 a.m. and end at approximately
Contact for information
To enroll in this Proof of Technology, please contact your IBM Software Sales Representative or send a request to: email@example.com.
Thanks to Paul Rockwood for providing this information to me. If you’re in the Toronto area, you won’t want to miss this event!
Do you ever wonder what everyone else is making, and how your salary measures up? The CertMag’s 2007 Salary Survey
was recently released... and guess what? IBM Certified DBAs
are on top!
* IBM Certified DBA / Application Developer - $87,390 * Microsoft MCDBA - $78,420 * Oracle DBA OCA - $79,730 * Oracle DBA OCP - $84,520 * Oracle Developer OCP - $78,250
So... if you are working as a DB2 DBA.... I hope you're making this much and are happy that you are on top. If you are not working with DB2 yet.... there is always time to make a conversion
Craig Mullins also blogged about this news, so make sure you read his perspective
Meet author Bill Carpenter and have him sign a copy of his book at the IBM Information on Demand 2011 Conference. Come to the Conference bookstore Thursday October 27 from 11:00 – 12:00 pm to meet Bill. Soon you’ll be able to add this signing and others to your Smart Site schedule.
- Quickly get up to speed on all significant features and the major components of IBM FileNet P8 Content Manager
- Provides technical details that are valuable both for beginners and experienced Content Management professionals alike, without repeating product reference documentation
- Gives a big picture description of Enterprise Content Management and related IT areas to set the context for Content Manager
- Written by an IBM employee, William Carpenter, who has extensive experience in Content Manager product development, this book gives practical tips and notes with a step by-step approach to design real Enterprise Content Management solutions to solve your business needs
- IBM FileNet P8 Content Manager, built on top of the mature FileNet platform, is a complete, world class Enterprise Content Management platform. With its rock solid document management features, tight integration with BPM systems and other components, and rich API set, it is a highly scalable and secure solution to common and uncommon Enterprise Content Management requirements.
- Written by a FileNet insider, who is an Enterprise Content Management architect and engineer, this book is a straightforward guide to effectively install, manage, and administer FileNet P8 content Manager. It emphasizes practical, specific, and hands-on information about features for building Enterprise Content Management solutions. At every step, real-world tips and important information are called out to save you time and trouble when building customized solutions.
- Beginning with an overview of Enterprise Content Management, the book moves quickly to the matter of getting a real Content Management system up and running. You learn key Content Management applications that are demonstrated to show you the major concepts that matter you as a developer, administrator, or as an end user. There are separate chapters that describe major platform features, security-related features, and integrations with other commonly used software components. A realistic sample application, designed right infront of you unfolds the genius in IBM Filenet P8 Content Manager. Finally, you take an in-depth look at troubleshooting, support sites, and online resources to help meet your security needs.
- Master the ins and outs of the FileNet P8 platform, easily
You can also see Bill in the following sessions:
Wednesday 4:30-5:45 pm
IBM FileNet Content Manager
In this session, you will have the opportunity to meet with technical architects for IBM FileNet Content Manager and discuss the future direction of the technology.
For IOD sessions related to this book, see the Enterprise Content Management Roadmaps:
- ECM Advanced Case Management
- ECM Content Analytics
- ECM Document Imaging and Capture
- ECM General
- ECM Information Lifecycle Governance
- ECM Social Content Management
Other blog entries about IOD Events:
IBM InfoSphere Replication Server and Data Event Publisher
Design, implement, and monitor a successful Q replication and Event Publishing project
by Pav Kumar-Chatterjee
Covers the toolsets needed to implement a successful Q replication project Aimed at the Linux, Unix, and Windows operating systems, with many concepts common to z/OS as well A chapter dedicated exclusively to WebSphere MQ for the DB2 DBA Detailed step-by-step instructions for 13 Q replication scenarios with troubleshooting and monitoring tips Written in a conversational and easy to follow manner
Buy the book now from packtpub.com.
Available soon from Amazon.
Note… this is Pav’s second book. His first was co-authored with Mattias Nicola:
Packt will publish their 100th Enterprise focused title. The chosen title for this landmark moment: Lotus Notes 8.5 User Guide !
I hope that anyone who reads articles on dWorks understands that DB2 runs on multiple platforms. A couple of months ago, I was surprised to find a large number of attendees at a data warehousing conference who still think of DB2 as a database that runs ONLY on the mainframe!
Of course DB2 has servers that run on the mainframe, including s/390, z/OS, VM, VSE, and midrange systems such as iseries or OS/400.
But it also runs on Linux and UNIX such as AIX, HP-UX, and Solaris.
(Clients exist for all platforms as well.)
Most of the people at the conference were using competitive programs such as Oracle or SQL Server, so perhaps it is understandable that they were unaware of the platforms that DB2 runs on, but the next time I work at a similar conference, I'm going to ask for a huge sign that says DB2 runs on Windows!
The fact that we have servers on so many platforms is a huge benefit to our customers in that the function is the same (or very similar) regardless of which platform is being used. Applications can be developed on one platform and then executed on others against data in DB2 on any of the platforms. But the biggest benefit is the transfer or reuse of skills.
Our certification program was designed to take advantage of the similarities across multiple platforms by having exams that can work for everyone:Exam 700 DB2 Family Fundamentals
Passing this exam earns you an IBM Certified Database Associate Certification. Every question on the exam is true on ALL of the following platforms: UNIX, Linux, Windows, iseries, and z/OS. The exam covers the following topics:
* Planning (15%)
* Security (9%)
* Accessing DB2 UDB Data (15%)
* Working with DB2 UDB Data (31%)
* Working with DB2 UDB Objects (19%)
* Data Concurrency (11%)Exam 703 DB2 Family Application Development
Passing this exam (plus Exam 700 or equivalent) earns you an IBM Certified Application Developer Certification. The questions on this exam allow you to create an application that can access any of the DB2 servers, regardless of the platform. The exam covers the following topics:
* Database objects and Programming Methods (13%)
* Data Manipulation (26%)
* Embedded SQL Programming (11%)
* ODBC/CLI Programming (13%)
* Java Programming (13%)
* Advanced Programming (16%)
* User Defined Routines (8%)
The exam is structured so that you only need to know one of the following three sections very well in order to pass the exam:
* Embedded SQL Programming (11%)
* ODBC/CLI Programming (13%)
* Java Programming (13%)
Of course you'll have to know a fair amount about the other section of the test if you do not know ODBC or Java.
A few years ago, we tried to combine the DBA exams for all the platforms, but we found that we were only able to do so for the Linux, UNIX and Windows platforms, since the tasks for these platforms are virtually identical. See Exam 701 DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration
). We needed to cover the DBA tasks for the z/OS platform in a different exam to adequately cover the range of topics that are essential. See Exam 702 DB2 UDB V8.1 for z/OS Database Administration
We tend to make the same split for the books by covering all DB2 topics for Linux, UNIX and Windows in the same book and put the DB2 z/OS topics into separate books. We have a few exceptions though:DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX Windows, i5/OS and z/OS, Second Editionhttp://www.ibm.com/software/data/education/bookstore/ref.html#sql
This book covers SQL PL for all platforms! DB2 for Solaris: The Official Guide http://www.ibm.com/software/data/education/bookstore/ref.html#solaris
Obviously this is for the Solaris platform only.
Wee also looking into have a book specific for Windows and another specific for Linux in the next release. Perhaps that will help spread the word that DB2 is really available on ALL platforms?
IBM Press Program Manager
Modified on by svisser1
The latest addition to our authors doing a book signing at IBM Insights this year is Phil Simon. He is author of many books, but I’ll focus on his two latest ones for this blog entry.
The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions
In The Visual Organization, Phil Simon looks at how an increasingly number of organizations are embracing new dataviz tools and, more important, a new mind-set based upon data discovery and exploration. Simon adroitly shows how Amazon, Apple, Facebook, Google, Twitter, and other tech heavyweights use powerful data visualization tools to garner fascinating insights into their businesses. But make no mistake: these companies are hardly alone. Organizations of all types, industries, sizes are representing their data in new and amazing ways. As a result, they are asking better questions and making better business decisions. Rife with real-world examples and case studies, The Visual Organization is a full-color tour-de-force.
Too Big to Ignore: The Business Case for Big Data
Too Big to Ignore: The Business Case for Big Data is geared towards CIOs, CEOs, presidents, and IT professionals. At a high level, the book makes a compelling business case for that which we are calling Big Data. Simon provides commonsense advice for organizations looking to make sense out of the information streaming at us with unprecedented volume, velocity, and variety.
I haven’t read these books yet, but plan to pick them up at the conference. Both books are highly rated on amazon, so they are assured to be good books.
At IBM Insights:
Phil will be signing copies of his books at the Conference Bookstore on Tuesday, October 28 from 12:30 – 1:30.
Phil Simon (@philsimon) is a sought-after speaker and the award-winning author of six management books, most recently The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions. A recognized technology expert, he advises organizations on matters related to strategy, data, and technology. His contributions have been featured on Harvard Business Review, CNN, Wired, NBC, CNBC, Inc, BusinessWeek, Huffington Post, Fast Company, The New York Times, and many other sites.
To find out more about Phil and his books, go to www.philsimon.com.
Modified on by svisser1
This year's meeting of the Central Canada DB2 Users Group will once again be held at the Institute for Learning in Scarborough / Toronto. The event is scheduled for Monday June 17th and Tuesday June 18th, 2013. This is one of the largest user run DB2 learning events in Canada with regular attendance in excess of 200.
As usual, you’ll be able to expect the "best in class" educational sessions, including:
DB2 for z/OS Speakers will include:
DB2 for LUW Speakers will include:
IMS Speakers will include:
This year, in addition to our usual DB2 program, the local IMS Users Group will provide a 1 day IMS track on Mon Jun 17.
Abstracts for these sessions can be found on this website: Abstracts.
The Keynote will be given by IBM Fellow Curt Cotner: “The Latest News on DB2 Application Development Technology”. As you may have heard, Curt is retiring from IBM, so this may the last opportunity to hear from such a renowned speaker.
I will attend the conference during the expo hours to display books that can be purchased direct from publishers at a discount. I may also have a few books that I’ll give away as prizes, so be sure to come by to visit me.
The main web page is located at Central Canada DB2 User Group.
Click here to go to registration site. I heard that walk-ins will not be accepted at this event, so be sure to register in advance!
Thanks to Tim Johnson, President for providing me with this information.
Watch the DB2Night Show Friday 8/20 and Friday 8/27 to get the technical details about DB2 in the Cloud. Expert Mark Wilding from IBM Toronto has so much information to share that this topic needs to be spread across two shows!
As usual, join Scott Hayes the host of the DB2Night Show for some very entertaining learning… for free!
Visit http://www.DB2NightShow.com for details and FREE registration links.
This is it. We’ve done all that we can do and now we get to reap the rewards of our hard work. Show time!IBM
Information on Demand starts this weekend. Many of us are flying to
Las Vegas tomorrow already. The weekend will be filled with customer
meetings, business partner sessions and the inevitable last minute
can you expect? You’ll walk a lot, meet many people, maybe even eat
too much. You’ll learn about many new products and technologies.
You’ll be tired by the end of the week, but I hope you’ll end the
conference saying that you had fun and that every minute was worth it!If you want a running commentary on what’s happening at the conference, be sure to check out the Official IOD Blog and Twitter and Facebook. Several of us will be posting to these sites throughout the week.Here’s a list of the blog entries I’ve published in the past month to support this IOD: A few of my entries went straight to the Official Blog. Here are mine and a couple of my favourites:Have fun, learn a lot... and stay safe!Susan
Join Berni Schiefer
as Scott Hayes'
guest on tomorrow's edition of the DB2Night Show
Topic: DB2 LUW Performance Update & Best Practices
Who: Berni Schiefer
When: Fri April 30
Time: 11 am Eastern Time
Note that this event is nearly full to capacity... likely because Berni will NOT be presenting at this year's IDUG or IOD EMEA conferences! Berni's talks are always popular... is it the topic or the speaker?
Here's more info (from Scott) about the event:
In the DB2 LUW Community, Berni Schiefer is a man that doesn't need an introduction - but, just in case you are newer to DB2 LUW (like one of the many Oracle converts), Berni is "the performance guy". He's a Distinguished Engineer who leads the Information Management Performance and Benchmarks team at the IBM Toronto Lab. Berni has been a frequent speaker at IDUG conferences and other venues, and he gives terrific presentations that share DB2 Performance Benchmark results and performance best practices.
With DB2 pureScale announced last fall, we can only "guess" that IBM will be publishing some new benchmark results very soon. Claim your seat in our virtual studio audience to hear the very latest information on performance results and best practices!
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.
The DB2Night Show now has a LinkedIn Group - join us to stay up to date on our show and discuss show episodes! The group registration link can be found on www.DB2NightShow.com.
We hope you will join us and participate as a studio audience member. One studio audience member will be randomly selected to win an Amazon.com gift certificate - use this towards a new USB thumb drive, a new book, or anything you like!
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!
I hope you enjoy the talk!
Watch The DB2Night Show episode #5 Nov 12
"SQL Snapshot Potluck Party
with special IBM guest Chris Eaton
In this episode of The DB2Night Show
, special guest Chris Eaton
from IBM will
share his TOP 10 Favorite SQL Snapshot commands
, host Scott Hayes
will throw in
a few of his faves, and EVERYONE who contributes at least one of their own
favorite SQL Snaps to the show will receive access to a FREE text/zip file
containing ALL of the SQL Snaps on the Show! WOW - What a great way to build
your toolbox of SQL Snapshots!!! Click on the registration link
details on how to submit your SQL Snapshot to this potluck party.
has it that another special guest may make a cameo appearance as well -
independent security consultant, published author, and now DB2 LUW Security
blogger Rebecca Bond
has threatened to share SQL commands with viewers that will
help analyze DB2 Security! Have you discovered her new DB2 LUW security blog
- are you following http://www.twitter.com/db2nightshow
yet? YOU SHOULD BE! Set
your "follow" to enable mobile messages - The DB2Night Show is now starting to
give away Amazon.com gift certificates! Just be the first to directly and
correctly answer DB2 trivia, sample certification, or other DB2 related
questions, and you could win valuable prizes!
weekly for updates on upcoming
shows and recorded replays. Here is a look at future shows that are currently
* Nov 20 "Free Application Development Tools - Data
Studio vs Quest Toad" (tentative)
* Dec 4 "SQL Server versus DB2 LUW and
FREE DB2" with special guests Paul Z
and Leon K
from IBM (tentative)
Dec 11 "Managing the DB2 Workload Manager" with special guest Paul Bird
--AND-- A REAL LIVE CUSTOMER that is using WLM! (confirmed)
* Dec 18
"Crunching the Numbers - Snapshot Analysis with Scott Hayes
" We'll be looking at
real data from real live production databases. (confirmed)
* Jan 8, 2010
"DEAR IBM, ..." Special guests include IBM senior executives and leaders Sal
, Tim Vincent
, and Drew Bradstock
. Send your praise, comments, feedback,
questions, and requirements to the show! This is a virtual CAC of sorts with a
guest panel of IBM DB2 LUW top shelf leaders! (confirmed)
Congratulations on reading this far! Here is your reward! The first five
people to register for Episode #5
and who contribute a SQL Snapshot command will
receive a $25 Amazon.com gift certificate in appreciation for your contribution
to the Potluck Party.
The International DB2 User Group (IDUG)
co-sponsor of The DB2Night Show.
Have you taken IBM certification exams in the past, but don't remember what you've passed? Have you received the certificates that you are entitled to? Check on the Member Site for IBM Certified Professionals
to see where you stand.
IBM's Certification Member Site allows you to:
* View your test and certification history, including shipping status of certificates
* Submit requests to merge multiple candidate/testing IDs
* View and update your demographic information
* Request additional copies of your certificates (softcopy via email or hardcopy)
* Download the IBM Certification marks to which you are entitled
Remember, certification results are confidential to you, so if you have earned a certification, the only way for your manager to know is if you tell them. I suggest that you print a copy of the certificate and give it directly to your manager.
Today I registered for the IOD conference, requested a hotel room and certified that I’ll be presenting this year. Now it is time to start using the SmartSite to schedule my time. The conference takes place in Las Vegas, Nevada at the Mandalay Bay Hotel during the last week of October 2011. I hope you plan to come!
If you are planning to register, remember that you can save $300 by registering by Aug 31!
As you may know, I manage the book signings that take place at the bookstore conference, and as in previous years, we have a very full schedule planned. I’m busy building the schedule right now, so I can get the book signings added to SmartSite as we did last year.
As a teaser, I’ll tell you this:
1) We will be launching 2 new certification guides.
2) We’ll be giving out 3 brand new Flashbooks.
3) Michael Lewis will be signing his many books… some of which have been made into movies.
4) There are 8 new technical books launched at the conference that will appeal to you.
Stay in touch and I’ll reveal details as I can.
There are many reasons to attend! Amazing speakers, deep technical education, free certification exams and more. See the Justification information on the website for more reasons.
Join Sal Vella, (VP) and Jamie Watters (Senior Product Manager) as they give you an update on DB2. Specifically, what’s new since V9.7 GA .
IBM released DB2 9.7 for Linux, UNIX, and Windows (LUW) in June of 2009. Since that time we have been hard at work enhancing DB2 and adding new capabilities through a series of fixpacks, releasing DB2 pureScale, as well as introducing a high-value new edition called DB2 Advanced Enterprise Server. Attend this Chat with the Lab and learn about some of the improvements to DB2 LUW since the release of 9.7, as well as the outstanding value you can receive by upgrading to the new DB2 Advanced Edition.
Date: Mon, February 28, 2011 (28.2.2010)
Time: 12:30 AM - 2:00 PM Eastern Time (ET)
11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
Speakers: Sal Vella (IBM), Jamie Watters (IBM)
Will be downloadable just prior to the webcast from ibm.com/db2/labchats.
Click here to register and receive instructions for attending this webcast.
Want more content on DB2 pureScale?
Flashbook: DB2 pureScale: Risk Free Agile Scaling
Blog entry: More on DB2 pureScale.
developerWorks: DB2 pureScale.
This year at the IBM Information on Demand Conference (#IOD11), there is a crammer course for InfoSphere QualityStage 8.5 (Exam 422). If you use this product, you may want to earn an industry-recognized IBM Information Management certification by passing Exam 422. Passing this exam is a great way to validate your skills on the InfoSphere QualityStage 8.5 product. Remember, if you are a registered Information On Demand conference attendee, taking the exam is free. Normally it is $200 per take, so you are saving significantly.
To help you pass this exam, consider taking the Crammer course that is being offered for the first time at this event: (9Q061) InfoSphere QualityStage 8.5 Certification Crammer for Exam 422. This course is being offered the day BEFORE IOD begins: Sunday, October 23. You can register in advance or show up early morning to register at the event.
The instructor for this course is Dale Buckingham. Dale is a learning consultant and technical architect for InfoSphere.
This one day crammer course is designed to introduce you to the concepts a test candidate must know in order to take and pass the InfoSphere QualityStage 8.5 Certification exam 422. The material for this course is aligned with the 422 exam objectives.
To gauge whether you need to take this course or not, consider taking the assessment exam. Normally these exams cost $10, but for conference attendees they are free and will show you how much more you need to know to pass the exam. Beyond this crammer courses, check out the other types of education that are available to learn the material to pass this exam. Of course, you may not have time to take any of this education before going to IOD, so the crammer course may be the best timing and value.
The test contains six sections totaling approximately 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Methodology (5%)
- Describe the steps in data quality methodology.
- Understand the impact of data integration preparing.
Section 2 - Design Considerations (18%)
- Identify the steps for standardization.
- Given a scenario, demonstrate knowledge how to optimize QualityStage jobs using parallel concepts.
- Given a scenario, describe how to handle data from multiple countries.
- Describe initial vs. delta vs. real-time design considerations. (may use scenarios)
Section 3 - Investigation (10%)
- Given a scenario, demonstrate knowledge of investigation types.
- Given a scenario, describe how word investigation results can be used.
Section 4 - Standardization/Addresses/Postal (11%)
- Describe the differences between address certification, verification, and standardization. (may use scenarios)
- Define what the standardization stage is and how to use it. (may use scenarios)
- Given a scenario, describe the purpose of standardization and what results are produced by the process.
Section 5 - Rule Sets (16%)
- Demonstrate knowledge of how to customize standardization rules. (may use scenarios)
- Demonstrate knowledge of the components of a rule and their functions.
- Demonstrate knowledge of managing standardization rules.
- Demonstrate knowledge of user defined standardization rules.
Section 6 - Matching (21%)
- Given a scenario, demonstrate knowledge of match concepts.
- Describe the match job components. (may use scenarios)
- Given a scenario, describe how to review and tune a match.
- Demonstrate knowledge of managing match specification (re-usability). (may use scenarios)
- Given a scenario, demonstrate knowledge of match job design to achieve optimal performance.
Section 7 - Survive (10%)
- Describe the purpose of survive.
- Demonstrate knowledge of the different rule types for surviving data and when to use them. (may use scenarios)
- Describe how to implement a survive stage.
Section 8 - Setup and Troubleshooting (10%)
- Identify how to troubleshoot a QualityStage job. (may use scenarios)
- Describe how to configure data quality environment functionality.
- Describe QualityStage deployment considerations. (may use scenarios)
- Demonstrate knowledge of NLS/non-NLS install and its impact on QualityStage stages. (may use scenarios)
Good luck on this an any other exam you may choose to take at the IOD conference this year.
If you've considered making the move to DB2, developerWorks has made it easier than ever to find out everything you need to know.
The new DB2 enablement page for DBAs and database developers is loaded with resources -- articles, tutorials, demos, webcasts, and more -- to help you understand the benefits of DB2 for Linux, UNIX, and Windows. Benefits like industry-leading performance, autonomic admin features, and lower costs.
Are you already working with another relational database management system (like, say, Oracle)? Why not find out how easy it is to migrate your applications to DB2 9.7? Plus, new SQL compatibility features in DB2 9.7 (including support for Oracle's SQL and PL/SQL dialects) make it easy to reuse your PL/SQL knowledge.
And for more on all of IBM's data solutions, stop by our Information Management zone here on developerWorks.
And don’t forget the great books that are available for you to make the move to DB2:
Beginning DB2: From Novice to Professional
by Grant Allen
Understanding DB2®: Learning Visually with Examples, 2nd Edition
by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Last Friday Dan Dubriwny from the Big Data Tiger Team, IBM USA, was the guest speaker on episode 62 of the DB2 Night Show, hosted by Klaas Brant. The topic was BIG DATA Overview - What is it? Who cares? If you missed it, be sure to catch the replay.
According to Klaas:
If you have been to IOD 2011 in Las Vegas then the words Big Data will probably still resonate in your mind. The theme of IOD was "Turn Insight into action" and IBM is the only company that can do this for all sort of big data. Most people think that big data is all about Hadoop. And although Hadoop is one of the components in IBM's solutions it is not what big data is all about. Dan Dubriwny gives in this episode an excellent introduction into big data. It is all about Variety, Velocity and Volume. IBM can handle all of this for both data streams and data at rest. Probably by now you are curious how this all works, so go ahead and enjoy Dan's presentation with numerous examples.
Scott Hayes informs me that there is more… much more! Episode #63 on 18 Nov will be a deep dive into IBM solutions around BIG DATA.
Join special guests Paul Zikopoulos and Robert Thomas, both from IBM, to get a look at why IBM is the right partner for Big Data. You'll find that many vendors offer Big Data products whereas IBM is offering a Big Data PLATFORM. Most of this session will be technical--- show casing, for example, the file system (GPFS SNC) that's used with the IBM Big Data platform as opposed to the open source defacto standard HDFS because it provides better performance, management (it's POSIX compliant), security, and availability; with GPFS SNC, IBM hardens Hadoop for enterprise deployments. Of course, no one quite understands the enterprise like IBM so you can bet we are solving other enterprise challenges such as security, integration, governance, and more.
The DB2Night Show Episode #63: BIG DATA Technologies, Solutions, and Details
Speakers: Paul Zikopoulos and Robert Thomas
Friday, November 18, 2011
11:00 AM - 12:00 PM EST
As Scott always says, join to be educated, informed, and entertained.
Want more on Big Data? Check out this entry: Do you feel the excitement of Big Data?