Db2 12 for zOS Advanced Database Administration Training

4.7

(4.7)

Db2 12 for zOS Advanced Database Administration Training is developed to help professionals gain comprehensive knowledge about advanced database administration skills, including online schema changes, stored procedures, partition management, and the use of packages.

Category : IBM

Course Price : $1674 Per Participant

Enroll Now

Check Schedule

Course Description

This technical training program also familiarizes you with the availability and performance features of the utilities. To train all your employees at once, you can check out our enterprise training program.

It provides comprehensive information on program preparations, partition management, and online schema change processes and strategies.

Db2 12 for zOS Advanced Database Administration Training is suitable for database administrators who want to improve their skills and build credibility.

In this course, you will learn about REORG features and processes such as LOAD and REBUILD INDEX, and UNLOAD overview and processes.

It also provides in-depth information on native procedure deployment and stored procedures.

500+

Courses

20+

Years of Experience

95K+

Global Learners

What you will learn

Deploying the native procedure.
Preparing program and utilizing the packages.
Elaborating about UNLOAD processes and its overview.
REORG processes and features.
REBUILD AND LOAD INDEXES.
Managing partition and storing procedures.
Changing strategies for an online scheme and other processes.

Prerequisites

Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements
Basic skills in administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.