The aim of the certification is to provide candidates with skills on DB2. The individual is shown how to implement in DB2, a logical design- a database one, how to manage DB2 data, catalog tables in DB2,bind process, the database utilities includingREORG and LOAD and the security considerations.These programmers will get a know-howon creating, administering and maintaining DB2 9 databases in the z/OS platform & implementing XML with the DB2 database.
Who can do this Certification?
The certification can be done by those with the need for acquiring the basic skills that are required in the administration of DB2 database.
The database administrator will be knowledgeable in DB2 specifically the functionality and new features that are related to the version 9. The DBA will have the capability of performing both advanced and intermediate tasks that are related to implementation and database design, recovery and operation, auditing and security, performance, installation and upgrades or migration specific to z/OS operating systems.
The attainment of IBM Certified Database Administrator: DB2 9 DBA for z/OS certification requires an individual to pass two tests. C2090-700 DB2 V8 Family Fundamentals C2090-730: DB2 9 Family Fundamentals C2090-732: DB2 DBA for OS
Before one begins to prepare for the IBM Certified Database Administrator: DB2 9 DBA for z/OS certification, he or she must possess the following skills and experiences: must be experienced as being a database administrator on the DB2 9 for z/OS, have at least 2 years of experience in administration of database for z/OS operating system, be knowledgeable and experienced in system programming and application DBA areas, have knowledge of the major languages used in programming ranging from Java, C++ and COBOL and have the capability of working effectively and independently in any complex environment. The candidate can also do the following recommended courses but it is good to note that the courses are not a requirement before you attempt this certification test: DB2 9 database administration certification study guide, DB2 9 for z/OS implementation workshop, DB2 9 for z/OS database administration workshop part 2, SQL workshop, DB2 9 for z/OS database administration workshop part 2 and DB2 fundamentals.
C2090-730: DB2 9 Family Fundamentals test
- Planning (which covers 14%)
- Security (which covers 11%)
- Database Objects & Databases (covers 17%)
- SQL DB2 Data (covers 23.5%)
- DB2 indexes, views& tables (which covers 23.5%)
- Concurrency of Data (covers 11%)
The candidate is allowed to answer the 64 questions in this exam in a duration of 90 minutes which is equivalent to one hour and thirty minutes. 59% is the pass mark required for this test
C2090-732: DB2 DBA for OS Exam
The test is made up of five sections which are as follows:
- Database Implementation and Design (30.5%)
- Recovery and Operation (29%)
- Auditing and Security (7%)
- Performance (29%)
- Installing and Upgrade or Migration (4.5%)
The two tests require an individual to concentrate on all the sections and do a thorough study on them. More examination preparation tools and details of the examination sections are on the website of the vendor.
The candidate is allowed to answer the 69 questions in this exam in a duration of 90 minutes which is equivalent to one hour and thirty minutes. 57% is the pass mark required for this test. This exam does not have assignments or essays that that require to be submitted. The full exam topics list can be accessed in the provider’s website.
Validity of the certification
This certification does not expire.
Steps Involved in the Certification
The steps that are to be followed to earn this certification are 4:
- Training: take the approved training as earlier outlined in prerequisite section
- Exam: pass one exam from the following; 2090-700 DB2 V8 Family Fundamentals exam or C2090-730: DB2 9 Family Fundamentals exam
- Exam: pass the second test calledC2090-732: DB2 DBA for OS exam
- Form: complete the appropriate course registration form
The sequence listing order of the steps does not matter in completion of the steps but the last step must be after you complete the other steps.
This IBM certification will assist you in laying your personal journey groundwork that will lead you to becoming a world class resource to both your colleagues, customers, and company by providing you with the appropriate knowledge and skills that are needed for your success.
John G., IP Networks