ibm 2024
8280  Reviews star_rate star_rate star_rate star_rate star_half

Db2 12 for zOS: Basics for DBA Beginners

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

Read More
View Full Schedule Train Your Team
$3,975 USD GSA  $3,404.28
Duration 5 days
Course Code CV042G
Available Formats Classroom, Virtual

Upcoming Course Dates

  • Jun 2, 2025 - Jun 6, 2025 (5 days)
    Live Virtual | 9:30AM – 5:30PM EDT
    Language English
    Select from 1 options below
    Live Virtual |9:30AM – 5:30PM EDT
    Live Virtual | 9:30AM – 5:30PM EDT
    Enroll
    Enroll Add to quote
Ask a Question Request Other Date Request On-site Course

Overview

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.

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 12 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 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

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 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 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
  • 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
  • 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
|
View Full Schedule

Schedule

1 options available

  • Jun 2, 2025 - Jun 6, 2025 (5 days)
    Live Virtual | 9:30AM – 5:30PM EDT
    Language English
    Select from 1 options below
    Live Virtual |9:30AM – 5:30PM EDT
    Live Virtual | 9:30AM – 5:30PM EDT
    Enroll
    Enroll Add to quote

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

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.

Does Ascendient Learning 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?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 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 info@ascendientlearning.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 do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

Good course. I appreciate the time the instructor put into teaching this class.

Great instructor, clear and concise course. Labs were easy to follow and worked perfectly.

Although there seemed to be too many links for the course, everything worked smoothly.

it was good and very informative. Instructure covered everything in detail.

Labs and the study materials provided for Architecting on AWS course are very easy to understand and explains all the topics required to pass the Associate certification.