Db2 12 for zOS Advanced Database Administration Training

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.

📘 IBM 👥 1291 Enrolled ⏱️ 2 Days 💼 Level ⭐ 4.7 | 113 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$1860

Course Overview

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.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

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.

Who Should Attend This Course?

The target audience for Db2 12 For ZOS Advanced Database Administration Training are professionals working as Database Administrators.

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.

📞 Talk to a Learning Advisor

📘 Db2 12 for zOS Advanced Database Administration Outline

Program preparation overview
Execution time errors
BIND actions
Package status and REBIND
Deleting a package
Determining the table/view qualifier

Changing data type
Adding columns to a table
Renaming columns in a table
Renaming indexes
Adding columns to indexes
Versioning

Pending online schema changes
Dropping columns from a table
Converting to UTS
Other pending changes
Impact of pending changes on immediate options
Restrictions and considerations

Adding partitions
Rotating partitions

Modifying limit keys
Rebalancing partitions

External stored procedures
WLM-established application environments
Altering and dropping a stored procedure
Commands for stored procedures
Execution privileges
Catalog information
LOAD and REBUILD INDEX
LOAD with parallel index build
LOAD partitions in parallel
REBUILD INDEX
Inline image copies and statistics
LOAD SHRLEVEL CHANGE
LOAD REPLACE SHRLEVEL REFERENCE

Performance features of REORG
Online REORG
Inline image copies and statistics
Considerations for PBG table spaces
Online REORG with LOBs (optional)

Overview
Image copy specification
Table-only input specification
SHRLEVEL option
Modes of operation

Table mirroring
Package versioning
Plan management
Other REBIND PACKAGE options
Application compatibility

Native stored procedures
Native procedure deployment

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

✓ Certified Instructor-led Training
✓ Top Industry Trainers
✓ Official Student Handbooks

Measurable Learning Outcomes

✓ Pre- & Post-Training Assessments
✓ Practice Tests
✓ Exam-Oriented Curriculum

Real-World Skill Building

✓ Hands-on Activities & Scenarios
✓ Interactive Online Courses
✓ Peer Collaboration (Not in self-paced)

Full Support & Perks

✓ Exam Scheduling Support ^*
✓ Learn & Earn Program ^*
✓ Support from Certified Experts
✓ Gov. & Private Pricing ^*

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.