Job Role Description / Target Audience

This mastery test examines entry level zEnterprise fundamental concepts and system programmer and other user role tasks. The test is applicable to those completing the recommended education or those who have recently moved into a zEnterprise environment.

It is strongly advised that the candidate complete the recommended education prior to attempting this mastery test.

Test information
• Number of questions: 73
• Time allowed in minutes: 90
• Required passing score: 71%
• Languages: English
• Proctored

Job Role Description / Target Audience

This Database Associate certification is an entry level exam for a user of any of the DB2 for z/OS family of products. This individual is knowledgeable about the fundamental concepts of DB2 11 for z/OS through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 11, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Recommended Prerequisite Skills
• Entry level experience using DB2 11
• Basic knowledge of SQL

Requirements
Tests required:
(This certification requires 1 test).
1. Test C2090-320 - DB2 11 Fundamentals for z/OS

Job Role Description / Target Audience

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 11. This person is 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.

Requirements
Tests required:
(This certification requires 2 tests).
1. Test C2090-312 - IBM DB2 11 DBA for z/OS
2. Any 1 of the following tests:
• Test C2090-610 - DB2 10.1 Fundamentals
• Test C2090-320 - DB2 11 Fundamentals for z/OS

Job Role Description / Target Audience

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments.

Recommended Prerequisite Skills
• Working knowledge of DB2 z/OS in a system administration capacity
• Support of DB2 on a z/OS environment
• Knowledge of z/OS architecture
• Knowledge of Subsystem Parameters (DSNZPARMs)
• Knowledge of DB2 data sharing environment

Requirements
Tests required:
(This certification requires 2 tests).
1. Test C2090-317 - DB2 11 System Administrator for z/OS
2. Any 1 of the following tests:
• Test C2090-610 - DB2 10.1 Fundamentals
• Test C2090-320 - DB2 11 Fundamentals for z/OS

Job Role Description / Target Audience

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 10.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 10.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Recommended Prerequisite Skills
• Entry level experience using DB2 10
• Basic knowledge of SQL
Requirements
Tests required:
(This certification requires 1 tests).
1. Test C2090-612 - DB2 10 DBA for z/OS
2. Any 1 of the following tests:
• Test C2090-610 - DB2 10.1 Fundamentals

Job Role Description / Target Audience

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is 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.

Recommended Prerequisite Skills
• Experience as a database administrator on DB2 10 for z/OS DBA and system programming DBA areas
• At least two years experience in database administration for the z/OS operating system
• Some knowledge and experience in both the application DBA and system programming DBA areas
• Knowledge of SQL
• Capability to work independently and effectively in complex environments
Requirements
Tests required:
(This certification requires 2 tests).
1. Test C2090-612 - DB2 10 DBA for z/OS
2. Any 1 of the following tests:
• Test C2090-730 - DB2 9 Family Fundamentals
• Test C2090-610 - DB2 10.1 Fundamentals

Job Role Description / Target Audience

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments.

Recommended Prerequisite Skills
• Working knowledge of DB2 z/OS in a system administration capacity
• Support of DB2 on a z/OS environment
• Knowledge of DB2 data sharing environment
• Knowledge of DSNZPARMs
• Knowledge of z/OS architecture (Rudimentary knowledge of SMPE)
Requirements
(This certification requires 2 tests).
Tests required:
1. Test C2090-617 - DB2 10 System Administrator for z/OS
2. Any 1 of the following tests:
• Test C2090-730 - DB2 9 Family Fundamentals
• Test C2090-610 - DB2 10.1 Fundamentals

Job Role Description / Target Audience

This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 9 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Recommended Prerequisite Skills
• Experience as a database administrator on DB2 10 for z/OS DBA and system programming DBA areas
• At least two years experience in database administration for the z/OS operating system
• Some knowledge and experience in both the application DBA and system programming DBA areas
• Knowledge of SQL
• Capability to work independently and effectively in complex environments
Requirements
Tests required:
(This certification requires 1 tests).
• Test C2090-730 - DB2 9 Family Fundamentals

Job Role Description / Target Audience

Note: This certification will be withdrawn on 12/31/2013. The most current certification is: IBM Certified

Job Role Description / Target Audience

The IBM Certified Database Administrator is 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. This specialist is 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.

To attain the IBM Certified Database Administrator - DB2 9 DBA for z/OS Certification candidates must possess the skills outlined under Recommended Prerequisite Skills below and pass 2 tests. To gain additional knowledge and skills, and prepare for the tests based on the job role and test objectives, take the link to the test below, and refer to the Test Preparation tab.

Recommended Prerequisite Skills
(Knowledge and skills one needs to possess before beginning to prepare for this role-based certification)
• Experience as a database administrator on DB2 9 for z/OS
• At least two years experience in database administration for the z/OS operating system
• Some knowledge and experience in both the application DBA and system programming DBA areas
• Knowledge of major programming languages (such as COBOL, Java, and C++)
• Capability to work independently and effectively in complex environments

Requirements
Tests required:
(This certification requires 2 tests).
1. C2090-732 - DB2 9 DBA for z/OS
2. Any 1 of the following tests:
• Test C2090-700 - DB2 V8.1 Family Fundamentals
• Test C2090-730 - DB2 9 Family Fundamentals

Job Role Description / Target Audience

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, and tune secure DB2 for z/OS environments.

Requirements
Tests required:
(This certification requires 2 tests).
1. Test C2090-737 - DB2 9 System Administrator for z/OS Exam
2. Any 1 of the following tests:
• Test C2090-700 - DB2 V8.1 Family Fundamentals
• Test C2090-730 - DB2 9 Family Fundamentals

Job Role Description / Target Audience

The IBM Certifi ed Database Administrator for DB2 Universal Database V8.1 for z/OS (Exam 702) demonstrates lead database administrator (DBA) skills for the DB2 UDB Version 8.1 product for the z/OS operating system. This individual has signifi cant experience as a DBA and extensive knowledge of the DB2 Universal Database, specifi cally the new features and functionality related to Version 8.1. This specialist is 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 specific to the z/OS operating system.

The Open CITS certification program is:
• The most trusted independent benchmark for validating IT Specialist skills and experience
• A distinctive, peer-reviewed, vendor-neutral, globally recognized, portable credential
• Used by the world’s leading enterprises as an objective measure of capabilities
• A proven guide for filling critical roles and responsibilities
• An outstanding career move

Be confident of expertise and experience with The Open Group Certified IT Specialist (Open CITS) Program

The Open Group Certified IT Specialist (Open CITS) certification program is an independent global certification program for qualifying the skills, knowledge and experience of IT specialists. Accepted and applicable worldwide, Open CITS boasts over 3,000 certified professionals from a wide range of organizations in more than 50 countries worldwide.

The program requires applicants to demonstrate skills and experience against a set of conformance requirements through written applications and peer interviews. There are no training courses to attend, and no written exams to complete.

The Open CITS certification program is:
• The most trusted independent benchmark for validating IT Specialist skills and experience
• A distinctive, peer-reviewed, vendor-neutral, globally recognized, portable credential
• Used by the world’s leading enterprises as an objective measure of capabilities
• A proven guide for filling critical roles and responsibilities
• An outstanding career move

A Certified IT Specialist is someone who has shown both breadth and depth. This person is capable of leading a team, can work with client, and is able to adapt to new technology and processes. A certified specialist has moved beyond "the job" and is concerned with growing talent within IBM, collaborating with people across the company, and can communicate effectively.

Actualizing IT Solutions Thought Leader Level