IBM Analytics

CV042G : Db2 12 for z/OS: Intermediate Database Administration

Course Duration

5 Days

Delivery

ILT VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

Db2 12 for z/OS DBAs can develop intermediate 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.

What You'll Learn

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

Who Should Attend

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

Prerequisites

N/A

Learning Journey

Coming Soon...

Unit 1 : Introduction

The 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 2 : TSO/E and ISPF

Emulators
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 3 : Data Sets

Data 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 4 : JCL and SDSF

4.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 5 : Db2 Relational Database Concepts

Relational 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 SPUFI

Structured 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 Objects

7.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 8 : The Db2 System

The Db2 system
System parameters
Required address spaces
Optional address spaces
Started tasks
Master address space
System databases
Directory
Catalog
System database data sets
Data pages
Buffer pools
Buffer pools: Read operations
Buffer pools: Write operations
System buffer pools
Db2 logging
Bootstrap data set
Db2 locking
Integrity issues
Transaction locks
Isolation Levels
User interfaces

Unit 9 : Db2 Commands and Program Preparation

Accessing Db2
9.1. Db2 Commands
Db2 commands
Command format
DISPLAY DATABASE
DISPLAY DATABASE SPACENAM
Other DISPLAY DATABASE options
DISPLAY BUFFERPOOL
DISPLAY DDF
DISPLAY LOG
DISPLAY THREAD
ARCHIVE LOG
STOP DATABASE
START DATABASE
STOP DATABASE SPACENAM
START DABATASE SPACENAM
Executing commands
Executing commands: TSO
Executing commands: Batch
Executing commands: SDSF
9.2. Program Preparation
Db2 program preparation
Source program
Precompiler
Compile and link edit
Database Request Module
Bind plan
Bind plan
EXPLAIN
Program execution

Unit 10 Db2 Utilities

Utility categories
Utility and Tools Packaging
Standalone utilities
Service aids and samples
Online utilities
UNLOAD utility
UNLOAD control statement
LOAD utility
LOAD utility steps
Restrictive states
Db2| Utility Generator
Utility Panel One
Utility Panel Two
Utility batch job
DSNUPROC
SYSUTIL table
DISPLAY UTILITY command

Unit 11 Db2 Shutdown, Startup, and Recovery

Buffer Pools and Logging
Normal Db2 Shutdown
Restart phases
Starting Db2 after a normal shutdown
Abnormal Db2 shutdown
Starting Db2 after an abnormal shutdown
Log initialization
Current status rebuild
Forward log recovery
Backward log recovery
Object backup and recovery
COPY utility
Table space recovery
RECOVER utility

Unit 12 Course Summary

z/OS topics
Db2 for z/OS topics
Other Db2 courses
Db2 for z/OS certifications
Course Evaluation

Frequently Asked Questions (FAQs)

Why get IBM certified?

IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.
These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.
IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.
What to expect for the examination?

IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.
Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is IBM certification valid for?

The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.
However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By IBM

Browse All Courses

System Z

CV042G : Db2 12 for z/OS: Intermediate Database Administration

What You'll Learn

Who Should Attend

Prerequisites

Learning Journey

Frequently Asked Questions (FAQs)

Why get IBM certified?

What to expect for the examination?

How long is IBM certification valid for?

Why take this course with Trainocate?

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By IBM

Advanced Parallel Sysplex Operations and Recovery Workshop

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

IBM z/OS Management Facility Implementation and Use 2.1

Ready to Take Your Business from Great to Awesome?

Request More Information