Looking for an interesting way to introduce DB2 to new employees? Try a new approach to traditional learning with IBM DB2 Gaming. Take advantage of these new interactive self-study learning games to build your DB2 skills using real world problems and solutions. Play now and experience these games at no charge to you!
IBM DB2 Detective GameGetting started with DB2 9 and SQL can be easy with this new interactive game. Using an crime investigation theme, this introductory level game teaches relational database concepts and shows how technology can be applied to solving real-life problems.
IBM DB2 Business GamePut your DB2 and SQL skills to the test with this intermediate level game! Jump into a “run your own business” scenario, where your company’s future depends on a key report needed to secure funds for a critical upgrade. Play the game and you may be ready to transfer your skills into action!
Thanks to Pat and others for these learning assets!
Keep on Learning
svisser1 2700018UK9 2,704 Views
svisser1 2700018UK9 3,088 Views
Most Canadians who browse in bookstores know that deep technical books are rarely found at Coles or Chapters stores. I presume that this is true in most countries.... regardless of the bookstore's name. So where do you find books that support IBM products and technology, such as DB2? Online bookstores, of course.
Canada has two primary choices: amazon.ca and chapters.indigo.ca. Both online stores offer discounted prices, free or low cost shipping, and a very wide selection. I want to tell you about something I learned about amazon.ca this morning.
Apparently for a large number of titles, amazon.ca... and perhaps other online sites, tend to list the title and its details, but will not have them in stock UNLESS there is an order. There will be a message saying that the book will ship in 4-6 weeks. I've had many people tell me that they want one of the books for DB2, but cannot wait 4-6 weeks for delivery, so they look for a different way to get the book. Sounds like CATCH-22... a book must be ordered before it is stocked, but listed as "out of stock", who will order the title?
I don't have confirmation that the same policy is in place for chapters.indigo.ca, but I suspect that it is. In a way I don't blame the buyers at these bookstores as there are thousands of new titles every month, so which books should you stock? Which ones will sell? Not an easy decision, I'm sure. I guess I could place an order at these sites just to get the books I care about stocked....
The other interesting thing happening in Canada right now is that our dollar is at par with the US dollar. Canadians are used to seeing two prices on the backs of all books... a Canadian price and an American price. These prices are set when the book is first published, but rarely change when the currency fluctuates. Again, a difficult thing to do. As an example, the Understanding DB2 9 Security book has a price of $49.99 US and $61.99 Canadian! What a huge difference! What to do???
Well, you could order the book from amazon.com, but I'm not sure what the shipping charges would be... or if this is even allowed given that there is a Canadian version of amazon. If you live near a border or plan to travel to the US, you could buy when you are there.... a minimum of a $12 difference can be worth it. Another idea that someone mentioned to me is to use US$ at a Canadian store. Most large stores here accept both currencies and offer an exchange depending on the current exchange rate. But... if we are in Canada, I think the store would still charge the Canadian price regardless of the currency used.... so you'd still be paying the inflated price.
Let me know if you have any experience with these dilemmas... I'd like to know what your suggestions are.
svisser1 2700018UK9 3,254 Views
I know that it is very difficult for some people to arrange to go to a conference at their company's expense. Even IBMers who are trying to attend an IBM conference, it can be challenging. It seems that the rule is to now have 2 presentations or more accepted at the conference. Maybe this is a requirement for many other companies as well. If it's tough to get approval if you volunteer to be a speaker at the conference, you can imagine how difficult it is to get approval to attend the conference to be educated.
A friend of mine suggested that we look into providing a scholarship to one or more people that would entail a free registration to the conference. I like the idea and will promote this idea for future conferences where I can. As I was thinking of this, I came across this news item:
Got 10 minutes? Enter the DB2 9 Compression ChallengeThe DB2 9 Compression Challenge is less than a month away from closing and we need your entry. There is no purchase necessary and it takes only 10 minutes to enter. You don’t need to be running any version of DB2 to participate. First Prize - Full-event registration to one of IDUG's 2008 events. Second Prize – Upgrade Membership for the same eventsIDUG 2008 - Australia (March 2008 in Sydney, Australia) IDUG 2008- North America (May 5-10, 2008, in Dallas, Texas) IDUG 2008 - Europe (Dates/Location TBD)
So a "scholarship" to attend an IDUG conference in 2008 is possible! All you have to do is to enter this challenge. My friend is working at a shop that isn't running DB2... yet, so I like the caveat that You don’t need to be running any version of DB2 to participate.
I hope this gives an opportunity to one or two people who have not been able to go to conferences... and would like to. Conferences are a great way to keep up to date on a large variety of related topics. It helps you network with people who can help you in many different ways. And, perhaps most obvious of all, going to a conference gives you an opportunity to earn several certifications.... normally the tests are $150 US, regardless if you pass or fail, so taking exams is a very easy way to justify attending a conference.
But, if you are still unable to go a conference, don't despair. IBM provides many learning opportunities that you can take part in, either for free or inexpensively. I'll use books as an example... see our Bookstore Page for links to excellent books that can be used for self-study.... and we try to point to the lowest cost provider of the books. The other book example is of course the IBM Redbooks. For free you can download PDF versions of technical books that are excellent references as well as self-study resources. DeveloperWorks is another example where you can find a variety of helpful technical documents... free of charge. As for classroom education, our new ILO offerings are an excellent way to take award-winning education, right at your desk.
svisser1 2700018UK9 2,882 Views
Building an Intelligent Web: Theory and Practice will be available in October. The book is intended to be a textbook, so the price is higher than other books that I mention.
Here are the details:
The World Wide Web has become an extremely popular way of publishing and distributing electronic resources. Though the Web is rich with information, collecting and making sense of this data is difficult because it is rather unorganized. Building an Intelligent Web introduces students and professionals to the state-of-the art development of Web Intelligence techniques and teaches how to apply these techniques to develop the next generation of intelligent Web sites. Each chapter contains theoretical bases, which are also illustrated with the help of simple numeric examples, followed by practical implementation. Students will find Building an Intelligent Web to be an active and exciting introduction to advanced Web mining topics.
Topics covered include Web Intelligence, Information Retrieval, Semantic Web, Classification and Association Rules, SQL, Database Theory, Applications to e-commerce and Bioinformatics, Clustering, Modeling Web Topology, and much more!
Includes IBM DB2 Express-C, a data server used in the development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more.
If you are a professor or curriculum developer, request a sample copy from the publisher. We're very pleased that the authors and publisher of this book decided to include DB2 Express-C on the CD that is shipped with the book. Most publishers are reluctant to ship CDs with their books any longer, but it can be very important, especially for students.
svisser1 2700018UK9 3,126 Views
I've recently read the following articles about the pressure IT people have to continuously upgrade their skills in order to remain employable and valuable to their employers:
IT Workers Battle to Keep Skills CurrentDATE: 04-SEP-2007By Deborah Perelman
Back To School: Funding An Ongoing EducationSeptember 2007 - Daniel Margolis New instructor-led online (ILO) training
My team, WW Data Servers Education & Enablement, is either directly or indirectly involved in the creation of many of the training resources that are available to you in the Data Servers area. Our mission is to establish Education as a business driver for our customer’s and partner’s success. We do this by offering you a variety of ways for you to develop your skills, either as a first time user of database products, or as an established expert who wishes to stay abreast of key changes. Here are some of the things that we offer:
* IBM Training- traditional classroom educationOur excellent instructors, high quality materials and hands-on labs combine for an experience that keeps students coming back. In fact, according to our after-class surveys 93% of our students say they will come back to IBM for more training and 97% are extremely satisfied with their instructor.
Here are some of the courses you may want to consider:DB2 9 for z/OS Application Performance and Tuning (CV960)DB2 9 for z/OS Transition Workshop (CV300)DB2 9 for LUW Advanced Database Recovery (CF492)DB2 9 for LUW Multiple Partition DBA Workshop (CF242)DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CG242)
- instructor-led online (ILO) educationILO courses are taught by a live instructor on a specific date and time. These courses are exactly the same as their classroom equivalent, including the course length, content and student materials. Students receive their course materials in advance by mail. To participate on the day of the class, all you need is a high-speed Internet connection. This allows you to connect to a virtual classroom enabling you to interact directly with the instructor to ask questions or clarify material...just as you would in a physical classroom.
Here are some of the courses you may want to consider:DB2 9 Database Administration Workshop for UNIX - Instructor Led Online (3L210)DB2 9 Database Administration Workshop for Windows - Instructor Led Online (3L230)DB2 9 for LUW Quickstart for Experienced Relational DBAs - Instructor Led Online (3L480)DB2 for z/OS Data Sharing Implementation - Instructor Led Online (3V210)DB2 UDB for z/OS Data Sharing Recovery and Restart - Instructor Led Online (3V920)
* CertificationEarning a certification from IBM is a way for you to demonstrate your expertise to the world. It validates your skills and demonstrates your proficiency in the latest IBM technology and solutions. The certification requirements are tough, but it's not rocket science, either. It's a rigorous process that differentiates you from everyone else.
Here are some of the exams that you may want to consider:
Exam 730: DB2 9 FundamentalsExam 731: DB2 9 DBA for Linux UNIX and WindowsExam 732: DB2 9 DBA for z/OSExam 733: DB2 9 Application DeveloperExam 734: DB2 9 Advanced Database Administrator for Linux UNIX and WindowsExam 736: DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
* BooksBooks are wonderful resources to both build and refresh skills. They provide a wonderful opportunity for self-paced learning while becoming a handy reference guide for use on-the-job. IBM offers many great resources to build your library of technical and business skills - two of which are IBM Retail Books and IBM Redbooks.
- Retail books about IBM products are technologies are growing in number. Hopefully you are able to find some in physical bookstores or when searching online bookstores. For a complete list of those available for Information Management, see Information Management Retail books.
Here are some you may want to consider:Understanding DB2 9 Security (IBM Press) by Rebecca Bond, Kevin Yeung-Kuen See (IBM), Carmen Ka Man Wong (IBM), Yuk-Kuen Henry Chan (IBM).
IBM DB2 9 New Features (McGraw-Hill) by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton (all IBM)
DB2 9 Fundamentals Certification Study Guide (MC Press) by Roger Sanders
DB2 9 for Linux, Unix, and Windows: DBA Guide, Reference and Exam Prep (IBM Press) by George Baklarz (Author), Bill Wong (Author), Paul C. Zikopoulos (Author)- Sixth Edition of our most popular book EVER!
DB2 for Developers (MC Press) by Phil Gunning - expected in December.... SPECIAL 37% PRE-ORDER DISCOUNT!
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press) by Susan Lawson and Dan Luksetich - October - SPECIAL 30% DISCOUNT ON PRE-ORDERS!
DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press) by Roger Sanders - October
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press) by Roger Sanders
- IBM Redbooks are well-known to long time IBM customers, but if they are new to you, essential IBM Redbooks are developed and published by the IBM International Technical Support Organization, ITSO. The ITSO develops and delivers skills, technical know-how, and materials to IBM technical professionals, Business Partners, clients, and the marketplace in general. Most people read IBM Redbooks electronically or by printing out sections of the PDF files that may be downloaded, but did you know that you can also order a printed copy? It is called Print on Demand.
Some that you may want to consider: DB2 9 for z/OS Performance TopicsDatabase Partitioning, Table Partitioning, and MDC for DB2 9Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
* Tutorials and articlesAlthough you should be able to find tutorials and articles about DB2 in many locations, we focus on ensuring that the DB2 portal of developerWorks is kept up to date with a variety of learning materials.
Here are some you may want to consider:DB2 9 Fundamentals certification 730 prep seriesDB2 9 Database administration 731 certification prep seriesDB2 9 Application Development 733 certification prep series
If my team doesn't create it, we still try to promote it.... like conferences, newsletters, podcasts, etc. If you have some education that you'd like me to know about, make a comment.
I hope that you're able to find something in this list of options to help you keep your skills current!
svisser1 2700018UK9 2,875 Views
Every now and again, it is useful to have a list of valuable links..... Here is a list that I was quickly able to put together.
* IBM DB2 product support on-line
* For IBM DB2 Version 9 product documentation (HTML)
* For IBM DB2 Version 9 product documentation (PDF)
* DB2 9 Home Page
* Information Management Training and Certification – Certification, training, retail books, offers, and more
* DB2 9 Information Center
* DB2 9 Support Home Page
* DB2 9 Manuals and Documentation
* The DB2ZONE
* Blog on DB2 LUW
* IDUG DB2-L Listserver
* IBM developerWorks - DB2 portal
* LAZYDBA Listserver
* comp.databases.ibm-db2 Google Newsgroup
* IBM Redbooks
* Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.
* IDUG – International DB2 User’s Group
* DB2 Magazine Online
I hope you find it useful. If there are other links that you'd like me to be aware of, make a comment. We often use these links as part of promoting our skills resources.
svisser1 2700018UK9 2,840 Views
The August edition of the DB2 Magazine Newsletter came out today and I learned about this challenge that IDUG is running... IBM is sponsoring:
Introducing the DB2 9 Deep Compression Challenge
Based on feedback from early users, Deep Compression is a hugely-popular feature of DB2 9 for Linux/UNIX/Windows, IBM's latest data server. To highlight this feature, the International DB2 Users Group (IDUG®) is pleased to announce the IDUG DB2 9 Deep Compression Challenge, a non-competitive industry-wide competition aimed at highlighting the storage optimization benefits - costs savings, in particular- users can achieve with the Deep Compression feature available in DB2 9 for Linux, UNIX and Windows.
For details see the August edition of the DB2 Magazine Newsletter and the description of the IDUG DB2 9 Deep Compression Challenge.
svisser1 2700018UK9 3,022 Views
I hope many of you are able to join us in Las Vegas this October for the second annual Information On Demand Global Conference. If you are able to come, remember that tomorrow is the deadline for the Early Bird Special where you can save $200 on registration.
I've been putting together a book signing schedule for some of the speakers who are also authors. Those who are confirmed for a signing:
1) Stephen Covey - The 8th Habit: From Effectiveness to Greatness2) Chris Anderson - The Long Tail3) Paul Zikopoulos - To be announced at the conference.4) Carlton Doe - IBM Informix Dynamic Server 11, The Next Generation of OLTP Data Server Technology5) Carl Kessler - Outside-in Software Development: A Practical Approach to Building Successful Stakeholder-based Products
In addition, here is what the team has planned for this year's conference:
* 7,000+ attendees * 200+ customer and Business Partner speakers* An Expo Solutions Center powered by 200 Business Partners* More compelling content: 589 total elective 1 hour sessions; 100 Business Leader sessions; 468 Technical Skill Building sessions* More technical opportunities* Enhanced community programs* And the list goes on . . .
I hope to see you there! Besides the book signings, you'll find me helping in the certification lounge.... were you there last year with all the decadent food and even better: the massages!
svisser1 2700018UK9 2,813 Views
Have you ever looked at the annual results of the Certification Magazine Salary Survey? This year, take part in the survey to see how your salary measures up to the others who answer the survey!
Here are the details:
On Aug. 7, 2007 Certification Magazine launched its 2007 Salary Survey, which compiles compensation, certification and education information for IT professionals. The Litchfield Group, an independent research company, will conduct the research and finalize the data. The survey will close Friday, Aug. 31. To participate in this year’s survey, visit www.certmag.com/salarysurvey.
Last year, 22 companies agreed to partner with Certification Magazine as Salary Survey sponsors. Their extensive promotional efforts via e-mail, newsletters and Web sites helped draw more than 35,000 respondents worldwide — given this participation level, it was truly an industry-wide survey. This year, 23 companies have agreed to partner with Certification Magazine as Salary Survey sponsors. Additionally, the survey has been revised to expand its scope to represent the industry as a whole. The survey results will be reported in the cover story of Certification Magazine’s December 2007 issue. Every year, this article provides vital analysis on the state of the certification industry and IT in general. To ensure delivery of the December issue, sign up for a FREE subscription to Certification Magazine at www.certmag.com/subscribe.
svisser1 2700018UK9 2,606 Views
Check out Daniel Krook's blog from Aug 3: "Thoughts on the DB2 9 Fundamentals exam" where he discusses his study strategy and experience in preparing for, and passing, Exam 730: DB2 9 Fundamentals. You can find Daniel's blog, plus many others on PlanetDB2.
Let me know if you want to share your thoughts as well....
svisser1 2700018UK9 2,791 Views
This book was written by members of IBM Research: Mining the Talk: Unlocking the Business Value in Unstructured Information * By Scott Spangler, Jeffrey Kreulen * Published by IBM Press
Information from the publisher:
In Mining the Talk, two leading-edge IBM researchers introduce a revolutionary new approach to unlocking the business value hidden in virtually any form of unstructured data–from word processing documents to websites, emails to instant messages.
The authors review the business drivers that have made unstructured data so important–and explain why conventional methods for working with it are inadequate. Then, writing for business professionals–not just data mining specialists–they walk step-by-step through exploring your unstructured data, understanding it, and analyzing it effectively.
Next, you’ll put IBM’s techniques to work in five key areas: learning from your customer interactions; hearing the voices of customers when they’re not talking to you; discovering the “collective consciousness” of your own organization; enhancing innovation; and spotting emerging trends. Whatever your organization, Mining the Talk offers you breakthrough opportunities to become more responsive, agile, and competitive.
ISBN-10: 0-13-233953-6; ISBN-13: 978-0-13-233953-7;
Also from now until 10/31 there is a 35 percent discount - by using CODE - MINING at Pearson
svisser1 2700018UK9 2,913 Views
This one is Exam 732 - DB2 for z/OS V9 Database Administration exam.
If you are already certified as an IBM Certified Database Administrator - DB2 8 for z/OS, all you need is to take and pass the new exam 732.
If you are new to certification, you must take Exam 732 plus the prerequisite: Exam 730 - DB2 9 Fundamentals.
Exam 732 has 73 questions and you are allowed a maximum of 90 minutes to complete the exam. You must score 57% or greater to pass the exam. The sections and weightings for this exam are:
* Design and Implementation 26%* Operation and Recovery 29%* Security and Auditing 11%* Performance 29%* Installation and Migration/Upgrade 5%
The IBM Certified Database Administrator - DB2 9 for z/OS certification is meant for the lead database administrator (DBA) for the DB2 9 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of the DB2 9, specifically the new features and functionality related to Version 9. They are capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.
For more information about this exam and others that were released for DB2 9, see our Training and Certification web site.
Susan Lawson's book is getting close to being available as well... stay tuned... but I suspect it will be ready in time for the IOD conference in October. If you are planning to be at the conference, consider signing up for the pre-conference class to help you prepare to pass the exam, free of charge, while at the conference.
svisser1 2700018UK9 2,795 Views
Take Test 918 - System Administration for IBM Informix Dynamic Server V11 to validate your IDS V11 skills. Pass the exam and earn an IBM Certified System Administrator - Informix Dynamic Server V11 Certification.
This new exam is broken up into eight sections consisting of 71 multiple choice questions. Candidates have 120 minutes to complete the exam and must achieve 70% or greater to pass. Here are the sections and the weighting for each:
Section 1 - Installation and Configuration (14%)
1. Determine appropriate connection types and communication protocols 2. Plan for Distributed System capabilities 3. Determine the number and size and placement of logical and physical logs to accommodate transaction activity 4. Determine when an instance can/should use AIO or KAIO 5. Set up Operating System files and parameters 6. Demonstrate ability to configure a secure DBMS 7. Configure and manage dbspaces and sbspaces
Section 2 - System Activity Monitoring (no Java) (13%)
1. Monitor activity using systmaster, systadmin, and onstat utilities 2. Monitor the message log file for abnormal activity 3. Use the oncheck command /SQL API to view information about the database server
Section 3 - Troubleshooting (14%)
1. Isolate problems using systmaster, systadmin, onstat utilities 2. Use concurrency and locking
Section 4 - Performance Tuning (20%)
1. Recognize Operating System resources affecting system operations 2. Configure shared memory parameters 3. Determine optimal disk layout and configuration 4. Utilize Parallel Database Query (PDQ) to optimize query performance 5. Use UPDATE STATISTICS to achieve optimal performance 6. Configure system for optimal checkpoint duration 7. Monitor the number of Virtual Processors (VPs) needed for the resources available 8. Manage network parameters for optimal communication performance
Section 5 - Database Server Operations (13%)
1. Recognize fast recovery operations 2. Manage temporary tables and files 3. Use of operation modes
Section 6 - Backup and Restore (11%)
1. Select the appropriate backup and restore strategy and restore utilities for a particular situation 2. Configure Onbar parameters for optimal backup and restore performance 3. Configure ontape parameters for optimal backup and restore performance
Section 7 - Replication (14%)
1. Demonstrate the ability to manage and configure ER and HDR
Section 8 - SQL (14%)
1. Use the SQL admin API 2. Prepare and use user defined types 3. Use SQL built-in functions
To prepare for the exam, there are classes, tutorials, and a book being written by Carlton Doe that will publish next year. The exam can be taken at Prometric Testing Centers (prometric.com/ibm) or at select conferences.
svisser1 2700018UK9 2,622 Views
Common questions about certification go something like this: Do I have to get certified?, Is it worth anything?, and How do I get it? I've put together answers to these questions along with some other advice that I hope you find useful.
Do I need a DBA Certification to get a job as a DBA?
Not always as it depends on a number of factors. If you've worked as a DBA before or have a degree in an IT related field, and have experience using DB2, you may not need to get certified. I'd recommend it anyway, as regardless of what you already know, you'll learn something new during the process of earning a certification that may be tremendously valuable to you or your company If you have an older certification, upgrading to the most current level is an easy way to ensure that you stay on the top of your game.
If your employer requires you to be certified, or a job you are trying to get lists certification as a requirement, then for sure you'll need to earn the required certifications.
If you have little experience using DB2 or if you have a degree in a non-IT field and you're trying to break into the database arena, it's generally a good idea to get a few DB2 Certifications so employers take you a little more seriously.
For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
Classroom education is an excellent way to learn, but may be difficult to justify for some people due to costs. If you find that you learn most effectively through classroom education, encourage your employer to pay for them. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
Is there an easier way to get certified, that doesn't include studying?
Not many things of value don't require an effort. There are sites on the web that claim to have the actual certification exam for you to buy and memorize in order to pass the exam. These are created by a previous applicant who shares knowledge of the questions on a certification exam with a third party. There is no noble purpose of this information sharing. It is cheating, pure and simple. IBM has a non-disclosure agreement that they make every exam applicant agree to before they allow you to take the test. Any person who creates or gives out questions or answers from a certification exam is in violation of the NDA and if you get caught "dumping", you're likely to have your certs revoked, at a minimum! And, if you get caught using someone else's dump, you'll get your certs revoked and will never be able to get certified through IBM again.
Further more, there's the credibility issue of this information. Most dumps are littered with errors, spelling and otherwise. There are a lot of companies out there that sell brain dumps, but just because you pay for their version of sims / exams, doesn't make it legal. Be very careful of cheap exam sims because they tend to be brain dumps. If you have any questions about the validity of a company's product, ask other people in the DB2 Forums or go to IBM directly.
As mentioned earlier, DB2 exams are experience based, so lots of practice using the product in as many areas as possible, may allow you to pass the exam without studying.
If I take the assessment exams repeatedly, will I eventually see all the questions on the certification exam?
In the past, IBM offered free assessment exams to all candidates. It seems that several people were taking these exams multiple times in a possible attempt to memorize all of the questions. The bad news for these people is that the set of questions on the assessment exams is different than the set on the certification exams. Also, memorizing the questions and answers will not help you learn the material at all! I suggest that you take at least one assessment test to see how ready you are, but only AFTER you have read the exam objectives and had either experience or training. By the way, the assessment exams now cost $10 per take, so that will help you limit the number of assessment exams you decide to take. Here is the site that will get you to the assessment exams: ibm.com/software/data/education/cert/assessment.html.
Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:
Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.
IDUG DB2-L Listserver
IBM developerWorks - DB2 Portal
IDUG – International DB2 User’s Group
Is it true that the DB2 Fundamentals Exam (700 or 730) caters to an LUW audience?
Not at all. The DB2 Fundamentals Exam contains only questions that are true for each and every platform! In fact, I've noticed that people whose primary area of experience is with DB2 for z/OS find this exam pretty easy.
Recommended Learning Path for Certification:
Here is the recommended path I suggest you take to prepare for a DB2 exam:1) Choose the exam you want to take based on your job role. The DBA and AppDev certifications first require that you are certified as a Database Associate. To help you decide where to start, see the certification roadmaps
2) Read through the exam objectives. Every question on the exam relates directly to one or more of the exam objectives. For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
3) If you are experienced with DB2 and feel that you are prepared to pass based on what you saw in the exam objectives, take an assessment exam. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses.
4) If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
5) Decide on how you best want to increase your skills, and test your level of skill achieved by taking an assessment exam.
a) Consider buying one of the Certification Study Guides to refresh and deepen your skills:
b) Take a free tutorial.
c) Take an education class from IBM or one of its partners.
6) Feel ready? Book your test! Testing centers are located around the world. Find a location closest to your office or home: www.prometric.com/ibm. If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
To quote an article I read on sqlservercentral.com:* Schedule at least 1 free day (vacation day, etc.) off of work the day before you are scheduled to take your exam. This will give you time to relax, rest, and refresh your memory on any subjects you feel less that 100% on.
* Go to the bathroom before the exam and try not to drink or eat right before it. Some places allow you to have bathroom breaks during exams, some don't. Regardless of your local testing center's policy, it's hard to think when your bladder is full, so you might as well take care of business before you have to concentrate on the important stuff.
* Take your time during the exam. Yes, you have a time limit, but if you don't learn to read the questions before you answer them, then you might miss the most important detail (such as the "is not" portion of the question).
* Scenario based question groups. Briefly read the scenario, but don't get stuck on the details until you get to the questions. Scenario based questions often have the scenario in a separate window or a pop-up window that you can refer back to when you're answering the actual questions. This will save you time during the exam and keep you from focusing on the wrong details.
* (and the most important) Relax! It only feels like it's the End of the World. Once it's over, you'll feel so much better. And if you passed, then it's time for some serious celebrating!
I hope this helps you find a way to prepare to take one or more DB2 exams. I'd be happy to hear from you if any of these tips helped you on your journey towards being certified. If you have other questions that I should answer, throw them at me!
Have a great day!
svisser1 2700018UK9 2,643 Views
I'm writing an article with several tips to help you get a DB2 certification. There is a lot of information that I want to share, so it's taking me longer than expected... so... I'll keep writing and post in a few days.
In the meantime, I want to tell you about the new DB2 Certification blog by Roger Sanders, hosted on DB2 Magazine's Web Site. Roger plans to post a couple of sample questions and answers every two weeks.
Here is a link to the site: http://www.db2mag.com/blog/main/archives/db2_certification/index.html