Training
IBM
Data Platform
DB2
Db2 12 for z/OS: Intermediate Database Administration

7491 Reviews star_rate star_rate star_rate star_rate star_half

Db2 12 for z/OS: Intermediate Database Administration

Db2 12 for z/OS DBAs can develop intermediate skills or recognition through lectures and hands-on exercises of:TSO/E and ISPFData setsDb2 ObjectsStructured Query LanguageDb2 CommandsJCL and SDSFDb2...

View Schedule

$3,975 USD GSA $3,404.28

Course Code CV042G

Duration 5 days

Available Formats Classroom, Virtual

Enter your Email to Download Full Course Details

Overview

Schedule

FAQ

Reviews

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.

Skills Gained

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 Can Benefit

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

null

Course Details

Unit 1Introduction

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 2TSO/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 3Data 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 4JCL 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 5Db2 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 7Db2 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 8The 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 9Db2 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

Read Less

2 options available

Nov 27, 2023 - Dec 1, 2023 (5 days)

Language	Time
Live Virtual
English	9:30AM – 5:30PM EST
Select delivery method/location (1 options)
Live Virtual \| 9:30AM – 5:30PM EST Live Virtual \| 9:30AM – 5:30PM EST

Enroll: Enroll

Feb 26, 2024 - Mar 1, 2024 (5 days)

Language	Time
Live Virtual
English	9:30AM – 5:30PM EST
Select delivery method/location (1 options)
Live Virtual \| 9:30AM – 5:30PM EST Live Virtual \| 9:30AM – 5:30PM EST

Enroll: Enroll

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

Brandon was a great instructor. The virtual course materials and labs provided were very informative.

ExitCertified Student

ExitCertified

Good training material and good instruction. More time needs to be provided for the lab work.

ExitCertified Student

ExitCertified

this class was informative, made me think about certifying for the suse manager cert.

Reuben R

ExitCertified

Some Labs are very good but some steps it ask to update but its already updated, but overall its very good training.

ExitCertified Student

ExitCertified

Good training. A lot to take in for the short amount of time we have though

ExitCertified Student

ExitCertified