CV040: z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

מק"ט: #6148 | משך קורס: 40 שעות אק'

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
הקורס פעיל לקבוצות מטעם ארגונים בלבד, ניתן לשלוח פנייה רק אם מדובר בקבוצה
*שדות חובה
PDF version

מטרות

  • 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

קהל יעד

This basic course is for 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.

תנאי קדם

You should be able to:

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

נושאים

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
     
לפי יצרן: 
IBM
תגיות