DB2 version 8 certification: Everything you need to know >>
 
From valuable lessons for newcomers, to helpful reminders for old hands, this article is filled with tips for everyone.

Introduction

Introduction
The biggest trend in IT careers is certification. You see it everywhere you look... certification books dominate the bookstores, classroom training now guarantees a "pass," and IT professionals even sign their emails with a list of their "certs."

Certification has arrived, no question. But as a DB2® professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key -- knowing the inside story on DB2 certification before you proceed will save you a ton of time, stress and money. This article tells you what you need to know to decide if DB2 certification is for you, and if so, the secrets to doing it successfully, quickly and inexpensively.

Is certification "worth it"?
First, understand that an entire industry profits from certification. Trainers sell certification-oriented courseware, consultants push training, publishers market books, and vendors sell all the above. The upshot is that you can't take most articles on certification at face value. Let's take a different tack. We'll try to look at the issue objectively, strictly from the IT professional's standpoint.

Why certify? Some do it for the challenge of demonstrating their knowledge, or for the inner satisfaction that comes from mastery of the material. Whether a "certified DB2 developer" is better than one that is not certified is, to say the least, highly debatable. What we can say for sure is that if you certify you'll end up knowing more about DB2 than you did when you started.

Many certify for career benefits. If you view it this way, you need to:

  1. Certify with a product that has major marketshare (and is on the upswing)
  2. Investigate the marketability of the specific cert in which you're interested
On the first point, DB2 is the right choice. Most analysts agree that IBM has taken the lead in the database market away from Oracle (1). For example, Figure 1 shows recent figures from Gartner Dataquest (2).

First Exam Experiences
Some Struggle…
"My first exam was a total disaster… and I really studied! I’m not so sure about this certification thing anymore..." - Bob K., database administrator
"It’s was completely, totally impossible. Nobody knows all that stuff! I’ll never know how I passed. Maybe a higher power guided my mouse." - Chris P., DB2 developer

Some Soar…
"It was pretty much what I expected… not difficult if you were ready. I’m sure glad I asked around and got on the forums first." - Rajni P., database administrator.
"Piece of cake.. well, not quite that easy, but really not that bad if you knew what to expect. How could anybody not?" - Reilly C., programmer

Why ?
What these widely-varying experiences show is that before taking your first certification exam, you need to plug into what to study and how to study. The candidate who learns about the process from others who have been through it, who has worked with the right resources and taken the right practice tests is light-years ahead of those who have not. A few hours of orientation up front can make the certification process easier, more effective, and ultimately more successful. Sharing this information is the purpose of this article.

Figure 1. Database Market Share by Revenue

DB2 marketshare continues to expand. How did IBM pull off such a feat in a "mature" market? The company bought Informix® for one billion dollars and shrewdly invested another billion in the Linux marketplace, positioning DB2 as the leading database on this exploding platform (3). But the real reason may be what I learned while doing an informal survey of the database market last year. One manager after another told me: "DB2's features and technology are second to none, yet it costs way less than Oracle."

Since database marketshare varies by platform, which platform you work on should factor into your decision. DB2 completely dominates on mainframes and the IBM e-server® iSeriesTM (AS/400), with over 90% of the database marketshare for each. IBM comes in a strong second in UNIX® database marketshare, and a distant but growing third on Windows® Server. Data for Linux is sketchy, but DB2 appears dominant among the commercial databases (3).

The most practical way to verify the marketability of a certification is simply to check out job ads on the Web. Do they mention it? And when they do, is it considered preferable or a job requirement? Few ads today specifically mention DB2 certification. This likely reflects of the newness of the DB2 certification program more than anything else. Given the investment IBM is making in the database market and the statistical trends cited above, the most likely scenario is that DB2 certification becomes increasingly valuable as a career credential.

Whether you can enhance your career through certification depends on how you approach it. Here are examples from my own experience where IT pros have leveraged certification to their benefit:

  • A DB2 programmer wanted to shift into database administration. Getting her DBA cert bagged her the transfer.
  • A DB2 developer was great with JavaTM but felt too narrow because he didn't know about other approaches to DB2 application development. Getting the "developer" cert gave him the breadth he needed.
  • A stay-at-home mom wanted to reenter the workforce after a 10-year absence. She got certified and successfully leveraged this as "proof of currency" for her skills.
  • A new college grad desperately wanted to be a DBA but only received programming job offers. He proved his devotion to his goal by certifying as a DB2 DBA, which led to an entry-level DBA position.
  • A mature database veteran realized he needed to update his skills. Certifying both did this for him and supplied the proof. Age discrimination? His certification is as current as anyone else's.

