Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
    Training
|
    Solutions
|
    Company
|
    Offers
| |
Contact Us 877-206-0106 |
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Db2 12 for zOS: Basics for DBA Beginners

Price
4,075 USD
40 Hours
CV042G
Classroom Training, Online Training
Db2 12 for zOS: Basics for DBA Beginners - Code: CV042G
IBM Business Partner

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees.
Prices reflect a 24% discount for Kyndryl employees.
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

  • Date: 20-Feb-2023 to 24-Feb-2023
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 4,075 USD
  • Date: 27-Feb-2023 to 3-Mar-2023
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 4,075 USD
View Global Schedule

Course Description

Overview

Db2 12 for z/OS beginning 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

Objectives

  • 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

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

Topics

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

Recognition

When you complete the Instructor-Led version of this course, you will be eligible to earn a Training Badge that can be displayed on your website, business cards, and social media channels to demonstrate your mastery of the skills you learned here.

Learn more about our Data Storage Badge Program →
Report Studio Foundation IBM Digital Badge

This course is eligible for the Db2 12 for zOS: Basics for DBA Beginners - Code: CV042G

2021 Top 20 Training Industry Company - IT Training

Need Help?

Call us toll free at 877-206-0106 or e-mail us at info@learnquest.com

Personalized Solutions

Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

Contact Us

Need Help?

Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

Talk to us

Self-Paced Training Info

Learn at your own pace with anytime, anywhere training

  • Same in-demand topics as instructor-led public and private classes.
  • Standalone learning or supplemental reinforcement.
  • e-Learning content varies by course and technology.
  • View the Self-Paced version of this outline and what is included in the SPVC course.
  • Learn more about e-Learning

Course Added To Shopping Cart

bla

bla

bla

bla

bla

bla

Self-Paced Training Terms & Conditions

??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??

Sorry, there are no classes that meet your criteria.

Please contact us to schedule a class.


STOP! Before You Leave

Save 0% on this course!

Take advantage of our online-only offer & save 0% on any course !

Promo Code skip0 will be applied to your registration

Nothing yet
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Add to cart clicker.

Purchase Information

??elearning-coursenumber?? ??coursename??
View Cart

Need more Information?

Speak with our training specialists to continue your learning journey.

 

Delivery Formats

Close

By submitting this form, I agree to LearnQuest's Terms and Conditions

heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.