Certification: IBM Certified Database Administrator - DB2 9.7
Certification Full Name: IBM Certified Database Administrator - DB2 9.7
Certification Provider: IBM

Pass Your IBM Certified Database Administrator - DB2 9.7 Exams - 100% Money Back Guarantee!

Get Certified Fast With Latest & Updated IBM Certified Database Administrator - DB2 9.7 Preparation Materials

IBM Certified Database Administrator - DB2 9.7 Bundle

$25.00

C2090-541 Questions & Answers

IBM C2090-541 Exam

DB2 9.7 DBA for Linux UNIX and Windows

1 Product

Includes 102 Questions & Answers.

C2090-730 Questions & Answers

IBM C2090-730 Exam

DB2 9 Family Fundamentals

1 Product

Includes 299 Questions & Answers.

Individual Products

C2090-610 Questions & Answers

IBM C2090-610 Exam

DB2 10.1 Fundamentals

1 Product

Includes 138 Questions & Answers.

Learn More About C2090-610 Exam
C2090-541 Questions & Answers

IBM C2090-541 Exam

DB2 9.7 DBA for Linux UNIX and Windows

1 Product

Includes 102 Questions & Answers.

Learn More About C2090-541 Exam

Individual Products

C2090-730 Questions & Answers

IBM C2090-730 Exam

DB2 9 Family Fundamentals

1 Product

Includes 299 Questions & Answers.

Learn More About C2090-730 Exam
C2090-546 Questions & Answers

IBM C2090-546 Exam

DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade

1 Product

Includes 78 Questions & Answers.

Learn More About C2090-546 Exam

Individual Products

C2090-610 Questions & Answers

IBM C2090-610 Exam

DB2 10.1 Fundamentals

1 Product

Includes 138 Questions & Answers.

Learn More About C2090-610 Exam
C2090-546 Questions & Answers

IBM C2090-546 Exam

DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade

1 Product

Includes 78 Questions & Answers.

Learn More About C2090-546 Exam

Certification Prerequisites

No prerequisites.

Certification Notation

There are 2 steps to get IBM Certified Database Administrator - DB2 9.7 certification:

  1. You need to pass: C2090-730 exam or C2090-610 exam.
  2. You need to pass: C2090-541 exam or C2090-546 exam

Certification Overview

DB2, a product of IBM based of the relational model of database management system. IBM DB2 is available for the operating systems like WINDOWS, UNIX and LINUX. IBM as a brand is one of the biggest ones and the certifications offered by the company are valued at the high level all over the world. IBM Certified Database Administrator – DB2 9.7 is for professionals who can administer the DB2 database technology.

Who can do this certification?

Consultants or professionals who are experienced with IBM DB2 9.7 and having hands on experience in performing intermediary to advanced level of database administration could do this certification.

Benefits

By finishing the certification, one may be able to project the knowledge gained with a proof stating that consultant is competent enough to perform the IBM DB2 administration tasks. This certification also will help you acquire a climb the ladder of promotion in the appraisal cycle.

Associated exam

There are 2 certification paths for clearing this exam.

  1. Certification path 1 – Complete the below two certification exams
    • Either pass the exam C2090-730(Fundamentals of DB2 9) or pass the exam C2090-610(Fundamentals of DB2 10.1)
    • Take the test C2090-541(IBM Database Administrator DB2 9.7 for Linux UNIX and Windows)
  2. Certification path 2 – Complete the three exams
    • First take the exam C2090-730 (Fundamentals of DB2 – 9) or the exam C2090-610 Fundamentals of DB2 10.1)
    • Secondly take the exam C2090-731 (Database administrator for Windows, Unix and Linux for - DB2 9)
    • Finally take the exam C2090-546 (DBA for Unix, Linux or Windows upgrade - DB2 9.7)

Prerequisites

Knowledge and hands on experience on the IBM DB2 administration is good to be known in advance to appear for this exam. Concepts level might vary from the intermediately to advanced with sufficient expertise to solve the basic issues that are raised.

Examination Overview