Benefits must be weighed against costs. Discussion on popular certification web sites like Cramsession.com and Certification Magazine indicate that most IT pros take from two to five weeks studying for each test. You'll also have to take an "update" test as new DB2 releases come out, once every couple years, to remain current. The dollar costs can potentially run into the thousands of dollars per cert, but as we discuss below, you can certify for little more than the cost of a few books, if you know how (my DB2 DBA cert cost me less than $150). Finally, consider the "opportunity cost" of certification. What other use would you make of the time you would spend certifying if you did not certify? Some might prefer non-directed, serendipitous learning or extending their knowledge into entirely new areas.

As a contractor, I've directly benefited from certification. It gives me instant credibility with potential employers who've never met me and serves as my trump card for contractor interviews. It deals me an Ace in today’s extremely competitive job market.

Employers desperately want some standard measurement to quickly separate qualified from unqualified candidates. Fair or not, they've adopted IT certifications as that yardstick. There is little question that DB2 certification can help your career, but ultimately each person must decide for him or herself whether it's worth the time and effort.

How to certify
You certify by passing one or more exams. The Roadmap to DB2 Version 8 certification in Figure 2 shows that you certify as a DB2 Database Associate by passing the required entry test, "DB2 Family Fundamentals, 700." Then take any of the five additional certification exams, depending on your area of interest. For example, to become a certified DB2 Database Administrator, pass "DB2 DBA for Linux, UNIX and Windows, 701," or certify as a mainframe DBA by passing "DB2 DBA for z/OS, 702." (Note- exam #702 will be available in 1st quarter 2004). You could also become a Certified Application Developer by passing "DB2 Family Applications Development, 703." Or certify in Business Intelligence by taking "DB2 Business Intelligence, 705," or specialize in the Content Manager via exam #442.

Figure 2. The DB2 Version 8 Certification "Roadmap"

A really nice feature of the DB2 certification program is its modularity. After passing the “DB2 Family Fundamentals” entry test #700, take whichever exam(s) you like. Each one you pass gives you another certification.

IBM introduced several new features in the Version 8 certification program. First, there is a tripartite path yielding three ascending levels of DBA certification. This clear path replaces the grab-bag of advanced “Certified Solution Expert” (CSE) exams in Version 7:

Table 1. The version 8 DBA certification path

Step Exam Number Exam Title Certification
1.700DB2 Family FundamentalsDatabase Associate
2.701DB2 Database AdministrationDatabase Administrator
3.704DB2 Advanced Database AdministrationAdvanced Database Administrator

The Version 8 program also introduces a single test by which Version 7-certified DBAs can upgrade their certification. This is called “DB2 for Linux, Unix and Windows Version 8 Upgrade Exam, 706.” If you are a Version 7 certified DBA, you can either take this new upgrade test, or simply pass the standard database administration exam #701 to upgrade your DBA cert to Version 8. The Upgrade test features fewer questions and is a shorter test, but many more study resources are available to help you pass the standard DBA test, #701. In Version 8, IBM introduced a new test called the “DB2 Problem Determination Mastery Exam”. The exam covers problem determination using DB2 tools, for installation, configuration, communications and the like. Technically, it is not a certification exam, so it has no formal pre-requisites, nor do you achieve an official certification by passing it. This test will be of great interest to those who certify as a DBA and want to strengthen (and prove) their problem identification and resolution abilities. The test costs only $40 and can be taken online via the web. For full information on this exam, and a free, downloadable set of nine study tutorials, visit the exam web page at http://www.ibm.com/software/data/support/pdm/db2exam.html.

To take any certification test, simply visit Prometric, the testing organization. If you’re outside of North America, visit testing organization Pearson VUE. These Web sites list testing locations (there are usually many to choose from in any city), and you can sign up for exams online. Show up at your scheduled exam time with two forms of picture identification. They'll assign you a PC onsite, where you'll take the test via a standardized multiple-choice interface. Table 2 shows how many questions are on each DB2 exam, how many you need to correctly answer to pass, and how long you have to take the exams.

Table 2. Exam information

Exam Exam Title Number of questions Correct questions to pass Time (minutes)
700DB2 UDB V8.1 Family Fundamentals5461%75
701DB2 UDB V8.1for Linux, UNIX and Windows Database Administration7061%90
702DB2 UDB V8.1 for z/OS Database Administrationn/an/an/a
703DB2 UDB V8.1 Family Application Development6357%75
704DB2 UDB V8.1 for Linux, UNIX and Windows Advanced Database Administration5756%75
705DB2 Business Intelligence Solutions V8.15658%75
706DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration Upgrade exam3055%40
442DB2 Content Manager V86464%90
n/aDB2 Problem Determination Masteryn/an/a60

Before starting the certification process, read the IBM "terms and conditions" and current explanation for their program to ensure you understand and feel comfortable with it before committing.

What are the tests like?
Different candidates have different experiences. Nevertheless, there exists some conventional wisdom on the subject. Compared to other database vendors' exams, the questions on the DB2 tests are difficult. But as Table 2 shows, the percentage of questions you need to answer correctly to pass is quite low. Experience at IDUG conferences indicates a pass rate of about 75% for DB2 exams. Remember that all questions are multiple choice, so answer every one (there is no penalty for wrong answers, so at least guess at every question). The exam software allows you to mark questions to return to later, so you can skip hard questions and return to them.

The time allowed for the exams is generous. You'll only consume the allotted time if you check your work carefully. When you're done with the exam, click the Done button and the software instantly shows you whether you passed. You can print copies of your score on the spot via the LAN-attached printer. If you pass, IBM sends you a certificate via mail for printing and framing. You may also request one by mail.

What if you do not finish the test in the allotted time? The screen freezes, a message tells you the exam has ended, and you'll see the same pass or fail message you would if you had clicked the Done button yourself. Oops!

You must study for the exams. Being a DB2 guru won't help if you don't study! The tests are broader than most IT pros' knowledge base and also very specific in what they ask. They are designed to be rigorous.

Compared to competing database vendors' exams, the IBM DB2 tests seem to have fewer overly specific trivial pursuit questions and more questions requiring deep thought. The exams are intended to test your DB2 knowledge and ability to figure out DB2 problems (not just your ability to memorize what's in the certification study guides). My feeling is that they achieve this a little better than competitors' tests. Be prepared to stay cool while facing some tough questions. Remain secure in the knowledge you'll only need a low percentage of questions answered correctly to pass.

