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.
Keep on Learning
svisser1 2700018UK9 2,915 Views
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,644 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
svisser1 2700018UK9 2,725 Views
ILO is a fairly new acronym for me... and maybe for you as well. ILO = Instructor-led online training.
Now when you take an online course, you no longer need to miss the benefits of being in a classroom: live instruction, hands-on labs and group interaction. IBM offers our most popular courses in this new ILO format, meaning you get the benefits of being in a classroom with the convenience and cost savings of online training.
How does ILO training work?
ILO courses are taught by a live instructor on a specific day and time. These courses are exactly the same as their classroom equivalent, including the course length, content and student materials. You receive the course materials in advance. To participate on the day of the class, all you need is a broadband Internet connection. This allows you to connect to a virtual classroom that lets you interact directly with the instructor to ask questions or clarify the material...just as you would in a physical classroom.
And since the best way to learn is by doing, you'll have access to the same hands-on labs available in the classroom course. The lab environment is available 24x7 for the duration of the class. The instructor can shadow you as you work through the lab exercises, provide guidance and address questions or issues.
If your team is geographically-dispersed you can also request that our instructor-led online format be delivered as a private class for your company. This is very cost effective, minimizes travel, and enables you to receive training customized to your unique needs - all with this alternative method of delivering education in multiple locations simultaneously.
What are the benefits of this format? * No travel costs or travel time* Live instructor with whom you can interact and ask questions using Voice Over IP (VOIP)* Same content as in the classroom version of the course* Modest connectivity requirements let you participate from anywhere* Thin client implementation for easy system preparation* Hands-on labs reinforce concepts learned* Purchasing is easy with an IBM Education Pack
Currently the following courses are available in the United States, select courses will become available in additional countries over the next few months.
* DB2 9 for LUW Advanced Database Administration for Experts (3L460)* DB2 Family Fundamentals (3E030)* DB2 SQL Workshop (3E120)* Using Rational Data Architect (3E190)* DB2 9 for Linux, UNIX, and Windows Transition (3L300)* DB2 9 for Linux, UNIX, Windows DBA Certification Crammer (3L512)* Query XML data with DB2 9 (3L120)* DB2 9 Database Administration Workshop for Linux (3L200)* DB2 9 Database Administration Workshop for UNIX (3L210)* DB2 9 Database Administration Workshop for Windows (3L230)* DB2 for z/OS Data Sharing Implementation (3V210)* DB2 UDB for z/OS Data Sharing Recovery and Restart (3V920)* DB2 Data Warehouse Edition 9 Components (3W350)* DB2 9 for LUW Advanced Recovery( 3L492)* DB2 9 for LUW Quickstart for Experienced Relational DBAs (3L480)* DB2 9 Pure XML (CT140) (Blended course: self-paced & ILO)
For more information: * Information Management courses available
svisser1 2700018UK9 2,650 Views
Just a reminder to those of you outside of the United States, some of our publishing partners have set up local online bookstores that provide a discount, allow you to use your own currency PLUS reduce the duty, taxes, and shipping costs of the books. For details on all of the international sites, see ibm.com/software/data/education/bookstore/international.html.
For the direct URLs:
Europe, Middle East and Africa (EMEA) Orders: www.pearson-books.com/ibmpressbookshop/Canadian Orders: www.pearsontechnology.ca/DB2/
svisser1 2700018UK9 2,642 Views
I posted information about this offer last month, but the publisher had a few problems on their end. These problems have been fixed, so I wanted to once again make you aware of this special offer:
Buy any two DB2 V8 books from the IBM Press Bookstore and save 50% off cover price as well as free ground shipping in the U.S. Be sure to make space on your library shelf for these invaluable resources. Quantities are limited, so order soon as this offer ends on July 31, 2007! Please be sure to enter the case sensitive promotion code: DB2DEALS during checkout to receive this discount.
As always, check out our bookstore page for the latest releases and offers: ibm.com/software/data/education/bookstore/
I'm on vacation next week - to all: have a wonderful Canada Day and Independence Day :)
svisser1 2700018UK9 2,682 Views
I was talking to Sam Lightstone yesterday about his book that published in March: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more.
It covers DB2 very heavily, but also some competitive products (Oracle, SQL Server, and to a lesser extent some others).
From the back cover of the book:
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration.
Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.
Features* The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. * Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). * Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!
Currently there are no customer reviews on amazon.com. If you have read the book and can give us feedback, post here or on amazon.
svisser1 2700018UK9 2,984 Views
Top 10 Reasons To Deploy DB2 9 For z/OS Now! is a 90-minute webinar that will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can!
DATE: Thursday, June 28, 2007TIME: 2:00 PM - 3:30 PM EDT
Featured speakers Troy Coleman of SoftBase and Roger Miller of IBM will review real-life success stories from companies already receiving significant benefits from using DB2 9 for z/OS and provide a live Q&A session for attendees.
The Top 10 Reasons to Deploy DB2 9 for z/OS Now! will be presented from the following perspectives:
Corporate Officers and Managers * Plug and play CPU cycle reductions with DB2 9 for z/OS* Business agility - new pureXML™ enables companies to include DB2 9 for z/OS into their SOA and XML application initiatives
Database Administrators (DBAs) * Improved database availability and performance including LOB, reorganization, backup and recovery, and partitioning enhancements* Easier role-based security and improved DBMS regulatory compliance* DB2 9 for z/OS enhancements to improve ERP application and data warehouse functionality and performance
Application Developers * Powerful new SQL enhancements including MERGE and TRUNCATE statements, INSERT and EXCEPT set operations, and spatial support for geographical data * Improved SQL and data definition compatability with other DB2s * PureXML adds a powerful SQL and XML interface to access all XML data stored in DB2 9 for z/OS.
To register for this event, please complete the following form: http://www.softbase.com/db2v9top10/
svisser1 2700018UK9 2,765 Views
Informix Dynamic Server (IDS) 11 was announced to the world on June 12. Thanks to hard work by the team, we were able to produce a 100-page book written by Carlton Doe that introduces all the latest features: IBM Informix Dynamic Server 11, The Next Generation in OLTP Data Server Technology. Did you get a copy of the book? Likely not.... we're only distributing the book through our marketing teams. If you want one, check with your rep or attend one of the many IDS events planned for the coming months. See the IDS 11 Launch page for further details.
svisser1 2700018UK9 2,702 Views
I spent the day presenting to Lab employees about the process of publishing external publications about IBM products and technology. I hope you feel that you reap many benefits from employees sharing their knowledge and experience in the form of articles, conference presentations, tutorials, white papers, redbooks, and published books. In most cases employees are asked to write this information while continuing to focus on their day jobs. This means that employees quite often give up their evenings, weekends, and vacations to write this information.
IBM very much appreciates these efforts and has recently promoted Paul Zikopoulos... not entirely because of his publishing efforts, but certainly that helped increase his profile! Congratulations to Paul! Congratulations and Thanks to all of our authors!
As always, here is the best website to go in order to see what books we've published to support the many products within Information Management: http://www.ibm.com/software/data/education/bookstore.
svisser1 2700018UK9 2,727 Views
Join us October 14-19th, 2007 at the Mandalay Bay Hotel and Convention Center in Las Vegas, Nevada for the econd annual IBM Information On Demand 2007 global conference. Book before the end of August to qualify for the discounted rate.
Attending the conference is a great way for you to learn about IBM's Information Management software, industry trends, and how to maximize the value of your existing investments. If you are an IT professional, a line of business manager, a developer or compliance officer, you won't want to miss this event.
See the agenda that provides 500 Technical Skill Building sessions, 120 Business Leadership sessions, the addition of the IBM ECM UserNet Conference, and an EXPO of more than 200 Business Partners. You'll have an opportunity to meet with experts to discuss topics of your interest, use our Hands On Labs to experiment and test solutions for your business, and utilize our Onsite Certification to enhance your personal skills. Attend our executive keynotes, breakout sessions and more than 130 demonstrations.
As for entertainment... that's in place as well: Dana Carvey will be our conference master of ceremonies; Steven Covey is our keynote speaker; and Donna Summer is the featured entertainer.
I hope you are able to make it to the conference for the learning opportunities, certification exams, networking, and of course, for a bit of fun in Vegas!
PS... Signing off for a couple weeks of vacation. Ciao![Read More]
svisser1 2700018UK9 3,405 Views
Willie Favero gave an excellent summary of the best speakers at IDUG NA last week, but I don't remember seeing the complete list.... Melanie Stopfer who is on my extended team, was one of the top 10 speakers! Congratulations!
During the conference closing session on Thursday, May 10, IDUG announced the best-rated presentations from the conference. Listed in alphabetical order, the top 10 DB2 technical session presenters for this event, based on evaluations received from attendees, were:
• Bonnie Baker, Bonnie Baker Corporation • Leon Katsnelson, IBM • Bob Lyle, IBM • Dale McInnis, IBM • Roger Miller, IBM / Chris Munson, IBM • Bryan Paulsen, John Deere Corporation • Terry Purcell, IBM • Suresh Sane, DST Systems, Inc. • Bryan Smith, IBM • Melanie Stopfer, IBM
Congratulations to all the speakers!
PS..... I underlined the people who I've had the pleasure to work directly with over the past few years.
svisser1 2700018UK9 2,844 Views
The May 2007 DB2 Magazine Email Newsletter contains a number of excellent articles including:
IN THE MAY 2007 ISSUE:
1. From the Editor: DB2 Magazine gets the community spirit2. Poll Positions: Rate your company's information security efforts3. Asked and Answered: How do you clone just a portion of a database?4. Skills Set: News and information about IBM education5. Must Read: DB2 9 Fundamentals6. In the Zone: The latest articles on DB2, Informix, U2, and more
Of significance is the new DB2 Magazine Community Wiki... a great place for you to post your favorite tips and tricks for working with DB2, Informix, U2, Cloudscape, and related tools and solutions. Today, the DB2 Magazine Community Wiki is something of a blank slate. With your help, we can compile the best online technical resource for IBM information management software outside of IBM.
The mission of this wiki is to gather DB2, Informix, U2, Cloudscape and other IBM information management know-how and make it available to the DB2 Magazine community.
Thanks to Kim and her amazing team for continually making this magazine a must read!
svisser1 2700018UK9 2,693 Views
You must register ON or BEFORE May 15... You'll have the rest of the month to send in your proof of purchase:
Buy the IBM DB2 9 New Features Book & Save 50% off select DB2 9 Certification! For a limited time, when you purchase the newly released IBM DB2 9 New Features book (ISBN: 0072264594), you can receive a Professional Certification Voucher good for 50% off the list price of IBM DB2 9 Fundamentals Exam 730, or IBM DB2 9 DBA for Linux, UNIX and Windows Exam 731.