Topics covered – topics are divided into several sections as explained below.

  1. Configuring and managing the DB2 databases, servers and instances by knowing the details of configuration, registry variable information and compatibility details with the Oracle database.
  2. Schedule a job with by knowing the list of the tools available, details on managing the task and how to configure a job.
  3. Knowledge on usage of the Autonomic features like knowing the available features, self-tune memory manager and regulate the impact of performance  - Utility throttling
  4. How to create a database, create, usages, schemas and the different features of SMS, AS table space and DMS?
  5. What is partitioning, range partitioning, indexes of XML, functions of XML, data types of XML, features that are new in V9.7 and data objects of XML?
  6. What is compression, compression enabling, compression of the index, how to create a dictionary automatically, concepts of replication and its support, Inline LOB, compression of XML and concepts of temporary tables.
  7. How to create constraints on tables using NOT NULL, Primary key, With default, Unique constraint, Check Informational and RI. How to create views along with the CHECK OPTION
  8. How to monitor the database using the SQL functions and Admin views, managing the work load by calculating the time for every job with metrics and setting up with the advanced waterfall approach.
  9. Usage of the automated monitoring tools available by configuring the Health center with the help of Health monitor and monitoring the events
  10. Identifying the usage of tools that determine the problems and capturing and analysing the information about VISUAL EXPLAIN AND EXPLAIN.
  11. Demonstrate the ability to use the data movement utilities (IMPORT, LOAD, EXPORT), when and how to user load and import utility. Details about the DB2Look and DB2Move
  12. Using the RUNSTATS, REORG, REBIND and REORGCHK utilities and DB2 advisor.What is the principle of Data Studio Administrator and its basic concepts?
  13. What are the DB2 actions of data integrity, table and database level recovery and backup action along with split mirroring and configuring and managing HADR
  14. What is DB2 database privilege, authorization and authentication, Facility of audit, Infrastructure of security in DB2
  15. How to configure a Database using the SQLJ and JDBC connections

The exam will test the aptitude of yours in the administration of the DB2 and after finishing this certification you would be effectively able to administer the DB2 database and become a master in all the topics required for a DBA to perform his role.

The exam would be available in Japanese and English which would be of 60 questions on the whole which will be on choosing the best answer type and on which 61% should be correct. The time allotted is 90 minutes.

Validity of the Certification

This certification does not expire.

Expert Review

IBM as a brand is big and doing certification with such a brand is a credit in the career. One should aim high to reach on top and I did the same. This certification helped me big time in my career path.

Johnson, BMW Financial Services.

Munich, Germany.

Frequently Asked Questions

How can I get the products after purchase?

All products are available for download immediately from your Member's Area. Once you have made the payment, you will be transferred to Member's Area where you can login and download the products you have purchased to your computer.

How long can I use my product? Will it be valid forever?

Test-King products have a validity of 90 days from the date of purchase. This means that any updates to the products, including but not limited to new questions, or updates and changes by our editing team, will be automatically downloaded on to computer to make sure that you get latest exam prep materials during those 90 days.

Can I renew my product if when it's expired?

Yes, when the 90 days of your product validity are over, you have the option of renewing your expired products with a 30% discount. This can be done in your Member's Area.

Please note that you will not be able to use the product after it has expired if you don't renew it.

How often are the questions updated?

We always try to provide the latest pool of questions, Updates in the questions depend on the changes in actual pool of questions by different vendors. As soon as we know about the change in the exam question pool we try our best to update the products as fast as possible.

How many computers I can download Test-King software on?

You can download the Test-King products on the maximum number of 2 (two) computers or devices. If you need to use the software on more than two machines, you can purchase this option separately. Please email support@test-king.com if you need to use more than 5 (five) computers.

What is a PDF Version?

PDF Version is a pdf document of Questions & Answers product. The document file has standart .pdf format, which can be easily read by any pdf reader application like Adobe Acrobat Reader, Foxit Reader, OpenOffice, Google Docs and many others.

Can I purchase PDF Version without the Testing Engine?

PDF Version cannot be purchased separately. It is only available as an add-on to main Question & Answer Testing Engine product.

What operating systems are supported by your Testing Engine software?

Our testing engine is supported by Windows. Andriod and IOS software is currently under development.

Money Back Guarantee

Test-King has a remarkable IBM Candidate Success record. We're confident of our products and provide a no hassle money back guarantee. That's how confident we are!

Total Cost: $249.98
Bundle Price: $224.98

Purchase Individually

C2090-541 Questions & Answers

IBM C2090-541

1 Product

$124.99
C2090-546 Questions & Answers

IBM C2090-546

1 Product

$124.99
C2090-610 Questions & Answers

IBM C2090-610

1 Product

$124.99
C2090-730 Questions & Answers

IBM C2090-730

1 Product

$124.99
Close

November campaign! 30% Discount for All Exams!

This is a ONE TIME OFFER. You will never see this Again

Instant Discount
Test-King Testing Engine

30% OFF

Enter Your Email Address to Receive Your 30% OFF Discount Code Plus... Our Exclusive Weekly Deals

A confirmation link will be sent to this email address to verify your login.


* We value your privacy. We will not rent or sell your email address.

Close

Your 30% Discount on Your Purchase

Save 30%. Today on all IT exams. Instant Download

Test-King Testing Engine

Use the following Discount Code during the checkout and get 30% discount on all your purchases:

Start Shopping