Useful background information on certification is freely available at Certification Magazine's Web site and Cramsession.com. You can always seek technical help while you study in discussion forums at DBAZine, Database Journal, IDUG's Web site, the IBM DB2 Developer Domain, DBForums.com , and Database Toolbox. These are great resources, with tons of technical articles and active online communities from which to learn.

What should you study?
Books that specifically target certification are your best bet. Their coverage matches what you’ll face on the exams. Other DB2 books can be useful in pursuing your goal as well, but concentrate your effort on those designed to help you certify. Table 3 lists DB2 certification books and other worthy tomes. You can find enlightening reviews by those those who have used the books for exam preparation posted on websites like Amazon or Barnes and Noble online , and you can purchase the books there as well. IBM’s website also offers a certification booklist.

My personal recommendation is the DB2 V8 certification guides written by Roger Sanders. Each book covers one DB2 exam and includes “practice questions” to hone your exam-readiness. The books hew strictly to what you need to know for the exams: they don’t waste your time with extraneous material, and they don’t leave anything out you need to know (full disclosure – I have no financial interest in these books but have acted as an unpaid reviewer and wrote a foreward to one).

Table 3. DB2 version 8 certification books

For Exams Title Authors ISBN
700DB2 UDB V8.1 Certification Exam 700 Study GuideRoger Sanders0131424653
700, 701DB2 UDB V8.1 for Linux, Unix, and Windows Database Administration Certification GuideBaklarz and Wong0130463612
701DB2 UDB V8.1 Certification Exams 701 and 706 Study GuideRoger Sanders0131840487
703DB2 UDB V8.1 Application Development Certification GuideMartineau et al0130463914
702DB2 UDB for OS/390 Version 7.1 Certification Guide (Version 8 release in 1st quarter 2004)Yevich and Lawsonl0130650765
705Business Intelligence for the EnterpriseMike Biere0131413031
704Advanced DBA Certification Guide and Reference for DB2 UDB V8.1 for Linux, Unix and WindowsSnow et al0130463884
706This book also covers the Upgrade Exam -- DB2 UDB V8.1 Certification Exams 701 and 706 Study GuideRoger Sanders0131424653
Other Worthwhile DB2 Books….
--DB2 Version 8: The Official GuideZikopoulos et al0131401580
--DB2 UDB V8 Handbook for Windows and UNIX/LinuxPhilip Gunning0130661112
--Teach Yourself DB2 UDB in 21 Days (covers Version 8)Susan Visser and Bill Wong0672325829
--DB2 Developer’s GuideCraig Mullins0672311682
--DB2: The Complete Reference (covers Version 7)Zikopoulos et al0072133449
--DB2: The Complete Reference (covers Version 7)Zikopoulos et al0072133449
512DB2 Fundamentals Certification for Dummies (covers Version 7)Zikopoulos et al0764508415
512, 513DB2 Administration All-in-One Exam Guide (covers Version 7)Roger Sanders0072133759

