IBM Db2 12 for z/OS Certification

Certification Overview

An IBM Certified Administrator on IBM Db2 12 for z/OS is the lead database administrator for the Db2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of Db2, up to and including Db2 12 for z/OS Function Level 506. This individual is capable of performing intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, installation and migration/upgrades specific to the z/OS operating system.

Recommended Skills

The following qualifications are requirements for success:

Basic knowledge of z/OS and Workload Manager
Extensive knowledge of Db2
Basic knowledge of SQL, XML and JSON
Basic knowledge of database security
Basic knowledge of Db2 routines

Requirements

Exam C1000-078 : IBM Db2 12 for z/OS Administrator

Exam Objectives

The IBM Certified Administrator - IBM Db2 12 for z/OS is an intermediate-level certification for experienced system administrator who has extensive knowledge and experience of Db2 12 for z/OS. This administrator can perform tasks related to installation and configuration. The administrator also handles daily management and operation, security, performance, updates (including installation of fix packs and patches), customization and/or troubleshooting.

Number of questions : 60

Number of questions to pass : 42

Time allowed : 90 minutes

Status : Live

IBM Certified Administrator - Db2 12 for z/OS

Group : Data, Analytics, and AI

Certification status : Live

Credential code : C0005400

Replaces Credential code : N/A

Being Replaced By : C9006700

Required exam : IBM Db2 12 for z/OS Administrator

Exam status : Live

An Assessment Exam is an online test that results in a score report to help you gauge your preparedness. They can be booked through Pearson VUE.

The Sample Test is designed to give you an idea of the type of questions you can expect to see on the exam.

Exam Languages : English

Price Per Exam : $200 USD

Course Details

1. Database Design and Implementation

Design tables and views
Explain the different performance implications of identity column, ROWID, and sequence column definitions
Design indexes
Design universal table spaces
Perform partitioning
Normalize data (E-R model, process model) and translate data model into physical model
Understand and describe Db2 database enforced integrity rules
Use the appropriate method to alter Db2 objects
Explain the use and impact of different encoding schemes

2. Operation and Recovery

Explain and execute commands and subcommands for normal operational conditions
Explain and execute commands and utility control statements for use in abnormal conditions
Load and unload data into and from Db2 tables
Reorganize objects when necessary
Monitor objects by collecting statistics
Monitor and manage threads and utilities
Identify and respond to advisory/restrictive statuses on Db2 objects
Identify and perform problem determination
Perform object and catalog/directory health checks
Identify and perform actions needed to protect databases from planned and unplanned outages
Identify and perform actions needed to recover data to a consistent point in time

3. Security and Auditing

Explain privileges and authorities
Protect access to Db2 and its objects
Audit Db2 activity and resources and identify primary audit techniques
Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
Explain and use roles, trusted context, data masking and encryption

4. Performance

Plan for performance monitoring by setting up and running monitoring procedures
Analyze performance (manage and tune CPU requirements, memory, I/O, locks, response time, index and table compression)
Analyze and respond to RUNSTATS statistics analysis
Determine when and how to perform REBIND
Describe Db2 interaction with Workload Manager (WLM)
Review and tune SQL
Monitor dynamic SQL performance
Design features for performance
Explain how to control and influence access paths

5. Installation and Migration

Recommend settings for critical Db2 system parameters
Identify and explain Db2 data sharing components and commands
Describe use of premigration checklists
Describe the function of the catalog and directory
Demonstrate understanding of the Db2 12 continuous delivery process
Explain the migration process and activation of new function levels

6. Additional Database Functionality

Explain and use SQL constructs
Explain the use of stored procedures
Explain the use of SQL/XML and XQuery
Explain the use of user-defined functions
Explain and use global variables
Describe the use of triggers, merge statement, pagination options and JSON support

7. Distributed Access

Demonstrate understanding of distributed data access and the role of the communications database
Demonstrate understanding of Distributed Data Facility (DDF) implementation options
Recommend values for critical DDF configuration settings
Understanding and implementing distributed data access
Describe Db2 support for Native REST services and differentiate from RESTful API

Video Packages
Online Live Class

Fees Structure :	15500 INR / 185 USD
Total No of Class :	50 Video Class
Class Duration :	39:30 Working Hours
Download Feature :	Download Avalable
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure Buy Now Sample Demo

Fees Structure :	22500 INR / 270 USD
Class Duration :	30 Days
Class Recording :	Live Class Recording available
Class Time :	Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure Pay Online

IBM Certified Administrator - DB2 12 for z/OS

1. Database Design and Implementation

2. Operation and Recovery

3. Security and Auditing

4. Performance

5. Installation and Migration

6. Additional Database Functionality

7. Distributed Access

Why People Like us!

More Info

Account

Contact