EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

CV040MY - zOS and DB2 Basics for DB2 for zOS DBA Beginners

Course outline

5 days
Discuss this programme →

Duration

5 days

Course Description

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners will help beginning DBAs develop fundamental z/OS and DB2 for z/OS skills through lectures and hands-on labs in the areas of:

  • z/OS
  • TSO/E and ISPF
  • Data sets
  • JCL and SDSF
  • DB2 Objects
  • Structured Query Language
  • DB2 Commands
  • DB2 Utilities
  • DB2 Logging
  • DB2 Program Preparation

Audience

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

Pre-requisites

You should be able to:

  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables

Course Objective

  • Tell some services provided in a z/OS environment
  • Log On to TSO/E
  • Navigate TSO/E and ISPF
  • Use SDSF (SYSLOG Display and Search Facility)
  • Give an overview of the DB2 9 environment
  • Describe DB2 Objects
  • Describe and use some DB2 Utilities
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Setup and execute DB2 Commands from DB2I (DB2 Interactive Facility)
  • Describe DB2 Logging
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Describe job roles in a z/OS environment
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Setup and use JCL (Job Control Language) to administer DB2 9 databases
  • Describe the different types of data sets in a z/OS environment
  • Use ISPF utilities to allocate a data set and list data set information and content
  • Create and modify data set content
  • Compare volume and logical partitions
  • Describe DB2 program preparation process
  • Use TSO commands

Introduction

  • List some benefits of z/OS
  • Describe typical mainframe workloads
  • Tell typical batch applications
  • Explain online transaction processing
  • Report job roles in the Mainframe environment

TSO/E and ISPF

  • Invoke TSO from a desktop using IBM Personal Communications (PCOMM)
  • Explain TSO Logon parameters
  • Invoke ISPF from TSO
  • Explain ISPF Primary options
  • Swap screens within ISPF
  • Customize ISPF

Data Sets (Part 1)

  • Allocate a sequential data set
  • Allocate a partitioned data set
  • Describe a VSAM data set
  • Maintain a sequential data set
  • Maintain members of a partition data set
  • Use ISPF Data Set List Utility

Introduction and Concepts

  • List some benefits of using DB2
  • Describe the structure of a DB2 table
  • Give some rules for a relational data model
  • State DB2 delete rules for referential integrity

Structured Query Language (SQL)

  • Communicate the components of the SQL language
  • Describe four SELECT statement clauses (SELECT, FROM, WHERE, ORDER BY) and their purpose
  • Retrieve all rows of a table
  • Retrieve specific columns
  • Retrieve rows based on comparisons to numeric or alphanumeric column values
  • Use the keywords BETWEEN, IN, LIKE, DISTINCT
  • Order the resulting rows in a desired sequence
  • Use some of the DB2I facilities to communicate with DB2

DB2 Objects

  • Relate DB2 objects and their properties
  • Create DB2 objects
  • Explain DB2 object dependencies

Data Sets (Part 2)

  • Define the acronyms:
  • VSAM
  • KSDS
  • ESDS
  • LDS
  • BSDS
  • Describe a VSAM Cluster
  • Explain VSAM Cluster definition syntax for a KSDS

DB2 Overview

  • Identify Z/OS Allied Address Spaces
  • Describe DB2 address space functions
  • Explain the function of the IRLM (Internal Resource Lock Manager)
  • Interact with the DB2 catalog
  • Describe the DB2 Directory

DB2 Commands

  • Relate ways to issue DB2 commands
  • Identify the syntax of a DB2 command
  • Demonstrate commands:
  • DISPLAY DATABASE
  • DISPLAY THREAD
  • DISPLAY UTILITY
  • DISPLAY GROUP
  • DISPLAY LOG
  • START DATABASE
  • STOP DATABASE
  • TERM UTILITY
  • ARCHIVE LOG
  • CANCEL THREAD
  • SET SYSPARM

JCL and SDSF

  • Describe JCL-related activities
  • Write JCL - Basic statements
  • Make use of some SDSF options

Utilities

  • Categorize DB2 utilities:
  • Online
  • Standalone
  • Service aids and samples
  • Explain the sequence of the Load utility
  • Explain the sequence of the DB2 Image copy
  • Communicate with DB2 online utilities

DB2 Logging

  • Explain at a high-level the DB2 logging process
  • Relate the interaction of archive/active logs and the BSDS
  • Recite the contents of the BSDS

Shutting down and Restarting the DB2

  • Explain two-phase commit processing
  • Relate the DB2 Restart phases

DB2 Program Preparation

  • Explain the program preparation steps
  • Explain:
  • DBRM
  • PLAN
  • PACKAGE
  • Difference between BIND and REBIND

Programme scope, delivery arrangements and suitability are confirmed during enquiry.