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.
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.
There are 2 certification paths for clearing this exam.
- 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)
- 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)
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.
Topics covered – topics are divided into several sections as explained below.
- 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.
- Schedule a job with by knowing the list of the tools available, details on managing the task and how to configure a job.
- Knowledge on usage of the Autonomic features like knowing the available features, self-tune memory manager and regulate the impact of performance - Utility throttling
- How to create a database, create, usages, schemas and the different features of SMS, AS table space and DMS?
- 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?
- 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.
- 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
- 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.
- Usage of the automated monitoring tools available by configuring the Health center with the help of Health monitor and monitoring the events
- Identifying the usage of tools that determine the problems and capturing and analysing the information about VISUAL EXPLAIN AND EXPLAIN.
- 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
- Using the RUNSTATS, REORG, REBIND and REORGCHK utilities and DB2 advisor.What is the principle of Data Studio Administrator and its basic concepts?
- 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
- What is DB2 database privilege, authorization and authentication, Facility of audit, Infrastructure of security in DB2
- 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.
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.
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 firstname.lastname@example.org 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. Android and IOS software is currently under development.