IBM's 000-731

IBM DB2 9 DBA for Linux UNIX and Windows

• 100% Exam Coverage • Interactive E-Book • Pre-Assessment Test • 323 Practice Questions with Full Explanations • 103 Interactive Quizzes • Chapter by Chapter Study Guide & Notes • Articles, How Tos, Tips, Flash Cards • Test History and Performance Review and Powerful Analytics • Study Planner • Continuously Updated

The IBM Certified Database Administrator - DB2 9 DBA for Linux, UNIX and Windows certification is an industry recognized, vendor neutral credential. The certification is proof of a person's competence across a spectrum of skills includingDB2 Server Management, Data Placement, Database Access, Analyzing DB2 Activity, and associated DBA utilities. uCertify’s guaranteed certification prep for 000-731 is comprehensive and helps you not only earn your certification in the shortest time possible, but to also gain the knowledge required on the job. Here’s what to expect from your uCertify prepkit:

IBM 000-731 test prep and exam questions 100% test pass guarantee

100% Test Pass Guarantee.

You will pass your exam in the first attempt or we will refund your money in full. Read More...
Buy Now Try it Online

Prepare for the following certification

The IBM-DB2-731: DB2 9 DBA for Linux UNIX and Windowsexam is part of IBM's IBM Certified Database Administrator - DB2 9 DBA for Linux, UNIX and Windows ccertification which comprises of 000-730 and 000-731 exams. It is a required piece to the certification.

The certification is targeted at DB2 9 users who possess the knowledge and skills necessary to perform the day-to-day administration of DB2 9 instances and databases residing on Linux, UNIX, or Windows platforms. If you have knowledge of DB2 9 technology and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role. The exam covers DB2 Server Management, Data Placement, Security, Analyzing DB2 Activity, etc.

Skills Measured

  • Management of DB2 data servers
  • Performing data placement
  • Analyzing DB2 activities
  • Understanding the use of various DB2 database utilities
  • Performing database-level and table space level BACKUP & RESTORE
  • Configuring online parameters
  • Authorizing and authentication various DB2 roles and database instances
  • Understanding DB2 security infrastructure (e.g. LBAC and Security Plug-ins)

Related Certifications

  • IBM Certified Advanced Database Administrator - DB2 9.7 for Linux, UNIX and Windows

000-731 Course Duration

This is a self-paced, independent study program, so there are no minimum or maximum restrictions placed by uCertify. The amount of time you will take depends on your existing knowledge of the area and related experience, as well as your availability. We recommend at least 3 weeks if you have a reasonable amount of knowledge of using DB2.

Related Exams

000-731 Course/Exam Objectives

  • Chapter 1: DB2 Server Management
    • Ability to configure/manage DB2 instances (e.g. ...obtain/modify database configuration information
    • Knowledge of the DB2 force command, ability to c...matic Maintenance (i.e., RUNSTAT, Backup, REORG)
    • Ability to configure client server connectivity ...COVERY, and skill in interpreting the Notify log
    • Ability to obtain and modify DB2 registry variab...config, and ability to use Throttling utilities)
  • Chapter 2: Data Placement
    • Ability to create a database, skill in discussin...ill in discussing the various table space states
    • Ability to create and manipulate the various DB2...aracteristics of an automated managed tablespace
    • Knowledge of partitioning capabilities (e.g., Ta... performance), and knowledge of compression data
  • Chapter 3: Database Access
    • Knowledge of the creation and management of indexes
    • Ability to create constraints on tables (e.g., R...rmational, Unique) and to create views on tables
    • Skill in examining the contents of the System Catalog tables
    • Ability to use the GUI Tools for administration and knowledge of how to enforce data uniqueness
  • Chapter 4: Analyzing DB2 Activity
    • Ability to capture and analyze EXPLAIN/VISUAL EX...configure Health Monitor using the Health Center
    • Ability to identify the functions of Problem Determination Tools (e.g, db2pd, db2mtrk)
  • Chapter 5: Utilities
    • Ability to use EXPORT utility to extract data fr... table, LOAD utility to insert data into a table
    • Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
    • Ability to use DB2Move, DB2Look and DB2Batch
    • Knowledge of the functionality of the DB2 Adviso...ility) and ability to use the DB2 Control Center
  • Chapter 6: High Availability
    • Ability to perform database-level and table space level BACKUP & RESTORE
    • Knowledge to identify and explain issues on index recreation
    • Knowledge of database logging, crash recovery, version recovery, Roll Forward recovery
    • Ability to perform HADR, Log Mirroring, and knowledge of Configurable Online Parameters
  • Chapter 7: Security
    • Knowledge of DB2 authentication
    • Knowledge of DB2 authorizations
    • Ability to set user and/or group privileges
    • Knowledge of the DB2 Security Infrastructure (e.g. LBAC and Security Plug-ins)

Career Prospects

An IBM Certified Database Administrator - DB2 9 DBA for Linux, UNIX and Windowscertified person has several career opportunities open up to them, including:

  • Database Administrator
  • Database Analyst

000-731 Exam FAQ's

What certificate do I earn on passing the vendor certification?
If you pass IBM's 000-731 exam you will get credit towards the following certification:
What is the exam registration fee?
200
Where do I take the exam?
The IBM 000-731 exam is administered by Prometric at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam?
The exam consists of multiple choice questions.
How many questions are asked on the exam?
The exam contains 69 questions.
What is the duration of the exam?
90 minutes

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the 000-731 exam, IBM's retake policy is:

  • The same certification test may be taken only twice within a 30 day period.
  • If a certification exam is not completed successfully on the first attempt, there is no waiting requirement before taking the test a second time. However, candidates may not take the same test more than twice within any 30 day period of time.
  • Additionally, retakes are not allowed after the successful completion of an exam.
  • A test result found to be in violation of the retake policy will not be processed, which will result in no credit awarded for the test taken. Repeat violators will be banned from participation in the IBM Professional Certification Program.
What is the validity of the certification?
The IBM DB2 9 DBA certification has no expiration. The certification holder is certified for life unless the vendor changes their policy.
Where can I find more information on this exam?
You can find more information about the 000-731 here: http://www-03.ibm.com/certify/tests/ovr731.shtml
000-731 Course Includes Free Buy
Chapters 1 7
Practice Tests 1 4
Total Questions (inc. quizzes) 30 323
Interactive Quizzes 15 103
Final Test No Yes
Articles, How Tos.., Tips No Yes
Study Notes Sample 121

Overall Customer Rating!

 
 

4.6 out of 5 Pass Ratio: 97.23%.
9 out of 10 customers who purchased this course would recommend the product to their friends.

Our Customers are talking!


I chose ucertify for the 000-730 which is indubitably essential and helped me in passing. After passing the IBM 00-730 exam, 000-731 was next in line. So I went for 000-731 prepkit and the result was better than before.

Bob Jonas

A big thanks to ucertify for the 000-731 prepkit.

David Trott

This prepkit is full of useful material, sample questions and the exercises you are supposed to perform are generally relevant and useful for preparing for the 000-731 exam.

Christa