Db2 12 for z/OS Basic Database Administration

IBM Training for Db2 12 for z/OS Basic Database Administration

Skill Level: Basic

Modality: CR - Classroom based Trainng or ILO - Instructor Led Online Class

Duration: 3 Day/s

Starting Price: $ - 3,946

Overview:

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS.

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Cyber Retaliator Solutions

CRS is the Top Global Training Provider for some of the world’s biggest brands.
Authorized Training delivered to you by the global leader in IBM Training.

Request a Quote

Target Audience:

_x000D_
Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database.
_x000D_ .

.

Prerequisites: _x000D_

Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF

_x000D_

Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables

_x000D_ .

Topic: PrefaceCourse Overview

Intended Audience

Course Objectives

Prerequisites

Unit 1 - Db2 Relational database conceptsRelational Database design

Data access

Interacting with Db2Catalog and directory

Unit 2 - SQL and SPUFISQL SELECT statement review

SQL INSERT, UPDATE, DELETE review

SQL COMMIT and ROLLBACK review

Joining tables

Executing SQL using SPUFI

Unit 3 - Db2 objects (Storage groups, databases, and table spaces)Object concepts

Storage Groups

Databases

Table Spaces

Unit 4 - Db2 ObjectsTables

Indexes

Views

Unit 5 - UtilitiesUtility Categories

Load Utility

Check Data Utility

Unload Utility

Runstats Utility

Reorg Utility

Unit 6 - Commands and program preparationDb2 Command Structure

Display Command

Archiving Logs

Stop and Start Commands

Executing Commands

Program Preparation

Unit 7 - The Db2 systemSystem Parameters (zParms)

Address Spaces

System Databases

Buffer Pools

Logging

Integrity

Security

Unit 8 - Db2 Shutdown, startup, and recoveryStart and Stop Commands

Db2 Shutdown Process

Db2 Startup Phases

System Recovery

Object Recovery

Copy Utility

Recover Utility

Appendix A - Demonstration solutions.

IBM Training

Objective: Please refer to course overview

Category: Data, Analytics, and AI

Product Name:

IBM Db2 Utilities Solution Pack for z/OS

Badge and Certification Info:

Badge Title: Db2 12 for z/OS Basic Database Administration - Code: CV844G

Badge ID: 3894a4a5-09f7-467f-aa72-80870fe55300

Brand: Analytics

IBM Training is available now.

Cyber Retaliator Solutions (CRS) is a Cyber Security Distributor, Authorized IBM Training Center, Red Hat and SUSE Training Partner, and a CompTIA Training Delivery Partner, operating throughout the Globe. Our Head Office is in Centurion South Africa, with IBM Training Centers in Centurion, Midrand, Sandton, Cape Town, California CA, Florida FL, New York NY, Washington DC, Georgia GA, Texas TX.

CRS is the Top Global Training Provider for some of the world's biggest brands.

Authorized Training delivered to you by the global leader in IBM Training.

Select courses in:

IBM Cloud

DataPower

IBM Automation

IBM Rational

Watson

IBM Tivoli

IBM Systems

Cognos

IBM Storage

Mainframe

IBM Security

System Z

IBM Industry

IBM Asset Management

Websphere

IBM Data and AI

Get the Best IBM Training from CRS. As an IBM Training Provider, we've partnered with IBM through Arrow ECS to deliver training that covers the full portfolio of IBM systems and software.

Authorized IBM Training

RedHat Training

SUSE Training

Agile SAFe Training

Cyber Awareness Training

Cyber Security