Db2 12 for zOS: Basics for DBA Beginners

IBM Training for Db2 12 for zOS: Basics for DBA Beginners

Skill Level: Basic

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

Duration: 5 Day/s

Starting Price: $ - 6,576

Overview:

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Db2 12 for z/OS DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of: TSO/E and ISPF

Data sets

Db2 Objects

Structured Query Language

Db2 Commands

JCL and SDSF

Db2 Utilities

Db2 Logging

Db2 Program Preparation

The course materials cover Db2 12 for z/OS.

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:

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment..

.

Prerequisites: .

Topic: Unit 1IntroductionThe modern Mainframe Environment

Defining z/OS

What are the benefits of z/OS?

Typical z/OS workloads

Batch processing

Online Transaction Processing

Job roles in the Mainframe environment

z/OS Components and Services

UNIX System Services

The Parallel Sysplex Environment

z/OS Management Interfaces

Unit 2TSO/E and ISPFEmulators

z/VM systems

2.1. TSO/E

TSO Logon panel

Changing passwords

Additional logon panel options

The Reconnect option

TSO READY prompt

TSO HELP command

LISTALC command

PROFILE command

Changing PROFILE

LOGOFF command

Scripting support

2.2. ISPF

What is ISPF

ISPF command

ISPF Primary Option Menu

Primary Option Menu Areas

Action Bar

Options option

ISPF Settings

Global Color Change Utility

Function Keys

Option or Command Prompt

Keylist Utility

F3 Exit

F1 Help

F2 Split

ISPF Navigation Techniques

PFSHOW

More ISPF commands

Option listing

ISPF Command Shell

TSO Command Prefix

Unit 3Data SetsData sets

Types of data sets

DASD versus Tape

Volumes

Storage allocation

Data set naming conventions

Catalogs

Storage Management

Checkpoint

3.2. Sequential Data Sets

Creating data sets

Utility Selection Panel

Data Set Utility Panel

Creating a data set

Allocate New Data Set

Creating a sequential data set

Editing a sequential data set

ISPF Editor

ISPF Editor primary commands

ISPF Editor line commands

Data Set List Utility

Data set name wild cards

Data Set List Utility

DSLIST results

Select Action

HELP on Line Commands

DSLIST by volume

3.3. Partitioned Data Sets

Partitioned data sets

Creating a PDS

PDS members

Creating a PDS member Library Utility Panel

DSLIST Utility

PDS Member List

Member Actions

3.4. VSAM Data Sets

VSAM data sets

VSAM data set components

Creating a VSAM data set

Unit 4JCL and SDSF4.1. JCL

Batch Jobs versus Online Transactions

Batch job activities

Creating the batch job

JCL: Job Control Language

Statement format

JOB statement

EXEC statement

DD statement

Instream Input Data Set

Instream Output Data Set

DD DUMMY

Sample Jobstream 1

Sample Jobstream 2

Submitting the job

Notification

4.2. SDSF

SDSF

SDSF Primary Option Menu

Output and Held queues

PREFIX command

Working with queue query

Select command

? command

Canceling or Purging output

Sample jobstream 1 revisited

Sample jobstream 2 revisited

Unit 5Db2 Relational Database ConceptsRelational Database Systems

Db2 for z/OS and Db2 family

The Db2 Optimizer

Benefits of Db2 for z/OS

Database

Tables

Indexes

Primary Key

Relationships

Referential Integrity

Integrity Rules

Data domains

Table scan access

Index access

Interacting with Db2

Transactions

UNIT 6 Structured Query Language (SQL) and SPUFIStructured Query Language (SQL)

SQL categories

SELECT statement

SELECT list

FROM clause

Simple SELECT statement

SUBSTR function

SELECT with SUBSTR function

WHERE clause

SELECT with WHERE clause

IN operator

WHERE with IN operator

BETWEEN operator

WHERE with BETWEEN operator

LIKE operator

WHERE with LIKE operator

ORDER BY clause

The NULL value

SELECT with ORDER BY

Putting it all together

Joining tables

Correlation Names

Additional criteria

Cartesian products

Executing SQL

SQLCODE

Unit 7 Db2 Objects7.1. Databases and Table Spaces

Db2 objects

The Db2 catalog

Storage group

Database

Table Space

Segmented table space

Partitioned table space

Partition By Growth table space

Partition By Range table space

VSAM data sets

7.2. Tables, Indexes and Views

Table

Partitioned table

Index

Clustering index

Index space

Partitioned index

View

7.3. Qualified names, Implicit Object Creation, and SQL statements

Qualyfing Db2 objects

Implicit object creation

DML statements

Insert statement

UPDATE statement

DELETE statement

COMMIT statement

ROLLBACK statement

Unit 8The Db2 SystemThe Db2 system

System parameters

Required address spaces

Optional address spaces

Started tasks

Master address space

System databases

IBM Training

Objective: Describe several services provided in a z/OS environment

Explain workloads in the batch environment

Explain workloads in the online environment

Describe job roles in a z/OS environment

Log On to TSO/E

Navigate TSO/E and ISPF

Use TSO commands

Setup and utilize JCL (Job Control Language)

Utilize SDSF

Describe the different types of data sets in a z/OS environment

Allocate data sets and list data set information and content

Create and modify data set content

Give an overview of the Db2 9 environment

Describe and utilize Db2 Objects

Describe and utilize several DB2 Utilities

Describe the Db2I (Db2 Interactive Facility) environment

Use SPUFI (SQL Processing Using File Input) to compose and execute SQL

Setup and execute Db2 Commands

Understand Db2 Logging

Describe Db2 program preparation process

Understand Db2 startup and shutdown

Understand and utilize Db2 recovery strategies

Category: Data, Analytics, and AI

Product Name:

Db2 for z/OS

Badge and Certification Info:

Badge Title: Db2 12 for zOS: Basics for DBA Beginners - Code: CV042G

Badge ID: b552d1cb-42e4-40f3-96ce-cfcbb3e0e173

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