Whichever certification guidebook you choose, you increase your chances of passing by supplementing them with complementary study resources. Here are some suggestions.

IBM offers two free courses that you install and learn from on your PC. Both are GUI-based and interactive. The first is oriented to the DB2 developer cert (exams 700 and 703), the second towards the Linux/Unix/Windows DBA tests (exams 700 and 701). Download both from IBM at http://www7b.software.ibm.com/dmdd/trainingcertification.html. These courses are excellent.

IBM also offers a series of six free interactive online tutorials that prepare you for exam 700, downloadable from http://www7b.software.ibm.com/dmdd/trainingcertification.html, or directly from http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_V8_tut.html. These are great background if you’re new to DB2.

It is essential that you take “practice tests,” mock-ups of the real thing with similar questions. You need to be test-ready. IBM offers a free online test for each certification exam. Take any of them via the web from http://www7b.software.ibm.com/dmdd/trainingcertification.html or http://certify.torolab.ibm.com/ice/displayPage/en. You must have Internet Explorer 5 or above or Netscape Communicator 4.7 or above to take these practice exams. The other source for practice questions are the certification books by Roger Sanders mentioned earlier.

The DB2 Developer Domain has free DB2 tutorials, technical articles, and sections where you can "ask the experts" and even "meet the experts." Bookmark this site in your browser as a top choice for learning DB2.

You'll need hands-on experience with DB2 to pass the exams. Get it at work, or install DB2 UDB V8 on your home PC running Windows or Linux. You can directly download DB2 UDB for free from IBM’s DB2 Developer Domain (just click on the IBM support and downloads tab at the top of the webpage). Many of the certification books for the core tests include a CD-ROM with a trial copy of DB2 UDB V8 for Windows PCs. The trial versions shipped in the books have a special trial period of 180 days. The trial version that is downloaded is 90-days. You can always reinstall the program if your certification effort takes longer.

If you need any of the DB2 manuals, all come with the product and are accessible when you install the database from the CD-ROM. Or you can download any manual for free from IBM in PDF format. You can also obtain IBM redbooks on advanced topics by free download from http://www.redbooks.ibm.com/, specifically DB2 redbooks.These web sites allow you to order hardcopies, if you so choose.

Do you need classroom training? My feeling is that IT pros experienced in the area in which they are testing do not need it to pass. But those new to their testing topic should consider it. The DB2 exams are difficult enough that it's very unlikely you'll pass from book learning alone. IBM's training site can help you decide.

IBM posts the official test objectives, suggested resources, and training information, and short self-assessment exams. Review all of them to ensure your progress is on target.

The most effective certification effort encompasses three essentials:

  • Book study
  • Practice tests
  • Hands-on DB2 experience.
The sources above give you everything you need to cover these bases.

How to get certified for (almost) free
A Computerworld article (4) estimated the cost of a typical certification at between $4,000 and $10,000. Wow! This is real money if you pay it yourself. Your first step is to see if your employer will pay for either all or some of your certification costs. About half of employers pay most certification costs, according to a recent informal survey (5). To convince your manager of the value of certification, access the promotional materials developed by IBM marketing professionals and use them as your own. For example, IBM’s training and certification site includes videos on benefits, testimonials and other “convincers” ready to hand over to your manager at http://www-306.ibm.com/software/data/education/cert/.

If your company does not cover certification or training costs, you can still minimize your expense. The key is to take advantage of the many free resources IBM offers. A great beneift of certifying with DB2 (as compared to Oracle or SQL Server), is the outstanding breadth and quality of the free, IBM study resources.

Leveraging these resources makes it possible to certify with DB2 for very little. For example, my Database Adminstrator certification came in at a total of less than $150. This reflects the only cost you really must bear, purchasing the certification books you’ll study. You can avoid paying the exam testing fees (currently $120 per test) by attending conferences that offer free testing, such as those of the International DB2 Users Group (IDUG) and the DB2 Technical Conference.

We've mentioned above how to take the core exams for free, where to get free PC-based courses, tutorials and study guides, how to get DB2 UDB for free, and where to download free DB2 manuals and redbooks. Table 3 summarizes these resources and where to get them. Together with the certification books, they represent everything you need to pass the tests.

Table 4. Recommended FREE DB2 resources

For Exams Resources
MostFree testing at conferences: DB2 Users Group and Technical Conference
700 Exam Preparation Resources
701 Exam Preparation Resources
700, 701 Downloadable PC-based course for DBAs
700, 703 Downloadable PC-based course for Developers
All Trial copy of DB2
All DB2 manuals
All DB2 redbooks
All Study guides or “Cramsessions,” plus tips, what you need to know tips to pass, and advice on the best study materials
AllThe International DB2 Users Group offers many DB2 resources.
All Official test objectives, sample tests, and resource lists for each exam
All DB2 Magazine runs a regular column on DB2 certification.
Problem Determination Mastery A set of 9 downloadable tutorial courses for this exam

While the monetary cost of DB2 certification is minimal, your time is also a valuable, limited resource. Here again, look to your employer first for support. Even companies that do not pay for employee certification will often offer study time at work. The key is to show them that they will receive a tangible benefit from your effort. Most organizations want to quantify training and progress in skills. This fits perfectly with certification, since it produces a quantifiable result. To sell managers on the value of certification, there is no better pitch than that written by the marketing professionals at the vendors themselves. Show your manager IBM justification for certification.

If your company won't support your certification effort, we've shown how to minimize your out-of-pocket expense. Even if your company doesn't let you study at work, the certification books, DB2 manuals and redbooks, and other DB2 resources are all legitimate tools for solving work problems. No one is likely to object if your productivity and problem-solving abilities soar as you use these materials at work.

Pool your resources
I've known several IT pros who successfully certified by creating a study group, or teaming up with a study buddy. You've seen by now that certifying requires some up-front work in gathering resources and making judgments about what and how to study. The whole process can be a lot easier (and more fun) when done with friends.

If you take this approach, be sure you've all got compatible goals. It doesn't matter much if one person in a study group drops out before completion, but a shared schedule is critical. All members must commit to taking the exams in the same order in about the same timeframe for the group to succeed.

Don't have local friends with the same certification interests? Try a virtual community at one of the web sites below.

What next?
Whether DB2 certification is "worth it" is a highly personal decision. My friends, professional peers, and I have benefited, but research the issue for your own satisfaction before committing to the effort. Check out certification trends and community at major certification websites like Cramsession.com, Certification Magazine, or CertifiedComputerPro. Investigate online job ads at Monster, Dice, and JustDB2Jobs. And join the online DB2 community at the DB2 Developer Domain, IDUG, or DBForums. Then, make your own decision about certification benefits and costs.

There are unwritten rules to successfully certifying with any product. Candidates who are aware of them prior to testing have a distinct advantage. I've included these DB2 certification secrets in this article. Happy testing!

References

  • (1) See articles in EWEEK from 05/26/03, 03/17/03, 05/08/02 and 07/07/02; INFOWORLD, 05/08/02; DATABASE TRENDS AND APPLICATIONS, 07/02 and 06/02; INTELLIGENT ENTERPRISE 06/28/02.
  • (2) Gartner Dataquest statistics quoted from EWEEK, 05/26/03, p. 18.
  • (3) The RDBMS Top Ten: License Sales Analysis and Market Forecast, 2001-2006. Document #28096. International Data Corp. (IDC), 10/02.
  • (4) COMPUTERWORLD 03/01.
  • (5) Posted at Cramsession.com 10/03.

About the author
Howard Fosdick is an IBM-certified DB2 DBA and an Oracle-certified DBA. He's a founder and former president of IDUG and the Midwest Database Users Group. He works hands-on as an independent DBA contractor and can be reached at: hfosdick@compuserve.com
Home